https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43199

            Bug ID: 43199
           Summary: Evaluate migration from DBIx::Class to DBIO
   Initiative type: ---
        Sponsorship ---
            status:
           Product: Koha
           Version: Main
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Architecture, internals, and plumbing
          Assignee: [email protected]
          Reporter: [email protected]
        QA Contact: [email protected]
  Target Milestone: ---

DBIO (https://codeberg.org/dbio/dbio) is a hard fork of DBIx::Class that Koha
should aim to migrate to over time. This bug tracks the DBIO project evolution
and the eventual development of migration tooling.

Key benefits for Koha:

- SQL::Abstract (modern) replaces SQL::Abstract::Classic
- Native desired-state deployment (no SQL::Translator dependency)
- Async storage interface (all_async, find_async, etc.)
- Built-in replicated storage with access brokers (rotating credentials)
- Automatic change tracking (insert/update/delete logging)
- DBIO::Candy / DBIO::Cake sugar for result class definitions
- Internal fixes (e.g. get_from_storage no longer triggers spurious __DIE__
exceptions on tables with multiple unique constraints)

Migration path is expected to be largely mechanical (namespace rename from
DBIx::Class:: to DBIO::), but will require:

1. Tooling to regenerate Koha::Schema::Result classes under the DBIO namespace
2. Audit of any SQL::Abstract::Classic-specific syntax in searches
3. Replacement of SQL::Translator-based deploy with DBIO's native deploy
4. Testing on all supported databases (MySQL/MariaDB primarily)

This is a long-term tracking bug. No immediate action required.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list -- [email protected]
To unsubscribe send an email to [email protected]
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to