ICT: Diary
D: 28 W: 05
| < | May 2014 | > | ||||
| Sun | Mon | Tue | Wed | Thu | Fri | Sat |
|---|---|---|---|---|---|---|
| 1 | 2 | 3 | ||||
| 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| 11 | 12 | 13 | 14 | 15 | 16 | 17 |
| 18 | 19 | 20 | 21 | 22 | 23 | 24 |
| 25 | 26 | 27 | 28 | 29 | 30 | 31 |
[ < ]
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: dates.htm,v 1
$Id: diary,v 1.38 2025/01/01 22:43:54 fred Exp $