Page 21 - Phyton_GUIprogrammingwithTkinter

P a ge | 12

3.2 SQLite

SQLite is an Open Source Database. SQLite supports standard relational
database features like SQL syntax, transactions and prepared statements. In addition,
it requires only little memory at runtime (approx. 250 Kbyte).

SQLite implements a self-contained, server-less, zero-configuration and
transactional SQL database engine. SQLite is the most widely deployed SQL database
engine in the world.

3.2.1 SQLite Features

a) Self-contained
SQLite is self-contained means it requires minimal support from the operating
system or external library. This makes SQLite usable in any environment especially in
embedded devices like iPhones, Android phones, game consoles, handheld media
players, etc.

SQLite is developed using single ANSI-C. It is easy to compile and easy to add
into a larger project. If we want to develop an application that uses SQLite, we just
need to drop sqlite3.c and sqlite3.h files into our project and compile it with our code.

b) Server-less

Normally, DBMS such as MySQL, PostgreSQL, etc., requires a separate server
process to operate. This is called client-server architecture. The following diagram
illustrates the DBMS client-server architecture:

Figure 3.2: DBMS client-server architecture