v0.7.0

SQLite/CE 0.7.0 introduces simple live data editing to the grid view via the Schema Explorer, allowing users to quickly correct and maintain tables without having to write full SQL queries, and inching us ever closer to a full-fledged database editor. 0.7.0 also now leverages the Windows registry to persist settings and recent files across settings.

Cell editing

SQLite/CEdit now implements basic support for direct editing of table data using the Schema Explorer, which now displays table data in an editable grid view. Double tapping on a cell will enter edit mode, allowing you to set a new value and commit by pressing Enter or cancel by pressing Escape. Cell editing is currently not entirely type-aware, but will respect basic hard constraints like NOT NULL by setting empty strings on cell delete for non-nullable columns, with feedback for other kinds of constraint violations displayed to the user through both the status bar and dialog boxes. Type-awareness is planned for future releases.

The cell editor in the Schema explorer currently only supports editing existing data, and cannot DELETE or INSERT new rows to a table; these operations still must be performed through handwritten SQL queries, though this will be enhanced in future releases.

Registry persistence

SQLite/CEdit now remembers settings and recent files across settings using the registry, storing configuration at the registry key HKEY_CURRENT_USER\Software\IntermountainSystems\SQLiteCEdit. For uninstallation or configuration reset, registry entries can be cleared using a new control in the SQLite/CEdit options dialog. SQLite/CEdit will remember all current configurable options, including:

• Grid view/text view preference for results
• Execute-at-cursor mode in the query editor
• Default database path for open/create actions

Binaries

This release includes both SH3 and MIPS binaries for Windows CE 2.0 systems. SH3 binaries are tested on an HP 620LX running CE 2.0. For the first time, the MIPS binaries have also been successfully tested, though on a newer NEC MobilePro running CE 3.0. The MIPS build of SQLiteCETest passes all 64 currently implemented test cases, with both the library and SQLite/CEdit executable appearing fully functional. Be aware, however, that as I still don't have a proper MIPS CE 2.0 system to test with, I cannot fully guarantee its functionality on earlier systems, though it is very likely it will behave just as well.