s3 is handy and useful, but it would be a lot more handy and useful if we had a shell script for pushing things to buckets; a script that didn’t require a special cli tool. something portable that we could add to existing scripts or throw in a cron job or distribute to our friends. a script that we could tell “put this file in this bucket” and it would just do that. that would be a good thing. let’s build that.
Continue reading →making mysql STDOUT less (or more) of a mess
you’re doing some command line mysql work, something like piping in a query to mysql and dumping the output to STDOUT. what you want, of course, is some nicely-formatted output. what you get, instead, is hot trash like this:
$ echo "SELECT * FROM albums" | mysql record_collection_db
id artist tite
1 Bratmobile Pottymouth
2 Coltrane, John Giant Steps
fortunately, mysql has some built-in formatters to help the world make sense again.
Continue reading →