Posts by Sheeri Cabral
The database schema really should be source controlled in the same place as the application code, because otherwise how do you know what changes happened when, and which version of the code goes with which version of the schema. The problem I have is this — being a purist (and by the way, *not* a programmer so there could very well be concepts I’m missing), I really want to source control the DDL/GRANT statements and whatever that are applied to the production database, because that way anyone can see exactly what was run, and I can do a schema backup and compare to the source controlled version.
A company has come up with a vendor-neutral database certification exam. Some are wondering how much use this will be, as it doesn’t go into vendor-specificities. For me, it will be interesting to see if companies value a vendor-neutral database certification as they would a degree. It seems to cover the same topics, at least from my standpoint.
Well, Paul Vallee tagged me, and as I haven’t yet passed my probationary period I should probably answer the call…..Eight things about me that aren’t common knowledge:
n Stuffing Six Million Pages Down Google’s Throat, Tim O’Reilly brings up a point, and some questions. . . just how poorly the big search engines index small sites with large collections of data . . .But it’s worth thinking about absolute (and temporary) limits to the growth of Web 2.0. What constraints do we take for granted? What constraints are invisible to us? Read more.
A friend asked for this, so I thought it’d be helpful and provide the code for, All tables with no primary key, and one showing, All tables and their primary keys, if exist. Enjoy!
Play or download the podcast interview with Brian Aker of MySQL here. A special thank you to our sponsor, The Pythian Group, www.pythian.com.
t 2 pm EST (-5 GMT), OurSQL will be interviewing Brian Aker, MySQL’s Director of Architecture, about today’s announcement that Sun Microsystems bought MySQL. If you have a burning question (about the purchase), please comment here. If you’d like to be identified, please leave your name and where you’re from in your comment
SUN Microsystems just bought MySQL. I don’t know much about SUN internals, but I’m not sure how the company resolves being the primary developer of 2 differing DBMS’s. Since those are the top 2 open source DBMS’s (and there aren’t really any other ones out there, as I don’t count sqlite as a DBMS), there could be a real conflict of interest.
At the November MySQL User Group, Patrick Galbraith ran into a problem where binlog-do-db was duplicated. It manifests itself like this…Well, it’s a bug. Patrick confirmed that upgrading fixed his bug. Unfortunately, this is an enterprise release. Even more sadly, http://www.dorsalsource.org does not have the source or binaries for the most recent Enterprise version, MySQL 5.0.54.
With this particular client, I ran a SHOW STATUS, waited 100 seconds, and ran it again. Handler_read_first jumped by about 53. So I wrote down in my notes: first in the index…every other second. Lots of table scans? As soon as I wrote it down I said, “That’s a haiku!” I counted syllables, and it works, but only if you pronounce “Every” with 3 syllables.