In FL0, all projects have a database. You can use this database to store and manage the data of a backend service.

Databases in FL0 are similar to existing databases technologies, so there's not many new concepts to learn. They do, however, offer some extra perks:

  • There's nothing to set up.
  • You can manage the database via the UI.
  • Seamless integration with flows.

This page explores some of the key concepts relating to databases in FL0, including tables, fields, and records. If you'd like a practical guide to working with databases, read Setting up a database.

Tables

Databases are made up of one or more tables.

A table organizes and represents relationships between data. For example, a database for blogging software might have tables for the blog posts, categories, and comments.

You can think of tables as equivalent to sheets in a spreadsheet.

Fields

Tables are made up of one or more fields.

A table's fields define the structure and format of data that can be inserted into the table. For example, a table that stores blog posts might have the following fields:

  • id
  • title
  • body
  • publishedAt

These fields prevent arbitrary data from being inserted into the database.

In other database software, fields are sometimes referred to as columns.

Field options

In addition to a name, all fields have options for configuring the behavior of the field.

The following options are available:

  • Data Type
  • Nullable
  • Default Value
  • Min Value
  • Max Value
  • Reg Value
  • Reference
  • Cascade delete

To learn more about these options, see List of field options.

Data types

All fields have a data type.

The data type of a field determines what type of data can be saved in that field. For example, a table that stores blog posts might have a title field with a data type of String and a publishedAt field with a data type of Datetime.

A field's data type prevents data of an invalid type from being inserted into the database.

Many of the data types that FL0 supports are based on the data types in MS SQL. This means they share many of the features and limitations. FL0 also offers some unique data types, such as Image and Reference.

To learn more about the available data types, see List of data types.

Records

Tables can contain zero or more records.

A record is a data object that conforms to the structure of a table's fields. For example, in a table of blog posts, each individual blog post is stored as a record.

In other database software, records are sometimes referred to as rows.