Explore the DB Studio interface
Explore the library, tables, queries, forms, reports and document tabs with a fictional practice database.
What you'll learn
You will find your way around the library, navigation pane, document tabs, Data/Design switch and app menu. You will explore a table, a query, a form and a report in Prototype workshop, then export a copy.
Before you begin
Open https://db.pyroom.app/ on a desktop computer. The relationship view and query designer used in this tour are desktop-only. Table design also works on tablets.
The video uses the English interface and a fictional teaching sample. The menu button in the top bar is labelled Application menu; its Language controls let you choose English or Ukrainian. Create the sample in English to match the object names in the video.
Steps
- Start in My databases. Click All samples and choose Prototype workshop to create and open it. The library holds databases stored in this browser; each database has its own card.
- In the navigation pane, find Tables, Queries, Forms and Reports. Under Tables, open Tool kits. Its document tab appears above the workspace, and the record counter shows 24 records. Each row is a record; each column is a field.
- Click Design to inspect the field names and types. Find ID and its key mark, then click Data to return to the stored values.
- Click Data schema in the navigation pane. A new document tab opens. The connection joins Work areas to Tool kits: one work area can have several kits, while each kit belongs to one area. Tabs keep the objects you have opened together above the workspace.
- Under Queries, open Ready for use and click Run. This saved SQL query shows 16 ready kits ordered by Unit cost, highest first. It reads the existing table to answer a question about the data.
- Under Forms, open Record card. Click Next record and watch the values change together. The form presents one record at a time with labelled controls.
- Under Reports, open Group overview. Inspect the groups and summary values. The report presents the inventory for reading rather than editing individual records.
- Click the PyRoom Database Studio logo to return to My databases. Open the menu on the Prototype workshop card and choose Export. The browser downloads Prototype workshop.sqlite.
Expected result
You can identify the four object sections, recognise document tabs and distinguish Data from Design. You know where the app menu and language controls are. Prototype workshop remains in this browser, and you also have an exported .sqlite copy outside browser storage.
Common mistakes
- The library lists databases; the navigation pane lists objects inside the open database.
- Design shows the table structure. Return to Data to see records.
- The app menu and the menu on a database card are separate controls. Use the card menu for the export shown here.
- Clearing site data deletes the browser's stored databases. Keep your exported file somewhere you can find it.