BobaBoard uses a PostgreSQL 12 database. There is no plan to allow different types of underlying DBs, which means we can rely on PostgreSQL-only constructs. That said, for ease of onboarding of new engineers, standard SQL functionality should be preferred.

Naming & Conventions

• Database tables should use plural names.
• Words are separated by _ (snake case).

Base Tables Structure

The base tables structure is defined in db/init/000_init.sql. Splitting up the initialization code in logical chunks is on the TODO list.

Views

Views are defined at db/init/100_views.sql.

TODO

Queries

Test Database

The test database init data is defined at db/test_db_init/.