Verbose Logging

software development with some really amazing hair

14 May 10

10:00 AM MDT

Posted in Programming

Find queries missing indexes in your Rails application

Rails developers aren’t exactly known for getting their indexes right (or even at all) on their databases. Granted, databases are a tough subject, and some people and companies make their living dealing with only databases, and some only with one database (like MySQL or Oracle). If you coming to web development with no formal background in databases, and it’s all new to you, then it’s totally understandable to maybe forget about indexes initia...


Read the full article

Comments

20 Apr 10

05:41 PM MDT

Posted in Programming

Getting rid of transactions for the poor man

A quick post for today. Want to get rid of transactions from ActiveRecord for something? Here’s a cheap way to do it. It only works for MySQL obviously, but you can roll your own if you are on postgres. I’ll make it a bit less crappy and make it a gem or something.


Read the full article

Comments

08 Jun 09

08:00 AM MDT

Posted in Software

Supercharge Wordpress

Wordpress is pretty much the blogging engine of choice. It’s used by so many people, and has so many plugins and an amazing following, you’d wonder why anybody would use anything else (well there are a number of reasons, but we can talk about that later). Some problems that come with Wordpress, with all that power, is sometimes it’s slow. Combine php, lots of plugins, and everything else, and your blog can come to a crawl, especially if you wr...


Read the full article

Comments

12 May 09

09:38 PM MDT

Posted in Software

Overview of MySQL engine

It’s for the 4.x version line, but whatever. Old but good. Javascript. On. Now.


Read the full article

Comments

01 May 09

12:27 AM MDT

Posted in Programming

Oracle + auto_increment = Pain

I had to do auto increment in Oracle a while back and it was painful. It ended up happening, but not in the nice MySQL way. Whatever, it worked. This site has a few tricks. Autoincrement primary key for Oracle


Read the full article

Comments