SQLiteManager

With SQLiteManager, you may create, edit and manage sqlite databases faster and easier. It provides a user friendly interface, with clear and easy to understand functions to go with it. The software allows you to query data with a single click, create indexes or triggers faster, write your own plug-ins and automate repetitive actions and perform all sorts of basic or advanced tasks, without too much effort.

The setup file is almost 12 MB and it does not take long to install the program on your computer. It is distributed for Windows and Mac OS X platforms. If you opt for the Windows edition, you can run it on Win XP, Vista and Win 7. The program is not freeware, but you can try it free of charge, with a few restrictions.

When launched, SQLiteManager will place a series of options at your disposal, for creating different database types, such as file based or in-memory databases or encrypted databases. You can also choose to connect to a cubeSQL server. The user interface has the same layout and options, regardless of your initial choice.

The software allows you to create tables of contents, indexes and other components, edit them, verify or analyze your database, generate charts and perform other actions, in different sections of the interface, which can be accessed via navigation buttons, located on a toolbar. Creating new components, executing scripts or performing other actions can be done on separate windows. Most configurations are quite easy to make. For example, if you wish to create a table, you just need to create a few columns, set their content type to text, integer, timestamp or others and select one or more constraints for each column, such as primary key, auto increment, unique and so on. To create an index, you must name it, select a table and target one or more columns. The corresponding code will be generated automatically, on the same window.

Although the software provides support for inline editing, its trademark record editor can make your work much easier. It allows you to interact with your data in various ways and you can also save individual values as files and load them when you need to. SQLiteManager allows you to edit a few predefined scripts or create new ones. Additionally, the program's Lua-based scripting language can be useful if you wish to write your own plug-ins and automate repetitive tasks, like inserting records in loops, downloading data and many others.

You can perform many analysis tasks on your database and generate various charts. The program allows you to choose between bar or pie charts, radar, scatter or Venn charts and QR code. Each chart type can be displayed in different ways. For example, a pie chart can be made 2D, 3D or concentric. There are a few cases in which you have to write a few code lines, but most operations can be carried out just by clicking a series of options.