digital community which I founded in Slovakia in 2002

still used by few hundred people

architecture based around the principle "all nodes are functionally identical"

MySQL database; core tables: "nodes", "neurons" and "node_access"

Learn SQL

what You want to use is PostgreSQL and nothing else than PostgreSQL

hstore is Your friend https://www.postgresql.org/docs/current/hstore.html