Find the collation of all tables within a mysql database

Needing to find a collation of a mysql database for a migration I went to google. Found several options, but the best was one from stack overflow. SELECT TABLE\_CATALOG, TABLE\_SCHEMA, TABLE\_NAME, COLUMN\_NAME, COLLATION\_NAME FROM INFORMATION\_SCHEMA.COLUMNS; This will output something like: mysql> SELECT …



How to find mysql variables with a query, specifically data directory

I needed to find out the data directory for mysql. A quick way to do this within mysql is to use the show variables command. mysql> show variables; Which will output something like: +-----------------------------------------+-------------------------------------------------------------------------------------------+ | Variable\_name | Value | +-----------------------------------------+-------------------------------------------------------------------------------------------+ | auto\_increment\_increment | 1 | | auto\_increment\_offset | 1 | | autocommit | ON | | automatic\_sp\_privileges …



Laravel 4 release date

When will Laravel 4 be released? Per Taylor's announcement at Laracon it will be released in May of 2013. Further on the wiki there is a time table for the next 4 releases. Is Laravel 4 stable enough to use in production? I would say yes. At this point in …



How to specify specific engine in Laravel 4 migration

Earlier today I needed to set up a specific database engine for a mysql table that wasn't the databases's default. In this instance, the default was INNODB and I needed it to be MyISAM. We could discuss the reasons why I shouldn't use MyISAM but in this instance that's what …



Using xargs to parallel a process in the command line

Most of us have multiple CPUs in our personal machines. I would also hope that your servers do too. If you're running an intensive command line process, running them in parallel will speed it up by paralleling the process. Say you need to find a string in all of your …



Under PHP's Hood

Recently watched/listened to Sebastian Bergmann presentation on PHP interpreter. Very useful way to brush up on how php processes a request. Audio From techportal Slides: PHP Compiler Internals by kaplumb_aga



Awesome vim setup

Among the editors and IDEs that I use the old stand by vim is always there. It's literally the first thing I install on a server. One of the great features of vim is the vast plugin library. This becomes even better when someone wraps a lot of the extremely …



Rsync over ssh between remote servers

In order to use rsync with a ssh key I used the -e flag on the rsync command. It will allow rsync over ssh local to a remote server. [ps] [\$ \~] rsync -avz -e "ssh -i .ssh/id_key.pem" /opt/stuff/here/ [email protected]:/opt/stuff/here/ [/ps …



How to set Laravel 4 environments

The environment is based on url matches. You'll find that configuration in /bootstrap/start.php [ps] \$env = \$app->detectEnvironment(array( 'local' => array('your-machine-name'), )); [/ps] Now say you are developing locally and use the prefix/postfix local. E.g: my-new-site.local or local.my-new-site [ps] \$env = \$app->detectEnvironment(array( 'local' => array …



Why I don't use AppFog

Simple no persistant storage. Starting up, setting up, etc are all great, but without persistance storage I'm forced to use S3 or the like. If I'm doing a very simple app or a WordPress install it's not worth the effort. Does AppFog have a persistent file system? Not yet. We're …