Monday, September 14, 2009

SQLite Expert Professional v2.1.8 Portable powerful visual tool

SQLite Expert is a powerful visual tool that enables you to easily administer your SQLite3 databases and gain significantly better visibility into how your databases are operating. SQLite Expert integrates database management and maintenance into a single, seamless environment, with a clear and intuitive graphical user interface.


Features and Benefits
- Edit tables and views visually, without writing a line of SQL. Easily restructure fields, indexes, constraints, triggers without losing data already existing in the tables.
- Build SQL scripts and generate views visually using the integrated Query Builder.
- Create SQLite3 databases, view and change database parameters, check database integrity and vacuum (compact) databases.
- Easily transfer data between SQLite databases, import data from SQL scripts or ADO data sources, or export to SQL scripts.
- Display and edit data in the grid, including BLOB and image fields. Currently supports BMP, JPG and PNG image formats. BLOB fields can be edited with the integrated hex editor.
- Execute SQL queries and display results in the grid or as text.

September 12, 2009: Version 2.1.8. build 1876
* Enabled editing triggers and constraints in Personal Edition.
* Enabled cell select mode. Added option to switch between cell select and row select modes.
* Modified query parameter prompt to accept string parameters not enclosed in quotes.
* Added 'Generate random data' function.
* Improved error handling.
* SQLite library 3.6.18 is now included.

* A few internal bug fixes.