That was not what was being expected. MySQL was touted to go public and Sun never seemed to be wanting to become a database company. But it has happened (press release), and Sun seems to be planning to come out with global support offerings for MySQL. [Continue]
One of the most ignored features of the modern RDBMSs today is the stored procedures. In fact most of the web applications go to extreme lengths to increase performance but avoid the stored procedures. They are also one of the favorites in theory, but hated in practice. [Continue]
For a while I have been playing around with buzhug, a pure Python database. It seems to be slower than other RDBMSs, but is fastest amongst the Python databases. I think buzhug can make life easier in some Python applications. [Continue]
Dare Obasanjo says do not normalize immutable data, and refers to Pat Helland’s presentation. Database Normalization is an activity in database design to reduce redundancy and eliminate update anomalies. In short, it minimizes possibility of loss of data integrity while updating data. [Continue]
Frank Sommers discusses an idea presented by Robert McIntosh about building a high volume application without a RDBMS. The idea itself is not new, I have seen references to scalability problems converging towards the database. But the details with which Robert McIntosh tries to achieve some advantages of the database, like indexing, through other options are engaging. [Continue]
MySQL has not had its native storage engine until recent times. It supported various engines like MyISAM, InnoDB and BerkleyDB through plugins and the users could choose one of them. Oracle acquired both, InnoDB and BerkleyDB through their purchase of Innosoft in late 2005 and Sleepycat in early 2006. [Continue]
SQL Injection is probably the best reason, other than speed of execution sometimes, to use stored procedures instead of dynamic SQL queries. Ill-intentioned users can inject character literals through their input that can be used to comment out part of the query being executed. Scott Glu has a tip on ways of preventing it (via Miguel de Icaza). [Continue]
Wordpress database queries have been put under scanner by Domas Mituzas. Very casually he looks at the possible optimizations in MySQL (database used by Wordpress) queries for a single page view. Probably more optimizations are possible when other complicated activities are considered. [Continue]