[MacPorts] #70846: macports.sqlext should be updated to current extension APIs

[MacPorts]

#70846: macports.sqlext should be updated to current extension APIs
------------------------------+--------------------
  Reporter:  RJVB             |      Owner:  (none)
      Type:  defect           |     Status:  new
  Priority:  Normal           |  Milestone:
 Component:  ports            |    Version:
Resolution:                   |   Keywords:
      Port:  macports.sqlext  |
------------------------------+--------------------

Comment (by RJVB):

 Correction: the init function does get called, but is doesn't appear to
 have the intended effect:

 {{{
 > sqlite3
 SQLite version 3.46.0 2024-05-23 13:25:27
 Enter ".help" for usage hints.
 Connected to a transient in-memory database.
 Use ".open FILENAME" to reopen on a persistent database.
 sqlite> .load /alt/local/libexec/macports/lib/registry2.0/macports.sqlext
 creating collation sequence VERSION to sql_version()
 sqlite> .open /opt/local/var/macports/registry/registry-20240920.db
 sqlite> VACUUM;
 Runtime error: no such collation sequence: VERSION
 }}}

 With a bit more info printed it finally becomes clear that loading
 extensions only applies to already attached database(s)...

 {{{
 > sqlite3
 SQLite version 3.46.0 2024-05-23 13:25:27
 Enter ".help" for usage hints.
 Connected to a transient in-memory database.
 Use ".open FILENAME" to reopen on a persistent database.
 sqlite> .load /alt/local/libexec/macports/lib/registry2.0/macports.sqlext
 creating collation sequence VERSION to sql_version() for database ""
 sqlite> .open /opt/local/var/macports/registry/registry-20240920.db
 sqlite> .load /alt/local/libexec/macports/lib/registry2.0/macports.sqlext
 creating collation sequence VERSION to sql_version() for database
 "/opt/local/var/macports/registry/registry-20240920.db"
 sqlite> VACUUM;
 sqlite> ^D
 }}}

 I'll attach my modifications as a patch but this ticket can be closed. Or
 rather, maybe only after updating the instructions for the sake of other
 database n00bs.

-- 
Ticket URL: <https://trac.macports.org/ticket/70846#comment:1>
MacPorts <https://www.macports.org/>
Ports system for macOS