Skip to main content

A library dedicated to easy and seamless handling of sqlite3 / db files

Project description

NanoJson library provided by Mohammed Ghanam.

PyPI - Version
Python License
Status


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

This version

0.1

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)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

managedb-0.1-py3-none-any.whl (3.3 kB view details)

Uploaded Python 3

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

Hashes for managedb-0.1.tar.gz
Algorithm Hash digest
SHA256 33285c1d781cc4cca2a5c57991ad10191e9b72d8c17dcc229e52a5a5aec3a11b
MD5 dc11c6f4864bbc2eeda70e0eb72a5451
BLAKE2b-256 2911dfb7fa120e4e6aef1285ac13758596e9cded5ec53c6abbe8e6105e325caa

See more details on using hashes here.

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

Hashes for managedb-0.1-py3-none-any.whl
Algorithm Hash digest
SHA256 31e730068fd56320437eaa5771b659dc2261818a70a92350c69fa8d6838e4bca
MD5 6c40aea53c565e89af6b4dce5aea038e
BLAKE2b-256 90afedb43576ed815eb60538923fe9ba095090e1ba0f6385b12f4861fb3306aa

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page