DEV Community

Discussion on: Today I learned: Why there aren't many tools for SQLing a csv

Collapse
 
reidterror profile image
reidterror

How good is sqlite for a small startup project is what i find myself wondering lately. Been doing a bit of django in my spare time and the default for that is sqlite.

Collapse
 
therealkevinard profile image
Kevin Ard • Edited

idk if I'd recommend sqlite as the prime backend store for a production thing. It's default for a number of frameworks etc because it's great for RAD (embedded; no running server), and its sql-compliance means switching to the production backend is usually just a question of updating the driver in your ORM layer (assuming you're using one).

Translation: it's default for dev, not generally recommended for prod.