Adding Database & Authentication To Tkinter Apps In 8 Minutes

Tkinter is a popular GUI library for Python that allows you to create desktop applications with a graphical user interface. However, adding database and authentication features to Tkinter apps can be a bit challenging. In this article, we will show you how to easily add database and authentication to your Tkinter apps in just 8 minutes.

Step 1: Install Required Libraries

First, make sure you have installed the necessary libraries. You will need sqlite3 for the database and bcrypt for password hashing. You can install them using the following commands:

pip install sqlite3
pip install bcrypt

Step 2: Create a Database

Create a new SQLite database file using the following code:

import sqlite3

# Create a connection to the database
conn = sqlite3.connect('app.db')
cursor = conn.cursor()

# Create a table for storing user information
cursor.execute('''
    CREATE TABLE users (
        id INTEGER PRIMARY KEY,
        username TEXT,
        password TEXT
    )
''')

# Commit the changes and close the connection
conn.commit()
conn.close()

Step 3: Add Authentication

Now, let’s add authentication to your Tkinter app. Here’s an example of a login screen that checks the user’s credentials against the database:

import tkinter as tk
import sqlite3
import bcrypt

def login():
    username = entry_username.get()
    password = entry_password.get()

    conn = sqlite3.connect('app.db')
    cursor = conn.cursor()

    cursor.execute('SELECT * FROM users WHERE username = ?', (username,))
    user = cursor.fetchone()

    if user:
        if bcrypt.checkpw(password.encode('utf-8'), user[2].encode('utf-8')):
            print('Login successful!')
        else:
            print('Incorrect password')
    else:
        print('User not found')

    conn.close()

root = tk.Tk()

label_username = tk.Label(root, text="Username")
label_username.pack()
entry_username = tk.Entry(root)
entry_username.pack()

label_password = tk.Label(root, text="Password")
label_password.pack()
entry_password = tk.Entry(root, show='*')
entry_password.pack()

button_login = tk.Button(root, text="Login", command=login)
button_login.pack()

root.mainloop()

Step 4: Register Users

To allow users to register for your Tkinter app, you can add a registration screen with the following code:

def register():
    username = entry_username.get()
    password = entry_password.get()

    hashed_password = bcrypt.hashpw(password.encode('utf-8'), bcrypt.gensalt())

    conn = sqlite3.connect('app.db')
    cursor = conn.cursor()

    cursor.execute('INSERT INTO users (username, password) VALUES (?, ?)', (username, hashed_password))
    conn.commit()
    conn.close()

root = tk.Tk()

label_username = tk.Label(root, text="Username")
label_username.pack()
entry_username = tk.Entry(root)
entry_username.pack()

label_password = tk.Label(root, text="Password")
label_password.pack()
entry_password = tk.Entry(root, show='*')
entry_password.pack()

button_register = tk.Button(root, text="Register", command=register)
button_register.pack()

root.mainloop()

With these simple steps, you can now easily add database and authentication features to your Tkinter apps. Happy coding!