SQLite Expert Personal 1.7.87

SQLite Expert Personal 1.7.87 enables you to easily administer your SQLite3 databases and see better 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.

Major Benefits: By using SQLite Expert you will be able to:

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.

Major Features:

1. Create database   
2. View and change database parameters  
3. Register frequently used databases for using in SQLite Expert  
4. Check integrity  
5. Vacuum  
6. Transaction support
7. Create tables  
8. Delete tables  
9. Rename tables  
10. Restructure tables without losing existing data  
11. View, add, delete, modify, reorder fields  
12. View, add, delete, modify indexes  
13. View constraints
14. View triggers
15. Supports temporary tables
16. Create views  
17. Delete views  
18. Rename views  
19. View triggers
20. Supports temporary views
21. Execute SQL scripts  
22. Stop long running queries  
23. SQL history  
24. SQL syntax highlighting  
25. Save and load SQL scripts
26. Display and edit data in the grid  
27. Display data as text  
28. Data filtering  
29. Image editor (supports BMP, JPG and PNG)  
30. BLOB editor  
31. Text editor
32. 40 predefined data types  
33. Custom data types 

WareSeeker Editor