sqlite VS grimoire

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...

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

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!

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!