[ ] Monday, 19 May 2014 [ ]

sqlports

The OpenBSD ports database is now in an sqlite db:

port:fred ~> sqlite3 /usr/local/share/sqlports
and so you can query the tables:
SQLite version 3.8.4.3 OpenBSD
Enter ".help" for usage hints.
sqlite> select name from sqlite_master where type='table' order by name;
Broken
Categories
Configure
ConfigureArgs
DPBProperties
Depends
Descr
Flavors
MasterSites
Modules
Multi
NotForArch
OnlyForArch
Paths
Ports
PseudoFlavors
ReadMe
Shared_Libs
Targets
Wantlib

Using .tables and .schema works at the sqlite> prompt.

Exploring Binary


$Id: diary,v 1.38 2025/01/01 22:43:54 fred Exp $