Wouldn’t a zero-knowledge hosting solution (you provide hosting, but you can’t see what’s into it past a stream of binary) help with that?

If you mean citizenship as being associated to the city whose hosting services you are using, yhe power or water bill pointed at your name and residence should be able to do that. Now, if you want that plus anonimity, the only practical option I can think of for a city-wide physical campaign is some sort of GPG Signature Meetup (“signature party”).

Zero-knowledge hosting solutions should help with that, but I’m unsure how the tech and UX has been going for that on FOSS as of yet.

Maybe, really.

It locks you to postgres. You don’t necessarily have full control over postgres unless you are using your own instance / service, but oftentimes you might need to connect to an external one. SQLite gives you a local option.

Also what do you even mean with “does it store passwords?” A password is just a TEXT or a BLOB if you are feeling charitable and SQLite does support those since forever. If you can store “hello world” you can store a password (just… don’t do it in plaintext, but storage is different from encryption).

blorp

The Fediverse. Poob has it for you.

It does mean a form of provider lock-in, which is or can be its own issue. Also, while PostgreSQL is one of the best database engines out there among the FOSS stuff, it is verifiably and vastly overblown for stuff like “store a name and a email”, and I at least am not aware of any sort of “Postgres Lite” engines else I’d be using them at work.

Positives: nice uwu art.

Negatives: requires javascript, intrinsically ableist.

Ideally on a platform similar to Gmail in its decentralized nature

Really? This is the key to understanding that you don’t even know what you’re talking about.

“No. Get more info on that for $35/mo!”