Re: PgSQL vs MySQL

2004-03-03 Thread Mark Warner
as in the relative PgSQL list. This supports my belief that PgSQL is a better DB platform. Thank you all for your information. Good Day, Mark Warner. David Griffiths wrote: One other point that I forgot I mentioned - PostgresQL does not have a decent replication solution. There are a few solu

Re: PgSQL vs MySQL

2004-03-03 Thread Mark Warner
The thing which bothers me most about MySQL is the lack of a proper boolean. I don't like having to abstract a tinyint(1) into true or false. As much of my work involves building applications with Yes or No questions, I think I am switching to PostgreSQL. [EMAIL PROTECTED] wrote: What advantag

PgSQL vs MySQL

2004-03-03 Thread Mark Warner
What advantages, besides ease of setup, does MySQL hold over PostgreSQL? It would seem, to me, that the two are close competitors (both in quality, and performance). Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[

Re: Index on a bit?

2004-01-27 Thread Mark Warner
Sounds to me like you are either trying to re-invent the wheel, or you're running your database on an old 10MB hard drive. I would just use 8 discrete fields, indexed, and "waste" those 7 extra bytes. -Mark Mike Boone wrote: Hi all, I was hoping to use a TINYINT to store 8 distinct boolean va