Veni, Vidi, VISA

# Anzahl der ports, die Perl nutzen

sqlite> SELECT COUNT(FULLPKGPATH) FROM Ports WHERE CONFIGURE_STYLE LIKE '%perl%';



# Ports in deren Beschreibung "statistics" steht

sqlite> SELECT COMMENT FROM Ports WHERE COMMENT LIKE '%statistics%'; 



# Die Beschreibung von allen Ports mit den Namen "zsh"

sqlite> SELECT FULLPKGPATH,COMMENT FROM PORTS WHERE FULLPKGNAME LIKE 'zsh%';



# Alle Ports die Gmake, aber nicht libtool benoetigen

sqlite> SELECT DISTINCT FULLPKGPATH FROM Ports WHERE USE_GMAKE=1 AND USE_LIBTOOL IS NULL;



# Die FLAVORS von vim anzeigen lassen

sqlite> SELECT FULLPKGPATH,FLAVORS FROM PORTS WHERE FULLPKGNAME LIKE 'vim%';

$ /usr/ports/infrastructure/build/out-of-date > ~/ports

$ for i in `awk '{print $1}' ports | cut -d, -f1`; do (cd /usr/ports/$i && ls); done

editors/vim

editors/vim,huge,no_x11,perl