So let's start...

Previously, we asked one question... Where should permissions live?

If you haven't read the previous note, you can read it here.

So here's the update. I actually implemented RBAC permissions, admins, auth, and database introspection.

In short, the permissions look something like this...

permission(admin, schema, object(table), actions(read, write, delete))

Before, I was also looking into stateless permissions, like using temporary JWT tokens, but I couldn't find a good approach because it was too complex and mostly not stable for what I'm trying to achieve. It's good when you need temporary permissions. Then it's probably one of the best options to explore.

Now the dashboard is finally coming together. I'm mostly going to spend my evenings building the dashboard, then patching things up... just so I can use it on my own projects. I'll keep posting updates here.

I'm also not getting that much time to work on the project, so updates might be a little late.

The second thing I wanted to note down here is that I'm going with SQLite for now. I know it's not ideal because even my own projects are running on serverless, and most people are using serverless too. But I'm still going with SQLite because I just want to finish the project first.

Then I'll spend more time figuring out how to persist the data that actually needs to be persisted in a way that's a good fit for serverless and other environments, while still actually solving the problem.

Thanks for reading.