sqlite
go-sqlite
sqlite | go-sqlite | |
---|---|---|
3 | 12 | |
150 | 677 | |
- | - | |
3.8 | 7.6 | |
9 months ago | 13 days ago | |
Go | Go | |
GNU General Public License v3.0 or later | ISC License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
sqlite
-
Row Level Security Extension for SQLite Feasiblity
A recent project has me happily using SQLite but I am missing having Row Level Security (RLS) for my application. I searched around and SQLite has no out-of-the-box or 3rd party ext support for RLS.
I am seeing that 1) we can load extensions into SQLite (see attached URL), and 2) that extensions can create modules with pretty rich functionality. Maybe a virtual table impl with `xFilter` and/or `xNext` fns could help yield the row filtering, plus some custom fns to add some state used during the query to configure the dynamic constraint?
Interesting idea? Plausible?
I also saw someone made some handy golang bindings, which could add a few niceties to writing such an extension (albeit heresy to some, to lodge Go into SQLite :)).
https://github.com/riyaz-ali/sqlite/blob/master/virtual_tabl...
-
SQLite-HTML: A SQLite extension for querying, manipulating, and creating HTML
Hey, author here, happy to answer questions! A few other recent posts/tools that you may be interested in:
- sqlite-lines discussion from a few days ago: https://news.ycombinator.com/item?id=32288165
- htmlq, Rust CLI for (like jq but for html): https://github.com/mgdm/htmlq
- The Go library that sqlite-html uses for making runtime-loadable SQLite extensions https://github.com/riyaz-ali/sqlite
- sqlean, a ton of other helpful SQLite extensions (in C): https://github.com/nalgeon/sqlean
- Build SQLite Extensions in Go
go-sqlite
-
JSON Canvas β An open file format for infinite canvas data
Check out https://github.com/zombiezen/go-sqlite if you're interested in trying out Sqlite in Go again. Nice interface, negligible compile time impact, fast, compiles without CGO. It's very comfortable.
I agree that going from text to sqlite is a bit of a hurdle, especially if you're not writing C :)
-
Jsonfile: A Quick Hack for Tinkering
struggling figuring out how to make my cgo sqlite cross-compile to Windows
Plenty of people trying to fix that.
There's at least:
https://modernc.org/sqlite
Then there's https://github.com/zombiezen/go-sqlite that actually builds https://crawshaw.io/sqlite on top of modernc.
And there's mine that has both a low level and a database/sql driver builds and runs everywhere Go does: https://github.com/ncruces/go-sqlite3
-
Any Full Text Search library for json data?
There are several different Go bindings for SQLite. I maintain https://pkg.go.dev/zombiezen.com/go/sqlite
-
Whatβs your preferred setup to work with SQL DB (without ORM) ?
I like and use https://github.com/zombiezen/go-sqlite for CGo-free SQLite. It avoids some of the problems database/sql has, discussed here: https://crawshaw.io/blog/go-and-sqlite.
- SQLite in Go, with and Without Cgo
- A pure Go embedded SQL database
-
Containerize Go and SQLite with Docker β 9MB Image Size
> C libraries are required to interact with SQLite
Or: modernc.org/sqlite (https://github.com/zombiezen/go-sqlite), "an automatically generated translation of the original C source code of SQLite into Go"
- Gokrazy β A Native Go Userland
-
Library for sqlite3 recommendations?
https://pkg.go.dev/modernc.org/sqlite via https://pkg.go.dev/zombiezen.com/go/sqlite
-
New advanced, CGo-free SQLite package
modernc.org/sqlite provides a database/sql driver, but does not (currently) provide an easy way to get at the more advanced functionality of SQLite, like streaming blob I/O or user-defined functions. David Crawshaw has argued that the database/sql API is not a good fit for SQLite, which is how crawshaw.io/sqlite came about.
What are some alternatives?
grimoire - Database access layer for golang
go-sqlite3 - sqlite3 driver for go using database/sql
sqlite-html - A SQLite extension for querying, manipulating, and creating HTML elements.
bbolt - An embedded key/value database for Go.
grimoire - Bookmark manager for the wizards π§
distroless - π₯ Language focused docker images, minus the operating system.
bun - SQL-first Golang ORM
bun - Incredibly fast JavaScript runtime, bundler, test runner, and package manager β all in one
sqlite - Go SQLite3 driver
chai - Modern embedded SQL database
go-sqli - Interfaces for Golang's 'database/sql' and 'sqlx'.
ql