SmartKDB v5 🧠

The Easiest Database for Python

SmartKDB is a local-first database that's as easy as a Python dictionary, but with superpowers:

• 🚀 No setup - Works instantly
• 💾 ACID Transactions - Bank-grade safety
• 🧠 AI-Powered - Learns from your usage
• ⏰ Time-Travel - Query past data
• 📦 Pure Python - No dependencies

🎯 Install in 10 Seconds

pip install smartkdb

⚡ Use in 30 Seconds

from smartkdb import SmartKDB

# Create database
db = SmartKDB("mydb.kdb")

# Create table
users = db.create_table("users")

# Add data
users.insert({"name": "Alice", "age": 25})
users.insert({"name": "Bob", "age": 30})

# Query data
results = users.query().where("age", ">", 25).execute()
print(results)  # [{'name': 'Bob', 'age': 30}]

That's it! 🎉

📚 Learn in 5 Minutes

Run our interactive tutorial:

python -c "from smartkdb import SmartKDB; help(SmartKDB)"

Or check our example files:

• Quick Start Tutorial
• Transactions Demo
• AI Features Demo

🚀 What Makes SmartKDB Special?

1. Zero Configuration

No servers, no config files, no complexity. Just pip install and code.

2. ACID Transactions

tx = db.tx_manager.begin()
try:
    users.insert({"name": "Charlie"}, transaction_id=tx)
    db.tx_manager.commit(tx)
except:
    db.tx_manager.rollback(tx)

3. AI Brain 🧠

The database learns from your queries and suggests optimizations:

db.brain.suggest_indexes("users")
# Returns: ['Create index on email for faster queries']

4. Time-Travel Queries ⏰

See your data as it was in the past:

history = db.version_manager.get_history("users", "user_123")
# Shows all versions of the record

📖 Complete Documentation

Full Documentation: https://smartkdb.readthedocs.io/

💡 More Examples

Example 1: E-Commerce Store

db = SmartKDB("store.kdb")
products = db.create_table("products", indexes=["category"])

products.insert({
    "name": "Laptop",
    "price": 999,
    "category": "Electronics"
})

# Find all electronics under $1000
cheap_electronics = products.query()\
    .where("category", "==", "Electronics")\
    .where("price", "<", 1000)\
    .execute()

Example 2: User Management

users = db.create_table("users", pk="email", indexes=["role"])

users.insert({"email": "admin@company.com", "role": "admin"})

# Update user
users.update("admin@company.com", {"role": "superadmin"})

# Delete user
users.delete("old_user@company.com")

See more in our examples folder!

🎮 Try It Now

# Clone and run examples
git clone https://github.com/alhdrawiz6-ai/smartkdb
cd smartkdb
python examples/quickstart.py
python examples/transactions.py
python examples/ai_features.py

🤝 Contributing

We welcome contributions! See CONTRIBUTING.md

📄 License

MIT License - See LICENSE

🌟 Why SmartKDB?

Perfect for:

• 🎯 Prototypes & MVPs
• 📱 Desktop applications
• 🤖 AI/ML projects
• 📊 Data analysis scripts
• 🧪 Testing & experiments

🔗 Links

• PyPI: https://pypi.org/project/smartkdb/
• Documentation: https://smartkdb.readthedocs.io/
• GitHub: https://github.com/alhdrawiz6-ai/smartkdb
• Issues: https://github.com/alhdrawiz6-ai/smartkdb/issues
• Changelog: https://smartkdb.readthedocs.io/en/latest/CHANGELOG.html

Made with ❤️ by Alhdrawi

Star ⭐ this repo if you find it useful!