Working with Databases Guide

This guide provides instructions on how to work with databases in our platform. There are several methods to manage and manipulate your databases.

Method 1: Content Tables

  1. Navigate to the main dashboard of the platform.

  2. From the left-hand side menu under the “Manage” section, select “DATABASES”.

    _images/open_content_menu.png

  3. This will show a list of all connected databases. You’ll see the database name, type (dialect), and four methods for each database:

    • Get: Retrieves all tables from the selected database and creates a dark box for each table in the platform. These boxes can be used for further operations like select, update, insert, delete, etc.

    • Edit: Opens a new form with prefilled database connection details. You can change any field and press “Submit” to update the connection details.

    • Test: Tests the connection to the selected database.

    • Remove: Removes the connection to the selected database.

    _images/content_menu.png

Method 2: Using Database Node

  1. From the left-hand side menu under the “Build” section, select “DATA SOURCES”.

    _images/data_sources.png

  2. Then, select “Add Database”. This will create a new database node which can be used for further operations.

    _images/add_database_form.png

Method 3: Using Database Operation Nodes

  1. In the left-hand side menu under the “Build” -> “DATA SOURCES” section, you will find nodes called “DB Select”, “DB Insert”, “DB Update”, “DB Delete”, “DB Query”, etc.

    _images/database_nodes.png

  2. Click on the node based on the operation you want to perform. For example, if you want to select from a database, click “DB Select”. This will create a “DB Select” node and open a form on the right side of the platform.

    • Database: Choose the database from which to select data.

    • From: Choose the table from which to select data. To select all columns, use the “*”.

    • Select: Enter the columns to select, separated by commas.

    • Where section: Enter the conditions for the operation.

    • Column: Enter the column for the WHERE condition.

    • Operator: Select the operator for the WHERE condition (e.g., <, >, =).

    • Value: Enter the value for the WHERE condition. The query will select rows where the column “operator” value condition is met.

    • Limit: Enter the maximum number of rows to retrieve.

    • New Variable: Enter the name of the new variable. This will hold the selected dataframe.

    _images/db_select_node.png