SQLite Expert Professional 1.7.87

SQLite Expert Professional 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, constraints, triggers without losing data already existing in the tables.
2. Build SQL scripts and generate views visually using the integrated Query Builder.
3. Create SQLite3 databases, view and change database parameters, check database integrity and vacuum (compact) databases.
4. Easily transfer data between SQLite databases, import data from SQL scripts or ADO data sources, or export to SQL scripts.
5. 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.
6. 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. View database schema report  
8. Export to Excel  
9. Export to XML  
10. Import and export from and to text files (CSV, TSV)  
11. Import data from ADO data source  
12. Transfer data between SQLite databases  
13. Export data to script  
14. Create tables    
15. Delete tables    
16. Rename tables    
17. Restructure tables without losing existing data    
18. View, add, delete, modify, reorder fields    
19. View, add, delete, modify indexes    
20. View constraints    
21. Add, delete, modify constraints  
22. View triggers    
23. Add, delete, modify triggers  
24. Supports temporary tables  
25. Create views    
26. Delete views    
27. Rename views    
28. View triggers    
29. Add, delete, modify triggers  
30. Supports temporary views  
31. Execute SQL scripts    
32. Stop long running queries    
33. SQL history    
34. SQL syntax highlighting    
35. Save and load SQL scripts  
36. Completely visual building of complex SQL queries  
37. User-friendly interface with drag & drop support  
38. Visual building of sub-queries and unions  
39. Visual criteria constructing tool for Where and Having clauses  
40. Save and load SQL scripts  
41. Display and edit data in the grid    
42. Display data as text    
43. Data filtering    
44. Image editor (supports BMP, JPG and PNG)    
45. BLOB editor    
46. Text editor    
47. Generate HTML Reports  
48. Lua scripting support  
49. Pascal scripting support  
50. Lua and Pascal example scripts  
51. 40 predefined data types    
52. Custom data types

WareSeeker Editor