Trolling around on the web, found a fun little process for generating animated GIFs: http://rarlindseysmash.com/posts/stupid-programmer-tricks-and-star-wars-gifs
You are currently browsing the blog archives for October, 2013.
Archives
September 2018May 2016
October 2015
August 2014
May 2014
January 2014
December 2013
October 2013
September 2013
August 2013
July 2013
June 2013
May 2012
February 2012
December 2011
October 2011
June 2011
March 2011
September 2010
June 2010
May 2010
March 2010
Categories
Code (30)Electronics (2)
Freelancer (1)
Personal (2)
Projects (1)
Systems (14)
Uncategorized (2)
Fun With Automated GIF Generation
October 29th, 2013Tags: animation, developer, gif, programming, python
Posted in Code | No Comments »
MySQL Views and Explain
October 13th, 2013This week, I ran into a problem when I was profiling that didn’t seem to be very well documented anywhere. I was trying to profile a query that included a view. The error message that I got when I tried to execute my EXPLAIN was: “EXPLAIN/SHOW can not be issued; lacking privileges for underlying table”
After a lot of flailing out, me and the DBA for this project figured out that in order to be able to execute my EXPLAIN, I needed to have SELECT on the key columns that I was using in my query for the table behind the view. Simple enough, but not something made easy to figure out.
Hopefully this helps someone else figure this out faster.
Happy hunting!
Tags: database, dba, explain, mysql, permissions, profiling, query, sysadmin
Posted in Code, Systems | No Comments »