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 > >
