Store and manage data with a hosted Postgres Database. database-header Every Fastgen project comes with its own dedicated PostgreSQL Database. Within this database you can create unlimited tables to manage and store data records of your application. You have two ways of interacting with the database:
  • Programmatically, through the DB Query Action within your APIs & workflows
  • Manually, to make edits directly in the UI

​
Creating a table

Navigate to Database on the left side bar and click Add table in the top right. Give your new table a unique name, specify columns settings and create a new table with a click of a button.

​
Column Settings

You can apply individual data validation settings for each column you add to your table. Specify the column data type, which columns are required, have to be unique in name as well as which ones serve as primary or foreign keys. Index will improve the query performance for a record but be careful not to create too many indexes on one single table because more indexes means the database needs more time for insert and delete operations getting incrementally slower the more indexes there are. So best to have between one or five indexes per table.