A PHP ORM FRAMEWORK WITH A FLUENT QUERY BUILDER. MYSQL, MARIADB, POSTGRESQL, SQLITE AND SQL SERVER.
use Miko\Database\ORM\Model;
// Simple insert
$user = User::create([
'Name' => 'Ersun Pehlivan',
'Email' => 'ersun@example.com',
]);
// Fluent query builder
$users = User::where('IsActive', true)
->orderBy('Name')
->take(10)
->get();
CONNECTION POOLING AND QUERY CACHING BUILT-IN. OPTIMIZED PDO WRAPPER FOR MAXIMUM SPEED.
PREPARED STATEMENTS, VALIDATION ATTRIBUTES AND INPUT CHECKS. FULL SQL INJECTION PROTECTION.
MODEL RELATIONSHIPS, SOFT DELETES, TIMESTAMPS AND LIFECYCLE EVENTS. CLEAN INTUITIVE SYNTAX.
MINIMAL FOOTPRINT WITH MODULAR ARCHITECTURE. LOAD ONLY THE COMPONENTS YOU NEED.
WRITE ELEGANT, CHAINABLE QUERIES WITHOUT RAW SQL. SUPPORTS MYSQL, MARIADB, POSTGRESQL, SQLITE AND SQL SERVER.
SET THE CONNECTION, CREATE A DBCONTEXT, START QUERYING. MIGRATIONS AND SEEDERS ARE BUILT-IN.