cruzer/dolphin

Dolphin ORM and Query Builder with Laravel Eloquent like syntax but very small footprint

v0.0.8 2019-12-29 15:39 UTC

This package is auto-updated.

Last update: 2024-05-29 04:22:17 UTC


README

Donate GitHub issues PHP from Packagist Packagist Version Scrutinizer Code Quality Build Status Packagist Code Coverage GitHub license

A lightweight Database Query builder and ORM for PHP 7 without any external dependency(only PDO is required). API looks quite same as of Laravel's Eloquent but without the complexity.

Features

  • Easy to use and rememberable syntax
  • Uses prepared statements
  • Method chaining
  • Support multiple database driver through PDO
  • Support join(), leftJoin(), rightJoin(), crossJoin()
  • Supprts where(), whereIn(), whereNotIn(), whereNull(), whereNotNull(), whereRaw()
  • Support groupBy(), having(), orderBy()
  • Supports offset() and limit()
  • Supports the shortcuts for retreiving data such as first(), last(), min(), max(), avg()
  • Supports count()
  • insert()
  • update()
  • delete()
  • truncate()

Not yet Supported

  • union()
  • exists()
  • orWhere()
  • events support
  • transactions support

Tests

Tests are still pending.

Inspirations

Initialy, I created it for the CruzerMini to interact with the database because I was looking for a good library like Laravel's Eloquent but with small footprint. I tried severals but found nothing that has the nice syntax as Eloquent. Thats why it inspired me to create it.

Contributing

Please see CONTRIBUTING for details.

Security

If you discover any security related issues, please email support@cruzersoftwares.com instead of using the issue tracker.

Credits

License

The MIT License (MIT). Please see License File for more information.

Buy me a coffee

Become a Patron