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.

▲

tensor 3 days ago | parent | next [-]

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.

▲

thruflo 3 days ago | parent | prev | next [-]

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.

▲

emschwartz 3 days ago | parent | next [-]

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.

▲

OutOfHere 3 days ago | parent | prev [-]

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

▲

ncruces 3 days ago | parent [-]

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

	▲	markusw 3 days ago \| parent [-]
		Ah, I thought I recognized your username from a Github URL. :D Thank you for your contributions in the SQLite & Go space!

▲

xarope 3 days ago | parent | prev | next [-]

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

▲

markusw 3 days ago | parent | prev [-]

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