me talking out loud

Ok - I had to install MySQL on my Mac for the first time - using a tar of the binaries none the less. And it has been interesting. These are notes mostly for myself but if others find them helpful - great.

1. instructions I used - http://dev.mysql.com/doc/refman/5.0/en/installing-binary.html
2. to create a group in 10.5 - use dscl. In my case ‘dscl . -create /groups/mysql’
3. to create a user in 10.5 - again use dscl. ‘dscl .-create /Users/mysql’
4. I had to make /usr/local with mkdir -m 775
5. I did not have to decompress things since the Mac did it for me - but I did have to place it in my Library dir and make the ln to it in my /usr/local dir
6. DO NOT FORGET to give your root user a password and either drop the anonymous user or put a password on it!

Other notables (yes I am a server noob):

• start the deamon with ’sudo bin/mysqld_safe –user=mysql &’
• If you forget the ampersand at the end - use cntl+z to escape then use ‘bg’ to put the deamon in the background
• stop the deamon with ‘bin/mysqladmin -u root shutdown’

Other notes to self on having multiple versions available:

1. option 1 - have multiple binary installs in their own folders and just change the ln.. or have multiple ln with individual names. since I do not need to have all of them running at one time - I can start and stop the deamons as I need.
2. option 2 - is provided in the manual at http://dev.mysql.com/doc/refman/5.0/en/multiple-servers.html

Yep - I have finally ready for my trip to the MySQL User Conference in Santa Clara. MySQL and Oreilly have been incredibly generous in providing us the opportunity to attend their conference, giving us an exhibition booth and a free pass to all the sessions. With out them - we couldn’t have gone.

Anyway - for those that will be there, make sure to stop by our booth and pick yourself up a PHPWomen sticker (for your laptop, car, bag or anywhere else you can think of). Or if you just want to talk about what we are and what we are doing or the weather - that is great too. Come out and meet me!

Just a quick not to let the world know that I have started the mentor listing for testfest. It can be found at http://wiki.php.net/qa/testfest

Mentors - if I missed you please send me an email to update it or feel free to add yourself to the wiki.

Also we have moved the listing of the User Groups to the wiki so if your user group is participating and not listed - again let me know if you want to be added or add yourself to the testfest wiki page.

Edit: forgot to mark it as PHP. Ooops.

I am pleased and proud to say that come Monday - I will be working for MySQL (*sigh* - Ok Sun). I will be working for a Dream Company of mine - doing a Dream Job. Life does not get better then that.

So to everyone who kept telling me I would get the job when I swore there was no way (you know who you are) - feel free to tell me “I told you so” next time we talk - and first beer is on me when we meet.

It has been a really long time since I wrote anything - luckily the folks at phparchitect gave me just the push I needed to get back to my writing. Took me a while to get back in the hang of it again - but I did it - and even finished by my deadline (even if it was turned in a day late).

So if you feel the need to learn a bit more about foreign keys and what they can do for you the coder - be sure to check out my article on them at c7y

Just found out about the Orlando BarCamp from another member of the JaxPHP UG. I had no idea there was a BarCamp out this way.

It will be held on April 5 and 6 at Wall St Plaza. The 5th will be dedicated to Developers and the 6th to various media (film, photo, etc.). For more information on it be sure to check out their site - http://www.barcamporlando.org/ Registration is now open for any who want to go.

Unfortunately I will not be able to attend - niece will be participating in a gymnastics state championship that weekend in Tampa. Family comes before playing.

While talking with Dynom and Davey I learned something really cool today - how to get the declared definition of a column all by itself with MySQL (I used version 5.0.45). Yes there are lots of other ways to get the info - not the least of which is using the information_schema - but this just struck me as being way cool.

You can even use wildcards in the column name. From a different database (note you have to have the perms to access the alternate database):


DESCRIBE Db.table column;


Example from my test db:

mysql> describe lig_test.student guardianship;
+--------------+---------+------+-----+---------+-------+
| Field        | Type    | Null | Key | Default | Extra |
+--------------+---------+------+-----+---------+-------+
| guardianship | char(1) | NO   |     |         |       |
+--------------+---------+------+-----+---------+-------+
1 row in set (0.08 sec)

mysql> describe lig_test.student 'guard%';
+----------------+----------+------+-----+---------+-------+
| Field          | Type     | Null | Key | Default | Extra |
+----------------+----------+------+-----+---------+-------+
| guardian_photo | longblob | YES  |     | NULL    |       |
| guardianship   | char(1)  | NO   |     |         |       |
+----------------+----------+------+-----+---------+-------+
2 rows in set (0.01 sec)

I have recently been asked to do some coding in C - a language I haven’t looked at (never mind code in) in over 5 years. I don’t even remember how the heck to set up the environment anymore. Anyway - got me to thinking how much has happened since that time… so many things - large and small - have happened… Where does the time go?

