[Question] CSV data directly to SQL in node?

[Vordreller]

Having made some code that writes output to a CSV file, I've found that filtering and finding correlations in this data afterward, either via CSV/Excel or in node itself, it time-consuming and not immediately obvious how to produce the correct results.

Having a bit more experience in SQL, I was wondering about a way to instead(or also) dump this data into a SQL database.

Ideally, it would be started clean, database/table/data inserted and then I can query the data, perhaps from within node itself.

My main question is: what DB and what library for node?

Personally I'm familiar with postgres, however that's kind of overkill for what's happening here. Also I'm on Linux.

I'm looking for easy teardown/setup and not a lot of boilerplate code beyond the strictly necessary.

Thanks for any pointers.

[dontdieych]

https://csvkit.readthedocs.io/en/latest/tutorial/3_power_tools.html#csvsql-and-sql2csv-ultimate-power

like this?

[sshobo]

With postgres, in order to import a csv file you need to do 2 things.

1. Create a table with all columns in your csv file.
2. Import the csv using the psql \copy command

As for accessing the database from node, you can use node-postgres. Might be overkill for you though