News for hackers. Stuff that matters.

A comment on SQLedge: Replicate Postgres to SQLite on the Edge. Parent comment

Re:SQLedge: Replicate Postgres to SQLite on the Edge by zbentley on Thursday August 10, 2023 @04:32PM (#37081379)
There are still context switches with sqlite, even in-memory sqlite (it has to mess with files, which means syscalls). Just not network ops.
[ Parent | on HN ]
Re:SQLedge: Replicate Postgres to SQLite on the Edge by kiitos on Thursday August 10, 2023 @05:40PM (#37082154)
In-memory SQLite doesn't read or write files, and therefore doesn't generate syscalls, by definition.
[ Parent | on HN ]
Re:SQLedge: Replicate Postgres to SQLite on the Edge by zbentley on Thursday August 10, 2023 @08:54PM (#37083777)
Fair enough; I didn't realize that ":memory:" SQLite accesses did zero syscalls overall, I had assumed that they required shared memory writes that entailed syscalls for barriers and the like.

I'm happy you helped me learn that's not the case! That'll make several things I regularly need to do much, much easier.

[ Parent | on HN ]
Re:SQLedge: Replicate Postgres to SQLite on the Edge by kiitos on Thursday August 10, 2023 @09:47PM (#37084136)
Sure! It's a huge and important benefit of that access mode.
[ Parent | on HN ]