Litestream VFS

(fly.io)

306 points emschwartz | 5 comments | 11 Dec 25 17:59 UTC | HN request time: 0.691s | 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 #

1. jtbayly ◴[11 Dec 25 18:41 UTC] No.46235231[source]▶

>>46234956 #

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 #

2. christophilus ◴[11 Dec 25 18:43 UTC] No.46235263[source]▶

>>46235231 (TP) #

Works for very small prod databases, I guess.

replies(3): >>46235353 #>>46236901 #>>46238347 #

3. tptacek ◴[11 Dec 25 18:48 UTC] No.46235353[source]▶

>>46235263 #

We use it internally for some rather large databases. It's not database size that matters, it's usage pattern.

4. andersmurphy ◴[11 Dec 25 20:45 UTC] No.46236901[source]▶

>>46235263 #

Handles billions of rows just fine. Can take you unreasonably far on a single server.

5. victorbjorklund ◴[11 Dec 25 22:42 UTC] No.46238347[source]▶

>>46235263 #

What is a very small database? At what size do you think read queries stops working in SQLite?

↑