O'Reilly logo

Tkinter GUI Programming by Example by David Love

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating a database and table

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required