Earlier quoted context omitted.
It's pretty easy to statically link SQLite[0]. Are there other disadvantages to CGO? [0]: https://www.arp242.net/static-go.html
Without additional configuration cgo breaks cross-compilation.
A pure Go embedded SQL database
31–40 of 51 posts
Re: A pure Go embedded SQL database
#32The cardinal rule of databases: http://www.dbms2.com/2013/03/18/dbms-development-marklogic-h... Ignoring that leads to long postmortems about how your embedded db failed in a way you didn’t expect: https://blog.roblox.com/2022/01/roblox-return-to-service-10-... SQLite is good Rocksdb is good You don’t need pure go.
Re: A pure Go embedded SQL database
#33Earlier quoted context omitted.
The same author ("cznic") has also built a C-to-Go compiler/transpiler and used it to convert SQLite to pure Go source, so that it doesn't require CGo: https://gitlab.com/cznic/sqlite ... the converted Go code is pretty much unreadable and it's somewhat slower than SQLite via CGo. But a pretty neat idea! I use it in one of my projects and it works well.
I saw that recently. I would be interested in using it but it wasn't clear what level of compatibility it has or how many tests it's passing/not passing.
Re: A pure Go embedded SQL database
#34The cardinal rule of databases: http://www.dbms2.com/2013/03/18/dbms-development-marklogic-h... Ignoring that leads to long postmortems about how your embedded db failed in a way you didn’t expect: https://blog.roblox.com/2022/01/roblox-return-to-service-10-... SQLite is good Rocksdb is good You don’t need pure go.
How many tens of millions of dollars were ploughed into SQLite?
His paycheck alone should be tens of millions of dollars.
He should be making so much money that if he'd drop a 100 dollar bill it wouldn't be worth his time to pick it up.
Re: A pure Go embedded SQL database
#35Earlier quoted context omitted.
I saw that recently. I would be interested in using it but it wasn't clear what level of compatibility it has or how many tests it's passing/not passing.
I think there are many tests used for testing sqlite that are not public. Hipp said so in a podcast I recall.
Re: A pure Go embedded SQL database
#36For one, are you ready to write tests the way SQLite does?
Re: A pure Go embedded SQL database
#37What are the use cases for this? Is this a good fit for Memory based testing for db stores? Also, I can’t seem to find documentation for how this compares to SQLite
Re: A pure Go embedded SQL database
#38The cardinal rule of databases: http://www.dbms2.com/2013/03/18/dbms-development-marklogic-h... Ignoring that leads to long postmortems about how your embedded db failed in a way you didn’t expect: https://blog.roblox.com/2022/01/roblox-return-to-service-10-... SQLite is good Rocksdb is good You don’t need pure go.
Re: A pure Go embedded SQL database
#39use go-sqlite3 to work with sqlite3 is one choice. https://github.com/etcd-io/bbolt is another pure go option. cznic seems like an alternative to bbolt. nice to have some options.
Re: A pure Go embedded SQL database
#40use go-sqlite3 to work with sqlite3 is one choice. https://github.com/etcd-io/bbolt is another pure go option. cznic seems like an alternative to bbolt. nice to have some options.
go-sqlite3 is not pure Go. It is a Go wrapper around the SQLite amalgamation.
There's of course safety issues with C, but sqlite is one of the most rigorously tested sw packages out there.