SQLite3 with Python 🛢️🐍

This repository contains practical examples developed in Python using the built-in SQLite3 library. The goal is to teach how to connect, create, query, and manipulate databases in a simple and clear way. 💻🛢️

The examples are especially designed for beginners who want to understand how to work with local databases without the need to install complex systems.

---

✨ Features

✅ SQLite database connection
✅ Table creation
✅ Data insertion (CRUD)
✅ Queries and filters
✅ Safe connection closing
✅ Simple and easy-to-understand examples

---

📂 Project Structure

SQLite3Python/
│
├── data/
│   └── database.db
│
├── src/                   # main code
│   ├── crud.py
│   ├── delete.py
│   ├── insert.py
│   └── ...
│
├── README.md        # Documentation
├── LICENSE
└── .gitignore

---

🖥️ Requirements

• Python 3.x
• SQLite3 (included by default in Python)
• DB Browser for SQLite (optional, to visualize the database)

---

⚙️ Installation

Clone the repository:

git clone https://github.com/Bredalis/SQLite3Python.git

Enter the directory:

cd SQLite3Python

---

🚀 Usage

Run any Python file from the project:

python main.py

To visualize the database:

1. Open DB Browser for SQLite
2. Load the .db file from the repository

---

🧠 Code Example

from crud import Crud

crud = Crud("../data/database.db", "report")

crud.insert_data(1, "Perla", "Mendoza", "15-9-1998")
crud.close_database()

---

📜 License

This project is licensed under GPLv3 (GNU General Public License v3.0)

---

👩‍💻 Author

Bredalis Gautreaux

😊 Programmer passionate about technology, artificial intelligence, and continuous learning. #python #sqlite #ai #nlp

---

⭐ Support the Project

If this repository helped you, consider giving it a ⭐ on GitHub.