sqlite_count_rows.sh

function count_rows {

    # Count the rows in all the tables in a sqlite db
    # Usage: count_rows my-sqlite.db

    DB=$1
    TABLES=`echo "SELECT name FROM sqlite_master WHERE type='table';" | sqlite3 $DB`
    for TABLE in $TABLES
    do
        printf "%10d %s\n" `echo "SELECT count(*) from $TABLE;" | sqlite3 $DB` $TABLE
    done
}