Bad data, no biscuit.

To: John Robinson

The newest version of MySQL now more closely rivals PostgreSQL. Not knowing the version you currently use or how it is implemented, you may want to look into the upgrade.

However, for the longer term, you may want to explore more "business robust" open-source DBMS environments such as PostgreSQL and Ingres. Unfortunately, there would likely be minor SQL implementation differences (why can't SQL be totally standard?!).

In my humble opinion, any of these options would be a viable choice for the type of data demands you have on Free Republic. For read speeds, you may find Ingres to be the fastest for the reliability, with PostgreSQL next in line. My SQL trades off a bit in robustness of data for pure speed. It is a nice tradeoff for low-end servers, but not so much for more critical environments.

Finally, I know for business use MySQL requires a business license to be safe. It is not a big cost (hundreds of dollars). But PostgreSQL is totally free and it appears Ingres would possibly be the same now.

Computer Associate's Ingres R3:

http://opensource.ca.com/projects/ingres

Ingres Open Source license:

http://www3.ca.com/Files/Licensing/trusted_open_source_license.pdf

PostgreSQL:

http://www.postgresql.org/

MySQL(you are already very familiar with this):

http://dev.mysql.com/

121 posted on 10/21/2005 11:30:50 AM PDT by ConservativeMind

To: John Robinson

I'm sorry to not have noticed post 46, in which you mentioned more database information.

I encourage you to go forward with the new implementation if possible, as that will have to be done soon, anyway.

Jim, I hope the best for you and your other development guys. But I would still push you a bit toward prototyping on one of the other two environments in the future. They are inherently more reliable (fully ACID-compliant!).

122 posted on 10/21/2005 11:50:18 AM PDT by ConservativeMind

To: John Robinson

When I saw the Bisquick announcement on the main forum I thought we were having a pancake breakfast. :-)

123 posted on 10/21/2005 11:52:52 AM PDT by WestCoastGal (I'm not gonna send our cowboy back out there to get hurt. We need him healthy for the next rodeos.)

To: John Robinson

Thanks for everything you do to keep us up and running!

124 posted on 10/21/2005 5:38:41 PM PDT by StarCMC (Old Sarge is my hero...doing it right in Iraq! Vaya con Dios, Sarge.)

To: John Robinson

I kept wondering why there was a biscuit shortage. I need something to eat with my tea.

125 posted on 10/21/2005 8:44:15 PM PDT by moog

126 posted on 10/21/2005 8:59:59 PM PDT by Frank_2001

To: John Robinson

127 posted on 10/21/2005 9:10:26 PM PDT by Delta 21 (MKC USCG-ret)

To: John Robinson

Nevermind. I thought this was a Recipe thread.

For all you do, *Kudo's* to ya', John!

128 posted on 10/21/2005 10:09:14 PM PDT by JUMPIN JEHOSPOHAT

129 posted on 10/21/2005 10:25:51 PM PDT by JUMPIN JEHOSPOHAT

FreeRepublic, LLC, PO BOX 9771, FRESNO, CA 93794