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

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!

▲

ncruces 3 days ago | parent [-]

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.

▲

Imustaskforhelp 3 days ago | parent [-]

I love sqlite a lot but there is always this idea in my head that maybe some day I might out grow sqlite and require postgres which in my opinion can be just "enough"

Starting out with postgres if done via pglite and similars with golang's sqlite-ish approach can be brilliant I guess and I had this what if idea sort of inspired by yours actually but I don't think I can do that project basically right now but yea

Idk maybe its offtopic and I really love golang but I am interested in converting cli golang awesome applications into android apps but they seem like a nightmare to create android apps in golang, do you know if there is some easier way to create golang android apps (sorry if its offtopic but I am interested to learn sooo much more about golang :p)?

	▲	Confirm2754 3 days ago \| parent [-]
		[dead]