SQLite Sorcerer

Databases are found under various different formats, and are commonly used to store large quantities of info. Some programming knowledge might be required to work with a database, unless you rely on specialized applications like SQLite Sorcerer to handle them in a visually appealing, intuitive environment.

You get to check out the set of features in no time at all, since you only spend a little while installing the application. However, for this to be possible, and for all functions to work, you need to check whether or not Adobe AIR is installed on your computer.

Once launched, you can access a new database, or even create a new one. The database doesn’t have to be on a specific computer, in fact, it needs to be on the same on running the application. File support allows you to work with database files under formats like DB, DB3, or SQLite, which can either be dragged over the main window, or opened with the browse dialog.

With the database loaded, a side navigation panel shows up with a tree view of all elements such as tables, views, triggers, and indices. You can filter according to them in case only specific entries are of interest.

Selecting an entry shows its content in the rest of the space. Editing is fully integrated within the application’s set of features. Due to the polished, neat visual design, requirement fields, or options change state as you handle them, and mandatory requirement fields are marked.

You can create special queries to execute on the loaded database. You can load a query from an existing script, or save the one you’re working on. Moreover, the application is able to generate the entire database code at the press of a button, letting you copy it to clipboard.

If there are multiple databases on your watch, the application comes with a comparison feature. Loading target databases is done in the same manner, with differences shown in a table. However, keeping two databases active at the same time doesn’t change, or lock any edit options, thus letting you easily transfer data from one to the other.

Taking everything into consideration, we can state that SQLite Sorcerer is a practical application with which you can work on one, or two database files at a time, and also compare them when active. The visual design is fitted with all kinds of animations for almost every element you interact with, while editing, and export options are sure to make it worth your while.