Show HN: PGlite – in-browser WASM Postgres with pgvector and live sync

509 点作者 samwillis9 个月前

Hey, Sam and the team from ElectricSQL here.PGlite is a WASM Postgres build packaged into a TypeScript/JavaScript client library, that enables you to run Postgres in the browser, Node.js and Bun, with no need to install any other dependencies. It's 3mb Gzipped, now has support for many Postgres extensions, including pgvector, and it has a reactive "live query" API. It's also fast, with CRUD style queries executing in under 0.3 ms, and larger, multi-row select queries occurring within a fraction of a single frame.PGlite started as an experimental project we shared on X, and the response to it was incredible, encouraging us to see how far we could take it. Since then we have been working to get it to a point where people can use it to build real things. We are incredibly excited as today, with the release of v0.2, the Supabase team has released the amazing <a href="http://postgres.new" rel="nofollow">http://postgres.new</a> site built on top of it. Working with them to deliver both PGlite and postgres.new has been a joy.- <a href="https://pglite.dev" rel="nofollow">https://pglite.dev</a> - PGlite website- <a href="https://github.com/electric-sql/pglite">https://github.com/electric-sql/pglite</a> - GitHub repo- <a href="https://pglite.dev/docs" rel="nofollow">https://pglite.dev/docs</a> - Docs on how to use PGlite- <a href="https://pglite.dev/extensions" rel="nofollow">https://pglite.dev/extensions</a> - Extensions catalog- <a href="https://pglite.dev/benchmarks" rel="nofollow">https://pglite.dev/benchmarks</a> - Early micro-benchmarks- <a href="https://pglite.dev/repl" rel="nofollow">https://pglite.dev/repl</a> - An online REPL so that you can try it in the browserWe would love you to try it out, and we will be around to answer any questions.

36 条评论

simonw9 个月前

I'd seen this running in a browser before (the ~3MB download is really impressive for that), but I hadn't clocked that it runs server-side with Node.js and Bun as well: <a href="https://pglite.dev/docs/" rel="nofollow">https://pglite.dev/docs/</a>Since that's still not spinning up an actual network server, that feels like it's an alternative to SQLite - you can spin up a full in-process PostgreSQL implementation, that persists to disk, as part of an existing Node.js/Bun application.That's really interesting!I'd love to use this from Python, via something like <a href="https://github.com/wasmerio/wasmer-python">https://github.com/wasmerio/wasmer-python</a> or <a href="https://github.com/bytecodealliance/wasmtime-py">https://github.com/bytecodealliance/wasmtime-py</a> - has anyone run PGlite via one of those wrappers yet?

评论 #41225520 未加载

评论 #41226800 未加载

评论 #41228367 未加载

评论 #41226494 未加载

评论 #41242461 未加载

creativedg9 个月前

Huge fan of PGlite.It's the perfect solution to have Postgres without the need of Docker. With just `npm install`, you can have a Postgres instance on your computer. So, it's extremely easy to onboard a new developer in your team.And, the good news, PGlite works perfectly with Next.js.I'm using PGlite in local and development environment with Next.js Boilerplate: <a href="https://github.com/ixartz/Next-js-Boilerplate">https://github.com/ixartz/Next-js-Boilerplate</a>With only one command `npm install`, you can have a full-stack application, which also includes the database (a working Postgres). And, no need to have/install external tools.

评论 #41226518 未加载

sgbeal9 个月前

To keep the next person from having to look (or ask without looking): it supports browser-side persistence via IndexedDB and OPFS: <<a href="https://pglite.dev/docs/filesystems" rel="nofollow">https://pglite.dev/docs/filesystems</a>>

评论 #41225028 未加载

Cu3PO429 个月前

When I saw the headline, I immediately thought "I bet this would go really well with ElectricSQL", so it's great to see this coming from you!The immediate DX is incredible and I'm itching to use PGLite (and ElectricSQL) in a production project, I expect it would remove quite a few pain points I'm currently experiencing. (Also, I just like working with CRDTs.)I don't have any constructive criticism to offer right this moment, but I just wanted to congratulate you on the launch and an incredible looking product!

satvikpendem9 个月前

