Page 23 - Phyton_GUIprogrammingwithTkinter

P a ge | 14

Table 3.1: SQLite Storage Classes

Storage Classes Description
NULL Store a null value
INTEGER Store a signed integer, stored in 1, 2, 3, 4, 6, or 8 bytes
depending on the magnitude of the value
REAL Storing floating point value
TEXT Storing text or strings
BLOB The value is a blob of data, stored exactly as it was input.

3.2.3 SQLite Management Tools

SQLite Expert is a Free GUI-based management tool for SQLite databases. With this
application we can easily manage the database that we have created. The interface of
SQLite Expert is as shown in Figure 3.4 below.

Figure 3.4: SQLite Expert Interface

We can download it for free. To download SQLite Expert application just go to URL
below.

https://sqlite-expert-personal.software.informer.com/download/