Database Integration 🚀

Python Database Integration is a core Python concept covering learn how to connect Python to databases. Master SQLite (built-in), MySQL, and MongoDB using the Digital Librarian scenario. This topic is essential for academic learning, board exam preparation, and developing optimized real-world code.

Mentor's Note: Lists and Files are great for small data. But if you have 1 million users, you need a Database. Python makes connecting to databases feel as easy as reading a dictionary! 💡

---

🌟 The Scenario: The Digital Librarian 📚

Imagine you own a huge library with 1 million books.

• The Problem: You can't just put all books in one big pile (The List). You also can't put every book in its own drawer (The File). 📦
• The Logic: You hire a Librarian (The Database). You just hand them a note: "Find me every book by Vishnu."
• The Result: The librarian runs to the exact shelf and brings the books back instantly. Python is the Pen you use to write that note! ✅

---

📖 Database Types in Python

1. SQLite (Built-in) 🗄️

The easiest way to start. It requires NO installation. The database is just a file on your computer.

2. MySQL (The Industry Standard) 🏢

Used for web servers and large apps. Requires a server and the mysql-connector-python library.

3. MongoDB (The NoSQL Choice) 🍃

Stores data like JSON (Dictionaries). Very fast for "unstructured" data like social media posts.

---

🎨 Visual Logic: The CRUD Cycle

---

💻 Implementation: The CRUD Lab

SQLite (Built-in)

import sqlite3

# 🚀 Action: Creating a simple student record
conn = sqlite3.connect("college.db")
cursor = conn.cursor()

# 🏗️ 1. Create table
cursor.execute("CREATE TABLE IF NOT EXISTS students (id INT, name TEXT)")

# 📥 2. Insert data
cursor.execute("INSERT INTO students VALUES (101, 'Vishnu')")

# 🏁 3. Save and Close
conn.commit()
conn.close()
print("Database Updated! ✅")

MongoDB (NoSQL)

# Installation: pip install pymongo
from pymongo import MongoClient

# 🚀 Action: Storing a dictionary as a 'Document'
client = MongoClient("mongodb://localhost:27017/")
db = client["school"]
collection = db["users"]

# 🍃 MongoDB loves Python Dictionaries!
student = {"name": "Ankit", "grade": "A+"}
collection.insert_one(student)

---

📊 Sample Dry Run (Read)

Task: Fetch name from ID 101

Step	Action	Logic	Result
1	cursor.execute	Send SQL query to Librarian 📝	Query queued.
2	cursor.fetchone	Librarian brings 1 book 📚	Row (101, 'Vishnu')
3	row[1]	Open the 'Name' column	"Vishnu" ✅

---

📈 Technical Analysis

• Transactions: Always use .commit() after changes. If your program crashes halfway, the database will "Rollback" to keep your data safe. 🛡️
• Injection Attacks: NEVER use f-strings for SQL queries (e.g., WHERE name = '{user_input}'). This allows hackers to delete your table. Always use Parameterized Queries (? or %s). ❌

---

🎯 Practice Lab 🧪

Task: The Grade Updater

Task: Using SQLite, write a program that updates the grade of a student to 'A' based on their id. Hint: UPDATE students SET grade = ? WHERE id = ?. 💡

---

💡 Interview Tip 👔

"Interviewers love asking about ORMs (Object Relational Mappers). Mention that in professional projects, we use SQLAlchemy or Django ORM to avoid writing raw SQL!"

---

💡 Pro Tip: "A database is a repository of truth. Protect it with good constraints and clean code!" - Anonymous

---

🔗 Related Topics

• GUI with Tkinter
• Specialized Libraries
• File Handling
• Exception Handling

---

← Back: Specialized Libraries | Next: GUI with Tkinter →