• v3.0.0 cc19cc9ce1

    v3.0.0 Stable

    danieljsummers released this 2026-01-24 22:37:16 +00:00 | 0 commits to main since this release

    • Adds Field->addQualifier() function to set the qualifier for a field and return that instance
    • Adds pipeable Field::withQualifier to create a new instance of the Field with the qualifier set
    • Updates tested PostgreSQL versions to 14, 15, 16, 17, and latest (18)
    • Updates dependencies to their latest versions

    Prior versions of this library continues to be supported; v1.2.0 (PHP 8.2+) and v2.2.0 (PHP 8.4+) have this change as well, minus the pipeable Field::withQualifier() function.

    Downloads
  • v2.2.0 7008b8d632

    v2.2.0 Stable

    danieljsummers released this 2026-01-24 22:16:28 +00:00 | 0 commits to v2 since this release

    • Adds Field->addQualifier() function to set the qualifier for a field and return that instance
    • Updates tested PostgreSQL versions to 14, 15, 16, 17, and latest (18)
    • Updates dependencies to their latest versions

    The 2.x series of this library continues to be supported; v1.2.0 (PHP 8.2+) has this change as well, and v3.0.0 (PHP 8.5+) has this change plus a pipeable Field::withQualifier() function.

    Downloads
  • v1.2.0 2478be1c99

    v1.2.0 Stable

    danieljsummers released this 2026-01-24 21:57:13 +00:00 | 0 commits to v1 since this release

    • Adds Field->addQualifier() function to set the qualifier for a field and return that instance
    • Updates tested PostgreSQL versions to 14, 15, 16, 17, and latest (18)
    • Updates dependencies to their latest versions

    The 1.x series of this library continues to be supported; v2.2.0 (PHP 8.4+) has this change as well, and v3.0.0 (PHP 8.5+) has this change plus a pipeable Field::withQualifier() function.

    Downloads
  • v2.1.0 44c3670f2e

    v2.1.0 Stable

    danieljsummers released this 2025-04-25 01:21:18 +00:00 | 2 commits to main since this release

    This release adds the Json static class to return JSON strings or output JSON directly to the response

    Downloads
  • v1.1.0 54b32bc906

    v1.1.0 Stable

    danieljsummers released this 2025-04-25 01:20:10 +00:00 | 1 commits to v1 since this release

    This release adds the Json static class to return JSON strings or output JSON directly to the response

    Downloads
  • v2.0.0 85b461e441

    v2.0.0 Stable

    danieljsummers released this 2024-11-21 03:46:18 +00:00 | 5 commits to main since this release

    The PHP 8.4 version of this library is now generally available.

    RC 1 required no changes; tests have been migrated to Pest from straight PHPUnit.

    Downloads
  • v1.0.0 3b2d2ced98

    v1.0.0 Stable

    danieljsummers released this 2024-11-21 03:30:35 +00:00 | 2 commits to v1 since this release

    The PHP 8.2/8.3 version of this library is now generally available.

    RC 1 required no changes; tests have been migrated to Pest from straight PHPUnit.

    Downloads
  • v2, RC 1 Pre-Release

    danieljsummers released this 2024-10-02 01:41:57 +00:00 | 7 commits to main since this release

    This version is a PHP 8.4+ change of this library. There are two major API changes:

    • On DocumentList, items and hasItems are now properties rather than functions.
    • In the dependent InspiredByFSharp library, several functions on Option and Result are now properties. See its README for a table with their new APIs.

    Version 1 of this library will continue to be supported, including to a full release status. Making this major revision change is the best way for composer to be able to tell which one should be installed; version 1 requires PHP 8.2 or 8.3, while this library requires 8.4 or greater.

    Downloads
  • v1, RC 1 Pre-Release

    danieljsummers released this 2024-10-01 00:31:33 +00:00 | 8 commits to main since this release

    This version fixes a bug where ORDER BY clauses were not generated correctly if the field had a qualifier.

    This version also restricts PHP versions to 8.2.* or 8.3.*. A forthcoming v2 of this library will target PHP 8.4, using properties in some places where functions are currently used. v1 will be supported.

    Downloads
  • v1, Beta 10 Pre-Release

    danieljsummers released this 2024-09-27 02:30:09 +00:00 | 9 commits to main since this release

    Lots of good stuff here!

    • There are two new field comparisons; in implements an IN comparison against a field, and inArray does the same thing for fields that are themselves JSON arrays.
    • The Find functions (except byId) now support an array of Fields, as their last parameter, which will be used to order the results. There is also a new Field::named() function which can be used to create field definitions for this purpose. These names follow the same rules as other field names (use "a.b.c" for nested fields), but they support other features as well.
      • To sort descending, include DESC in the name (ex. Field::named('code DESC')).
      • To specify a null clause, include it as well (ex. Field::named('example NULLS FIRST')).
      • To sort the field as a number, prefix the field name with n: (ex. Field::named('n:ranking')). PostgreSQL will cast the field to a number, while SQLite will do its usual best-guess.
      • To sort case-insensitively, prefix the field name with i: (ex. Field::named('i:comment')). SQLite's default is case-sensitive sorting, with uppercase values first. PostgreSQL's behavior is based on libraries in the underlying operating system; some are case-insensitive by default, but others (particularly Mac OS) are case-sensitive.
    • The names of the comparisons in Field constructor functions are now spelled out (ex. Field::equal instead of Field::EQ). The two-character versions remain as aliases, so this will not break existing code.
    • The project now comes back clean for PHPStan level 6, and had some changes flagged on higher levels. One of these changes may fix an issue where IDEs were not picking up the generic type coming from DocumentList->items().
    Downloads