|
|
## Defining our relational database
|
|
|
# Toolkit
|
|
|
|
|
|
* Database: [Postgresql](https://www.postgresql.org) v10+, with [JSONB columns](https://www.compose.com/articles/faster-operations-with-the-jsonb-data-type-in-postgresql/) for storing ActivityStreams data as-is
|
|
|
* Data modeling tools:
|
|
|
* [JSON Editor Online](https://jsoneditoronline.org) & [JSON-LD Playground](https://json-ld.org/playground-dev/) or [Hackolade](https://hackolade.com/) for JSON objects
|
|
|
* [SQLEditor](https://www.malcolmhardie.com/sqleditor/) (Mac) or [DBdesigner](https://www.dbdesigner.net) (online) for SQL DB
|
|
|
|
|
|
|
|
|
|
|
|
# Defining our relational database
|
|
|
|
|
|
Starting off with Pleroma's Postgres DB, imported into SQLEditor:
|
|
|
|
... | ... | |