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...
Verbose Logging
software development with some really amazing hairGetting 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
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
Overview of MySQL engine
It’s for the 4.x version line, but whatever. Old but good. Javascript. On. Now.
Read the full article
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