Medoo

Medoo - simplify SQL queries in PHP | Awesome Repos

Features

Database Wrappers - Serves as a minimal database wrapper providing a unified interface for CRUD operations and aggregate calculations.
Relational Database Abstractions - Provides a unified, vendor-agnostic PHP interface for interacting with multiple relational database systems via PDO.
Array-Driven Query Construction - Provides a mechanism to define complex SQL queries and filters using PHP associative arrays.
Database Engine Abstractions - Implements a layer that decouples application logic from specific SQL engines to allow multi-backend support.
Database Record Querying - Enables retrieving records from tables using a variety of filters, limits, and column selections.
Prepared Statements - Uses prepared statements with parameterization to prevent SQL injection attacks.
Query Abstraction Layers - Provides a unified query abstraction layer for executing SQL across multiple engines using a single PHP API.
Record Deletion - Provides methods for removing one or multiple records from a table based on filtering criteria.
Record Insertion - Implements standard interfaces for inserting single or multiple data records into tables.
Record Updating - Provides fluent methods for modifying existing database records based on conditional filters.
SQL Database Engine Support - Supports a wide range of SQL engines including MySQL, PostgreSQL, SQLite, MSSQL, Oracle, and Sybase.
SQL Dialect Adapters - Provides a unified API that adapts queries to ensure compatibility across different SQL database implementations.
SQL Query Builders - Includes a programmatic utility for constructing and executing structured query language operations.
SQL Query Building - Enables programmatic construction of complex SQL statements with prepared statements to prevent injection.
Multi-Database Support - Enables building applications that remain portable across different SQL backends via a unified interface.
Aggregate Calculations - Provides built-in methods for performing aggregate calculations like sum, average, and count on database tables.
Atomic Batch Commits - Implements atomic batch commits to ensure a group of database mutations either succeed completely or roll back.
Database Transaction Management - Manages database transactions to ensure data integrity through atomic operations.
Raw SQL Execution - Allows the injection of raw SQL expressions into generated queries for complex logic.
Lightweight Integrations - Provides a minimal interface for adding basic database CRUD operations without the overhead of a full ORM.

Open-source alternatives to Medoo

Similar open-source projects, ranked by how many features they share with Medoo.

uptrace/bun
uptrace/bun
4,867View on GitHub
Bun is a type-safe object relational mapper for Go that prioritizes SQL-first query construction and result mapping. It functions as a programmable SQL query builder, a database connection manager, and a tool for mapping database tables to Go structs. The project distinguishes itself through a multi-dialect SQL support system, allowing a single codebase to interact with different database engines via a consistent interface. It includes a built-in database observability tool for query interception, distributed tracing, and logging, as well as a schema migration tool for versioning structural c
Godatabasegogolang
View on GitHub4,867
go-pg/pg
go-pg/pg
5,785View on GitHub
pg is a PostgreSQL object-relational mapper (ORM) for Go that maps Go structs to database tables and provides a fluent query builder for constructing SQL statements programmatically. At its core, it automatically generates CREATE TABLE statements from Go struct definitions using struct tags and naming conventions, and builds queries through method chaining with placeholder-based parameter binding to prevent SQL injection. The library distinguishes itself through relation-aware join generation that automatically constructs JOIN clauses for has-one, has-many, many-to-many, and polymorphic assoc
Go
View on GitHub5,785
codeigniter4/codeigniter4
codeigniter4/CodeIgniter4
5,924View on GitHub
CodeIgniter is a PHP web framework built on the Model-View-Controller pattern, designed for building full-stack web applications. It provides a lightweight toolkit with minimal configuration, organizing application logic into controllers, models, and views for clean separation of concerns. The framework includes a fluent query builder for constructing SQL statements programmatically, PSR-4 autoloading with namespace mapping, and a service-based dependency injection container for managing shared class instances. The framework distinguishes itself through its comprehensive set of built-in tools
PHPcodeignitercodeigniter4framework-php
View on GitHub5,924
linq2db/linq2db
linq2db/linq2db
3,239View on GitHub
linq2db is a type-safe object-relational mapper that translates LINQ expressions into optimized SQL queries for multiple database providers. It functions as a database mapper that links classes to tables and includes a SQL query builder and a command-line schema tool for generating data classes from existing databases. The project provides high-performance bulk data processing for inserting and loading large volumes of records via batch or binary copy methods. It also supports advanced SQL operations, including window functions, common table expressions for recursive hierarchical querying, an
C#accessbulk-insertsclickhouse
View on GitHub3,239

See all 30 alternatives to Medoo

catfanMedoo

Features

Open-source alternatives to Medoo

uptrace/bun

go-pg/pg

codeigniter4/CodeIgniter4

linq2db/linq2db

Star history

Open-source alternatives to Medoo

uptrace/bun

go-pg/pg

codeigniter4/CodeIgniter4

linq2db/linq2db