SQLiteManager

Developer’s Description

Inline editing done right

Inline editing is always difficult within most database management apps, where available space is limited and there are no options which are easily accessed. With SQLiteManager 4, a special popover window is displayed when you click on a cell which has plenty of space and options available.

Table editor with live sql preview

The Table editor is incredibly powerful. Based upon your settings, it automatically recognises whether the Alter Table operation is natively supported by sqlite or whether a special transaction is required. Live SQL preview offers you detailed information about the sql generated by your actions.

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.

Pros:
The software makes it easier to manage sqlite databases. It allows you to create tables, indexes and perform numerous tasks faster, without typing too much code. You can verify and analyze your databases, create various charts and more, without too much effort.

Cons:
SQLiteManager’s trial version comes with a few restrictions.

With SQLiteManager’s powerful and effective features, sqlite databases can be managed much faster and easier.

DB Browser for SQLite (DB4S) is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite.

DB4S is for users and developers who want to create, search, and edit databases. DB4S uses a familiar spreadsheet-like interface, and complicated SQL commands do not have to be learned.

Controls and wizards are available for users to:

• Create and compact database files
• Create, define, modify and delete tables
• Create, define, and delete indexes
• Browse, edit, add, and delete records
• Search records
• Import and export records as text
• Import and export tables from/to CSV files
• Import and export databases from/to SQL dump files
• Issue SQL queries and inspect the results
• Examine a log of all SQL commands issued by the application
• Plot simple graphs based on table or query data