CommonsPub has chosen Postgresql as the default database for building ActivityPub applications.
There's another speaker at the same conference complaining about performance of #diaspora* with RDBMS. He created an #ActivityPub project called #Mammoth which uses #CouchDB.
@njoseph wondering about that too
Very interested in #TerminusDB graph database (RDF storage, JSONLD wire format, time-travel, git-like branching and merging).
Some #ActivityPub libraries, like @Cj #gofed support AP extensions as JSONLD-formatted OWL2 (subset) vocabularies. Currently they are used for compile-time codegen of strongly-typed #golang code. But wouldn't it be great if this could be done dynamically somehow and stored in a DB with native support for vocabs?
@njoseph Also note the publish–subscribe pattern, could we publish and subscribe to JSON?
The social network of the future: No ads, no corporate surveillance, ethical design, and decentralization! Own your data with Mastodon!