Rust Bindings

[callum-gander]

Are there any future plans to add Rust bindings for this? I can see this as an appealing alternative to bundling up Postgres as a sidecar for things like Tauri apps or using SQLite. Thanks

[realmorrisliu]

Are there any future plans to add Rust bindings for this? I can see this as an appealing alternative to bundling up Postgres as a sidecar for things like Tauri apps or using SQLite. Thanks

Maybe you could try using pglite directly within Tauri’s webview? I’m not sure if it will work, but it could be an interesting alternative to bundling Postgres as a sidecar.

[callum-gander]

That doesn't feel very secure imo, feels like it should sit on the rust side rather than in the webview, but appreciate the idea

[pmp-p]

Not keen on Rust, but maybe a valid approach would be to just run pglite inside rust with https://docs.wasmtime.dev/lang-rust.html like it was done for Go here #89

To go further than that POC you would need to pick a rust postgres wire protocol client crate though.

[dlight]

Besides wasm, can pglite also build to native code? Getting Rust to run regular wasm pglite would be awesome, but the downside is that it would still require a wasm runtime. Embedding a native build of pglite as a library in a Rust program would be very useful, if at all possible.

Right now what exists in Rust for "embedding" Postgres is pg_embed and postgresql-embedded. They can use native binaries from embedded-postgres-binaries (which is a trimmed down Postgres made for testing SQL queries in the Java ecosystem), or, in the case of postgresql-embedded, also from postgresql-binaries. pg_embed downloads the Postgres binary in the first run, and postgresql-embedded can also do that, but can package the Postgres binary inside its own binary to make distribution easier, extract it somewhere in the first run either way - Postgres still runs as a separate program. An upside for postgresql-embedded is that it supports Postgres extensions though.

[tdrz]

Besides wasm, can pglite also build to native code?

Not yet, but we'd like it to. See the last part of this comment.

[realmorrisliu]

Super excited for libpglite to come!

[evanlhatch]

Besides wasm, can pglite also build to native code?

Not yet, but we'd like it to. See the last part of this comment.

native rust would be huge for me- any idea on when this will be coming?

[pmp-p]

i think the correct way -now- would be to embded wasmtime. Only wasm sandboxing can offer safety that would be lost by compiling pglite as transpiled rust and/or unsafe C library.

Wasmtime embedding is quick, easy and ultra portable. Any other mean would probably be only possible as a long term project.

[paulm17]

Why is wasmtime the way to go?

We want to extract the core changes to Postgres that we had to make and create a "libpglite" C lib that can be linked to from any language/platform.

Taken from: https://news.ycombinator.com/item?id=41225185

Wouldn't a libpglite be the most preferable way?

unsafe C library.

Wouldn't any issues be handled the rust side?

[TheKnarf]

I'd love a working example to work off on if anyone has gotten wasmtime + pglite wasm file working.

[f0rr0]

I was able to get some basic stuff working for rust and wasmtime here: pglite-oxide

[yujonglee]

@f0rr0 super cool. what are current limitations?