The latest from the MySQL community

One of my first tasks in my new position as Senior Programmer at mybanker.dk is to evaluate and/or create a CMS framework for upcoming versions of the several websites that we present to the world.

After evaluating the first many available frameworks and CMS systems out there. this entry, found on Planet PHP somehow seems to strike a cord or two…

I was reading through Expert MySQL over Christmas, and I thought I'd write a patch to solve some of the connection pooling problems I've mentioned earlier.

It was surprisingly pretty straight forward. Let's hope someone can clean it up, and reset connection is implemented into MySQL 6.0.

MySQL AB today announced it will be presenting a free, one-day technical training class for senior Oracle database administrators (DBAs) in the U.S. Government and other organizations who are interested in expanding their professional skill-sets by learning advanced MySQL techniques.

Date: Thursday, January 24, 2008
Time: 8 a.m. to 4 p.m. (Breakfast and Lunch included)
Location: Ronald Reagan Building and International Trade Center, Polaris Suite, Washington, DC
Registration: www.carahsoft.com/mysqldba

It's official. I'm moving from the Support team in MySQL to the training team on March 1st.

Multiple database connections are a great feature, but if you plan to generate a schema for each database, you will most certainly run into some problems caused by different connection names. This Howto will show you how to solve the problem.

Connections

Let's start by defining our database connections: open up the file config/databases.yml and create at least two connections with different names (like „database” and „database1”).

all:
  database:
    class:          sfPropelDatabase
    param:
      dsn:          mysql://ptest:ptest@localhost/ptest 

database1:
    class:          sfPropelDatabase
    param:
      dsn:          mysql://ptest:ptest@localhost/ptest2

Schema

In the config/propel.ini configuration file, go to the the sixth line and edit the „propel.database.url” setting so that it matches the first database connection.

propel.database.url = …

One week to go! Then we’ll have MySQL AB?s biggest internal meeting ever, with some 400 MySQLers being shipped to Orlando, Florida.

Almost four years ago in 2004, the company met in Cancún, Mexico. A year before that in 2003, we met in Budapest, Hungary. In 2002, we met in St Petersburg, Russia. In 2001, we met in Helsinki, Finland. In 2000, they (I wasn’t on board at that time) met in Monterey, USA. As we met last time in Cancún, we were fewer people in the whole company than last September at the Developer Mtg in Heidelberg, Germany.

I’m looking forward to meeting with all my fellow MySQLers. Besides all the working and catching-up, I expect to do some running with fellow MySQLers, share some photographs, and just enjoy spending face-to-face time.

Right now, I’m preparing for …

This is a continuance from my previous entry on reversing an email address to search for a domain. Minutes after I ran the following query,SELECT COUNT(1) FROM rv_emails WHERE rv_email LIKE REVERSE('%msn.com');I was asked to do a count of the top 50 domains in our table of email addresses.So, I simply changed my previous route by performing the following steps:1) Add a 'domain' column to my

By Tim O'Reilly

I've been meaning to write for a while about MarkLogic's awesome new search tool for trolling through open source mailing lists, MarkMail.

Let's face it. While there may be a new generation that thinks that email is for old fogies, for many of us, email is a primary online tool, at least as important to us as the web. Many of us no longer file documents or attachments -- we just search for them again in our email. Perhaps most importantly, email is a primary collaboration tool--and as many of us have figured out, collaboration is one of the internet's killer apps. Searching our shared memory in a collaborative space is REALLY useful -- with open source mailing lists being a great example.

Despite its importance, very little has been done to improve on email. The clients we use today are not radically …

Ah, Christmas Holidays! Time to take a break from the daily chores... to spend some time with family... but also time to catch up on reading and spend some hours on some fun hacking.

When catching up on my reading of Dr. Dobb's Journal, I came across an interesting article by Michael Owens about writing virtual tables for SQLite, which got me thinking about a small hack I've wanted to do for a while: a table that reads an RSS/Atom feed and presents the data to the query engine. Originally, I was planning to implement this as a MySQL …