Siren Call of SQLite on the Server

Re:Siren Call of SQLite on the Server by klabb3 on Tuesday February 18, 2025 @07:50AM (#43088905)

It appears we are essentially stack-buddies (I use those exact technologies too). I have 0 issues with perf, and I love the hermetic unit tests that literally doesn’t even use disk (let alone networking).

However, I find it a bit annoying that I have to restore from backup for one-off queries and data exploration. Do you have some tooling or tricks to recommend?

[ Parent | on HN ]

Re:Siren Call of SQLite on the Server by aranw on Tuesday February 18, 2025 @07:59AM (#43088971)

I'm curious what SQlite package do you use? Are you also using cgo or not? cgo has been a bit of pain point for me in the past with SQLite

[ Parent | on HN ]

Re:Siren Call of SQLite on the Server by klabb3 on Tuesday February 18, 2025 @03:19PM (#43094517)

Yeah cgo has been necessary for me, I forgot why but made that determination long ago. I have many pains with cross platform builds but never had an issue with cgo, and I’m targeting Android, iOS, macOS windows and two Linux flavors. I’m using the mattn/sqlite3 package.

[ Parent | on HN ]

Re:Siren Call of SQLite on the Server by hruk on Tuesday February 18, 2025 @11:35AM (#43091712)

We have some analytics queries powered by Airflow running on a separate box. We set up Litestream to replicate to that box via SFTP, and then dump changes hourly into Snowflake.

[ Parent | on HN ]