Inside your server folder, create a new Python file named create_database.py and add the following code:
import sqlite3database = 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 the sqlite3 module, we connect to a database named chat.db. This database will become a file inside our server folder once the code has run.
We use this connection to receive a cursor, which is able to perform SQL queries over a database.
The SQL query to create a table inside our database comes next. It is customary to write the keywords of SQL in capital letters to easily distinguish ...