3 ms·
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 routin
by Abishek_Muthian 4y ago
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 https://github.com/mattn/go-sqlite3
- tptacek 4y agoMy 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.
- Abishek_Muthian 4y agoThat's an useful information, Thanks for sharing.