What if we treated Postgres like SQLite?

I think this is a neat direction to explore. I've wondered in the past whether you could use https://pglite.dev/ as if it were SQLite.

This is very much the point of https://pglite.dev

It's an embeddable Postgres you can run in process as a local client DB, just like SQLite but it's actually Postgres.

Someone is working on a libpglite based around pglite. I think this is what will provide an actual sqlite alternative:

https://github.com/electric-sql/pglite-bindings

It would still be missing the standardized disk format aspect of sqlite, but otherwise will be neat.

I wish this were available for Go lang, perhaps via Wazero.

For sure. I’m curious if anyone using it in production as an alternative to SQLite and, if so, what the performance and experience is like.

Me too. There's only so much time in life. I'd take it for a spin if someone else did it. :)

Interesting! I'm going to look into that. :-) Thank you for sharing.

Ah, I thought I recognized your username from a Github URL. :D Thank you for your contributions in the SQLite & Go space!

You got my hopes up, but it's WASM for now, not something I could add into a golang [1] or python app and have running like sqlite. OK, still hoping...!

[1]https://github.com/electric-sql/pglite/issues/89