Verbose Logging

software development with some really amazing hair

T + G I F R

Articles tagged with "mysql"

Things You Need To Start Caring About Now

· Posted in Editorial
You need to start caring about a few things. Now. Code style Looking through code, you see all sorts of things. Some of them are good. Some of them are downright amazing pieces of code. Some of them are horrible. Some of them are so bad you feel your grip tensing around the keyboard and you have to restrain yourself so you don't snap the bloody thing in half. They might be bad decisions. They might be caused by someone who didn't have the knowle…

Find Queries Missing Indexes In Your Rails Application

· Posted in Programming
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're 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 initi…

Getting Rid Of Transactions For The Poor Man

· Posted in Programming
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.

Supercharge Wordpress

· Posted in Software
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 writ…

Oracle + auto_increment = Pain

· Posted in Programming
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