How the SQLite virtual machine works

Re:How the SQLite virtual machine works by 0x457 on Wednesday September 07, 2022 @01:39PM (#32753634)

To be fair, serving any kind of traffic with Rails required multiple replicas of Rails application running. So SQLite wasn't an option for production for any kind of production rails workload.

Then most hosting for rails were stateless, so you had no way of storing SQLite on disk.

And finally, for serious production you need high availability and SQLite couldn't offer that.

[ Parent | on HN ]

Re:How the SQLite virtual machine works by Abishek_Muthian on Thursday September 08, 2022 @03:29AM (#32762435)

Would Go's concurrency be an issue for SQLite too?

Edit: I looked into a common Go driver for SQLite[1] and the FAQ reads,

> Can I use this in multiple routines concurrently?

> Yes for readonly. But not for writable. See #50, #51, #209, #274.

Every time I see a blog post from fly.io reg SQLite I'm tempted to use it for my next project, But the need to rewrite my framework for limited data types and the doubts regarding concurrency keeps me away.

[1] https://github.com/mattn/go-sqlite3

[ Parent | on HN ]

Re:How the SQLite virtual machine works by tptacek on Thursday September 08, 2022 @03:38PM (#32770930)

My general M.O. for SQLite in Go is to have a single writer thread with a channel of closures to apply transactions, and a shared db handle for reads. Works fine.

[ Parent | on HN ]

Re:How the SQLite virtual machine works by Abishek_Muthian on Thursday September 08, 2022 @11:16PM (#32774887)

That's an useful information, Thanks for sharing.

[ Parent | on HN ]