News for hackers. Stuff that matters.
Re:Ask HN: Who uses SQLite database in production? by usgroup on Saturday July 06, 2019 @02:21PM (#20371011)
I do for a slack app. I have to queue the writes to avoid lock related errors but writes are relatively rare for the app so that’s no problem.

I also use SQLite for data analysis. If the data isn’t very big I always prefer it to ORC of Parquet because it enables full SQL. SQLite let’s you keep every table in a separate file and then use “attach database” to reference them into a query . It’s pretty ideal.

Re:Ask HN: Who uses SQLite database in production? by thunderbong on Monday July 08, 2019 @06:52AM (#20381611)
That's really interesting! SQLite never ceases to amaze. Have to look into that kind of implementation