|
Roberto C. Sánchez
roberto at connexer.com
Tue Mar 27 05:42:03 EST 2007
On Tue, Mar 27, 2007 at 10:06:16AM +0200, Bart wrote: > > Sounds accurate enough, except I consider them unnecessary quirks > instead of shortcomings. I recently gave MySQL a real chance > (in a real app) and yes, you can work with/around all the quirks, but it's > stupid that you have to *know* about (read:trip over) all of them first - > what are RDBMSes for if not the convenience, y'know? > (Not speed, for one, and yet that seems the reason for many of > MySQL's oddities, which is the reason I have trouble taking it seriously) > Sorry, but accepting invalid input without error, truncating overly long input and clipping overflowed numbers are not "quirks". They are serious data integrity issues. Think about it. If you develop multiple applications (by different teams or developers) against the same MySQL database, the *only* assurance that you have that your data won't get hosed is that *every* developer implements the proper data integrity checks in the application layer. That is wrong on so many levels it is not evn funny. > But talking about convenience: phpmyadmin is useful, while phppgadmin > is currently hopeless, which is relevant to database servers you don't have > admin control over, since they're typically a pain to poke around. > I've been using postgres for almost all serious things, but for my quick > proof-of-concept projects even on my own server I use mysql > because of just this. > That's fine. At least you aren't really using MySQL in production :-) Out of curiousity, what specific shortcomings do you see in phppgadmin? Have you tried pgadminIII? I've used both phppgadmin and phpmyadmin and found both to be adequate tools. > Back to the list/subject: > 'course, the MySQLdb module has an annoying quirk in unicode behaviour > until recent versions. I had to write a wrapper around it or have it bork on > still semi-current versions. > > I believe SQLObject does some similar wrapping, by the way. > Regards, -Roberto -- Roberto C. Sánchez http://people.connexer.com/~roberto http://www.connexer.com -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: application/pgp-signature Size: 189 bytes Desc: Digital signature Url : http://mm_cfg_has_not_been_edited_to_set_host_domains/pipermail/mod_python/attachments/20070327/5a6e5cc0/attachment.bin
|