Went to the Florida Linux Show today - a 1 day conference held in Jacksonville at the University of North Florida University Center. At only $10 to attend - it is hard to find a reason not to attend something so close and so affordable. Had a good time and met a number of my fellow JaxPHP members there who were also attending.

The conference ran from 8:30AM - 5PM and had 12 different sessions with 3 keynote presentations. There seemed to be about 150- 200 people (saw all together maybe 10 women) in attendance with representatives of Redhat, Ubuntu, and gentoo in booths along with various other companies both local and linux centric (like Linux Journal and the local LUG).

The sessions I attended were quite interesting. I particularly enjoyed “Software as a Service: Implications of Web Apps for Software Freedom” by Mr. Gavin Baker for the interesting questions it raised on web applications being closed source though they are built on the popular open source tools and languages. Until then I never realized how closed source a site is - which goes completely counter to FOSS like PHP.

All in all a good time and I will be back again next time.

I have to admit to not writing much lately on the blog - mostly because I haven’t been doing anything interesting. Visiting family, making new friends, catching up on my personal reading (no tech books - well ok only a few - Mostly High Performance MySQL with a dash of Flex 2), relaxing from the move and the craziness of the last year… basically trying to feel human again rather then a wound up ball of stress that is ready to explode - Man have I needed this break. This has got to be the longest stretch I have ever done where I intentionally tried to stay away from the computer and anything related to work to regain my personal internal balance. And it has been much more difficult then I thought it would be (still ended up doing stuff for PHPWomen and going to PHP User Group meetings… ). Wonder if I fulfill the definition of a junky.

As much as I love my work and the people… sometimes you have to step back and remember that life does go on - even when the computer is turned off. I mostly managed to do it.

Unfortunately my time to stop and relax is coming to an end soon. And I have to say I will miss it even as I revel in my ability to get back into to the game.

Ok - so I have RSVPed a yes to attend the local Jacksonville user group (JAXPHP) get together next week and I have to admit to being kinda nervous about it. I have never been to user group meeting and have no clue what to expect. Hopefully all will go well and I won’t get lost or show up late or make an idiot of myself.

Anyway - if anyone is in the area be sure to stop by, say Hi and hopefully save me from myself.

When?
Tuesday, Jan 8, 2008, 6:30 PM 20080108T233000Z
Where?
Jacksonville Public Library - Southeast Branch
10599 Deerwood Park Blvd.
Jacksonville, FL 32256
904-996-0325

Well we have finally done it. We have moved into a house. Not our final house - but a rental one. It is so nice to have my bed to sleep in.

Anyway - we decided to wait before buying a house so that things (life and money mostly) can settle down and we can take our time finding the house to buy. You know - pay attention to the little things like school districts and home owner associations and zip codes (parts of Yulee are under the Fernandina zip code)… little things.

Now if I am lucky I will be able to get the house semi-organized within the next week so that at least I know where most things are (even if they aren’t in their final resting spot) and get rid of most of the boxes and wrapping paper surrounding everything. Oh joy.

Well #phpc on freenode is at it again. This time we have cooked up a scheme to have a road trip to this springs |tek. Davey Shafik and I live pretty close together (he in the Tampa, FL area and I in the Jacksonville, FL area). So being the cheap people we are (conferences get VERY expensive very fast) agreed to carpool it to Chicago so we can both get there for the plane fair of one (it is about a 19 hour drive).

Somehow the conference comes up on the #phpc channel - who is going, who is thinking of going and who is speaking at the conference. We comment that we are car pooling it up - and poof! We have more people wanting to get in on it. At it’s height we had potentially 8 people going with us - though most ended up backing out. As it stands now, we are down to 4 (Davey, Ben Ramsey, Elizabeth Naramore and I) last I heard. It is pretty cool since we will picking up fresh meat drivers people as we go north so no one person will have to do all the driving.

I figure by the end of the road trip up and back… we will have become closer friends then we are now or will be ready to kill each other. Not quite sure which is more likely One thing is definite - we will have gotten to know each other well and isn’t that the goal of the community.

Woot - the book, The PHP Anthology: 101 Essential Tips, Tricks & Hacks, 2nd Edition, has been slash-dotted - and they actually liked it giving it a 9/10 rating. *gasp*

The reviewer, Michael J. Ross, seems to only have 5 major grips with the book overall:

