Easydb Versions Save

• Guarantee that EasyDB::row() always returns an array instead of throwing a TypeError when encountering null. See also: #144.

• #143: Don't assume the array passed to insertMany() is indexed at 0.
• Fixed the type declaration of the $duplicates_mode parameter to be nullable in buildInsertQueryBoolSafe().

• #141: Increased minimum PHP Version to 8.0
  • Lots of code refactoring went into this, including strict-typing with PHP 8's new support for Union Types.
• #142: Added support for Psalm Security Analysis

• Migrated from Travis CI to GitHub Actions
• #136: Added EasyPlaceholder for calling SQL functions on insert/update queries
• #137: Added csv() method to satisfy feature request #100
• Miscellaneous boyscouting

• #120: EasyStatement now defaults to WHERE 1 = 1 instead of WHERE 1 to ensure success with PostgreSQL.
• #122: Builds on PHP 7.4 in Travis CI, installs on PHP 8.

• You can now pull the original exception (which may leak credentials via stack trace) from a ConstructorFailed exception by calling the new getRealException() method.
• Added insertIgnore() (Insert a row into the table, ignoring on key collisions)
• Added insertOnDuplicateKeyUpdate() (Insert a row into the table; or if a key collision occurs, doing an update instead)
• #111: EasyStatement: Don't fail with empty IN() statements

• You can now side-step credential leakage in the Factory class by calling Factory::fromArray([$dsn, $username, $password, $options]) instead of Factory::create($dsn, $username, $password, $options).

Congruent with 2.7.0's changes

Changed the behavior of several public APIs to invoke $this->prepare() instead of $this->pdo->prepare(). This might seem subtle, but in actuality, it allows classes that extend EasyDB to implement prepared statement caching.

Seeing as PHP 5 is reaching EOL soon, you want v2.x instead of 1.x, but for legacy software this change can make EasyDB more useful.

Changed the behavior of several public APIs to invoke $this->prepare() instead of $this->pdo->prepare(). This might seem subtle, but in actuality, it allows classes that extend EasyDB to implement prepared statement caching.

See https://github.com/paragonie/easydb-cache for more information

Fixed issues with insert() and booleans. See #84