SQLedge: Replicate Postgres to SQLite on the Edge

Re:SQLedge: Replicate Postgres to SQLite on the Edge by simonw on Wednesday August 09, 2023 @01:41PM (#37066138)

They were being cached for at least a minute (maybe even more than that, I can't remember the details) - that's what the local memcached instance was for.

This was problematic though because changing a feature flag and then waiting for a minute plus to see if the change actually worked can be frustrating, especially if it relates to an outage of some sort.

[ Parent | on HN ]

Re:SQLedge: Replicate Postgres to SQLite on the Edge by kiitos on Thursday August 10, 2023 @04:42PM (#37081510)

If the cache is out-of-process, access is going to be subject to faults and latencies that are categorically different than anything that would be in-process.

You'd never want to include a request to an out-of-process service in any kind of hot loop, even if that service is on the same machine.

[ Parent | on HN ]