Sign Up
Loading...

Database Tables

Watch the walkthrough

Browse all video tutorials

Database tables are essential components of your Twidget workspace, serving as the primary storage locations for your data. In Twidget, each table consists of rows and fields, meticulously designed for efficient data management and retrieval.

Structure of Database Tables

  • Rows: Each row in a database table represents a single data entry or record.

  • Fields: Fields are the individual columns in a table that store specific types of data. Each field has a designated datatype, and the data stored within must conform to this datatype.

Key Field Attributes

  • Datatypes: Each field in a table is assigned a datatype, which dictates the kind of data that can be stored in that field (e.g., text, number, date).

  • System-Generated Fields: Each entry in a table automatically includes a unique identifier (_id) and a timestamp (created_at) indicating when the entry was created.

Table Management

Twidget provides robust features for managing your database tables:

  • Edit Table: You can modify the structure of your table by adding or removing fields as needed.

  • Manage Data: Manage the entries in your table effortlessly with tools for editing, deleting, and viewing records.

Authentication Table

  • Special Table: Each workspace in Twidget can have one authentication table. This table is critical for storing user data and authenticating requests.

Data Operations

  • View Data Usage: Monitor your table’s data usage statistics via the tables toolbar located at the top of the page.

  • Import and Export: Easily import data into your table or export it for external use.

  • Filter and Sort: Utilize the filter and sort tools to refine the data displayed in your table according to specific criteria.

Database tables in Twidget are powerful and flexible, allowing you to efficiently store, manage, and interact with your data. From automatic system fields to comprehensive data operations and authentication functionalities, Twidget tables provide a robust framework for your no-code applications.

Related Topics

Database Indexes

Indexes help Twidget find records quickly. A unique index also prevents duplicate values from being saved. Choose the right index. Use a lookup index for a field you regularly filter or sort, such as an order date. Use a unique index when a value must not appear twice, such as a membership number. A...

External Database Connections

Read records from an existing external database without copying all of its data into Twidget. Add a connection. 1. Select your workspace and open Settings → Database Connections. 2. Select Add database connection. 3. Choose the provider: PostgreSQL, MySQL, SQL Server or Snowflake. 4. Enter a connect...

Database Basics

Twidget offers a comprehensive database solution for all workspaces. Here's an overview of how databases are structured and managed within Twidget: Database Structure. 1. Tables: A database may contain multiple tables. Each table stores data in a structured format. 2. Fields: Tables consist of field...

Save Changes Together

A Database Transaction groups database work so its changes complete together. If a command in the block fails, the block's changes are rolled back. Example: an order and its stock change. 1. Add Database Transaction to the workflow. 2. Inside Save changes together, add the supported commands that cr...

Authentication Table

An authentication table is a crucial component in Twidget that is used to store all necessary authentication information, essential for authenticating requests. Overview. - Purpose: To store authentication details such as email, password, token signature, and reset key. - Recommendation: It's recomm...