Due to an influx of spam, we have had to temporarily disable account registrations. Please write an email to firstname.lastname@example.org, with your desired username, if you want to get access. Sorry for the inconvenience.
Change our DB backend from MariaDB to PostgreSQL.
For easier transition (codebase + data migration) we lowercase column names and use unquoted table names. This allows us to continue to use PascalCase in the codebase for the ORM as well as manually written SQL statements (git hook scripts) while at DB level everything is lowercase.
We might want to still change this in the future and f.e. switch to snake_case...
In terms of performance we should be pretty much on-par with MariaDB, although there are a few scenarios that are either in favour one or the other: So somewhat of a mixed-bag really. Now there is probably still some room for improvement/fine-tuning for postgres. Some benchmarks can be found linked below.
ToDo - Migration:
aurweb ansible playbook at infra (MR infrastructure!769). We can combine these with a new release also.