[MacPorts] #67044: Registry DB is 1.2GB and makes a 10.4.11 system unusable

[MacPorts]

#67044: Registry DB is 1.2GB and makes a 10.4.11 system unusable
-------------------------+--------------------
  Reporter:  evanmiller  |      Owner:  (none)
      Type:  defect      |     Status:  new
  Priority:  Normal      |  Milestone:
 Component:  base        |    Version:  2.8.1
Resolution:              |   Keywords:
      Port:              |
-------------------------+--------------------

Comment (by ryandesign):

 Replying to [comment:3 evanmiller]:
 > Thanks for the tips. VACUUM gives an error about VERSION not being
 collated (?).

 MacPorts uses an SQLite extension that implements a custom sort order (a
 "collation") for version numbers. When MacPorts uses the registry, it
 loads that extension. If you want to use programs other than MacPorts to
 interact with the registry file, you have to load the MacPorts SQLite
 extension first.

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