Browsing the database

Browsing the database#

Opening the database and browsing table structure#

../_images/inventory.sqlite-opened-in-rider.png

Fig. 33 Inventory databases’s table Items and its columns.#

  1. Double click inventory.sqlite.

    Data Sources and Drivers window will open up. Below you should see Download missing driver files.

  2. Click Download.

  3. Click OK.

    (Database) tab on the right tool bar will be activated and you will see inventory as shown in Fig. 33.

    You see the that the columns in the table Items correspond to the properties of the class Item.

    Other tables starting with sqlite_ are created automatically by the DBMS. We are going to ignore them.

Browsing table content#

  1. On the Database tool, double click Items. Alternatively click Items then click Edit Data.

    In the editor pane, a new tab Items will open up. It will be empty, because we did not store any data.

Warning

In the following examples we will change the structure of the database. Close the Item tab, after you have changed the structure. Otherwise, Item data can show wrong data.

Contents