SQLite Database

SQLite Database Window

In the cloud control backend group control screen casting interface, you can manage and operate databases on devices through the SQLite Database Window.

Opening Steps:
Right-click the target device → Click Functions → Click SQLite Database → Open SQLite Database Window

Main Features

1. View Database
   • Browse existing SQLite database files on the device;
   • Support switching between multiple tables to view table structures and data.
2. Create Tables
   • Support creating new tables in existing databases;
   • Can customize field names, types, default values, primary keys, and other attributes.
3. Edit Table Structure
   • Modify table names, field names, or field types;
   • Support adding, deleting, or modifying table fields.
4. Manage Data
   • View data records in tables;
   • Add new records, delete existing records;
   • Edit data of specified fields;
   • Support batch modification or deletion operations.
5. Execute SQL Queries
   • Can input any valid SQL statements in the SQL execution window;
   • Support query, update, delete, and transaction operations;
   • View SQL execution results and feedback information in real-time.
6. Import/Export Data
   • Support exporting table data to CSV/JSON files;
   • Support importing data from CSV files to specified tables.

💡 Usage Tip: It is recommended to back up before operating the database to prevent data loss due to incorrect operations.