| ptSqliteSteward - A GUI query agent and data viewer for SQLite databases. | ( Download Here ) |  |
This project began as an exercise in how to program with wxWidgets, and also, how to program SQLite with C++. The focus shifted later, to finding efficient and useful ways to represent query results; especially large ones, with the wxGrid class. Over time, a proto-type emerged that had some potential, and some interesting characteristics like:
- No DLL required. SQLite is compiled in from a static library.
- Query results are stored in dynamic 2D arrays that wxGrid accesses through virtual methods in its base class.
- A custom shell sort to impliment column sorting.
- Large result sets can be indexed, which allows very fast column sorts, by moving around row pointers.
- Custom operations to export results to CSV and xlsx;xls.
This program enables users to perform ad-hoc queries of un-encrypted sqlite3 data stores. You can do so without ODBC, excessive program overhead, or tedious connect configurations. Given sufficient available memory, the program is expected to handle result sets of 500,000 records or more, without degrading system performance, or becoming un-responsive. Results can be exported to CSV and to Excel. Left click on column headers to sort rows on that column. Right click any column header to restore the original row order.
|