Congrats on the Show HN. I follow the ElectricSQL Discord server and I was distinctly interested in this but for other languages than TypeScript, so it's nice to see that making it language independent is high on your list. I also saw that ElectricSQL is being rewritten due to architectural changes, does that impact PGlite at all or are they separate projects now? What is the relationship between PGlite and ElectricSQL as well, just curious?Also, fun etymological thing, SQLite is actually SQL-ite, as in, urbanite, not SQ-Lite, but due to rebracketing [0] and libfixing [1], now people seem to use the -lite suffix rather than the -ite one, presumably because lite actually implies something whereas ite would not, as much. It's like how helicopter is actually helic and opter, a helical wing that spins, but now people think of it as heli and copter, calling other things related to it like helipad, or quadcopter, as Wikipedia states.[0] <a href="https://en.wikipedia.org/wiki/Rebracketing" rel="nofollow">https://en.wikipedia.org/wiki/Rebracketing</a>[1] <a href="https://en.wikipedia.org/wiki/Libfix" rel="nofollow">https://en.wikipedia.org/wiki/Libfix</a>

评论 #41226698 未加载

Retr0id9 个月前

Normally I'd say the main difference between postgres and SQLite is that the latter is in-process. Now that they can both be in-process, is there a more detailed comparison of the two? When might I prefer one over the other?

评论 #41235191 未加载

评论 #41231637 未加载

评论 #41226514 未加载

bezbac9 个月前

I recently experimented with using pglite for API integration tests in one of my side projects. It worked pretty well and has much better DX than using something like testcontainers[0] to spin up postgres running in docker.[0]: <a href="https://testcontainers.com" rel="nofollow">https://testcontainers.com</a>

评论 #41226107 未加载

评论 #41225840 未加载

bearjaws9 个月前

PGlite / ElectricSQL is definitely something I want to use in a future job.The ability to replicate and subscribe to the changes, all within the browser seems incredibly powerful.Having worked on medical software that runs a 2,000,000+ patient workload that perform refills for chemotherapy/HIV/immuno drugs, where it was common for people to trample each others work as they ran insurance, called patients etc...We had to roll our own locking system that relied on interval functions (yay IE7) and websockets... This meant when you called the patient, someone running financial assistance would be unable to work on the same profile.I can envision other uses for FTS or even vector search locally, since they are insanely expensive at scale.

评论 #41227387 未加载

saurik9 个月前

Does there happen to be a native analog to this? So like, if I eventually want some kind of native app, I wouldn't have to throw away the architecture entirely and start over? I only see mention of the WASM version of this in the website/docs.

评论 #41225185 未加载

ZitchDog9 个月前

> it has a reactive "live query" APIVery cool! Most of the examples for reactive queries are very basic (only single tables). Do live queries support joins / aggregations?

评论 #41227584 未加载

herpdyderp9 个月前

What's the equivalent Postgres version? Meaning, if I wanted to make sure my app that is currently using a Postgres Docker image is compatible with PGlite before switching, which version of Postgres should my Docker image be on?I see "PostgreSQL 15devel" in a screenshot so I'm assuming that means v15 but explicit documentation on current and future Postgres version usage would be very nice. For example, how will I know when (if) you update to v16?

评论 #41227138 未加载

metadat9 个月前

How did they manage to fit Postgres in 3MB?

评论 #41226009 未加载

cpursley9 个月前

Woah, this is neat - insane that it can handle extensions.Just added a new section to my "Postgres Is Enough" gist:<a href="https://gist.github.com/cpursley/c8fb81fe8a7e5df038158bdfe0f06dbb#in-browser--wasm" rel="nofollow">https://gist.github.com/cpursley/c8fb81fe8a7e5df038158bdfe0f...</a>

FlyingSnake9 个月前

PGLite is a wonderful achievement and I've a fan of it since it's early days.If they get it to a stage where other languages apart from JS can use it, it could be revolutionary. The possibilities are limitless.

AlexErrant9 个月前

Bug report? On <a href="https://pglite.dev/repl/" rel="nofollow">https://pglite.dev/repl/</a> running `SELECT 'a fat cat sat on a mat and ate a fat rat'::tsvector @@ 'cat & rat'::tsquery;` works, which is cool.However, running `SELECT to_tsvector('fat cats ate fat rats') @@ to_tsquery('fat & rat');` fails with `y is not a function`. Then trying to run the first query yields `null`, which is weird. I can open an issue if you want :)

