Daily Life Tracker 📊

This is a personal daily life tracker/organizer I built using "Python's Tkinter" for the GUI and "MySQL" for the backend database.
The idea is simple — to help keep track of different aspects of life like diary entries, expenses, sleep, and entertainment, and to be able to look back and gain some useful insights from them.

---

🔧 What it can do

• Create and manage multiple users
• Add, update, delete entries in:
  • 📖 Diary
  • 💰 Expenses
  • 🎬 Entertainment
  • 😴 Sleep
• View and filter entries by mood, tags, date range, amount, etc.
• Visual insights like:
  • Mood trends
  • Sleep quality patterns
  • Expense breakdowns by category
  • Entertainment status and ratings
• Simple interface that can be extended with new modules (like water tracker, goals, etc.)

---

💡 Why I built this

I wanted a single place where I could log my personal stuff — how I feel, how much I sleep, what I spend on, what I’m watching or reading — and then reflect on it later through charts and summaries.
It’s part of my DBMS course, so I also made sure to apply database design concepts properly.

---

🧱 Tech used

• Python – Tkinter for GUI
• MySQL – Database backend
• Matplotlib – Charts and insights
• Other libraries – datetime, mysql.connector, tkinter, FigureCanvasTkAgg.

---

📂 Database (basic structure)

• users – user_id, username
• diary_entries – mood, tags, text, date
• expenses – amount, category, date
• entertainment_tracker – title, category, status, rating
• sleep_tracker – hours, quality, date
• Lookup tables like tags, expense_categories etc. to keep it organized

---

Role of Database in Daily Life Tracker

This project uses a database as the backbone to manage and organize all user-related data across various modules. Below are the key roles the database plays in the Daily Life Tracker application:

---

1. Stores Data

The database stores all essential data including:

• User information
• Diary entries
• Expense records
• Sleep logs
• Entertainment tracking data

---

2. Organizes Information in a Structured Form

Each type of data is stored in its own table. For example:

• users for user info
• diary_entries for daily logs
• expenses for spending details
• sleep_tracker for sleep records
• entertainment_tracker for entertainment activities

This structure keeps the data clean, organized, and easy to query.

---

3. Supports CRUD Operations

The database supports:

• Create: Add new entries via the GUI
• Read: View past records
• Update: Edit existing information
• Delete: Remove unwanted entries

---

4. Enables Insights

Using SQL queries and visualization tools, the app can extract insights like:

• Average sleep duration
• Mood trends over time
• Spending patterns
• Entertainment frequency

These insights help users understand and improve their daily habits.

---

5. Maintains Data Integrity

The database ensures:

• Data consistency across modules
• Valid data entries (e.g., valid dates, amounts)
• Proper linking of entries to the correct users

This prevents errors and maintains reliable app performance.

---

The database is crucial in making the Daily Life Tracker a meaningful, data-driven personal assistant.

---

▶️ Running it

1. Clone the project
2. Set up MySQL and run the schema file to create tables
3. Install requirements
   pip install mysql-connector-python matplotlib
4. Start the GUI using:
   python login_gui.py

---

🧑‍💻 About me

• Part of my Course: CS2008 Database systems
• Team Name : CraftHouse
• Number of members : 1
• Name : Anjana B Va
• Roll no. : CS23B1098