PGlite – Embeddable Postgres

dvdkon

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.

worthless-trash

Took the words out of my mouth, i can think of many use cases for this.

Imagine being able to go from 'embedded' to 'networked' without having to change any SQL or behavior, so cool.

avinassh

previous Show HN post submitted by the author (109 comments) - https://news.ycombinator.com/item?id=41224689

adhamsalama

I tried to use this when I was building a project about peer-to-peer database sharing in the browser using WebAssembly and WebRTC, but I found it a bit heavy so I used SQLite instead.

Here's the project if anyone is interested: https://github.com/adhamsalama/sqlite-wasm-webrtc

mythz

It's cool that this is possible, is this just for fun or are there good use-cases for this?

npodbielski

Hmm single user website run as HTML from some folder? I guess you could embed this from s3 for multiple users but probably this would be like running multiple engines from the same dir.

ekjhgkejhgk

> Hmm single user website run as HTML from some folder?

Why not just sqlite then?

vincnetas

More SQL functionality?

cosmotic

Embeddable (into JS et al)

urtie

There are projects such as https://github.com/wasmerio/wasmer-java and https://wasmtime.dev/ that extend this embeddability to Java, .net, C, C++, rust, Python, Ruby and Go. Wouldn't want to call those 'JS et al'.

Ofcourse, that ignores the fact that for many of these languages there are existing libraries and drivers to connect to databases that would not work with this embedded one, but still.

u834957920

Everyone is trying to copy DuckDB at this point

SquidJack

Duck db copied from the sqlite

spcldvlpr

Aaand sqlite uses postgres as reference ”what would psqgl do?” I think it is better hate them all.