News for hackers. Stuff that matters.

A comment on Why you should probably be using SQLite.

Re:Why you should probably be using SQLite by aaviator42 on Friday October 27, 2023 @09:07AM (#38037918)
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!

[ Parent | on HN ]
Re:Why you should probably be using SQLite by andreidd on Friday October 27, 2023 @09:22AM (#38038095)
Why not use “:memory:”?
[ Parent | on HN ]
Re:Why you should probably be using SQLite by aaviator42 on Friday October 27, 2023 @09:29AM (#38038183)
Multiple processes cannot access the same :memory: sqlite db, which makes it incompatible for our use cases.
[ Parent | on HN ]
Re:Why you should probably be using SQLite by hwd on Friday October 27, 2023 @09:44AM (#38038342)
Have you considered https://www.sqlite.org/inmemorydb.html
[ Parent | on HN ]
Re:Why you should probably be using SQLite by aaviator42 on Friday October 27, 2023 @10:24AM (#38038842)
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.
[ Parent | on HN ]
Re:Why you should probably be using SQLite by mharig on Saturday October 28, 2023 @08:19AM (#38049253)
Use tempfs.
[ Parent | on HN ]
Re:Why you should probably be using SQLite by mharig on Saturday October 28, 2023 @02:02PM (#38052005)
Sorry, it's tmpfs.
[ Parent | on HN ]
Re:Why you should probably be using SQLite by aaviator42 on Sunday October 29, 2023 @01:11PM (#38060587)
Yes, we are!
[ Parent | on HN ]