MySQL fun

Neo

Is that...

Cypher

The Website? Yeah.

Neo

Do you always look at it encoded?

Cypher

Well you have to. The MySQL databse works for Drupal. But there's way too much information to decode the website. You get used to it. I...I don't even see the code. All I see is blonde, brunette, red-head.

I'm having some fun converting the Drupal user database to and from the IVRPA member database. The IVRPA member database is kept up to date in Filemaker Pro. It's a rather simple affair; a single table with lots of columns (values) and rows (members). The Drupal user database on the other hand is a bit more complex and relational.

In Drupal, there's user data (user name, email, sign up date; the basic data you need to log in to a website), and then there's profile data (all the rest, including address info, membership, etc). The user data part straightforward, like the Filemaker db, but profile db is more relational. Piecing the two together into a Filemaker-like structure using MySQL 3.2x syntax has taken most of the afternoon. But given a couple of inbetween steps and intermediate tables, I'm getting there...

Next up: syncing the two similarly formatted database. Yeay! Oh, the fun to have with data...