Use the built-in database: tables, records and imports.
To add the built-in TeleportHQ database, open Data Sources in the editor's left sidebar, click + (Add Data Source), choose TeleportHQ database and click Setup TeleportHQ Database; TeleportHQ creates a hosted database for the project that you then fill with tables.
On Pro and Premium, a TeleportHQ database holds up to 200,000 records per table, 3,000,000 records in total and 2 GB, with up to 30 tables, 20 columns per table and 20 indexes; a database created during the trial gets the lower tier (5,000 records per table, 15,000 in total, 50 MB) and becomes inactive after 7 days.
In TeleportHQ, you create tables from the Add a new table card of your database in the Data Sources panel, either by filling in the Create New Table form or by describing the tables you need in the Create Tables with AI window.
In TeleportHQ, Import from File on your database's Add a new table card turns a CSV, Excel (.xlsx), OpenDocument, JSON, SQL dump or SQLite file into new tables with their rows, and the upload button in a TeleportHQ database table's window imports a CSV into that existing table, updating matching rows and adding the rest.
In TeleportHQ, you manage a database table's rows in its table window, opened with View Data in the Data Sources panel: click Create Record to add a row, double-click a cell to change it, open a row's menu for View Details or Delete Record, and use the SQL view to look up rows with a query.
In TeleportHQ, you change a table's columns in the Structure view of its table window: click Add Column to add a field, the pencil (Edit column) to change one, tick Foreign Key to link a column to another table, and use Recent changes to revert a change you made.
A TeleportHQ database on the lower tier, which includes every database created during the trial, becomes inactive 7 days after it's created or after a subscription ends, so logins, the store, bookings, the blog and anything else that uses it stop working; subscribing to Pro or Premium within 30 days restores it from its backup and moves it to the paid limits.
