Current Version: 4.0.2
Last Updated: 6 months ago
Download Size: 2.6 MB - Download
Liya allows a user to access three Database Systems simultaneously from a single visual interface.
Liya can access MySQL, PostgreSQL & SQLite3 databases, all in the same way, using a simple 3-panel display - one panel for selecting the database and the table, another for editing the table structure, and the last for editing the contents of the table.
Liya can access databases in all three systems simultaneously, using multiple windows, with each window showing the contents of a single database.
And Liya will move data from one database to another, just by dragging and droppiing. If you need to copy the table structure of one table to another, even across database systems, simply drag and drop across windows. Do the same with data. You can export data from one database for backups that can be read by any of the other databases.
General bug fixes. Also, for custom SQL commands, the column order will now follow the given Select statement.
Most Helpful Reviews
Beautiful free application, works well - I just wanna view a sqlite3 databasa and then found this wonderful application, it's beautiful and free. what is to be most important, it works well.
Can’t open existing databases - The app worked well for a few hours, but suddenly stopped displaying the action sheet that allows you to modify connection parameters. Deleting prefs didn’t help. Reinstalling app didn’t help. In its current state, I am unable to select a database to open, rendering the app useless for my needs.
More Reviews for Current Version
Works great for me - I’ve been using this for several years to help me debug CoreData in my apps. It works great. The author has also been responsive when I have contacted him about issues. The one thing I hope he will add is support for SQLite databases encypted using SQLCipher. Hint for those having problems opening a database: you can drag a .sqlite file directly on the Liya app icon to open that database.