(Leo Hsu and Regina Obe) Gathering from the number of hits we got from our What’s new in PostgreSQL 9.0, and the large number of slashdot responses we got as well as the fair number of reddit responses, I guess a lot of people are really excited about the upcoming PostgreSQL 9.0 or at least have a

(Aleksandr Kuzminsky) For a long time long types like BLOB, TEXT were not supported by Percona InnoDB Recovery Tool. The reason consists in a special way InnoDB stores BLOBs.

(Shlomi Noach) I happened upon a customer who left me in awe and admiration. The reason: excellent comments for their SQL code.

(Peter Eisentraut) A long time ago, in a text book far away, someone described the following (relational) database design approach: Put all your data in tables, normalized and so on, as you’d expect. An top of each table, create a view. The database clients only access the views. As the applicati

(Quassnoi) Frode Underhill asks: I have some applications that are logging to a MySQL database table.

(Leo Hsu and Regina Obe) A while ago we demonstrated how to use Open Office Base to connect to a PostgreSQL server using both the native PostgreSQL SBC and the PostgreSQL JDBC driver.

(Giuseppe Maxia) If you have tried Quick start guides: MySQL cluster in 10 minutes, you may have realized that it is really quick and easy.

(Andrew Morgan) By default, MySQL Cluster sends log data to a file but you can also send it to the console or to Syslog; this article explains how to send it to Syslog. The example given here is for LINUX.

(Michael McLaughlin) Somebody, who read this post on Debugging MySQL Procedures, asked why the strategy of selecting a string literal didn’t work in a MySQL function. That’s easy, they’re not designed to support a SELECT statement, only a SELECT-INTO statement.

(Rob Gravelle) In the MySQL Data Manipulation and Query Statements article, we looked at two variations of the INSERT INTO statement. If you recall, we utilized the INSERT statement to populate tables, rather than the Data Manipulation Language (DML) SELECT…INTO command, which is unsupported in My