What do you think about CSV to Postgres?

Question

Hey HN,What do you guys think of CSV spreadsheets to Postgres DB? Most brick and mortar companies have their data in CSV file. They might not have the expertise to spin up AWS RDS DB or other complicated setups. Do you think a cloud hosted Postgres + an option to convert their CSV files to tables on Postgres would be useful?Is it possible? Has this been done before? Is it something that you would be willing to pay for? What could be some pros and cons?Please discuss your thoughts.

brodouevencode · Accepted Answer

Postgres has a mechanism for importing CSVs. Not sure what the value of something like this would add.

verdverm · Answer

Dolt has this feature, but it is iffy and could be done better, inferring the schema is hard

codingdave · Answer

I don't see the use case. CSV imports are fairly standard tasks, not rocket science. Anyone without the skills to handle such a routine thing wouldn't know what to do with a bunch of tables in an RDS DB anyway.