A CGo-free port of SQLite/SQLite3

by tosh • 2 months ago

56 31 2 months ago

pstuart• 2 months ago

So is this a handmade port vs the translated port done by modernc?

vicek22• 2 months ago

modernc is the name of the GitHub fork (identical repo) of the same project. This is machine translated, not hand written.

spwa42• 1 month ago

It's machine translated with TLA, tested, and finished by adding a few extra pure go mechanisms (such as Go code-backed virtual tables)

yodon• 2 months ago

Seems like there are some trademark issues with just calling this SQLite.

downrightmike• 2 months ago

SQL would have been SEQL if not for trademark issues, the torch is passed

9rx• 2 months ago

SEQUEL. It was a play on QUEL [https://en.wikipedia.org/wiki/QUEL_query_languages].

tptacek3• 1 month ago

It's cznic/sqlite in Go-land; this is just a quirk of HN titling.

gnabgib• 1 month ago

A quirk of this submitter's choice? We've seen it several times before without the trademark violation:

2023: Go port of SQLite without CGo (255 points, 118 comments) https://news.ycombinator.com/item?id=35488980

2020: Cznic/sqlite: Sqlite in pure Golang (no CGO) (6 points, not interesting for discussion.. this project is old) https://news.ycombinator.com/item?id=24358826

(7 other similar submissions)

jsherer• 2 months ago

I was confused a few weeks ago. Check out the go pkg: https://pkg.go.dev/modernc.org/sqlite

1. gitlab.com/cznic/sqlite is the primary repo

2. github.com/cznic/sqlite was the github mirror but it moved

3. github.com/mordernc-org/sqlite is the read-only mirror of the primary repo

Cheers!

porjo• 2 months ago

3. github.com/mordernc-org/sqlite is the read-only mirror of the primary repo

Typo, should be: github.com/modernc-org/sqlite

usrnm3• 2 months ago

The readme really lacks the answer to the "why" question. What's the use case, why should I prefer it over real sqlite?

blubber• 2 months ago

Because it's cgo-free maybe?

usrnm3• 2 months ago

Cgo overhead is trivial compared to what's happening inside a database engine, totally not worth it

ameliaquining2• 2 months ago

The "port" terminology is misleading; this is real SQLite, compiled from C to Go using https://gitlab.com/cznic/ccgo/-/tree/master/v4 (by the same author; this library is its most widely used application). The use case is that a lot of Go codebases prefer to completely eschew FFI because a lot of the nice properties of Go's tooling and whatnot (cross-compilation is trivial, binaries are automatically static on Linux, etc.) only hold if the entire build is pure Go.

ivanjermakov• 2 months ago

So because of Go's design mistakes.

tptacek3• 1 month ago

The biggest reason you'd want a cgo-free sqlite is if you're cross-compiling; for instance, from your macOS dev laptop to an x64 dev server.

spwa42• 1 month ago

Exactly. Even though your m5 max laptop will run the x86 binary just fine, if you don't compile it for arm, your m5 max laptop drops most of its speed and only has the same performance as an x86 server ...

0x20cowboy• 1 month ago

If your codebase is pure golang it’s trivial to cross compile for different OSs (aside from binary signing on macOS). If you add some kind of C code you have to jump through a bunch of hoops to get a binary. Funny enough, I was looking for this exact project for that reason last week.

ncruces• 2 months ago

There's also my take on this [1], which does machine translation from C to Go via Wasm using [2].

It's a somewhat less faithful translation, since I manually ported the VFS (SQLite OS abstraction layer).

OTOH, each SQLite connection is sandboxed (can't access/corrupt Go memory, or other SQLite connections). And it should run everywhere Go runs.

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

2: https://github.com/ncruces/wasm2go

pjjpo• 1 month ago

This project seems to get shared every month or so. It's really sad that HN's signal to noise has fallen this hard... While I continue to have it in my feed, I'm more and more opening up Reddit since it just feels more robust now adays.

A CGo-free port of SQLite/SQLite3

Related Stories