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 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...
Related Records
Include related information in the same result instead of adding a separate lookup for each record in a list. Example: orders with customers. Suppose your Orders table stores a `customerId`, and your Customers table contains the corresponding customer record. 1. Add Get Multiple Data and select Orde...
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...
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: ...
