A library dedicated to easy and seamless handling of sqlite3 / db files
Project description
NanoJson library provided by Mohammed Ghanam.
ManageDB
ManageDB is a powerful and easy-to-use library for managing databases in Python projects. It simplifies database connections, query execution, and data handling with a clean and intuitive interface.
🚀 Features
- ✅ Support for multiple database types (SQLite, MySQL, PostgreSQL)
- ✅ Simple SQL query execution
- ✅ Automatic connection handling
- ✅ Easy table creation and modification
- ✅ Efficient data handling using Python
📦 Installation
Install via pip:
pip install ManageDB==0.1
---
🔥 Usage
from managedb import Database
# Connect to a SQLite database
db = Database('mydatabase.db')
# Create a Table
query = """
CREATE TABLE IF NOT EXISTS users (
id INTEGER PRIMARY KEY,
name TEXT NOT NULL,
age INTEGER
)
"""
db.execute(query)
# Insert Data
db.execute("INSERT INTO users (name, age) VALUES (?, ?)", ('John', 30))
# Fetch Data
result = db.fetch_all("SELECT * FROM users")
print(result)
# Update Data
db.execute("UPDATE users SET age = ? WHERE name = ?", (31, 'John'))
# Delete Data
db.execute("DELETE FROM users WHERE name = ?", ('John',))
# Close Connection
db.close()
---
## 🌍 Compatibility
Python: 3.8+
## Databases:
- 1) SQLite3
- 2) DB
---
##🎯 Contribution
- We welcome all contributions! Open an issue or submit a pull request on GitHub.
---
##📄 License
- ManageDB is released under the MIT License.
## For Contact:
- My telegram Account: [@midoghanam](https://t.me/midoghanam)
- My Channel: [@mido_ghanam](https://t.me/mido_ghanam)
## Best Regards ♡
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
managedb-0.1.tar.gz
(3.4 kB
view details)
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file managedb-0.1.tar.gz.
File metadata
- Download URL: managedb-0.1.tar.gz
- Upload date:
- Size: 3.4 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/6.1.0 CPython/3.12.9
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
33285c1d781cc4cca2a5c57991ad10191e9b72d8c17dcc229e52a5a5aec3a11b
|
|
| MD5 |
dc11c6f4864bbc2eeda70e0eb72a5451
|
|
| BLAKE2b-256 |
2911dfb7fa120e4e6aef1285ac13758596e9cded5ec53c6abbe8e6105e325caa
|
File details
Details for the file managedb-0.1-py3-none-any.whl.
File metadata
- Download URL: managedb-0.1-py3-none-any.whl
- Upload date:
- Size: 3.3 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/6.1.0 CPython/3.12.9
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
31e730068fd56320437eaa5771b659dc2261818a70a92350c69fa8d6838e4bca
|
|
| MD5 |
6c40aea53c565e89af6b4dce5aea038e
|
|
| BLAKE2b-256 |
90afedb43576ed815eb60538923fe9ba095090e1ba0f6385b12f4861fb3306aa
|