For example, on one site, called Pink Rave, I had to add blog functionality, which isn’t quite built right in like with WordPress. For the standard “archive” box, I had to make a bit to spin through all posts and chunk them based on date, then output the represented dates in the box. For the search functionality, Cogneato’s CMS has nothing built in, so I had to do custom queries. They are using the BLOB data type, so I couldn’t use the FULLTEXT searching, instead having to build concatenated LIKE statements. Luckily, the CMS can easily put the results of custom queries into its result objects, so it is easy to then work with them like I otherwise would. In fact, for this blog, I handle all multiple item listings with the same output script that just fills the object array with different data depending on the type of page.
The job doesn’t pay real high for a college graduate job, and I would easily be making this much had I stayed on at the Winking Lizard as a line cook. But it is much more relaxed, interesting, and rewarding. Cooking involved standing for many hours with a lot of physical movement, quite tiring, especially when it was busy. The Peninsula Lizard can really get a lot of throughput in the summer, when it could be busier than we could handle continuously all day. At Cogneato, though, I sit relaxed in a chair, able to stretch or go to the bathroom whenever. The Lizard was fun, but I’ve always found computers, the web, and data very interesting. Anyway, enough of the comparisons. I’ve not heard any mention of a raise after my three months, but two people were hired instead of the one originally planned, and I wasn’t the one that was supposed to be long term, so I can’t expect it that quickly.
The major point of this post, beyond a brief update of my status, was supposed to be that I’ve been learning a lot there. I’ve been learning better ways to do things and building bits of code/markup that I’ll be able to use on my own projects. Every project I make sure I learn something. I’ve shared some of what I’ve learned in this blog already, but am way behind if I want to post it all. I plan to try to get more of it on here in the near future and keep posting it at a decent frequency. I’m not working freelance projects at the moment, so the Cogneato stuff will mostly replace WordPress stuff.