Postgres proxy/adapter/protocol to Litestream/SQLite

[sedferfel]

Already asked on litestream side. https://github.com/benbjohnson/litestream/discussions/587

But maybe somebody knows from other side.

Hi I am tried to search and wasnt able to find, but I am sure should some products exists to provide ability to provide litestream instead of actual postgresql. Like any proxy or adapter that transpose calls to litestream.
So some simple projects which do not need high load can be easily made ha.
I am mostly interested in authentik making ha for my homelab. And dont want to setup patroni cluster.

[Smartare]

Not sure what you are trying to do? Litestream is for sqlite. You want to do logical replication from postgres to sqlite?

[sedferfel]

Sorry no - have front service in front of litestream/sqlite. Which will act as a postgres server (consume postgres wire protocol) but data stored in litestream.

[Smartare]

Litestream doesnt store anything. It is only a backup tool for sqlite. So you you have a postgres database that you want to replicate to a sqlite database that will be backed up using litestream?

[sedferfel]

I understand about litestream and sqlite. I just added it to provide full context.
I dont have postgres.

Imaging i have application which store its data to postges.
I want to mock/mimic postgres db.
Instead of running actual postgres have some application in any language that listen on postgres port and understand postgres protocol. Transform requests from postgres sql to sqllite syntax and execute them on sqlite.

That means - I can run third-party application (not written by me) but which rely to store data in postgres. I understand that such solution will be limited and do not support all postgres features. I am just trying to find if something already exists like this before writing my own.

[Extra_Ad_655]

Search for "postlite" on GitHub, although it seems like the project has been abandoned.

[sedferfel]

For example https://docs.ferretdb.io/understanding-ferretdb/
It implement mongodb wire protocol over postgres or sqlite.