Sign Up

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 fields that you can add or remove according to your needs.

  3. Data Types: Each field has a datatype that dictates the type of data it can store. The available datatypes are:

    • Text

    • Number

    • Boolean

    • Date

    • Object

  4. List Data: Fields can also hold lists of data if specified.

Data Storage

  • Rows: Data is stored in rows within a table. Each row represents an individual data entry.

  • Manual Editing: You can manually edit the data via the web application or through no code commands provided by Twidget.

  • Deletion: Be cautious when deleting data as deletion actions are irreversible. Once data is deleted, it cannot be restored.

Authentication

  • Authentication Table: You can designate a table as an authentication table. This is crucial for authenticating API requests. This table will specifically store user password data to manage secure access.

Related Topics

Database Tables

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 datab...

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...

Generate CRUD Endpoints

With Twidget, you can efficiently generate CRUD (Create, Read, Update, Delete) endpoints for your database tables upon their creation. This functionality is designed to streamline the development process and ensure that essential API operations are readily available. Enabling CRUD Endpoints. 1. Crea...

CSV Import

Twidget enables seamless import of data from a CSV file into your database. Follow the steps below to successfully import a CSV file. Step-by-Step Guide. 1. Initiate the Import: - Click on the Import button within the table toolbar. - Select Import from CSV from the dropdown. 2. Open Import Dialog: ...

Database Storage

Managing your database storage effectively is crucial for ensuring optimal performance and cost-efficiency when using Twidget. Each entry within your database table utilizes a certain amount of storage space. Twidget provides intuitive tools to help you monitor and manage this storage. Viewing Datab...