logoalt Hacker News

Imustaskforhelplast Tuesday at 10:18 AM1 replyview on HN

I knew I remember your name working with something of sqlite and golang

https://github.com/ncruces/go-sqlite3

Man I really enjoy golang and cross portability and wazero + sqlite could still be cross portable which is super fascinating

What are your thoughts on https://github.com/electric-sql/pglite (postgres in wasm)?

Also what were the goal behind a pure golang solution via wazero + wasm sqlite as you had made?

Was it cross platform support, if so, what are your thoughts on zig, I have seen a project use zig + golang to create cross platform C language support but I think that adding zig into the picture complicates the build process so there are tradeoffs and I am interested to hear your opinions about it!


Replies

ncruceslast Tuesday at 10:55 AM

Started as fun "what if" side project, but kept me interested for 3 years now. Turns out it's actually useful.

It's pretty portable: with some caveats, it works pretty much everywhere Go does. Performance is bad outside amd64/arm64, but for most popular OS/platforms it's fine. See this for an overall picture (these are the platforms I test): https://github.com/ncruces/go-sqlite3/wiki/Support-matrix

I bet you could do the similar with pglite, but this (and helping out with wazero) already consumes all my spare time.

show 1 reply