[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: Getting started with Postgres or MySQL

Roberto C. Sanchez wrote:
On Wed, Jan 31, 2007 at 02:54:01PM -0900, Joshua J. Kugler wrote:
In that same document, they give the reason for doing so:

"The reason for using the preceding rules in non-strict mode is that we can't check these conditions until the statement has begun executing. We can't just roll back if we encounter a problem after updating a few rows, because the storage engine may not support rollback. The option of terminating the statement is not that good; in this case, the update would be ???half done,??? which is probably the worst possible scenario. In this case, it's better to ???do the best you can??? and then continue as if nothing happened."

I'm sorry, but "our database can't always handle transactions" is not a
valid excuse for allowing bogus data.

And also provide a way (from 5.0.2 on) of enabling the "traditional" strict behavior. So, with one config option, MySQL will now reject all invalid data (providing you're using transactional engines, for reasons described above).

Please read this:


Now, tell me seriously that it is valid for any database to treat data
integrity as an *optional* feature.

As for your assertion that those who spec MySQL don't know what they're doing, I do believe the techs that work at MySQL are some pretty sharp cookies. I think they know what they're doing, and I'm sure they know how to either enable the above config option, or check their data before it gets to their database.

So what?  Microsoft has some absolutely brilliant architects, engineers
and developers.  They are still polishing a turd.

All products have their gotchas. One should be familiar with the product against which one is writing, or weird things will bite you down the road.

Boy, that's an understatement.



Maybe MySQL is not the best database engine in the world but it is one the best engines. I have worked on MySQL for several years and from four years ago I have started to develop my own database engine inspired by MySQL. During development of my own database engine (BromeliaSQL) I realized the magical techniques which have been used in MySQL which are unique. For example MySQL was (and maybe is) the only database engine which allows you to read and write to a table which has been indexed even by using B-Tree which is the most complex structure, at the same time. About allowing corrupted data, it is not the responsibility of database engine to verify if the data is valid or not since the database engine only "Manages" data and not validate. Although, MySQL have a very very powerful library of functions to validate and generate and validate date and kind in any possible format.


Reply to: