Hello sqlite users! About two weeks ago I released Tad, an open source (MIT licensed) desktop application for viewing and analyzing CSV files:
http://www.tadviewer.com The core of Tad is a pivot table that generates SQL queries run against an embedded instance of SQLite. I've just pushed an update to Tad that may be of interest to SQLite users. This latest release of Tad (0.8.3) allows Tad to be used to explore tables in saved sqlite database files. For example, to explore table expenses in sqlite db file /data/accounts.sqlite: $ tad sqlite:///data/accounts.sqlite/expenses (Note that there are 3 slashes following sqlite:) Tad uses LIMIT and OFFSET to only pull as many rows as needed to display the current viewport, even in the presence of pivoting, so it's possible to use Tad on large tables. If you're interested in the (monster!) queries that Tad throws at SQLite to construct the pivot table, add the arguments -f --show-queries to the command line. I hope you find Tad useful. Please send feedback and bug reports to tad-feedb...@tadviewer.com. -Antony Courtney _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
