Popularity
9.0
Growing
Activity
8.5
-
4,431
220
1,139

Monthly Downloads: 18,914
Programming language: PHP
License: MIT License
Tags: Database     MySQL     Sqlite     Postgresql     SQL     Query Builder     Lightweight     Oracle     Mssql     Php Framework     Mariadb     Database Library    
Latest version: v1.7.10

Medoo alternatives and similar libraries

Based on the "Database" category.
Alternatively, view Medoo alternatives based on common mentions on social networks and blogs.

Do you think we are missing an alternative of Medoo or a related project?

Add another 'Database' Library

README

The lightweight PHP database framework to accelerate development

Features

  • Lightweight - Portable with only one file.

  • Easy - Easy to learn and use, friendly construction.

  • Powerful - Supports various common and complex SQL queries, data mapping and prevents SQL injection.

  • Compatible - Supports MySQL, MSSQL, SQLite, MariaDB, PostgreSQL, Sybase, Oracle, and more.

  • Friendly - Works well with every PHP framework, like Laravel, Codeigniter, Yii, Slim, and framework that are supporting singleton extension or composer.

  • Free - Under the MIT license, you can use it anywhere, whatever you want.

Requirement

PHP 7.3+ and installed PDO extension.

Get Started

Install via composer

Add Medoo to composer.json configuration file.

$ composer require catfan/medoo

And update the composer

$ composer update
// Require Composer's autoloader.
require 'vendor/autoload.php';

// Using Medoo namespace.
use Medoo\Medoo;

// Connect the database.
$database = new Medoo([
    'type' => 'mysql',
    'host' => 'localhost',
    'database' => 'name',
    'username' => 'your_username',
    'password' => 'your_password'
]);

// Enjoy
$database->insert('account', [
    'user_name' => 'foo',
    'email' => '[email protected]'
]);

$data = $database->select('account', [
    'user_name',
    'email'
], [
    'user_id' => 50
]);

echo json_encode($data);

// [{
//    "user_name" : "foo",
//    "email" : "[email protected]",
// }]

Contribution Guides

For starting a new pull request, please make sure it's compatible with other databases and write a unit test as possible.

Run phpunit tests for unit testing and php-cs-fixer fix for fixing code style.

Each commit is started with [fix], [feature] or [update] tag to indicate the change.

Please keep it simple and keep it clear.

License

Medoo is under the MIT license.

Links


*Note that all licence references and agreements mentioned in the Medoo README section above are relevant to that project's source code only.