MySQL

Drupal-Performance-Odysee mit Happy-End

Mit dem Update unseres Intranet-Portals von D5 auf D6 und dem gleichzeitigen Umzug der Installation von einem virtuellen Webserver (Xen+Linux) auf einen physischen Server (auch Linux, identische Hardware) handelte ich mir einen totalen Einbruch der Performance der Seite ein.

DBDesigner on Mandriva

I just wanted to run DBDesigner on my mandriva linux notebook. A colleague of mine told me that it is a very productive visual Db modelling tool. So I downloaded it from http://fabforce.net/dbdesigner4/downloads.php, unpacked it and wanted to run it. But the script exited without any output. And no GUI window appeared. Running the app with strace showed me somethng like

SQL Developer - your friend for Oracle DBs

Recently I wrote about a cool SQL DB client called SQL Explorer. Now a colleague of mine, who was developing against a Oracle DB presented SQL Developer. And my review reveals: It’s cool too!

SQL Explorer: Getting familiar with Databases

Sitting in the Oracle course I get more and more in touch with SQL and its varieties Data Manipulation Language, Data Definition Language (DDL), Data Control Language (DCL) and Transaction Control Language (TCL).

But its very cumbersome to use the iSQL*Plus web front-end to write and execute all the queries.

Changing of the $db_prefix of the Drupal database

Recently I had to migrate two drupal instances running on different servers into one drupal instance with exactly one MySQL database as backend. I started both installations without databse prefix (see your site’s settings.php for details). Now I had to change this. The first site should get the prefix ‘www_’, the second site ‘o4e_’.