Setting up a database

By default, all projects in FL0 have a database. There's nothing to install or provision. Simply create a database table via FL0's UI and then configure the table's fields and data types.

This tutorial uses a to-do list management application as an example how to create and configure a database table.

Prerequisites

  • You have a FL0 account.
  • You're familiar with fundamental database concepts, such as columns and rows.

Step 1: Create a project

  1. Log in to FL0.
  2. Click Create a new project.
  3. In the Project Name field, enter Todo.
  4. Select a hosting region.
  5. Click Save.

Step 2: Create a database table

  1. In the Explorer pane, click Create new.
  2. Select Table.
  3. Type Tasks.
  4. Tap the Return key.

Step 3: Add fields to the table

  1. Switch to the Configuration tab.
  2. Create a row to store the name of the task.
    1. In the Name field, enter Name.
    2. From the Data type dropdown, select String.
  3. Create a row to store the status of the task.
    1. In the Name field, enter IsComplete.
    2. From the Data type dropdown, select Boolean.
    3. Enable the Nullable option.
    4. Enable the Default value option.
  4. Click Save.

Warning: You can't edit fields after creating them. To edit an existing field, first delete it and recreate it.