CityCatalyst Storage Layer

CityCatalyst Storage Layer

For the installable Web API, we will use a PostgreSQL server.

We will use Sequelize migrations to set up and update the database table structures.

Conventions

• SQL tables use snake_case for attribute names and PascalCase for table names
• sequelize ORM models (in TypeScript) use camelCase for property names (to better match the language conventions and so we don't have mixed case in the method names generated for relations using sequelize-auto. We pass the --caseProp c flag to sequelize-auto when generating the models to achieve this.

CityCatalyst Global API

For the Global API, we will import data sets to a PostgreSQL server, running in Amazon's RDS hosted database platform.