macports.sqlext @2.6.3: Update to 2.6.4; fix livecheck; add to release process

[ryandesign (Ryan Carsten Schmidt)]

macports.sqlext is outdated; should be updated to 2.6.4

livecheck doesn't work and should be fixed:

$ port livecheck macports.sqlext
Error: cannot check if macports.sqlext was updated (Could not resolve host: macports_distfiles)

MacPorts base release process documentation should be updated to include updating this port.

[jmroot (Joshua Root)]

It should not be updated because there were no changes to its source between MacPorts 2.6.3 and 2.6.4.

[ryandesign (Ryan Carsten Schmidt)]

That would be another good reason to spin it off into its own project as suggested in #62368.

[RJVB (René Bertin)]

Has this extension even been tested lately? I followed the build, install and usage instructions from the version in the "base" master branch and it doesn't seem to be doing anything. Sqlite still tells me there's something non-standard about the registry db and refuses to operate on it.

EDIT:

> port installed macports.sqlext
The following ports are currently installed:
  macports.sqlext @2.6.3_0 (active)

> sudo cp -p /opt/local/var/macports/registry/registry{,-20240920}.db
> sqlite3
SQLite version 3.41.0 2023-02-21 18:09:37
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> .load /opt/local/lib/sqlite3/macports.sqlext
sqlite> .open /opt/local/var/macports/registry/registry-20240920.db
sqlite> VACUUM;
Runtime error: no such collation sequence: VERSION

(FWIW, all I'm interested in doing is changing the pagesize parameter to see how that affect "cleanup" performance when closing a large, old registry db.)

[ryandesign (Ryan Carsten Schmidt)]

Off-topic in this ticket; it can be addressed in the new ticket you filed, #70846.