leafs / db
Leaf PHP db module.
Fund package maintenance!
Open Collective
leafsphp
Installs: 16 276
Dependents: 8
Suggesters: 0
Security: 0
Stars: 6
Watchers: 3
Forks: 11
Open Issues: 3
Requires (Dev)
- friendsofphp/php-cs-fixer: ^3.14
- leafs/alchemy: ^1.0
- pestphp/pest: ^1.21
README
Leaf Db v3
Leaf DB has gone through yet another re-write. This time, Leaf DB focuses on maintaining a cleaner structure with more usable and grounded code. v3 supports more databases like postgres and sqlite, comes with some performance gains and is far more efficient than v1 and v2. It is also independent of the leaf core which makes it suitable for any project you run.
What's new?
DB Support
Leaf DB now supports connections with other databases like postgresql, sqlite, oracle and more.
Deep syncing with leaf 3
Leaf DB is now detached from leaf, however, as a leaf 3 module, there's additional functionality you can get from using leaf db in a leaf 3 app. Deep syncing config, instances and functional mode all become available to you.
PDO rewrite
Under the hood, Leaf DB has been rewritten to fully support PDO, both internally and user instantiated PDO instances. This makes leaf db more flexible and more compatible with most systems and applications.
Performance Improvements
After a series of benchmarks with ApacheBench, apps using leaf db v3 were almost twice as fast as apps using the prior version. These small performance wins can go a long way to improve the overall perfomance of your app drastically.
Methods
create
drop
insert
with multiple fields- Connections with pgsql, oracle, sqlite and many more db types
- Functional mode
Installation
You can easily install Leaf using Composer.
composer require leafs/db
Basic usage
After installing leaf db, you need to connect to your database to use any of the db functions.
$db = new Leaf\Db('127.0.0.1', 'dbName', 'user', 'password'); # or $db = new Leaf\Db(); $db->connect('127.0.0.1', 'dbName', 'user', 'password');
If you're using leaf db in a leaf 3 app, you will have access to the db
global
db()->connect('127.0.0.1', 'dbName', 'user', 'password');
From there, you can use any db method.
$users = db()->select('users')->all();
You can find leaf db's complete documentation here. The docs are still being updated.