←back to thread

Litestream VFS

(fly.io)
306 points emschwartz | 4 comments | 11 Dec 25 17:59 UTC | HN request time: 0s | source
Show context
petcat ◴[11 Dec 25 18:20 UTC] No.46234956[source]▶
Are people still trying to shoehorn sqlite to run in a server-side context? I thought that was a fad that everyone gave up on.
replies(7): >>46235036 #>>46235082 #>>46235231 #>>46235259 #>>46235272 #>>46235793 #>>46236871 #
jtbayly ◴[11 Dec 25 18:41 UTC] No.46235231[source]▶
I am. Super simple. Super cheap. Great dev experience. Want to know whether the migration is going to work? Just download the prod db locally and test it. I'm happy.
replies(1): >>46235263 #
1. christophilus ◴[11 Dec 25 18:43 UTC] No.46235263[source]▶
Works for very small prod databases, I guess.
replies(3): >>46235353 #>>46236901 #>>46238347 #
2. tptacek ◴[11 Dec 25 18:48 UTC] No.46235353[source]▶
We use it internally for some rather large databases. It's not database size that matters, it's usage pattern.
3. andersmurphy ◴[11 Dec 25 20:45 UTC] No.46236901[source]▶
Handles billions of rows just fine. Can take you unreasonably far on a single server.
4. victorbjorklund ◴[11 Dec 25 22:42 UTC] No.46238347[source]▶
What is a very small database? At what size do you think read queries stops working in SQLite?