Side Notes

Just random stuff that some might find useful.

 

I’m Certified Certified Scrum Master

November 9, 2011 Posted in: Side Notes
Took a short course back in September and now I'm Certified Certified Scrum Master.
 

Where IN Query Using Codeigniter MongoDB Library

July 20, 2011 Posted in: Side Notes
Thanks to Alex Bilbie we all have simple way of integrating new MongoDB data store into Codeigniter applications. Thank you Alex and all others who contributed. Library lets you easily create complex where clause without touching MongoDB syntax. Unfortunately IN (and I imagine NIN and some other statements) are not translated correctly. Specificaly proble surfaces when you try to query documents by _id. It looks like there is an open issue on bitbucket.org, but page never loads for me. If it works for you and it has fix, you can stop reading.
 

Command Line And Friends

February 24, 2011 Posted in: Side Notes

Import Multiple SQL Files Into Database

So we have multiple files exported from db. In fact we have so many it will take a day to inport them one by one. If on Windows, you probably have nifty tool that will let you drag and drop them into db. I could not find one for linux or Mac, so command line to rescue: cat *.sql | mysql -u USERNAME -pPASSWORD DATABASENAME To be continued...
 

WPMU Redirects to Admin Page All The Time?

October 22, 2010 Posted in: Side Notes
You just added new blog to you WordPress MU and it goes to admin dashboard all the time? The answer is simple. WordPress did you a "favor" and set new blog as Dashboard Blog. all you have to do is go to Site Options ([your blog]/wp-admin/wpmu-options.php) and clear "Dashboard Blog" input box. Save. Done!
 

Changing Search Query Parameter in WordPress

October 19, 2010 Posted in: Side Notes
You may wonder why some would do such thing? Well, most obvious case is integration with existing website. Some times "s" parameter is already used and/or required to have function different from search. This where you have to alter default behavior of WordPress.
 

How-to: Show Analytics Data With Google Chart Tools

September 30, 2010 Posted in: Side Notes
How many times did you deploy a website and a client asked to see some visitor stats or maybe even conversion rates? At this point, many said sure, just go to Google Analytics; unfortunately, not every client wants to. Despite all Google's attempts to make their services user-friendly, many people are stillĀ  reluctant to use them; may be because they have to create an account, or may be for some other reasons. At this point, I usually think how great it would be if I can bring Google Analytics to my back end? Fortunately for everyone Google offers Analytics API.
 

Before You Run WordPress on XAMPP

May 3, 2010 Posted in: Side Notes
You may think that there is nothing easier than installing WordPress on you local machine with XAMPP, and in most cases you will be right. However there are some instances when you have to bring in someone else's code to your WordPress and all of the sudden all hell breaks loose. Here some things that I came around that definitely annoyed hell out of me and waisted good chunk of my time.
 

Install SSL certificate on Plesk

March 29, 2010 Posted in: Side Notes
While deploying a new server in uncharted territory (environment you never worked with) it is very much possible to encounter shallow waters that you trap your ship of deployment for hours until high rise comes in (write tutorial that is). As the title says following will narrate some steps that needed to make SSL install possible and hopefully will take frustrations out of the process. Following applies to brand new install of Plesk. I assume that you have root access to the server as well.