Not sure how I missed this for so long (feeling kind of lame right now for not even knowing about it), but today I ran across using breakpoints in Chrome Developer ToolsRead More…
AngularJS – ‘orderBy’ for multiple fields
The documentation for orderBy uses a function to rearrange the order of the result set, but I wanted to order my results by multiple fields, and the documentation didn’t seem to mentionRead More…
05May/14
PHP and OCI predefined constants
Today I had an import script to pull data from Oracle into a MySQL instance, but the script returned an “undefined index” error for one of the fields in the result set. Read More…
05Mar/14
ORA-01745: Invalid host/bind variable name error
I had a simple query where I was pulling data on a user, but binding with :user, as in select * from user_table u join other_table o on u.user_id = o.user_id whereRead More…
27Feb/14
MySQL coalesce() for empty sub-queries
One of the library scripts was pulling borrower data, but for some people a required “email” field was missing. I was using IFNULL() to test if a particular type of email existed,Read More…
19Feb/14
Fixing Your Hash of Commits
Resetting all commits At one point, for various reasons that seemed perfectly logical at the time, I had several half completed commits, commits that included files that should have been ignored (likeRead More…
17Feb/14
Using .gitattributes For Config Files
Config files and dev/staging/prod If you’re using any kind of framework in your development, you’ll most likely have database and api/route configuration files somewhere in the mix of things. Since most frameworksRead More…
14Feb/14
When .gitignore Fails to Ignore
What you expect it to do Normally, you expect .gitignore to keep files from uploading to your repository, and it is, of course, especially useful for holding on to local configuration files.Read More…
07Jan/14
OCI_NO_AUTO_COMMIT: Oracle OCI and PHP
So today I did something fun. I wrote a script to parse out data from a CSV file and push the various data into several different (and mostly unrelated) tables in theRead More…
04Dec/13
SCP: Command Not Found
Today I was working on setting up a MySQL backup/failover for our Identity Management servers and needed to install some additional MySQL Utilities to make it work. I downloaded the files toRead More…