Using node_sqlite3 with Electron


At the moment, node_sqlite3 doesn’t want to play nicely with Electron apps. This is likely to change, however none of the methods shown in the Electron documentation worked for me. I was able to finally piece together a workaround until the module is natively supported. The problem begins after installing sqlite3 and attempting to use it […]

Read More

FizzBuzz in One MySQL Statement


I was thinking recently that it would funny to implement FizzBuzz using only a single MySQL statement.  FizzBuzz is a simple test that a programmer might run into at a job interview.  They may be asked to implement FizzBuzz in a specific language or with pseudo-code, depending on the interview.  For whatever reason FizzBuzz tends to […]

Read More

Compile PHP Extensions for MAMP


Compiling a PHP extension (shared object / module) from source for MAMP requires a bit of special configuration.  If you follow the standard instructions to phpize, configure and make the .so file then you’ll most likely end up with a module that’s incompatible with MAMP due to the fact that it is compiled for whichever […]

Read More

Not Knowing What Else To Do, I Baked A Cake


In the wake of the 9/11 tragedy the Onion posted an article entitled Not Knowing What Else To Do, Woman Bakes American Flag Cake.  With all of the recent press about the NSA’s programs to gather information on American citizens without warrants, I found myself thinking about that article.  I’m not a very particularly political […]

Read More

SVN Command Reference


This is a random collection of SVN functions, in no particular order.  They’re here for my own selfish reference purposes: View all files not in version control: svn status | grep “^\?” | awk “{print \$2}” Manually add files to SVN Ignore List: export SVN_EDITOR=vim svn propedit svn:ignore /path/to/directory  

Read More