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.
User interface bug fix. The OK button was inadvertently occluded by an invisible UI element, making it sometimes difficult to detect a mouse click. This is fixed in this version.
Ratings and Reviews
excellent liteweight database viewer-editor
Just updated to 5.0, connected to a mysql 8.0.19 database, selected a table, and added some new records. (It took longer to write this note than it did to update to the database via Liya).
Sure, it doesn't do everything MySQL Workbench does... but it isn't always practical to use a 20,000 pound SnapOn tool truck just to turn on a light switch in the garage.
Huge thumbs up to the developers for continuing to provide a simple, fast, liteweight solution that works! :)
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.
Excellent lightweight tool.
I only wish there was a way to refresh the schema view without closing/opening the connection.
Data Not Collected
The developer does not collect any data from this app.
Privacy practices may vary, for example, based on the features you use or your age. Learn More
- Bernard Teo
- 11.1 MB
- Requires macOS 10.15 or later.
- Age Rating
- © Bernard Teo, cutedgesystems.com
With Family Sharing set up, up to six family members can use this app.