News for hackers. Stuff that matters.
Re:Go port of SQLite without CGo by ehhthing on Saturday April 08, 2023 @01:36AM (#35490838)
Beware: This library seems to have bugs that cause it to break on some writes. Recently held an event that heavily used this library and it broke on us half way through, had to wipe the database and switch it back to the cgo version (the data inside was mostly ephemeral, which was quite a relief).
Re:Go port of SQLite without CGo by adastra22 on Saturday April 08, 2023 @01:46AM (#35490889)
Yeah I would be very suspect about this library. Writing a transpiler that handles all aspects of the C spec correctly is hard enough, to say nothing of replicating stuff that is technically undefined behavior but known to work a certain way. C is not Go and Go is not C--simply rewriting syntax will not result in exactly the same behavior.
Re:Go port of SQLite without CGo by terinjokes on Saturday April 08, 2023 @06:34AM (#35492086)
I've noticed it has different transaction behavior than normal Sqlite, which can cause things to break more easily. I patch Go software that uses it to use the C library as a result, and I stopped having corruption problems.
Re:Go port of SQLite without CGo by dpiddy on Saturday April 08, 2023 @09:03AM (#35492746)
Hey, sorry to hear that. I'm a contributor on the project and if you're able to open an issue (https://gitlab.com/cznic/sqlite/-/issues/new) with any info you have it would be very appreciated.