While researching an article I came across a piece at http://www.simple-talk.com/sql/t-sql-programming/cursors-and-embedded-sql/. Basically the author says “embedded SQL” is bad — meaning developers should never put SQL in their code. Nor should they use ORM tools to generate SQL for them.

Instead, they should access everything they need through stored procedures. I have mixed feelings about this. On one hand, you have to give table-access permissions to users and then deal with the resulting security risks sounds very control-freakish to me. On the other hand, I agree that embedded code can be bad because if you change the database model in any way, you have to rewrite the procedural code that relies on the existence of the previous model.

And of course, stored procedures also help make your code more …

While researching an article I came across a piece at http://www.simple-talk.com/sql/t-sql-programming/cursors-and-embedded-sql/. Basically the author says “embedded SQL” is bad — meaning developers should never put SQL in their code. Nor should they use ORM tools to generate SQL for them.
Instead, they should access everything they need through stored procedures. I have mixed feelings about this. On one hand, you have to give table-access permissions to users and then deal with the resulting security risks sounds very control-freakish to me. On the other hand, I agree that embedded code can be bad because if you change the database model in any way, you have to rewrite the procedural code that relies on the existence of the previous model. …

So, O’Reilly’s ONLamp.com has published the “Top 10 MySQL Best Practices” at http://www.onlamp.com/pub/a/onlamp/2002/07/11/MySQLtips.html. Sadly, I find most “best practice” list do not thoroughly explain the “why” enough so that people can make their own decisions.

For instance, #3 is “Protect the MySQL installation directory from access by other users.” I was intrigued at what they would consider the “installation” directory. By reading the tip, they actually mean the data directory. They say nothing of the log directory, nor that innodb data files may be in different places than the standard myisam data directories.

They perpetuate a myth in #4, “Don’t store binary data in MySQL.” What they really mean is “don’t store large data in MySQL”, which they go into in the tip. While it’s true that there is …

So, O’Reilly’s ONLamp.com has published the “Top 10 MySQL Best Practices” at http://www.onlamp.com/pub/a/onlamp/2002/07/11/MySQLtips.html. Sadly, I find most “best practice” list do not thoroughly explain the “why” enough so that people can make their own decisions.
For instance, #3 is “Protect the MySQL installation directory from access by other users.” I was intrigued at what they would consider the “installation” directory. By reading the tip, they actually mean the data directory. They say nothing of the log directory, nor that innodb data files may be in different places than the standard myisam data directories.  More »

The built-in HQ database is PostgreSQL. Recently, users have been discovering PostgreSQL has a certain limitation: it will not execute more than 2 billion transactions between vacuums. In rare cases, an HQ built-in database can get into this state.

If this happens, the database will stop accepting connections and HQ, which needs a data store, will obviously cease to operate properly. The immediate symptom will be that users will not be able to log in to HQ and the message displayed on the screen will be The backend datasource is unavailable.

That error is not enough to say for sure that the problem is PostgreSQL avoiding wraparound failure by not accepting connections. A quick look at the hqdb.log can confirm. The telltale log entries look like this:

FATAL: database is not accepting commands to avoid wraparound data loss in database "postgres"
HINT: Stop the postmaster and …

I just saw dveeden's post in PlanetMySQL.

He writes: 3. Database locator. So you've got hundreds of servers … and a multitude of databases. How to connect to the right server to reach the database you needed? Something like oracle TNS would be helpful here. What about implementing TNS for MySQL or just using DNS? How do you solve this?

krow has written a plugin that announces a MySQL server via Apple's BonJour zeroconf protocol. Extending it to announce databases in the server might be doable …

Also, I'm (slowly) working on a SNMP AgentX plugin for MySQL server. …

I have two talks in the coming few weeks, that I’m still madly writing. I’ve come to the realisation that writing talks, really does take a lot of time (when you have a deadline). Especially, if you’re doing it my style - everytime I write a slide, and find something missing in the Wiki, I go ahead and fix it. So its not actually talk writing I’m doing, but expansion of our online documentation, and keeping it in check. That takes time.

• Enhancing Competitiveness Through Technology - I’m giving this talk at the Malaysian Employers Federation (MEF) Annual Conference 2007. Their conference is themed around “Enhancing Competitiveness Through Technology & Law Reforms ? The Next 50 Years” and is on the 19-20 November 2007, at the KL Convention Centre. My talk is on the 20th, as I’ll be on a plane on the 19th. This is targeted at CEO/manager level, so is lighter on tech-related content, but more …

Yesterday I wrote about SHOW PROFILES in 5.1, and announced that the source code is available for you to try.
Since I have a few servers at home, I decided to publish some binaries that I compiled while testing. In the meantime, the backport patch for MySQL 5.0 was available, so I started testing that one as well.
Now, at the experimental downloads page you can find some goodies:

• source code for 5.1.23
• source code for 5.0.53
• binary tarball for Linux i686 5.1.23
• binary tarball for Linux i686 5.0.53
• binary tarball for Mac OS X 10.4 i386 5.1.23

Once more, let me remind you that this code is experimental, so don’t use it in production. But have fun with it!

Sun announces VM offering based on Xen. Oracle enlightens on Unbreakable Linux adoption. Red Hat and Hyperic partner on systems management offering. (and more)

Sun Microsystems CEO Jonathan Schwartz Previews Sun xVM and Unveils Partner Ecosystem at Oracle OpenWorld, Sun Microsystems (Press Release)

Oracle Unbreakable Linux Support Demonstrates Exceptional Momentum, Oracle (Press Release)

Oracle University Launches Enterprise Linux Training and Certification, Oracle (Press Release)

…

one of the features we had planned for mysql connector/odbc 5.1 is native setup libraries for the major platforms. we have the microsoft windows version going, and some code to get us going on linux/unix (using gtk instead of qt), but our gui team is too busy to get us started on a native mac os x version.

anyone want to pitch in by showing us how to get a basic dialog window to pop up based on a c library call? i think we will be able to customize it from there, but i am just unfamiliar enough with mac os x gui programming that i have a feeling it would take a long time for me to get that going.