MyCafe – Is it finished?
I’ve been rolling out several features behind the scenes that many of you most likely haven’t noticed just yet. But here they are:
Voting has it’s own table.
User networks have their own table.
This has caused a TON of changes behind the scenes with the code. I’ve had to change the profile pages almost completely along with the voting on each poem and pencushion page. Yeah, that’s only four pages, but it was a lot of code to work around.
Of course, that wasn’t all the trouble I had to go through to push these changes. I have a semi-new laptop which I got at an excellent price (gotta love duel core!). Stupid me, I didn’t have the MySQL database on my laptop. And with the database being as huge as it is… I couldn’t download it during the day because my ISP has a bandwidth cap except between 1am and 6am. So trying to stay up that late and actually remember downloading the database once I got there was a feat I had to conquer.
I ended up not bothering with installing MySQL on here, instead I opted for using XAMPP (which is a totally awesome lite server you can put on just about anything) on my 2gb memory stick I’ve had for several years now (you can get them for ~$10, mine was $65 when I bought it… oh how technology changes!).
I haven’t been coding as much as I’d like to lately, so trying to remember some things weren’t easy. Plus, stupid mistakes are my forté. I’ll think I have something finished and WAM! Stupid mistake which may take me a few hours to find–error logs be damned.
Hopefully everything is working fine. The members section should be faster now. But I don’t guarantee anything. The code was using less database selections and more code to make up for it. Now I am using more database and less code. So let’s see how this works out.
If you run into any problems or have some ideas, feel free to leave them below!
EDIT: Forgot to mention what the change on the MyCafe actually was. The MyPoems Comments actually works now, the Cafe voted now uses the new database table, and cafe commented now includes your new network friends as opposed to your old ones.
The page seems to load in the exact same time as before with the added MyPoems Comments. With the old table, MyPoems Comments was taking up to 3 minutes to query–lots of resources used. That’s why it was “out of order” until I could move some of the tables and recode some of the pages.

