Skip to content

🌊 Aquifer

Choose a tag to compare

@mychidarko mychidarko released this 12 Aug 22:54
· 3 commits to v5.x since this release

v5.0 - 12 Aug 2026

Added

  • Added multiple database connections: db()->addConnections([...]), then db('analytics')->select(...) to query any of them
  • Added IN, NOT IN and BETWEEN support right in where() comparators
  • Added JSON querying with whereJson() and whereJsonContains()
  • Queries now leave breadcrumbs in [Leaf Crash](https://leafphp.dev/docs/routing/error-handling), so error reports show what ran before a crash
  • Added a much larger test suite, run through Alchemy

Fixed

  • Transactions work on every PDO driver β€” SQLite, Postgres and SQL Server, not just MySQL
  • unique() checks and eager loading run as prepared statements, so values with quotes and string or UUID foreign keys work correctly
  • db()->config('key', $value) sets falsy values like '', 0 and false instead of silently ignoring them
  • Transaction failures land in errors()['transaction'] where you can actually read them
  • beginTransaction() no longer clears a half-built query
  • The error array resets between queries (thanks [@terrybr](https://github.com/terrybr))
  • Fixed a wrong connection reference in the deferred default-connection check

Changed

  • Db now requires PHP 8.2+