Chris, pgAdmin III is a good tool for PostGres.
Jacques ----- Original Message ----- From: "Chris Howe" <[EMAIL PROTECTED]> To: <dev@ofbiz.apache.org> Sent: Wednesday, January 17, 2007 3:03 AM Subject: Re: recommended upper/lower case setting for mysql > I'd like to stop dealing with some of the quirks. And > they seem to be up to something with some recent > activity..are there any decent GUI tools to mess with > Postgresql? It has an odbc so at worst case it can be > used through access. I've been using Sqlyog for MySql > recently and I had only originally used MySql because > of phpmyadmin. > > --- "David E. Jones" <[EMAIL PROTECTED]> wrote: > > > > > On Jan 16, 2007, at 5:28 PM, Si Chen wrote: > > > > > Actually, believe it or not it's for the table > > names. I ran into > > > problems moving stuff between windows, linux, and > > os x because the > > > MySQL defaults are different for each one. I > > thought since that > > > ofbiz can run fine with case-insensitive, it might > > be better to > > > recommend to everybody to do the case-insensitive > > setting as a > > > lowest common denominator. > > > > Interesting... gotta love database quirks! > > > > I think this is fine. I did a quick search on > > docs.ofbiz.org for > > "mysql" and I see mention in a number of pages, but > > we should really > > have something like a bunch of database how-tos, in > > the case a "MySQL > > How-To" page or something along those lines. > > > > There has been a fair amount of discussion about > > MySQL lately with a > > number of different issues that it would be good to > > address in such a > > document (if a good best-practice solution exists). > > > > BTW, for anyone reading in: I don't mean to single > > out MySQL here, > > and in fact I personally don't recommend that people > > use MySQL with > > OFBiz, especially if they need to do anything > > internationalized or > > the like, and I have issues with the MySQL licensing > > policies to some > > extend, and practices to a large extent. Anyway, my > > favorite > > production database for OFBiz is PostgreSQL, just in > > case anyone is > > wondering. > > > > -David > > > >
