v0.5.0

Version 0.5.0 introduces a substantial new feature: the Schema Explorer, which gives you a hierarchical, graphical overview of every object in the active database new tools to inspect and manage them.

Schema Explorer

The Schema Explorer is a new view mode in addition to the Query Editor and Results pane, and can be accessed via a command bar button or using the keyboard shortcut Ctrl+3. With the Schema Explorer, SQLite/CEdit inches closer to becoming a proper database management tool, giving you the ability to quickly inspect, export and drop any object within a database, as well as see parameters such as rowcounts and sizes with the Show Details view mode. The Schema Explorer can be navigated either by touch or by key, with fully implemented arrow key support. To view the complete contents of a table, select and press Enter or double-tap its icon.

Dynamic interface

SQLite/CEdit 0.5.0 features an updated dynamic context window that shows tools relevant to your view mode, such as execution for queries, quick export for the Results view and DDL export in the Schema view.

Export extensions

SQLite/CEdit 0.5.0 includes a full host of DDL export functions that can extract DDL for single objects or entire databases into a .sql file. Additionally, results can now be exported to CSV or plaintext. Version 0.5.0 also supports exporting individual tables to CSV, with more formats planned in future releases.

UI/UX polish

Version 0.5.0 includes many subtle workflow improvements, including automatic return to the Query Editor view when a new query is loaded.

Test harness

The SQLite/CE Test harness has 27 new test cases to exercise some functions introduced with SQLite/CEdit 0.5.0, among other cases.

Binaries

As with 0.4.0, the SH-3 binaries provided are tested on an HP 620LX running Windows CE 2.0. The MIPS binaries are still untested, and while they should be fine, be wary of odd behavior or errors.