Sign Up
Loading...

Generate CRUD Endpoints

Watch the walkthrough

Generate CRUD Endpoints

Generate create, read, update and delete endpoints from a table.

Recorded with an earlier Twidget interface. Names, control locations and available options may differ; use the linked documentation for current guidance.

Watch tutorial (4:21)

Browse all video tutorials

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. Create a New Table:

    • When creating a new table in Twidget, you'll encounter the option to automatically generate CRUD endpoints.
  2. Tick the Checkbox:

    • Look for the checkbox labeled "Generate CRUD Endpoints" during the table creation process.

    • This checkbox is ticked by default to save time and provide immediate access to key operations.

  1. Automatic Endpoint Generation:

    • Upon ticking this checkbox, Twidget will generate the following endpoints for your table:

      • Create Endpoint: Allows adding new records to your table.

      • Read Endpoint: Fetches data from your table.

      • Update Endpoint: Updates existing records within your table.

      • Delete Endpoint: Removes records from your table.

After generating the CRUD endpoints, you can tailor them to your specific needs through Twidget's API view:

Best Practices

  • Review Generated Endpoints:

    • Always review the automatically generated endpoints to ensure they meet your application requirements.
  • Access Control:

    • Implement necessary access control measures to ensure your API endpoints are secure.

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

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

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

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

Adding Database Table Rows

In Twidget, you can easily add new entries (rows) to your database tables. This feature allows you to expand your data dynamically without the need for complex coding. This document provides a step-by-step guide on how to add rows to your database tables. Adding a New Entry to a Table. To add a new ...