Business Machine

Technology, business
and innovation.

And, not least, about
the Mac.

Weblog Archive Cutedge

by: Bernard Teo

Creative Commons License

Copyright © 2003-2012
Bernard Teo
Some Rights Reserved.

The Ultimate Business Machine - Archives

List of Categories : Database * Technology * Commentary * Singapore * Travel *

Mon 20 Feb 2012

Postgres Fixes in Liya 2.0.4

Category : Technology/Liya2dot0dot4.txt

I've fixed some annoying Postgres problems that Liya was having. I was trying to make Postgres work exactly like MySQL, from the point of view of a Liya user, although they work very differently in the way they are set up.

For example, I wanted to be able to create a new user for either database in Liya, and have this user be able to access either database system from any client machine.

And this user would then be able to create and modify new databases, tables and fields.

With Liya 2.0.4, I think I've finally nailed it so both database systems work exactly alike to a Liya user. I've been able to hide the internal differences between the two systems behind a common programming interface, so this benefit will also accrue to other database-centred applications that we are developing, like Luca

So Liya for Lion 2.0.4 is available for download now. It'll be available also at the Mac App Store, soon as Apple approves it.

I also have a new version of our PostgreSQL installer for Mac OS X Lion. It installs the latest PostgreSQL version 9.1.4. I'll release it tonight when I can get a faster internet connection. I'm now working at the King Albert Park McDonald's while my kid is studying for his exams.

Posted at 7:27AM UTC | permalink

Put your Mac to Work Now how would you do something like that?

Weblogs. Download and start a weblog of your own.

A Mac Business Toolbox
A survey of the possibilities

A Business Scenario
How we could use Macs in businesses

VPN Enabler for Mavericks

MailServe for Mavericks

DNS Enabler for Mavericks

DNS Agent for Mavericks

WebMon for Mavericks

Luca for Mavericks

Liya for Mountain Lion & Mavericks

Postfix Enabler for Tiger and Panther

Sendmail Enabler for Jaguar

Services running on this server, a Mac Mini running Mac OS X 10.9.2 Mavericks:

  • Apache 2 Web Server
  • Postfix Mail Server
  • Dovecot IMAP Server
  • Fetchmail
  • SpamBayes Spam Filter
  • Procmail
  • BIND DNS Server
  • DNS Agent
  • WebDAV Server
  • VPN Server
  • PHP-based weblog
  • MySQL database
  • PostgreSQL database

all set up using MailServe, WebMon, DNS Enabler, DNS Agent, VPN Enabler, Liya and our SQL installers, all on Mavericks.