Liya is an application solution for accessing, at the same time, three database systems from a single user interface. It lets users interact with MySQL, PostgreSQL, and SQLite3 databases and perform various editing actions.
The GUI has a dark theme, and it comes with well-delimited action zones. The navigation through the menu is quite smooth, and the response to user actions is quite decent. Yet, the text size seems too small.
As per its functionalities, Liya allows users to move data content from any of the supported databases, as well as editing the tables' structure by dragging data or fields. Furthermore, it lets you, as a user, set up a password for the 'root' user, or create multiple admin-level users so that they can access the system from a remote machine.
To edit a table, you first have to select it from the Tables list and press the 'Go' button. The moment the data from the table is displayed, you are able to search through the fields and make the desired modifications.
To sum it up, Liya is a reliable DB tool for making modifications to three database systems simultaneously. At times, it may miss displaying the search results, and there are some issues with the boolean fields, so take those into consideration.
v2.0 [Aug 17, 2011]
Fixed Liya so it'll handle SQLite fields declared as Real. Also added .sql and .sqldb to the document file types (a set which includes sqlite, sqlite3 and db) that will automatically launch Liya.
This is a tool to create, design and edit database files compatible with SQLite.
