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.
For a quick overview of your database storage:
Navigate to your Database Table: Open the database table whose storage you want to view.
Check the Toolbar: The total database usage is displayed in the toolbar at the top of the table. This allows you to quickly assess how much storage space each table is consuming.
To get a comprehensive view of your total database storage usage across all tables:
Access the Dashboard: Go to your Twidget Dashboard.
Review Storage Metrics: The dashboard will display your total database storage usage and quota. This includes cumulative data from all of your tables, giving you a clear picture of your overall storage consumption.
Regular Audits: Frequently check your database storage usage to ensure it remains within acceptable limits.
Optimize Entries: Consider removing obsolete entries or optimizing data storage practices to free up space.
Upgrade Plans: If you are consistently reaching your storage quota, consider upgrading your Twidget plan to accommodate your growing database needs.
By keeping a close watch on your database storage usage and quotas via the table toolbar and dashboard, you can effectively manage your resources and maintain optimal performance in Twidget.
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 Change Triggers
Run an event automatically when a record is created, updated or deleted in a Twidget table. For example, send a welcome message after adding a customer, or refresh a summary when an order changes. Prepare the event. Create an event containing the steps you want to run. Add an Object input named `tri...
Table Relationships
In Twidget, you can connect database table data using the `_id` field that is automatically generated for every row in a table. This `_id` field is essential for creating and maintaining relationships across different tables. Types of Relationships. A one-to-one relationship occurs when a single row...
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...
