Download the PHP package progrmanial/simplemdb without Composer
On this page you can find all versions of the php package progrmanial/simplemdb. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download progrmanial/simplemdb
More information about progrmanial/simplemdb
Files in progrmanial/simplemdb
Package simplemdb
Short Description Enterprise Database Toolkit for PHP - Modern schema management, intelligent migrations, and advanced query building
License MIT
Homepage https://github.com/imrnansaadullah/SimpleMDB
Informations about the package simplemdb
SimpleMDB - Enterprise Database Toolkit for PHP
🚀 Production-Ready Database Management - Build enterprise-grade applications with Laravel-like syntax, 25+ data types, intelligent migrations, and military-grade security.
⚡ 5-Minute Quick Start
Install SimpleMDB:
Create your first table (MySQL):
Or use PostgreSQL:
That's it! You now have a production-ready table with modern data types and enterprise features.
👉 Try the complete quick start example →
🏆 Why Choose SimpleMDB?
Laravel-Like Developer Experience
25+ Modern Data Types
Intelligent Migrations
Enterprise Security & Performance
- 100% SQL injection prevention with comprehensive validation
- Memory-efficient streaming for large datasets (10-50x reduction)
- AES-256 encryption for sensitive data
- Connection pooling and advanced caching
Complete Database Object Management
- Functions & Procedures with fluent parameter management
- Views with algorithm optimization and security contexts
- Events with flexible scheduling (one-time, recurring, intervals)
- Triggers for data integrity and automated auditing
- Unified Management interface for all database objects
📚 Documentation
🚀 Getting Started
- 5-Minute Quick Start - Get SimpleMDB working immediately
- Installation Guide - Detailed setup and configuration
- Basic Concepts - Core SimpleMDB concepts
- Testing Guide - Write reliable tests for your application
🏗️ Core Features
- Schema Builder - Create and modify database tables
- Data Types Reference - All 25+ data types with examples
- Query Builder - Advanced query building
- Migration System - Intelligent database migrations
🔄 Migration Guides
- From Laravel/Eloquent - Migrate from Laravel
- From Doctrine ORM - Migrate from Doctrine
- From CodeIgniter - Migrate from CodeIgniter
- Complete Migration Guide - All framework migrations
🛡️ Enterprise Features
- Security Guide - Enterprise security best practices
- Performance Optimization - Caching, pooling, optimization
- Backup System - Complete backup and restore solution
- Database Objects - Functions, procedures, views, events, triggers
- Testing Guide - Testing your SimpleMDB applications
🔄 Migration Guides
- From Laravel - Step-by-step Laravel migration
- From Doctrine - Doctrine to SimpleMDB
- From Raw SQL - Converting raw SQL projects
🗄️ Multi-Database Support
SimpleMDB now supports multiple database engines with 100% backward compatibility:
Supported Databases
- ✅ MySQL 5.7+ / 8.0+ (Full support)
- ✅ MariaDB 10.2+ (Full support)
- ✅ PostgreSQL 9.6+ / 12.0+ (Full support with advanced features)
Database-Specific Features
| Feature | MySQL | PostgreSQL |
|---|---|---|
| JSON Storage | json() |
json() + jsonb() |
| IP Addresses | ipAddress() |
inet() (native type) |
| Arrays | JSON arrays | Native arrays textArray(), integerArray() |
| UUIDs | uuid() as CHAR(36) |
uuid() native + uuidWithDefault() |
| Auto-increment | AUTO_INCREMENT |
SERIAL/BIGSERIAL |
| Full-text Search | FULLTEXT indexes |
Built-in text search |
Connection Examples
🎯 Feature Comparison
| Feature | SimpleMDB | Laravel Schema | Doctrine DBAL |
|---|---|---|---|
| Multi-Database | ✅ MySQL + PostgreSQL | ✅ Multiple | ✅ Multiple |
| Data Types | ✅ 25+ types | ✅ 27+ types | ✅ 20+ types |
| Schema Validation | ✅ Comprehensive | ⚠️ Basic | ⚠️ Basic |
| Migration Intelligence | ✅ Smart Templates | ⚠️ Static | ❌ Manual |
| Database Objects | ✅ Complete | ❌ Limited | ❌ Limited |
| Security Features | ✅ Enterprise | ✅ Good | ✅ Good |
| Memory Efficiency | ✅ Streaming | ⚠️ Standard | ⚠️ Standard |
| Learning Curve | ✅ Gentle | ⚠️ Steep | ⚠️ Steep |
| Backward Compatibility | ✅ 100% | ⚠️ Breaking changes | ⚠️ Breaking changes |
💡 Real-World Examples
E-commerce Product Table
User Authentication System
Complete Backup Solution
Database Objects Management
⚙️ System Requirements
- PHP: 8.0 or higher
- Databases:
- MySQL: 5.7+ or 8.0+ (recommended)
- MariaDB: 10.2+ (fully supported)
- PostgreSQL: 9.6+ or 12.0+ (recommended)
- Extensions:
- PDO or MySQLi (for MySQL/MariaDB)
- PDO with pdo_pgsql (for PostgreSQL)
- Memory: 64MB minimum (128MB recommended)
🚀 Installation Options
Composer (Recommended)
Manual Installation
Verify Installation
🎓 Learning Path
Beginner (30 minutes)
- 5-Minute Quick Start - Basic table creation
- Schema Builder Basics - Understanding column types
- Simple Queries - SELECT, INSERT, UPDATE, DELETE
Intermediate (2 hours)
- Advanced Data Types - JSON, UUIDs, polymorphic types
- Migration System - Creating and running migrations
- Security Best Practices - SQL injection prevention
Advanced (1 day)
- Performance Optimization - Caching, connection pooling
- Enterprise Backup System - Complete backup solutions
- Production Deployment - Production best practices
🛠️ Quick API Reference
Schema Builder
Query Builder
🤝 Contributing
We welcome contributions! See our Contributing Guide for details.
Quick Contribution Setup
📖 Resources
- Complete Documentation - Comprehensive guides and references
- Example Projects - Real-world usage examples
- API Reference - Complete method documentation
- Video Tutorials - Step-by-step video guides
- Community Forum - Get help and share tips
📜 License
MIT License - Use SimpleMDB in any project, commercial or open source.
🌟 Enterprise Ready
SimpleMDB is production-ready for enterprise applications. Join the growing community of developers who choose SimpleMDB for its combination of power, security, and developer experience.
⭐ Star us on GitHub if SimpleMDB helps you build better applications!
Need enterprise support? Contact us for professional services, training, and custom development.
All versions of simplemdb with dependencies
ext-mysqli Version *
ext-pdo Version *
ext-json Version *
ext-mbstring Version *
psr/log Version ^3.0
psr/event-dispatcher Version ^1.0