Skip to Content
Tkinter GUI Programming by Example
book

Tkinter GUI Programming by Example

by David Love
April 2018
Beginner content levelBeginner
340 pages
7h 54m
English
Packt Publishing
Content preview from Tkinter GUI Programming by Example

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Tkinter GUI Application Development Blueprints, Second Edition - Second Edition

Tkinter GUI Application Development Blueprints, Second Edition - Second Edition

Bhaskar Chaudhary

Publisher Resources

ISBN: 9781788627481Supplemental Content