评论 #41225813 未加载

NetOpWibby9 个月前

This is exciting. My database of choice is EdgeDB, which uses Postgres under the hood. It's not so far-fetched to imagine EdgeDB in the browser now!

cheema339 个月前

The filesystems page at <a href="https://pglite.dev/docs/filesystems" rel="nofollow">https://pglite.dev/docs/filesystems</a> says the following:> "We would recommend using the IndexedDB VFS in the browser at the current time as the OPFS VFS is not supported by Safari."Is it possible to configure PGLite to use IndexedDB on Safari and OPFS on Chrome & Firefox?

评论 #41232355 未加载

drzaiusx119 个月前

Anyone know if something similar is available for MySQL/Maria? This is very cool, especially given the tiny size of it

srameshc9 个月前

If I understand correctly, this is like SQLite, but Postgres. I love SQLite, but sometimes I need a little more. So, no more saving Date as text and we have arrays, jsonb etc and all the good stuff from Postgres. Am I right ?

评论 #41226016 未加载

评论 #41233686 未加载

ChrisArchitect9 个月前

Related:Subabase announcement postPostgres.new: In-browser Postgres with an AI interface<a href="https://news.ycombinator.com/item?id=41224286">https://news.ycombinator.com/item?id=41224286</a>

blueprint9 个月前

Anyone know how this would play with at-rest encryption extensions?

评论 #41226820 未加载

ggregoire9 个月前

I was gonna ask what do people use to sync their local pg with their remote pg, but turns out, that's exactly what the authors are building. Cool stuff, and gratz on pglite!

wejick9 个月前

Curious to know How "vanilla" the pglite compared to the vanilla postgres? I saw many people are using this for automated testing and dev environment.

batmansmk9 个月前

Pretty awesome. Would love to use it in CI and locally for our PG product. We use Prisma, so I guess we have to wait for the connector that looks like pg to plug it in.

评论 #41225386 未加载

评论 #41226243 未加载

评论 #41225356 未加载

isoprophlex9 个月前

That's great! Corpo beancounters want us to move off docker on EC2 onto bare metal, making both dev and deploy experience terrible. This will help ease pain!

评论 #41226425 未加载

评论 #41227965 未加载

评论 #41228296 未加载

loevborg9 个月前

PGLite is amazing for integration testing of queries against a real in-memory db.Is it possible to use PGLite for that purpose in non-JS environments, like e.g. golang?

评论 #41226268 未加载

Kinrany9 个月前

Can it run in Node while still persisting data to disk?

评论 #41226312 未加载

vivzkestrel9 个月前

How does it compare with <a href="https://postgres.new/" rel="nofollow">https://postgres.new/</a>

评论 #41235848 未加载

sam_perez9 个月前

Oh cool, how would you compare this to DuckDB?

makkesk89 个月前

Awesome work! A killer feature of sqlite that I would love to see in pglite would be javascript window functions.

评论 #41226159 未加载

sabr9 个月前

This is amazing! Will there be something like Litestream/rqlite for PGlite?

revskill9 个月前

The migration docs to integrate with Vite/webpack is still lacking though.

namanyayg9 个月前

How does the performance compare to actual postgres?

评论 #41226152 未加载

teaearlgraycold9 个月前

Heads up, the supabase link on the front page 404s

评论 #41226272 未加载

non-9 个月前

Would really like to see a benchmarking analysis vs SQLite. How do they compare on memory usage and overhead?I already default to SQLite for new side projects with the idea that "eventually I'll migrate to Postgres if this project gets legs", so switching to PGlite feels like a no-brainer as long as it's not going to weigh my apps down or force me to upgrade out of whatever entry-level server solution I'm using is for a given project.EDIT: Found the benchmarks here <a href="https://pglite.dev/benchmarks" rel="nofollow">https://pglite.dev/benchmarks</a>

评论 #41226652 未加载

AIDataWhiz9 个月前

This is exactly the tool I needed and I will try it out in my new project. Thanks for your contribution