SQLite/CE 0.10.0 is an incremental release that introduces a significant enhancement to the SQLite/CEdit Schema Explorer's table editor: row insertion, rounding out the editor's feature set and allowing users to add, remove or modify data in an SQLite database without writing a single query. Also in this release are a number of enhancements to the Grid View, context menus, keyboard shortcuts and more.
Also significant are changes to the core SQLite/CE library, which now features a fully compliant vsprintf() implementation that no longer ignores certain specifiers, which should reduce the likelihood of unusual bugs in more advanced operations now and into the future.
Row insertion
The Schema Explorer in SQLite/CEdit now allows users to insert rows in addition to editing or deleting them, making basic SQL-free database management a possibility for the first time. The table editor will now display a placeholder row at the bottom of the result set that users can edit and commit with type hinting. Users can NULL out a nullable field by using the new Ctrl+0/Ctrl+Delete keyboard shortcuts.
Grid View enhancements
Grid View now supports multi-row selection, including discontiguous selection with Ctrl+Tap. Users who prefer keyboard navigation can also now enjoy proper arrow key support for scrolling through result sets.
Context menu enhancements
SQLite/CEdit 0.10.0 features a reworked context menu that now includes an "Edit" submenu with most common operations (Copy/Paste/Select/etc) and adds more feature hinting to the view-specific submenus.
An Undo option has been added for table editor operations, allowing you to roll back accidental row deletions. This operation is still unsupported in the query editor, as during development it was discovered that CE 2.0's native Undo functionality, apparently geared towards single-line fields, is generally inadequate for more complex text operations and behaved erratically, and so it has been disabled and postponed to a future release for now as text undo will need to be implemented from scratch.
Internal enhancements
Version 2.8.17ce4 of the ported SQLite library is included in this release, which includes a fully-compliant vsprintf() implementation that should behave to standard expectations. Although ce3 eliminated bugs from our testing, we can now be more confident in its ability to handle more advanced query flows or unusual edge cases yet to be uncovered.
To support type hinting and other features in the future, the Schema Explorer's column metadata extraction has been internally reworked and moved to a function that can be called by other SQLite/CEdit features.
Binaries
This release includes both SH3 and MIPS binaries for Windows CE 2.0 systems. SH3 binaries are tested on an HP 620LX and an HP 360LX, both running CE 2.0. MIPS binaries are currently tested on an NEC MobilePro 790 running CE 3.0, as I lack an earlier CE 2.0 MIPS system to test with, but this package is expected to be reliable on such devices.