Next gen Medoo v2.0 is developing

[catfan]

We are developing the next milestone version of Medoo (v2.0).

It will become more standard, and having more features.

You can check out the develop branch and try.
https://github.com/catfan/Medoo/tree/develop

Any ideas, suggestions are welcome to discuss here.

---

What's new on Medoo v2.0 (Updating)

New error initialization option (How to handle error information)

$database = new Medoo([
    // Can be set as PDO::ERRMODE_SILENT, PDO::ERRMODE_WARNING, PDO::ERRMODE_EXCEPTION
    // Default is PDO::ERRMODE_SILENT
    'error' => PDO::ERRMODE_SILENT
]);

Simplified connection options

Those option names are simplified (you can still use the old one of course).

• database_type -> type
• database_name -> database
• server -> host

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

// Old
$database = new Medoo([
    'database_type' => 'mysql',
    'database_name' => 'name',
    'server' => 'localhost',
    'username' => 'your_username',
    'password' => 'your_password',
]);

New callback closure for select()

For fetching data from the database, data will be first loaded into memory as an array variable, and output back to the frontend.

If fetching a large amount of data from the database, the memory will be exhausted.

When passing the callback closure function ($data) {} as the last parameter for select(), it will output each data immediately without loading it into memory. That's will be having a better performance for loading a large amount of data.

$database->select("account", ["name"], function ($data) {
    echo $data["name"];
});

// Test fetching over 20,000 records

$database->select("account", ["nickname"], function ($data) {
    echo $data["nickname"];
});

// Memory usage: 2.38 MB
// -----------------------------

$data = $database->select("account", ["nickname"]);

foreach ($data as $item) {
    echo $item["nickname"];
}

// Memory usage: 11.89 MB

New way to getting result from action()

$result = "";

$database->action(function($database) use (&$result) {

    $database->insert("account", [
        "user_name" => "foo"
    ]);

    $newId = $database->id();

    $result = "The account is created, id is {$newId}";
});

echo $result;

New way to get the error information

The function $database->error() is removed. Just read the $database->error or $database->errorInfo to get the error information last performed.

$database->insert("account", [
    "user_name" => "foo"
]);

var_dump($database->error);
var_dump($database->errorInfo);

Last inserted id on Oracle

If want to the last inserted id on Oracle, provide the primary key as third parameter for insert() and get it from id().

$database->insert("ACCOUNT", ["NAME" => "foo"], "ID");

var_dump($database->id());

Debug Logging

To debug the whole or the part of your project without putting debug() to every call, you can use beginDebug() to start debug logging, and then call debugLog() to stop it and get all debug logs as an array.

// Begin debug logging
$database->beginDebug();

// All those functions will not be executed but will save it as a debug log.
$database->select()......
$database->update()......

// Call debugLog() to stop debug logging and return all debug logs as an array.
var_dump($database->debugLog());

// Will output:
array(2) {
  [0]=> string(10) "SELECT ... FROM"
  [1]=> string(10) "UPDATE ... SET ... WHERE ..."
}

• PSR-2 standard
• Test cases included
• PHPDoc comments included
• Drop support for PHP 5.4, the minimal requirement is PHP 7.3+
• Better support for MSSQL and Oracle
• Supports using Unicode character as table/column name