Top 20 Python Project Ideas with Source Code in 2025

A to-do list app is one of the cool Python projects that will allow you to manage tasks in the command line interface and make it easy for users or yourself to manage tasks by providing add, delete, view, and complete tasks functionalities.

You can use Python’s sqlite3 library to create a database that stores tasks persistently, or even a simple text file for a less complex solution.

This app requires the use of CRUD (Create, Read, Update, and Delete) operations, as well as a navigational menu for task management.  This project will give the option to learn about handling data (database or plain text I/O), but it requires a final project that is a simple and efficient task management system that has a terminal interface.

Source Code

import sqlite3

# Create the tasks table

def create_table():

    conn = sqlite3.connect(“tasks.db”)

    cursor = conn.cursor()

    cursor.execute(“””CREATE TABLE IF NOT EXISTS tasks (

                        id INTEGER PRIMARY KEY AUTOINCREMENT,

                        task TEXT NOT NULL,

                        status TEXT NOT NULL DEFAULT ‘Pending’

                     )”””)

    conn.commit()

    conn.close()

# Add a new task to the list

def add_task(task):

    conn = sqlite3.connect(“tasks.db”)

    cursor = conn.cursor()

    cursor.execute(“INSERT INTO tasks (task) VALUES (?)”, (task,))

    conn.commit()

    conn.close()

    print(“Task added successfully!”)

# View all tasks in the list

def view_tasks():

    conn = sqlite3.connect(“tasks.db”)

    cursor = conn.cursor()

    cursor.execute(“SELECT * FROM tasks”)

    tasks = cursor.fetchall()

    conn.close()

    if tasks:

        print(“\nYour To-Do List:”)

        for task in tasks:

            print(f”ID: {task[0]} | Task: {task[1]} | Status: {task[2]}”)

    else:

        print(“No tasks found!”)

# Delete a task by ID

def delete_task(task_id):

    conn = sqlite3.connect(“tasks.db”)

    cursor = conn.cursor()

    cursor.execute(“DELETE FROM tasks WHERE id = ?”, (task_id,))

    conn.commit()

    conn.close()

    print(“Task deleted successfully!”)

# Mark a task as completed by ID

def mark_task_complete(task_id):

    conn = sqlite3.connect(“tasks.db”)

    cursor = conn.cursor()

    cursor.execute(“UPDATE tasks SET status = ‘Completed’ WHERE id = ?”, (task_id,))

    conn.commit()

    conn.close()

    print(“Task marked as completed!”)

# Main application loop

def main():

    create_table()

    while True:

        print(“\nTo-Do List App”)

        print(“1. Add Task”)

        print(“2. View Tasks”)

        print(“3. Delete Task”)

        print(“4. Mark Task as Completed”)

        print(“5. Exit”)

        choice = input(“Enter your choice: “)

        if choice == “1”:

            task = input(“Enter the task: “)

            add_task(task)

        elif choice == “2”:

            view_tasks()

        elif choice == “3”:

            task_id = input(“Enter the task ID to delete: “)

            if task_id.isdigit():

                delete_task(int(task_id))

            else:

                print(“Invalid ID!”)

        elif choice == “4”:

            task_id = input(“Enter the task ID to mark as completed: “)

            if task_id.isdigit():

                mark_task_complete(int(task_id))

            else:

                print(“Invalid ID!”)

        elif choice == “5”:

            print(“Exiting the app. Goodbye!”)

            break

        else:

            print(“Invalid choice. Please try again.”)

if __name__ == “__main__”:

    main(