sqlite
octillery
sqlite | octillery | |
---|---|---|
3 | - | |
150 | 189 | |
- | 0.5% | |
3.8 | 0.0 | |
9 months ago | 6 months ago | |
Go | Go | |
GNU General Public License v3.0 or later | MIT 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
octillery
We haven't tracked posts mentioning octillery yet.
Tracking mentions began in Dec 2020.
What are some alternatives?
grimoire - Database access layer for golang
Tile38 - Real-time Geospatial and Geofencing
sqlite-html - A SQLite extension for querying, manipulating, and creating HTML elements.
InfluxDB - Scalable datastore for metrics, events, and real-time analytics
grimoire - Bookmark manager for the wizards 🧙
badger - Fast key-value DB in Go.
go-sqlite - Low-level Go interface to SQLite 3
noms - The versioned, forkable, syncable database
dbr - Additions to Go's database/sql for super fast performance and convenience.
rosedb - Lightweight, fast and reliable key/value storage engine based on Bitcask.
goleveldb - LevelDB key/value database in Go.
go-cache - An in-memory key:value store/cache (similar to Memcached) library for Go, suitable for single-machine applications.