2.0 Aug 6th 2011. Liya version 2.0 for Lion released.
2.0.1 Aug 19th 2011. Added the Minimum System Key to denote that the app will only work on Lion.
2.0.2 Aug 24th 2011. Improved support for SQLite databases. Liya now knows how to handle SQLite tables which were created with data types specified in UPPER-CASE, as well as SQLIte databases which include stat tables. Liya can now open such databases properly.
2.0.3 Nov 7th 2011. Minor bug fixes.
2.0.4 Feb 19th 2012. Fixed a problem whereby a new PostgreSQL database user, created from Liya, does not have the correct privileges granted to it to create tables in the database.
2.0.5 Mar 8th 2012. Bug fixes. Includes updated database connectors to match the latest versions of MySQL, Postgres and SQLite3. Also, Liya will now do everything with a Postgres database that it can currently do with a MySQL database. For example, Liya can now do data entry and searches for data in fields with quotes, double-quotes, apostrophes, umlauts, diacriticals, any human language (like Traditional or Simplified Chinese or Tamil), and even partial date strings, for both MySQL and PostgreSQL databases, and it will do it consistently across Mac, iPhone or iPad devices.
2.0.6 July 1st 2012. Bug fixes for timestamp handling in PostgreSQL and SQLite3, and for Boolean handling in SQLite3. Plus numerous other bug fixes. Please keep your bug reports coming. The Search function has been changed to bring it more in line with the way Liya works on iOS devices, i.e., Liya now searches against the database, as opposed to searching against the records retrieved. This is meant to help Liya work faster across a slow Internet connection and the user can now specify a batch size for the number of records Liya should fetch each time. Finally, there is a revamped interface for sending arbitrary SQL commands to the database. And, one more thing, this is also the first version of Liya that will work on Mountain Lion, though we haven't implemented the Sandbox yet (that'll bring some restrictions and loss of features, believe me).
2.0.7 July 24th 2012. Bug fixes. Also fixed Liya so that SQLite databases (with .sqlite, .sqlite3 and .db file extensions) can simply be opened by double-clicking from the Finder, as has often been requested.
2.0.8 Aug 23rd 2012. Bug fixes for SQLite date field handling. Added ability to open connections to MySQL and PostgreSQL databases on non-standard ports. This version tested also to work with MariaDB databases. Will work on Mountain Lion.
2.0.9 Sep 2nd 2012. Added the ability for Liya to connect to MySQL, MariaDB and PostgreSQL databases via specified named sockets. Our SQL database installers for MySQL, MariaDB and PostgreSQL now come with Preference Panes that allow you to start the database from custom ports.
2.0.10 Sep 2nd 2012. Tabular data from Liya can be dragged and dropped onto a spreadsheet like Numbers but the number of columns brought over was always one short because of a stupid bug. This has been fixed in version 2.0.10.
2.0.11 Dec 1st 2012. Fixed Liya so it'll handle SQLite fields declared as Bool. Liya will treat it as an integer, and map it to the Cocoa NSNumber data type. Also, while it was always possible to drag and drop Liya table contents data onto a spreadsheet like Numbers, this version makes it easier by turning on also copy and paste. Liya will now also show the version number of the MySQL, MariaDB or PostgreSQL database that it is connecting to in the title of the connection window.
2.0.12 Dec 1st 2012. 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.
2.0.13 Oct 23rd 2013. Fixed Liya so it'll handle SQLite fields declared as very long 64-bit integers. Some bug fixes for date and number formatting. This version has also been tested on Mavericks. From this point on, Liya will be a 64-bit binary, dropping support for 32-bit machines and OS X Lion.
3.0 March 8th 2014. Support for the App Sandbox in the (currently awaiting review) App Store version, plus support for SQLite dates created by Core Data, plus some bug fixes and minor interface improvements.
3.0.1 March 18th 2014. The Mac Sandbox requires the Open Panel to be used for navigating to SQLite files, and so the URL and Database Name fields, in Liya 3.0, were locked from editing to force the user to use the Open Panel. However, if the user has Command-copied a path to a SQLite file (onto the pasteboard), Liya 3.0.1 now allows the user to Control-Click on the URL field to get a contextual menu that allows the URL to be pasted into the URL field, which then helpfully opens the Open Panel, thus restoring the copy-and-paste functionality, while still meeting the requirements of the Sandbox. Also, for the non-App Store version - restored the ability to check for updates to Liya from the Help menu.
3.0.2 April 13th 2014. This a bumper bug fix release. Fixed some of the more quirky user-interface oddities, so it’ll work as modelessly (and smoothly) as I can make it. This is the first version to get iCloud support for the App Store version. You can share SQLite files in iCloud with the (soon-to-be-released) iPad version of Liya. Fixed a bug when working in Mavericks where the smart quotes get in the way of entering custom SQL commands. Also, at some point, MySQL stopped allowing the time zone to be included in a timestamp field. Updated Liya to handle this rejection more gracefully. Finally, one oft-requested feature - Liya now reports SQL command line errors when users run custom SQL commands (or when Liya has a bug). I’ve made so many changes in this version that I could have introduced even more bugs. As usual bug reports are very welcome.
3.0.3 April 29th 2014. Minor bug fixes.
3.0.4 May 29th 2014. Bug fix: Custom SQL Command field didn't allow the use of the Character Input Menu, e.g., to choose Pinyin to enter Chinese characters into the SQL query string. This has been fixed. Made MySQL connections work more like PostgreSQL connections, in terms of the choice of character set used. The character set used in each connection to the database follows that of the database. If at the point of the connection, no database has been chosen, then the connection defaults to using UTF8. New databases in Liya are created using UTF8 as the default character set. Also fixed a crash while importing and exporting databases that occurred after version 3.0.3, when Liya was made to be Sandbox-compliant.
3.0.5 October 27th 2014. The Mac App Store version of Liya on Yosemite now works with iCloud Drive.
4.1 March 14th 2018. Reduced the number of Mac OS versions Liya works with to El Capitan, Sierra and High Sierra. This version includes some minor user interface bug fixes.
5.0 February 28th 2020. This version of Liya works with MySQL 8 and PostgreSQL 11.
5.0.2 May 11th 2020. Liya calculates timestamp for SQLite from 1st January 1970, if the data is stored as an integer or real number rather than a date string.
5.0.3 November 6th 2020. This is the version of Liya that will work on both Catalina and Big Sur. It is a “fat binary” that will work on Intel-based Macs (Catalina and Big Sur) and ARM-based Macs (running Big Sur).
5.0.4 November23rd 2020. Fixed interface oddities when the app is viewed in Dark Mode.
5.0.5 February 2021. 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.
Jan 30, 2014
Dec 21, 2013
Aug 03, 2013
Dec 8, 2012
Nov 23, 2012
Nov 18, 2012
Nov 14, 2012 Biguanodon
Aug 9, 2012
Jul 10, 2012
Jun 26, 2012
Mar 21, 2012
Mar 19, 2012
Mar 13, 2012
Feb 28, 2012
Feb 20, 2012
Dec 17, 2011
Nov 15, 2011
Nov 1, 2011
Sep 9, 2011