Hydro is designed with speed and memory efficiency in mind. As a result, it has extremely low footprint (consist of only just few classes) and is completely dependency-free, which takes up less of your memory.

The cost of speed and performance gain is kept minimal. With Hydro, you don't have to trade the ease-of-use for better performance.

Installation & Setup

Use Composer.

composer require adhuham/hydro

use Hydro\Hydro;

$pdo = PDOConnection(...);
$hydro = new Hydro($pdo);

Basic Usage

// multiple
$hydro->table('post')->select('id', 'title', 'content')->get();

// single
$hydro->table('post')->select('id', 'title', 'content')->one();

// where
$hydro->table('post')->select('id', 'title', 'content')->where('id', 1)->get();

// joins
$hydro->table('post')
  ->select('id', 'title', 'content')
  ->leftJoin('tag', 'post.tag_id', '=', 'tag.id')
  ->get();

See Documentation

TODO

Writing Tests
Proper exception and error handling
Completing the documentation

Performance

Memory usage comparison between Eloquent, Laravel's Query Builder, Hydro and raw PDO. (Lower is better)

Eloquent
==============================================================================  7,542,904

Laravel Query Builder
=============== 1,455,720

Hydro 
== 219,008

Hydro (using raw statements)
== 219,112

PDO
= 138,688