sqlite
grimoire
sqlite | grimoire | |
---|---|---|
3 | 4 | |
150 | 1,579 | |
- | - | |
3.8 | 9.5 | |
9 months ago | 6 days ago | |
Go | Svelte | |
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
-
[self-promotion] Grimoire - Bookmark manager for the wizards 🧙
A long time ago (9 days), on a distant land (/r/selfhosted), the project Grimoire was announced. Its promise was simple: make bookmarking magical and fun! And open-source, of course!
-
Grimoire: Open-Source bookmark manager with extra features
Hello there! I'm Robert, the creator of Grimoire.
I'm very flattered by such good observations and the warm welcome for this project. I won't be able to respond to every comment from you guys, but you bet I will read them all and take notes!
For now, Grimoire is at 1/10 of its potential, and I will work hard to make it worthy of being a good contender for your default bookmark manager. Definitely, it's missing many features, like a dedicated browser extension, import/export capabilities, and better documentation, and I'm well aware of that.
Was the launch rushed? Maybe, but I thought it would be great to hear your opinions and perhaps even appeal to some potential contributors (wink wink).
For now, I want to address the most common issues that prevent some of you from even running and testing it (clearly an oversight on my side). Then I will write a blog post on https://grimoire.pro to answer some of your questions and doubts, so (if not now, but maybe in the not-too-distant future), give it a chance.
Thank you again, and big kudos to user hunderbong for mentioning Grimoire on HN!
What are some alternatives?
grimoire - Database access layer for golang
omnivore - Omnivore is a complete, open source read-it-later solution for people who like reading.
sqlite-html - A SQLite extension for querying, manipulating, and creating HTML elements.
gomodel
svelte-shortener - An open-source URL Shortener written in SvelteKit with PocketBase.
gormt - database to golang struct
headscale-ui - A web frontend for the headscale Tailscale-compatible coordination server
reform - A better ORM for Go, based on non-empty interfaces and code generation.
go-pg - Golang ORM with focus on PostgreSQL features and performance
recipes - pre-built templates for docker-compose, svelte-kit, golang, pocketbase, rust, python, metabase, drupal, postgres, msql, nginx projects
GORM - The fantastic ORM library for Golang, aims to be developer friendly
markdownload - A Firefox and Google Chrome extension to clip websites and download them into a readable markdown file.