[ale] Java -> Data Integrity ->SQL Servers

[Mike Harrison]

> > On Tue, 29 Aug 2006, Geoffrey wrote:
> >> Well, you can always get more speed if data integrity is not important.
> > 
> > While true, as a basic statement. There is nothing that I can find 
> > in Java the makes 'data integrity' better. In fact, I think it obscures 
> > data, makes it hard to work with, extremely hard to debug...
> > way to much 'it's a magic black box object you feed other objects to and 
> > maybe what you want will come out of it' 
> 
> Actually I was referring to the comparision of Postgresql and Mysql.


I run both, PostgreSQL and MySQL. While PostgreSQL is definately a more 
robust database engine with more features.. MySQL is a wonderful tool for 
basic web based smaller database stuff, content, light math.. user/member 
data.. And for serious stuff with a budget, I'm one of the few that really 
like Sybase, and keep an install of 11.0.3 handy.. Oracle? Too intense for me. 

But I've never had a problem with "data integrity" with any of them. 
Not including the applications that were using them, of course. 
Oh boy.. have I made some glorious mistakes, and learned from them. 
And I've uncovered some in others code as well.