Other db backends

the thread on sqlite on a net reminded me that i’m still poking around for a new db server. i’d like:

  • oss
  • can be self-hosted or not
  • rest (or rpc) server attached or easy to attach
  • not just a db server, but have backend functionality (this seems pretty universal, but it should be said)

i’ve come across several, to date that are interesting

  • supabase (postgres)
  • pocketbase (sqlite)
  • soul (sqlite)

anyone have something else they’re using?

1 Like

PostgreSQL + postgREST

there are some other REST front ends for PostgreSQL (like psql-api but it looks like its been largely idle for years)

Postgresql is one of my faves :stuck_out_tongue:

Supabase looks like it has the things you want

right. supbase is actually postgres + postgrest + gotrue (for auth), and, as you know, you can self-host it via docker.
what’s wild, though, is there is no account lockout. you can brute force your way in, and there is nothing to stop you.

:exploding_head:
:scream:

the same is true for pocketbase. i have not looked at soul, yet.
supabase does have a hook that could be used to write something, but it’s only available for teams accounts, which cost $500/month. i’ve been talking to them for a couple of weeks about writing a brute-force-limit and submitting a PR, but the mechanism for hooking in is still not defined.

MariaDB? Anybody?

1 Like

Fail2Ban can help with that! I found a filter design proposal but it needs tweaks to actually function. A little light reading and I’m sure you’ll be better off than “let them keep trying.” :slight_smile:

3 Likes

imagine just leaving an admin account exposed to the air

No

PostgreSQL is much nicer and absolutely 100% free for ANY use commercial or otherwise
Maria & mySQL have long had screwy dual licensing

And they just arent as capable IMHO

Valentina DB Server.

Directus.

This is an interesting hosting services for a variety of RDBMSs.