Whether you are developing new SQLite databases or simply build and edit complex SQL queries,
SQLite Expert Personal
is a practical and reliable utility worth having when you need to perform such actions.
Using SQLite Expert Personal you have the possibility to quickly administer SQLite databases and gain significantly better visibility into how your tables and classes are operating. It integrates repository management and maintenance into a single environment, with an intuitive and user-friendly interface.
The main window of the utility displays all the connected databases and allows you to execute your own SQL scripts using the Query Builder option. You are able to easily restructure fields, foreign keys, indexes, constraints and triggers without losing any data. Simply point the utility to the Data tab and quickly perform any action you want.
When you launch the application for the first time, SQLite Expert Personal will choose a default alias for the database, but you can change it according to your preferences. Then you can easily open an existing database or create a new one by navigating to the File menu. After choosing the database you are interested in, you are able to view all the tables in the left tree panel and edit them by running complex SQL scripts such as Delete, Update, Insert, Create or Alter Table.
The Databases grid displays information about each internal database and allows you to view the total number of existing indexes, triggers, tables and views.
When you need to create a new table, you can simply navigate to the Design tab and hit the ‘Add’ button, which is located to the bottom of the application. Then, you are required to specify details such as name, type, size and precision and quickly create a new table that can be easily customized. In case you want to edit an existing table, select the one you want in the left tree panel, navigate to the Design tab and add, delete or modify existing foreign keys, constraints and indexes.
Additionally, with the help of SQLite Expert Personal you can reindex all the tables, release a savepoint or commit a transaction in the selected database using the Transaction menu effortlessly.
Considering the main purpose for which SQLite Expert Personal was designed, building complex SQL scripts and managing multiple databases at the same time becomes a simple task when using this application.