4 ms·
I'm a huge fan of SQLite! My org's apps use it heavily, often via this simple key-value interface built on sqlite: https://github.com/aaviator42/StorX https://
by aaviator42 3y ago
I'm a huge fan of SQLite! My org's apps use it heavily, often via this simple key-value interface built on sqlite: https://github.com/aaviator42/StorX https://github.com/aaviator42/StorX
Handles tens of thousands of requests a day very smoothly! :)
As an aside, has anyone tried using a RAM-disk as the storage medium for SQLite DB files? We've started experimenting with it lately and results have been promising!
- mharig 3y agoUse tempfs.
- mharig 3y agoSorry, it's tmpfs.
- aaviator42 3y agoYes, we are!
- andreidd 3y agoWhy not use “:memory:”?
- aaviator42 3y agoMultiple processes cannot access the same :memory: sqlite db, which makes it incompatible for our use cases.
- hwd 3y agoHave you considered https://www.sqlite.org/inmemorydb.html https://www.sqlite.org/inmemorydb.html
- aaviator42 3y agoYes! Like I mentioned in the other comment, multiple processes cannot access the same :memory: sqlite db, which makes it incompatible for our use cases.