5 ms·

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

• thruflo 1y ago
  This is very much the point of https://pglite.dev 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.
  • OutOfHere 1y ago
    I wish this were available for Go lang, perhaps via Wazero.
    • ncruces 1y ago
      Me too. There's only so much time in life. I'd take it for a spin if someone else did it. :)
      • markusw 1y ago
        Ah, I thought I recognized your username from a Github URL. :D Thank you for your contributions in the SQLite & Go space!
  • emschwartz 1y ago
    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.
• tensor 1y ago
  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 https://github.com/electric-sql/pglite-bindings It would still be missing the standardized disk format aspect of sqlite, but otherwise will be neat.
• markusw 1y ago
  Interesting! I'm going to look into that. :-) Thank you for sharing.
• xarope 1y ago
  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 https://github.com/electric-sql/pglite/issues/89