* Execute SQL queries and display results in the grid or as text.Īt first glance, version 2.0 is not much different from the latest version 1.7. BLOB fields can be edited with the integrated hex editor. Currently supports BMP, JPG, PNG and GIF image formats. * Display and edit data in the grid, including BLOB and image fields. * Easily transfer data between SQLite databases, import data from SQL scripts or ADO data sources, or export to SQL scripts.

* Create SQLite3 databases, view and change database parameters, check database integrity and vacuum (compact) databases. * Build SQL scripts and generate views visually using the integrated Query Builder. Easily restructure fields, indexes, constraints, triggers without losing data already existing in the tables.

* Edit tables and views visually, without writing a line of SQL. If you are on a webpage and there are some important functions disabled by the extension, then it is possible to unblock the script temporarily with just a few clicks.īy using SQLite Expert you will be able to: In case you want to start a new transaction in the selected database, you can choose the proper option from the main menu or execute a Begin command in an SQL script.The types of scripts can be allowed or blocked from the 'Options' window. SQLite Expert Professional supports transactions with rollback and atomic commit so you can easily correct recovery from failures and make sure that your databases won’t be affected due to system crashes. SQLite Expert Professional comes in handy for database administrators who need to manage multiple databases and execute SQL scripts using an intuitive interface. Additionally, you can add new entries by selecting the proper button located at the bottom of the application. The Design tab allows you to view, add, delete or modify fields, indexes, foreign keys, constraints and triggers using the right-click menu. SQLite Expert Professional is a straightforward and practical piece of software that helps you to manage and organize SQLite databases and gain better visibility into how your tables and classes are operating.

Sqlite expert pro