sqlite
sqlite-html
| sqlite | sqlite-html | |
|---|---|---|
| 3 | 4 | |
| 150 | 359 | |
| - | - | |
| 3.8 | 6.9 | |
| 9 months ago | 9 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
sqlite-html
What are some alternatives?
grimoire - Database access layer for golang
sqlite-spellfix - Loadable spellfix1 extension for sqlite as python package
grimoire - Bookmark manager for the wizards 🧙
sqlite-icu - Loadable ICU extension for sqlite as python package
sqlite-path - A SQLite extension for parsing, generating, and querying paths
sqlpkg-cli - SQLite package manager
sqlite-loadable-rs - A framework for writing fast and performant SQLite extensions in Rust
sqlite-url - A SQLite extension for parsing, generating, and querying URLs and query strings
pdftk-heroku - PDFTK binaries for Heroku
sqlite-ulid - A SQLite extension for generating and working with ULIDs
sqlite-jsonschema - A SQLite extension for validating JSON objects with JSON Schema
sqlite-regex - A fast regular expression SQLite extension, written in Rust