Insites Docs Instance DataManaging DataCreating a Database

Creating a Database

Last updated on January 16, 2025.

The ability to create and host databases on an Instance is at the core of what makes Insites a powerful platform. These databases serve as repositories for data collection and storage, enabling users to develop applications on the platform that deliver personalised information to users.

You can create a database using one of the following methods:

  • via Visual Builder
  • via JSON

via Visual Builder

To create a database using the visual builder:

  1. Navigate to Data from the main menu.
  2. Select Databases.
  3. Select the dropdown () on the CREATE DATABASE button.
  4. Select via Visual Builder.
  5. Fill out the forms on the following tabs:
    • Configuration
    • Fields
    The input requirements and descriptions for each tab are discussed in its corresponding section in this article.
  6. Select CREATE DATABASE.

Configuration

Use this tab to fill out the following field:

Input LabelTypeRequiredDescription
Database Table Name Input Field Yes The name of the database. Insites automatically cleans and transforms your database name to one that follows internal rules and conventions. For example: 'user's new database' translates to 'users_new_database'.
Database Table Path Display Field No The table path where Insites stores the database.
File Path Folder Selector No The file path to where you want to store your database.

Fields

To add fields or field groups to your database:

  1. Navigate to the 'Fields' tab
  2. Select ADD FIELD or ADD FIELD GROUP.
  3. Fill out the forms for adding a field or field group. Note that depending on the field type and UI element you select, the following tabs are made available for filling out:
    • Properties
    • Appearance
    • Advanced
    • Image Versions
  4. Select SAVE FIELD.

Please refer to our Fields and Field Groups article for more details on adding fields and field groups

via JSON

To create a database using JSON:

  1. Navigate to Data from the main menu.
  2. Select Databases.
  3. Select the dropdown () on the CREATE DATABASE button.
  4. Select via JSON.
  5. Fill out the form.
  6. Select CREATE DATABASE

Input requirements and descriptions for creating a database using JSON are displayed in the table below:

Input LabelTypeRequiredDescription
Database Name Input Field Yes Name of the database.
Table Name Display Field No Name of the database used internally in Insites.
JSON Configuration Code Editor Yes JSON configuration content used to build the database.
Have a suggestion for this page?

Didn't quite find what you are looking for or have feedback on how we can make the content better then we would love to hear from you. Please provide us feedback and we will get back to you shortly.