I’ve been playing with various GUIs off and on over the last couple of months. I find that I drop to mysql.exe quite often no matter which tool I use. My favorites until recently have been the MySQL GUI Tools and NaviCat.



I was using the Lite edition of Navicat. I actually started using navicat with postgres a few years ago. I like it but the lite version is limited in some annoying ways. It’s nice in that it runs (at least the mysql version) in Linux and windows. I don’t use a mac so that doesn’t really do anything for me.

I’m just back from a brisk walk around the Marriott World Center Resort in Orlando, FL.

What an amazing place! It is incredibly huge. I asked “How big?” when I was checking in and it has 2004 rooms, 265,000 square feet of meeting space, multiple pools (including some with waterfalls), at least one hot tub and a golf course. Oh yeah, and an alarm clock that doesn’t work. That’s my story and I’m sticking to it.

I’m here manning the EnterpriseDB booth with Derek Rodner and, my boss, Jim Mlodgenski. Jim is giving a presentation on Friday. We’re giving away copies of my book.

Set aside March 11 at 6pm for the first meeting of the Suncoast Postgres User Group. The SPUG serves Tampa, St Pete, Lakeland, Bradenton and the rest of central and western Florida.

You can get additional information at http://pugs.postgresql.org/spug

postgresql postgresql

Apatar is a provider of open source software tools for the data integration market. Apatar provides data integration to the companies by offering provides support, training, and consulting services for its integration software solutions.

Apatar provides connectivity to EnterpriseDB, Oracle, MS SQL, MySQL, Sybase, DB2, MS Access, PostgreSQL, XML, InstantDB, Paradox, BorlandJDataStore, Csv, MS Excel, Qed, HSQL, Compiere ERP, SalesForce.Com, SugarCRM, Goldmine, any JDBC data sources and more.

The free Community Edition is available for download and provides plenty of functionality out of the box. There is a also an Enterprise Edition that provides some additional features.

Postgres 8.3 is out and it contains plenty of new and improved features. Some of my favorites are: sql/xml support, text search, autovacuum improvements, performance improvements (significant) and some additional SQL changes.
You can read the press release.
You can also check out the feature list or review the simpler feature matrix which compares all of the versions since 7.4.
You may also want to read the release notes.
You can read about the release in the press by following along with the discussion at postgresql.org.

postgresql new release

EnterpriseDB’s CEO, Andy Astor, was named one of 13 “Top Leaders in Open Source Business” by LinuxWorld Magazine. EnterpriseDB was also recently named one of the “Top 20 Companies to Watch in 2008″ by Linux Magazine.

This is good news for open source and for people looking to save money on database license fees.

EnterpriseDB sells the open source based Oracle compatible EnterpriseDB Advanced Server as well as a packaged Postgres implementation. EnterpriseDB also offers consulting and training.

oracle enterprisedb

There is a new wiki comparing MySQL to PostgreSQL. Because it’s a wiki, hopefully it can be kept updated so that it’s current AND accurate.
The wiki is MySQL vs PostgreSQL.
Personally, I’d like to see this grow into a universal comparison site that the community could keep updated.
LewisC

There is a new wiki comparing MySQL to PostgreSQL. Because it’s a wiki, hopefully it can be kept updated so that it’s current AND accurate.
The wiki is MySQL vs PostgreSQL.
Personally, I’d like to see this grow into a universal comparison site that the community could keep updated.
LewisC

postgresql mysql