sqlite
htmlq
sqlite | htmlq | |
---|---|---|
3 | 27 | |
150 | 6,930 | |
- | - | |
3.8 | 2.3 | |
9 months ago | 7 months ago | |
Go | Rust | |
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
htmlq
- Htmlq: Like Jq, but for HTML
-
What monitoring tool do you use or recommend?
jq is pretty amazing. If you are comfortable with its jquery-like CSS selector syntax, then I should also mention a couple similar cli utilities that apply it to HTML: htmlp and pup.
- Yq is a portable yq: command-line YAML, JSON, XML, CSV and properties processor
- mgdm/htmlq: Like jq, but for HTML.
- hq: like jq, but for HTML
-
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
-
Any cool cURL/wget tools that you use?
thanks. that reminds me their's a jq for html: https://github.com/mgdm/htmlq
- A CLI to avoid remembering HTTP status codes
- A list of new(ish) command line tools – Julia Evans
- htmlq - like jq, but for HTML
What are some alternatives?
grimoire - Database access layer for golang
pup - Parsing HTML at the command line
sqlite-html - A SQLite extension for querying, manipulating, and creating HTML elements.
ht - Friendly and fast tool for sending HTTP requests
grimoire - Bookmark manager for the wizards 🧙
yq - Command-line YAML, XML, TOML processor - jq wrapper for YAML/XML/TOML documents
tools - all-in collection of productivity scripts, CLI tools, utility libraries, fuse filesystems, and also some stuff
hq - lightweight command line HTML processor using CSS and XPath selectors
cascadia - Go cascadia package command line CSS selector
jql - Easy JSON Query Processor with a Lispy syntax in Go
xidel - Command line tool to download and extract data from HTML/XML pages or JSON-APIs, using CSS, XPath 3.0, XQuery 3.0, JSONiq or pattern matching. It can also create new or transformed XML/HTML/JSON documents.
gitoxide - An idiomatic, lean, fast & safe pure Rust implementation of Git