v0.2.0

SQLite/CE v0.2.0

This preliminary release is a significant improvement on the 0.1.0 MVP's usability, featuring import/export functionality for both queries and entire databases, along with other improvements.

Data import and export

SQLite/CE 0.2.0's most major usability improvements are in data movement, with the ability to import and export the following:

• SQL queries: Can be saved and loaded in .sql format
• Tables: Can be exported and imported from CSV files with type inference
• Databases: Can be exported (copied) in native SQLite format, or as a folder of CSVs for each table. :memory: can also be exported for saving/instantiating scratch data.

User interface

Version 0.2.0 adds resizable fonts to the query and result views that can be changed independently of each other, as well as more responsive UI features such as selective greying of options based on current operating context. A new dedicated control for closing an open database has been added to the command bar for environments where databases can only be accessed by one application at a time. Currently, this feature will disconnect any active file database and return the context to the :memory: database.

To install:

• Place SQLiteCE.dll in the /Windows directory
• Place the .exe files in any location you like on the device.