markusw

15 ms·

1. 181.▲
   by markusw 4y ago

   What’s the advantage of the mutexed rw connection compared to the busy timeout and built-in locking?
2. 182.▲
   by markusw 4y ago

   This is news to me. What’s your source for that? AFAIK, SQLite is fully and completely ACID also in WAL mode.
3. 183.▲
   by markusw 4y ago

   Thank you for the kind words! :) The built-in busy timeout basically takes care of write queueing, so a standard setup like this will take you very, very far.
4. 184.▲
   by markusw 4y ago

   I don’t know pocketbase, will have a look.
5. 185.▲
   by markusw 4y ago

   I’m pretty happy with TablePlus. Does all the big dbs.
6. 186.▲
   by markusw 4y ago

   @levelsio famously runs a dozen websites all backed by SQLite, with 200M reqs / month: https://twitter.com/levelsio/status/1520356430800617472 Expensify got 4 million request _per second_ out of a custom SQLi
7. 187.▲
   by markusw 4y ago

   Haha, I’ve heard that comment before as well. If it’s _too_ fast, it feels suspicious, like it’s not doing anything. I think we’ve collectively forgotten how fast dynamic websites can be on modern hardware!
8. 188.▲
   by markusw 4y ago

   Essentially yes, with a single SQLite instance, you have a small window of downtime on every deploy. But depending on your setup, that window could be very small, and unnoticeable if you have something in front that just delays incoming req
9. 189.▲
   by markusw 4y ago

   It’s not just extra hops: there’s no network! (In distributed SQLite for reads at least.) Great for read-heavy workloads, and no n+1 query problems. Concurrent readers is no problem. No concurrent writes right now.
10. 190.▲
    by markusw 4y ago

    Have a look at the followup article that touches on distributed SQLite with LiteFS. :)
11. 191.▲
    by markusw 4y ago

    When you embed it in Go, you can have concurrent reads. Each HTTP handler request gets a separate goroutine, so you can definitely take advantage of multiple cores.
12. 192.▲
    by markusw 4y ago

    Saw the request spike, searched HN for "sqlite".
13. 193.▲
    by markusw 4y ago

    Ooops, thanks! Deploy on the way with a fix. :D
14. 194.▲
    by markusw 4y ago

    See my followup-article "Distributed SQLite with LiteFS" for the scale-out part: https://www.golang.dk/articles/distributed-sqlite-with-litef... And IMO, what you lose in the cloud layer you gain by having a
15. 195.▲
    by markusw 4y ago

    Hey! I'm the author of the article. Saw a sudden influx of traffic from HN and found the post here. Happy to answer any questions. Although SQLite is so dead-simple-but-awesome that you probably don't have any. :D Anyway, hope you
16. 196.▲
    by markusw 5y ago

    Hey fellow nerds! I'm building an online course to learn to build apps for the cloud in Go. It covers Go project basics, database integration and migrations, job queues, email communication, and later blob storage integration, observab
17. 197.▲
    Show HN: Build Cloud Apps in Go online course(golang.dk)

    2 points by markusw 5y ago|1 comments
18. 198.▲
    Gomponents: Declarative View Components in Go(maragu.dk)

    1 points by markusw 6y ago|0 comments