Lita

Database administration is a serious job and it can be carried out only by those with solid knowledge in this area. Having a set of appropriate tools for managing the data contained inside the special files is also mandatory and a utility like Lita could help a lot those who have to deal with SQLite databases.

This Adobe AIR based tool installs and runs smoothly, so the user friendly GUI should open in a couple of moments and allow you to perform the needed tasks.

Split into several areas and sporting several tabs, the main window of Lita has all the functions in plain sight and easily accessible, for increased efficiency in working with the loaded files.

Once you open an existing database or create a new one, since this is also possible with this program, the tables and the entire structure will become available. Adding tables can be done on the spot, while inserting new fields, copying the table or exporting the structure are one click away.

In order to view the records contained inside the SQLite databases and add new ones you can use the dedicated area of the application. Equally easy, importing statements from SQL files, executing and then saving them as new are some of the operations supported by Lita.

There is a specialized module for those who need to encrypt or re-encrypt databases, while exporting the data or compacting a database are also one click operations.

All things considered, it's safe to say that Lita is indeed a smart choice for the database administrator who wants to make daily tasks more easy to carry out. With enough features and a pleasant look, this app could be a great helper for many users.