sqlite
grimoire
| sqlite | grimoire | |
|---|---|---|
| 3 | - | |
| 150 | 161 | |
| - | - | |
| 3.8 | 1.8 | |
| 9 months ago | over 2 years 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
grimoire
We haven't tracked posts mentioning grimoire yet.
Tracking mentions began in Dec 2020.
What are some alternatives?
sqlite-html - A SQLite extension for querying, manipulating, and creating HTML elements.
GORM - The fantastic ORM library for Golang, aims to be developer friendly
grimoire - Bookmark manager for the wizards 🧙
gormt - database to golang struct
go-queryset - 100% type-safe ORM for Go (Golang) with code generation and MySQL, PostgreSQL, Sqlite3, SQL Server support. GORM under the hood.
beego orm
gomodel
ent - An entity framework for Go
reform - A better ORM for Go, based on non-empty interfaces and code generation.
QBS - QBS stands for Query By Struct. A Go ORM.
lore - Light Object-Relational Environment (LORE) provides a simple and lightweight pseudo-ORM/pseudo-struct-mapping environment for Go
Zoom - A blazing-fast datastore and querying engine for Go built on Redis.