Liya

Licence: Freeware
Version 3.0.3 | Release Date: 2014-05-01 | Download

What's New in Version 3.0.3

Minor bug fixes.

Version 3.0.2 | Release Date: 2014-04-24 | Download

What's New in Version 3.0.2

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. You can share SQLite files in iCloud with the iPad version of Liya.

Fixed a bug in the Query field 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.

Version 3.0.1 | Release Date: 2014-03-25 | Download

What's New in Version 3.0.1

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 at the correct URL, thus restoring the pre-3.0 copy-and-paste functionality, while still meeting the requirements of the Sandbox.

Plus, there are other bug fixes. Enjoy...

Version 3.0 | Release Date: 2014-03-14 | Download

What's New in Version 3.0

This version works with the Mac App Sandbox. Also provides support for SQLite dates created by Core Data. Plus some bug fixes.

Version 2.0.13 | Release Date: 2013-10-21 | Download

What's New in Version 2.0.13

General bug fixes. SQLite data handling improved for 64 bit large integers.

Version 2.0.12 | Release Date: 2013-06-25 | Download

What's New in Version 2.0.12

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.

Version 2.0.7 | Release Date: 2012-08-09 | Download

What's New in Version 2.0.7

Bug fixes. Also fixed Liya so that SQLite databases (with .sqlite, .sqlite3 and .db file extensions) can simply be opened from the Finder, as has often been requested.

Version 2.0.6 | Release Date: 2012-07-14 | Download

What's New in Version 2.0.6

Bug fixes for timestamp handling in PostgreSQL and SQLite3, and for Boolean handling in SQLite3. Thanks for sending me your database samples so I can fix the bugs. Yes, I know the UI is quirky and I should lose that icon, but one step at a time.

Version 2.0.5 | Release Date: 2012-03-14 | Download

What's New in Version 2.0.5

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.

Version 2.0.4 | Release Date: 2012-02-26 | Download

What's New in Version 2.0.4

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.

Version 2.0.3 | Release Date: 2012-02-14 | Download

<div class="product-review" metrics-loc="Titledbox_What's New in Version 2.0.3" more-text="More">

<h4>

What's New in Version 2.0.3
</h4>



<p>Minor bug fixes</p>


</div>