[INFO] Is there any DB schema somewhere to look up to? #325

New issue

Closed

opened 2022-11-30 20:22:42 +00:00 by ThePra · 4 comments

ThePra commented

2022-11-30 20:22:42 +00:00

I would like to study tha pleroma/akkoma is structured from the POV of the DB but can't find anywhere any kind of documentation or schema file. Is there any?

luna commented

2022-11-30 20:31:41 +00:00

Contributor

Pleroma and Akkoma use Ecto for database operations, that includes migration and schema management. If you want to take a look at how all the current entities are declared, you want to search for "use Ecto.Schema" across the codebase, and for the schemas that describe database upgrades, they're all in the priv/repo/migrations folder.

Pleroma and Akkoma use [Ecto](https://github.com/elixir-ecto/ecto) for database operations, that includes migration and schema management. If you want to take a look at how all the _current_ entities are declared, you want to search for "use Ecto.Schema" across the codebase, and for the schemas that describe database upgrades, they're all in the `priv/repo/migrations` folder.

ThePra commented

2022-11-30 20:33:36 +00:00

Author

What about the database structure, with it's tables and foreign keys, is there anything that I could throw to diagram maker and see graph?

floatingghost commented

2022-11-30 20:34:39 +00:00

Owner

as said above, that is defined by ecto

👍 1

ThePra closed this issue

2022-11-30 20:35:28 +00:00

luna commented

2022-11-30 20:36:13 +00:00

Contributor

Ecto is a pseudo-ORM, there is no direct schema.sql file you can inspect. If you wish to introspect into all the current table structure with SQL-specific tooling, you want to install Akkoma manually in your machine, and play with a tool like DBeaver for such.

Ecto is a pseudo-ORM, there is no direct `schema.sql` file you can inspect. If you wish to introspect into all the current table structure with SQL-specific tooling, you want to install Akkoma manually in your machine, and play with a tool like DBeaver for such.

👀 1

No milestone

No project

No assignees

3 participants

Notifications

Due date

The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference: AkkomaGang/akkoma#325

No description provided.