1. Firstly, a reader hoping for a well-edited book will likely become distrustful by the authors’ misuse of the term “that” in place of “who.”
2. Secondly, there are far too many ambiguous comments in the first-person, e.g., “I would dare to say that…” In a book written by five authors, the reader naturally has no idea who is speaking.
3. Thirdly, there is a fair amount of inconsistency in the formatting of the code throughout the book, including indentation and other spacing, as well as variable naming.
4. Also, every instance of a “{” on its own line (presumably to line up vertically with the corresponding “}”), is an antiquated waste of space, since any decent programmer’s editor or integrated development environment (IDE) can do brace matching automatically.
5. Lastly, almost all of the section titles begin with the phrase “How do I.” That is fine within the body of the book, at the beginning of every section. But when dozens of these section titles are listed together in the table of contents, that phrase could be excised so each section’s topic would be faster to spot, and there would be fewer unnecessary words.

I can live with those, (to me they are kinda minor),though I have to admit to being the person with a “{” on a new line - sorry but I like my code formatted that way when I am left to my own devices. Call it a quirk if you will - I like to see my braces visually line up.

On the plus side he remarks:

The chapters on error handling and access control are alone worth the price of the book.

Since I was responsible for the chapter on access control - I will take that as a pat on the back.

Well we made the flight and the drives (though I was hallucinating by the end of the first day - was kinda fun), picked up the dogs and dropped them off at my dad’s and finally made it to Georgia. All is going well except we have no home - but that will take time to find and organize. Luckily we have a room at the TVQ (Temporary Visitors Quarters) on the Kings Bay base - and I have to say - it isn’t to shabby for $30/night.

Today was a busy day. We hit up the Housing office (only got lost twice trying to find it) to see if they have any referrals for the area we want to live in (they don’t). So we took a drive to the area to just look around the area and maybe for a realtor. Liked the area (on a clear drive it is only 20 minutes away from the base) and found a real estate company that seems nice. Got a number of potential places to cruise through the neighborhoods to see if we like them. Talked to the bank about getting a mortgage and need to call a number to get a pre-qualifying value so we have a better idea of how much we can spend. Took a base tour to see some of the base’s services (gas is 2.96 on base) only to find they aren’t many and they are much smaller then we are used to but that is OK since we will primarily getting stuff out in town.

Tomorrow is Thanksgiving so everything will be closed. Sounds like a wonderful time to just sit back and relax for the day. Friday is soon enough to run around some more.

Well we have finished moving out of the house and are now in the hotel - 2 days and a wake up left until we go. Only one problem - the hotels internet in the rooms is out… and with the dogs in the room - I can’t sit around the lobby all day (the lobby internet doesn’t allow irc either) … *sigh*. So I will primarily be offline for a while, least until the get the room internet back up (heavan only knows how long that will be) or we get to the states - whichever happens first.

Yep - in less then one week we will be back in the states. So many things to still get done before the end of the week but everything seems to be organized and scheduled…

1) house - final pack out (Tuesday), final cleaning (in progress), yard cleaned (due by Monday) and final mowing, carpets cleaned (todo this weekend);
2) appliances - picked up on Tuesday;
3) bags packed - mostly - due by Tuesday;
4) dogs - tickets (done), crates (done), flight itinerary (done)… need to contact continental cargo for info on how to turn them in at 4AM, heath certificates (Vet Tuesday 10:20), need to drop that off at Dept of Agriculture for Guam vet to sign - pick up in 24 hours;
5) hotel reservations (accepts dogs) for the few days between when we move out and fly out - done;
6) hotel reservations for when we get there - done - need to reconfirm;
7) car - rented and can be dropped off at the airport when we fly out;
8) family notified - some - need to complete this weekend;
9) landlord final walk through inspection - Sunday;
10) sell the last car - dependent on husband;
11) Our tickets - bought and paid for - have passports available - fly out Sat the 17th at 07:30

Hope that is everything… If not - I am so screwed.

As much as I loved going to Zend Con - I now have to shoot someone from it. Why you ask - simple. They gave me bronchitis (irrelevant that my immune system was depressed from the jet lag ). As many friends know I have been battling a cold since I got back from Zend Con. Last night (Friday evening) along with my now standard hacking cough and runny nose I gained a few other symptoms - an earache, sore throat, and an on again, off again fever. Husband made me go to the Emergency Room since my doctor’s office was closed only to get the diagnosis - bronchitis (same as his). Oh joy.

So now I am drugged to the gills on antibiotics, cough suppressants and decongestants… I hate taking drugs but hopefully I will sometimes soon be able to sleep the whole night through without waking up every couple hours to hack up a lung. I don’t believe I am going to say this but… please drugs - hurry up and work!

In the latest PHP Abstract Podcast with Davey Shafik on Web Services, I actually got a mention because of the book we worked on together. Woot!

As for the podcast - Davey I love the accent. So very hot.

Finally, after almost a year, the book I helped write (The PHP Anthology, 2nd Edition) is now published and available through Sitepoint, Amazon and Bookpool.

I ARE PUBLISHED - WOOT!