4 ms·
My personal favourite use for SQLite was for my blog. I wanted to use flat-files for storing individual entries, but I still wanted to present tag-views, and p
by stevekemp 10y ago
My personal favourite use for SQLite was for my blog. I wanted to use flat-files for storing individual entries, but I still wanted to present tag-views, and per-month entries.
My solution was to create a simple SQlite database, import all the entries into it, and then generate the views by SELECTing from that store.
Populating the database, even if it got thrown away immediately afterwards, was more efficient than trying to store all the entries in RAM.
https://github.com/skx/chronicle2 https://github.com/skx/chronicle2
- cyberferret 10y agoYes, temp storage is another 'use case' for me too. On one particular web app I designed, there is a requirement for searching across multiple tables for text data. I simply transpose the columns I need from the different tables into a memory SQLite database 'on the fly' and perform a full text search on that for lightning quick responses and no need to do multi table joins.