Hacker News new | ask | show | jobs
by k2enemy 4081 days ago
I use sqlite to store all of my small datasets. Minimally, I think of it as a replacement for zipped CSV files. But it also has the added benefit of a relational structure and SQL.

It is super easy to access from julia, R, python, etc, so instead of importing a CSV and manipulating the data, I find it a lot easier to connect to the sqlite database and use SQL for the a lot of the joining and manipulating.

1 comments

I see. So the benefit is mainly in having more relational structure than in actually crunching numbers. Makes sense.