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
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.