sorcererdb 0.1.0a2

A magical Python database abstraction layer inspired by Sorcery

🔮 SorcererDB – A Smart SQL Abstraction Layer

SorcererDB is a lightweight, extensible database abstraction layer designed to simplify raw SQL access while offering advanced features like multi-connection management, query caching, and reusable query definitions.

✨ Features

• Named connections and connection pooling
• Safe, type-aware prepared statements
• Optional query result caching (e.g., Redis or in-memory)
• Stored query registration and reuse
• Lightweight CRUD helpers: insert, update, delete
• Query profiling and memory diagnostics
• Full transaction support

⚡️ Quick Start

pip install sorcererdb

from sorcererdb import SorcererDB, DBConfig

config = DBConfig(user="root", password="pw", database="test")
db = SorcererDB().connect("default", config)

rows = db.execute("SELECT * FROM users WHERE role = %s", ("admin",))

---

📦 Installation

pip install sorcererdb

Or install directly from source:

git clone https://github.com/ericktheredd5875/sorcererdb-python.git
cd sorcererdb-python
pip install -e .

---

🧭 Roadmap / TODO

• Basic DB connection pool
• Simple query execution interface
• Caching layer (Memcache/Redis backends)
• Query profiler with timing and trace support
• Named prepared queries (alias/shortcut system)
• SQLite and PostgreSQL drivers
• Type hinting and full doc coverage
• sorcerer CLI for testing and diagnostics
• PyPI release
• Connection Pooling (with thread-local binding)
• Multi-Threading Support
• ??

---

📜 License

MIT License © 2025 Eric Harris