Ruby

http://s.erious.ly

Posts tagged "mysql"

It’s Time To Double Up (Using Amazon’s RDS Read Replication Database Servers With Heroku For Master-Slave Replication)

Heroku is great for rapid application development but if you want to run multiple databases it doesn’t provide any options. Running multiple databases in a master-slave orientation can provide an elegant solution to many scaling issues. This can ...

June 18, 2010: Links Ahoy

I think a link post today… Book Status Still working on the style section, for some reason it’s going grindingly slow. The plan for beta 4 is the new style chapter, probably the legacy coding chapter. Also on the slate is updating the sample app to use Devise, which had a large constituency when I...

Installing Ruby on Rails, Passenger, PostgreSQL, MySQL, Oh My Zsh on Snow Leopard, Fourth Edition

Welcome to what seems like my tenth installment (actually, it’s the fourth) of showing you how I setup my development environment on a fresh OSX install. In this case, I’m actually getting a MacBook setup for a new employee with Snow Leopard.

Over the years, I’ve evolved these following steps and they’ve helped our team maintain...

Using BETWEEN for SQL comparisons

Recently, Carlos, suggested that I should start sharing some basic SQL tips that help with performance and/or general usage. I recently came across some code that I didn’t like to read and/or write. For example, let’s take the following…


SELECT * FROM brochures WHERE published_at <= now() AND archived_at >= now()

Essentially, this is pulling back...

Double Shot #550

At the end of the day, you have to ship code. Or sleep. MySQL vs. PostgreSQL comparison – Reasonably fair, though it misses the fact that GUI tools for MySQL are generally better. Software patents should be abolished – Amen. script/nginx – Instructions for getting nginx + passenger running in your dev environment. RubyMine 2.0 Beta Overview – Some...

Double Shot #518

Birthday season is just about over around here. A good thing, as I need to get some work done. open_gem – Gem extension to make it simple to open installed gems in your text editor. I’ve mentioned this before, but it’s still gaining useful features and I find I’m using it daily. Ruby 1.8.6pl383 released – New...

Double Shot #507

Wait, it’s still July? This month may never end. acts_as_taggable_on_steroids was REALLY slow – A case where having some MySQL knowledge turned out to be critical. Embrace Technical Debt – An argument that sometimes writing sloppy code isn’t such a bad thing to do. Freshlog – Screen capture for OS X that can automatically create Lighthouse or Unfuddle...

Double Shot #505

Looks like my August hours may be starting to fill out. That was a bit too close for comfort. The RailsBridge BugMash – Please do join us August 8-9 if you have any interest in improving the quality of Rails. Putting it all together – ResourceTemplates, described_routes and path-to – Plumbing to handle header-based discovery and easier...

Double Shot #496

It looks like the Fairy Godmother Department’s lunch hour may be over. Many Ways to Tag Taggables – Tobias hunted down all the Rails tagging libraries he could find. Looks like he settled on acts_as_taggable_on, which is the one I use too. fleakr – Flickr API integration gem recommended by a couple of my readers. read_from_slave – Read...

MySQL is just a toy

Twitterrific

Are you using PostgreSQL? EnterpriseDB want’s to hear your story at Postgres Rocks