On: Why you should probably be using SQLite

[aaviator42]

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

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!

[hwd → aaviator42]

Have you considered https://www.sqlite.org/inmemorydb.html

[aaviator42 → hwd]

Yes! Like I mentioned in the other comment, multiple processes cannot access the same :memory: sqlite db, which makes it incompatible for our use cases.

[andreidd → aaviator42]

Why not use “:memory:”?

[aaviator42 → andreidd]

Multiple processes cannot access the same :memory: sqlite db, which makes it incompatible for our use cases.

[mharig → aaviator42]

Use tempfs.

[mharig → mharig]

Sorry, it's tmpfs.

[aaviator42 → mharig]

Yes, we are!