v0.8.0

SQLite/CE 0.8.0 introduces a new custom file picker interface to replace the CE default, giving much better flow for keyboard-forward users with full support for arrow key navigation and tabbing between fields. 0.8.0 also implements storage card awareness, allowing users to maintain separate default directories for local and card storage, with an option to prefer the latter when a card is inserted. This version also introduces database backups, allowing a user to save timestamped copies of their databases on demand before making major changes or for retention purposes.

UI enhancements

SQLite/CE 0.8.0 introduces a new custom file picker with full keyboard support including arrow keys, tab and enter, replacing the CE standard dialog and allowing users to quickly open or save databases and queries without needing to tap the screen. Smart Ctrl+O behavior allows a user to open a database immediately when there is no active database and nothing has yet been typed into the query editor buffer. If the user has opened a database or typed something, Ctrl+O will rebind back to Open Query.

The context menu "Help" area has now been replaced by a proper CE Help button in the upper right next to the exit button. Currently, this only displays the About dialog, but will later grant users access to SQLite/CEdit help as well as a SQLite 2.x language reference.

Table editor enhancements

The Schema Explorer's table editor now supports deleting rows by pressing the delete key when a row is highlighted, with confirmation.

Database backups

Users can now back up a database using a dedicated control that creates a timestamped .bak.db copy in a configurable backup directory. Database backups can be directly opened themselves, or copied back over an existing database and renamed to .db to restore. Further automation of backup restores will be implemented in future releases.

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. While 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.