The sqlite3 module

SQLite is a database technology which comes included with Python, via the sqlite3 module. It works by creating a file on the user's filesystem which is then altered using basic SQL syntax.

Since data stored in a SQLite database is stored on disk, it can be used as a form of permanent storage for web and GUI applications.

Using sqlite in Python is as easy as importing the built-in sqlite3 module and then sending it several SQL queries.

We will be using sqlite to store some data about our chat application on the server. Let's have an introduction to sqlite by creating data storage for the users of our chat application.

Creating a database and table

Inside your server folder, create a new Python file named create_database.py and add the following code:

import sqlite3

database = sqlite3.connect("chat.db")
cursor = database.cursor()

create_users_sql = "CREATE TABLE users (username TEXT, real_name TEXT)"
cursor.execute(create_users_sql)

database.commit()
database.close()

After importing...