Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

PGlite – Embeddable Postgres

pglite.dev

Post reply on HN
Print view View original

21–30 of 118 posts

Re: PGlite – Embeddable Postgres

#22

Post by oulipo2 »

samwillis wrote: post #16

Hey everyone, I work on PGlite. Excited to see this on HN again. If you have any questions I'll be sure to answer them. We recently crossed a massive usage milestone with over 3M weekly downloads (we're nearly at 4M!) - see https://www.npmjs.com/package/@electric-sql/pglite While we originally built this for embedding into web apps, we have seen enormous growth in devtools and developer environments - both Google Fir…

I'm interested to use Pglite for local unit-testing, but I'm using timescaledb in prod, do you think you will have this extension pre-built for Pglite?

Re: PGlite – Embeddable Postgres

#23

Post by exceptione »

Are people using this in SPA applications with success? I saw on the website that syncing via ElectricSQL is in alpha and that no CRDT is available, afaik. Any other options? Also, I guess pgsql extensions are out of scope?

Nonetheless, this could be interesting for data heavy SPA's.

Re: PGlite – Embeddable Postgres

#24

Post by samwillis »

exceptione wrote: post #23

Are people using this in SPA applications with success? I saw on the website that syncing via ElectricSQL is in alpha and that no CRDT is available, afaik. Any other options? Also, I guess pgsql extensions are out of scope? Nonetheless, this could be interesting for data heavy SPA's.

There are a few people using it in prod for customer facing web apps.

Extensions are also available - we have a list here: https://pglite.dev/extensions/. We would love to extend the availability of more, some are more complex than others though. We are getting close to getting PostGIS to work, there is an open PR that anyone is welcome to pick up and hack on.

Re: PGlite – Embeddable Postgres

#26

Post by samwillis »

oulipo2 wrote: post #22
samwillis wrote: post #16

Hey everyone, I work on PGlite. Excited to see this on HN again. If you have any questions I'll be sure to answer them. We recently crossed a massive usage milestone with over 3M weekly downloads (we're nearly at 4M!) - see https://www.npmjs.com/package/@electric-sql/pglite While we originally built this for embedding into web apps, we have seen enormous growth in devtools and developer environments - both Google Fir…

I'm interested to use Pglite for local unit-testing, but I'm using timescaledb in prod, do you think you will have this extension pre-built for Pglite?

I'm not aware of anything trying to compile timescale for it. Some extensions are easer than other, if there is limited (or ideally no) network IO and its written in C (Timescale is!) with minimal dependencies then its a little easer to get them working.

Re: PGlite – Embeddable Postgres

#28

Post by evelant »

dvdkon wrote: post #6

This is very cool. Having to always set up a server is one major downside of Postgres, with cumbersome updates being the second. This solves the first and has potential to help with the second. Is there a way to compile this as a native library? I imagine some of the work should be reusable.

Yes! I (experimentally) compiled and packaged it for react-native. Postgres on iOS and Android https://github.com/electric-sql/pglite/pull/774

Re: PGlite – Embeddable Postgres

#30

Post by samwillis »

evelant wrote: post #28
dvdkon wrote: post #6

This is very cool. Having to always set up a server is one major downside of Postgres, with cumbersome updates being the second. This solves the first and has potential to help with the second. Is there a way to compile this as a native library? I imagine some of the work should be reusable.

Yes! I (experimentally) compiled and packaged it for react-native. Postgres on iOS and Android https://github.com/electric-sql/pglite/pull/774

This is such awesome work! We *are* going to get this integrated with the ongoing work for "libpglite".
Post reply on HN