SQLite Expert Personal 1.7.80

SQLite Expert Personal 1.7.80 is designed as a professional program that can allow you to  easily administer your SQLite3 databases and gain significantly better visibility into how your databases are operating.

In addition, SQLite Expert integrates database management and maintenance into a single, seamless environment, with a clear and intuitive graphical user interface.

Major Features:

1. Managing SQLite3 databases
   
   • Create database  
   • View and change database parameters  
   • Register frequently used databases for using in SQLite Expert  
   • Check integrity  
   • Vacuum  
   • Transaction support
2. Managing tables
   
   • Create tables  
   • Delete tables  
   • Rename tables  
   • Restructure tables without losing existing data  
   • View, add, delete, modify, reorder fields  
   • View, add, delete, modify indexes  
   • View constraints
   • View triggers  
   • Supports temporary tables
3. Managing views
   
   • Create views  
   • Delete views  
   • Rename views  
   • View triggers  
   • Supports temporary views
4. Executing SQL scripts
   
   • Execute SQL scripts  
   • Stop long running queries  
   • SQL history  
   • SQL syntax highlighting  
   • Save and load SQL scripts
5. Displaying and editing data
   
   • Display and edit data in the grid  
   • Display data as text  
   • Data filtering  
6. Image editor (supports BMP, JPG and PNG)  
   
   • BLOB editor  
   • Text editor
   • Data types
   • 40 predefined data types  
   • Custom data types

Major Benefits:

1. Edit tables and views visually, without writing a line of SQL. Easily restructure fields, indexes without losing data already existing in the tables.
2. Create SQLite3 databases, view and change database parameters, check database integrity and vacuum (compact) databases.
3. 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.
4. Execute SQL queries and display results in the grid or as text.