Maybe it's because I'm not an RBAC expert, but I had a hard time understanding the data model for folders. Are they a subject? And then there's a layered CASL where layers overwrite each other? And the user is an actor?

Pop a screenshot in your README please!

I just started diagramming with d2- I'll have to try this one out!

The great thing about using a package manager is that it also handles updating and uninstalling software, not just the initial install

Sure, but the point is (1) that you don’t need a package manager to install software, which the comment I replied to seemed to assume, and (2) that for something you’re developing against like SQLite, installing it via package manager really isn’t that important. It doesn’t need to integrate with the rest of your system the way typical apps might.

What seems to be happening here is that people have learned that package managers are the right way to install software, but they don’t really understand the reasons, or where and how exceptions might apply. IMO your comment does that as well.

Even for a personal project such as the one in the blog post, I'd still rather use a package manager to install SQLite.

It's POSSIBLE to build it from source, and manually re-download the source and C compiler (and any dependencies, though I'm not sure SQLite has any) when I want to update and instruct any collaborators to do the same thing... But I'd still rather automate it all with a package manager.

Especially because I'm probably also handling other dependencies in the project and I value the uniform simplicity of using a package manager for all of them

How are you using dbos with SQLite? The docs say its a Postgres library

Hello, I'm from DBOS.

Our Golang and Python SDKs support SQLite as well as Postgres.

Interesting, it's not mentioned anywhere in the https://github.com/dbos-inc/dbos-transact-golang README. By contrast, Postgres is mentioned right at the top.

I recommend updating the README to mention SQLite somewhere, with maybe a link to https://docs.dbos.dev/golang/reference/configuration#using-s... ?

I love XFCE, but I switched to KDE as it supports Wayland (and I want to use WayDroid). KDE has a similar window + shortcut philosophy.

Safer? From a mental health perspective? Tbh I like human names

um no. from a technical design perspective, obviously.

Entropy finds a way :)

What don't you like about SQLite views or foreign keys?

For example you can’t insert or update a SQLite view.

I don’t even think SQLite lets you fully update a table schema.

If you start trying to use it for sql and not just storing rows you run into these everywhere. SQLite is not serving the same needs as Postgres.

You can use a trigger with INSTEAD OF to update a view:

CREATE TRIGGER update_customer_emails_trigger INSTEAD OF UPDATE ON customer_emails BEGIN UPDATE customers SET email = new.email, name = new.name WHERE id = old.id; END;

Maybe that's not as flexible as you need.

SQLites process for table updates can be pretty onerous if their ALTER TABLE lacks support. Its a 12 step process the docs have the temerity to call "simple" instead of "tedious and risky" - https://www.sqlite.org/lang_altertable.html#otheralter

Yes, friction like this. It’s just not a fully featured SQL implementation.

As their saying goes, it competes with fopen not oracle.

I'm actually most excited about the new funding model: https://acadia.engineering/license/faq

I won't be able to use Acadia at work, and I don't have the risk tolerance to use it for personal projects, but I'm looking forward to seeing how/if this model pays the bills. Can it compete with more liberally licensed code?