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). In addition, SQLite Expert provides the user with the ability to index all tables or import/export data to other formats. After that, you can view and edit all tables by selecting them in the tree structure panel on the left. 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. When you open the file you get a warning saying that the file is encrypted or not a database, and are then prompted to select an encryption type, select 'RSA'. It includes a visual query builder, an SQL editor with syntax highlighting and code completion, visual table and view designers and powerful import and export capabilities. The free SQLite2009 Pro browser will let you open SQLite databases which were encrypted with. You can easily change all fields, external keys, indexes, restrictions and triggers. SQLite Expert Professional is a powerful program designed for writing from simple SQL queries to developing complex databases. The main window displays all connected databases and you can run your own scripts with Query Builder.

The program will be useful both when creating new databases and when building and editing complex SQL queries. 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.

Sqlite expert