Moving to Postgres

[brecke]

Here are some links to read as homework before getting down to business:

• https://info.crunchydata.com/blog/easy-postgresql-12-and-pgadmin-4-setup-with-docker
• https://mydbanotebook.org/post/postgres-settings/
• https://severalnines.com/database-blog/overview-join-methods-postgresql
• https://medium.com/@rbranson/10-things-i-hate-about-postgresql-20dbab8c2791

Drivers

• Node-postgres - Github
• Postgres.js

ORMs

• Ship-hold - Github
• Bookshelf - Github
• Typeorm - Github
• Sequelize - Github
• Prisma

Migrations

• Ley

Related tasks / issues

• Create a script to save database dumps and restore them (tip: https://github.com/sdelements/flan)
• Create a docker container with postgres
• Change the oae-demo container

Administration

Having adminJS would be great: https://github.com/SoftwareBrothers/adminjs