Flagged as primarily opinion-based.. ;P

I haven't compared different database engines since a long time ago. On my private machine, I still use an old MS SQL Server 2008 R2 Developer edition... At my last workplace, it was mySQL - oh my, I would not like to use it again. The more I had to deal with it, the less functional it proved, even for simple CRUD stuff. More than 10 years ago, I tested huge reporting queries in many different engines - Oracle and MS SQl Server were best, followed by postgres; mysql behaved worse than MS Access... Oh sanctissimi Wilhelmus, Theodorus, et Fredericus!

Hey... I could even follow the explanation :rolleyes: ;P :-D M.D.V. ;) If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about? Help me to understand what I'm saying, and I'll explain it better to you Rating helpful answers is nice, but saying thanks can be even nicer.

It's a real Crysis. Did you ever see history portrayed as an old man with a wise brow and pulseless heart, weighing all things in the balance of reason? Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful? --Zachris Topelius

This line seems very strange: object num1 = row.Table.Rows[0][0].ToString(); as you're always using the first row of the underlying table (and thus will always get just the value of its first column inserted). IMHO this should just read object num1 = row[0].ToString(); Would that help?

Totally forgotten about the Free Tools section :-O

So... now adding site driving to the list? ;P :laugh: :laugh: M.D.V. ;) If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about? Help me to understand what I'm saying, and I'll explain it better to you Rating helpful answers is nice, but saying thanks can be even nicer.

no worries rick, just thought I'd mention that's the way it's worked for me all these years. However, if you have to do this in C#, you might want to take a look at the latest version of NpgSQL and the fact if now supports bulk upload/download in a binary format :-) basically, you would skip the PG dump step and replace that with your tool using NpgSQL. I wrote the syncfusion eBook on postgres years ago (And if I'm being honest, it needs an update :-) ), anyway... point being, feel free to ask me if you have any PG queries...

I haven't used it and not sure it ticks all your boxes, but heard good things - Overview - Redmine[^]

Get create table statements for a database under a schema. SELECT TABLE_NAME, 'CREATE TABLE '||TABLE_NAME|| ' ('||STRING_AGG(CONCAT( C1, C2, C3, C4, C5, C6 ),', ')||')' AS QUERY FROM ( SELECT C.TABLE_NAME, '"'||C.COLUMN_NAME||'"' || ' ' || CASE WHEN DATA_TYPE='ARRAY' THEN LTRIM(UDT_NAME,'_')||'[]' ELSE DATA_TYPE END AS C1, CASE WHEN CHARACTER_MAXIMUM_LENGTH > 0 THEN '(' || CHARACTER_MAXIMUM_LENGTH || ')' END AS C2, CASE WHEN NUMERIC_PRECISION > 0 AND NUMERIC_SCALE < 1 THEN NULL END AS C3, CASE WHEN NUMERIC_PRECISION > 0 AND NUMERIC_SCALE > 0 THEN NULL END AS C4, CASE WHEN IS_NULLABLE = 'NO' THEN ' NOT NULL' END AS C5, CASE WHEN COLUMN_DEFAULT IS NOT NULL AND COLUMN_DEFAULT NOT LIKE 'nextval%' THEN ' DEFAULT' END || ' ' || REPLACE(COLUMN_DEFAULT, '::CHARACTER VARYING', '') AS C6 FROM INFORMATION_SCHEMA.COLUMNS C, INFORMATION_SCHEMA.TABLES T WHERE C.TABLE_CATALOG='tpch' AND T.TABLE_CATALOG='tpch' AND T.TABLE_SCHEMA='public' AND C.TABLE_NAME=T.TABLE_NAME AND C.TABLE_SCHEMA='public' AND T.TABLE_TYPE IN ('BASE TABLE') ORDER BY C.TABLE_NAME, C.ORDINAL_POSITION ) AS STRING_COLUMNS GROUP BY TABLE_NAME

1. Using SQL Query To show the list of tables with the corresponding schema name, run this statement: SELECT * FROM information_schema.tables; or in a particular schema: SELECT * FROM information_schema.tables WHERE table_schema = 'schema_name'; 2. Using psql To list all tables: In all schemas: \dt *.* In a particular schema: \dt schema_name.*

Ankur B. Patel wrote: can anyone please help me out here, how can i implement this scenario in a better manner. Then easiest and best answer do not do that in the first place. File systems, not databases, have existed for a long time and exist solely to manage files. What you have are files. If you want to reference the files in the database then do just that. Keep the files on the file system and provide a reference (absolute or relative) to the location of the file. You can keep meta data on the file in the database, such as name, size, type, etc. Might also want to insure uniqueness also. You do that by finding out what makes one file always different from other. Usually some combination of name and location. And insure that is maintained. Finally of course how will these files be used. For example if you expect a png to show up in a web page that has 10,000 unique visits a day, you certainly do not want to be pulling it out of a database.

I was looking for plagiarism, it had that stench to it ... :-O "I have no idea what I did, but I'm taking full credit for it." - ThisOldTony "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt AntiTwitter: @DalekDave is now a follower!

Imagine you load a file that has 3 sets of timeseries data: attributeA, attributeB and attributeC. Each timseries is of the form Array. There will be between 1000 and 15,000 time/value pairs in each series, so maybe 8Kb to 120Kb in each series. I will never query the data in the array. I will only ever return it as a chunk of data (meaning I could compress it into a BLOB for higher storage efficiency at a tradeoff in load speed if I needed to) A classic database such as MySQL or SQL Server seems massive overkill for this. cheers Chris Maunder

I have not used the jquery datepicker in this way but this link seems to explain how to do it, How to apply jQuery DatePicker in ASP.NET MVC in Create and Edit View - Stack Overflow[^]

Good to know. Thanks. I've been reading about it and will do more research.