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.
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 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...
Summarise Records
Use Summarize Records when you need a summary rather than a list of every record. Create a summary. 1. Add Summarize Records to your workflow. 2. Choose the table and add filters if you only want some records. 3. Open Output and add a calculation. 4. Choose Count, Sum, Average, Lowest or Highest. 5....
Table Field Types
Each table column in Twidget has a data type. The available data types are: - Text - Number - Boolean - Date - Object Field Type Adherence. Data added to the table should adhere to the column's field type. When you manually enter data via the web application, the value editor will use the input type...
