{"repo":"tommyknocker/pdo-database-class","free":true,"listed":false,"github":"https://github.com/tommyknocker/pdo-database-class","clone":"git clone https://github.com/tommyknocker/pdo-database-class.git","description":"Framework-agnostic PHP database library with unified API for MySQL, MariaDB, PostgreSQL, SQLite, MSSQL, and Oracle. Query Builder, caching, sharding, window functions, CTEs, JSON, migrations, ActiveRecord, CLI tools, AI-powered analysis. Zero external dependencies.","language":"PHP","stars":82,"topics":["database-abstraction-layer","mysql","postgresql","query-builder","sqlite3","database","database-adapter","sql","pdo","static-analysis"],"license":"MIT","category":"databases-storage","readme_excerpt":"PDOdb PDOdb is a lightweight, framework-agnostic PHP database library providing a unified API across MySQL, MariaDB, PostgreSQL, SQLite, Microsoft SQL Server (MSSQL), and Oracle. Built on top of PDO with zero external dependencies , it offers: Core Features: - Fluent Query Builder - Intuitive, chainable API for all database operations - Cross-Database Compatibility - Automatic SQL dialect handling (MySQL, MariaDB, PostgreSQL, SQLite, MSSQL, Oracle) - 80+ Helper Functions - SQL helpers for strings, dates, math, JSON, aggregations, and more (REPEAT, REVERSE, LPAD, RPAD emulated for SQLite; REGEXP operations supported across all dialects) Performance: - Query Caching - PSR-16 integration for result caching (10-1000x faster repeated queries) - Query Compilation Cache - Cache compiled SQL strings (10-30% performance improvement) - Prepared Statement Pool - Automatic statement caching with LRU eviction (20-50% faster repeated queries) - Query Performance Profiling - Built-in profiler for tracking execution times, memory usage, and slow query detection Advanced Features: - Window Functions - Advanced analytics with ROW NUMBER, RANK, LAG, LEAD, running totals, moving averages - Common Table Expressions (CTEs) - WITH clauses for complex queries, recursive CTEs for hierarchical data, materialized CTEs for performance optimization - LATERAL JOINs - Correlated subqueries in FROM clause for PostgreSQL, MySQL, and MSSQL (CROSS APPLY/OUTER APPLY) - Set Operations - UNION, INTERSECT, EXCEPT ","default_branch":null,"files":null,"tree":[],"storefront":"/r/tommyknocker","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/tommyknocker/pdo-database-class/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}