SQLite Expert Personal is a convenient utility for creating and managing several SQLite3 databases with a simple interface and the ability to edit tables and execute queries and scripts. The program will be useful both when creating new databases and when building and editing complex SQL queries. The main window displays all connected databases and you can run your own scripts with Query Builder. You can easily change all fields, external keys, indexes, restrictions and triggers.
The first time you run the program, it will select the default database alias (Alias), then you can change it at your discretion or open an existing database in the "File" menu. After that, you can view and edit all tables by selecting them in the tree structure panel on the left. In addition, SQLite Expert provides the user with the ability to index all tables or import/export data to other formats.
The main difference from the version of SQLite Expert Professional is that this version is completely free of charge for any use, but has a slightly limited functionality (in the Pro-version there is a wider possibility to work with SQLite functions).
- the program is completely free for both private and commercial use;
- a simple user-friendly interface;
- visual editor of SQL Query Builder queries;
- the ability to transfer data to different formats;
- convenient tools for data editing;
- Unicode support;
- support for SQLite add-ons.