Debian Package Stats using Sqlite
Monday, Oct 6, 2025
I am curious regarding how many packages existed on my system. Then I got to wondering how many are Google projects? How many are Apache projects? Are all packages fully installed? Get a list of packages into sqlite First, one needs to create the sqlite3 file. The following bash script generates a .csv file with a header (that’s the echo command on the third line) and a dpkg-query incantation. Then the script prepares a sqlite file and imports the .