More »

Pseudo Reverse Indexes in MySQL

over 4 years ago by Ilya Grigorik on igvita.com.
When the database grows at a rate of several hundred thousand records a day (AideRSS) you inevitably run into interesting ‘features’ of the...

SSMTP Relay & Mail Delivery in Rails

over 4 years ago by Ilya Grigorik on igvita.com.
Role separation and vertical scaling between the database and the app servers is almost taken for granted, but is no reason that we can’t do this...

Subqueries and SQL Syntax Sugar Diet

over 4 years ago by Ilya Grigorik on igvita.com.
In theory, theory and practice are the same, in practice they are usually not. Likewise, the syntactic sugar provided by modern SQL databases comes with...

Mongrel Timeout / Throttle Misnomer

over 4 years ago by Ilya Grigorik on igvita.com.
Earlier today I made an intriguing discovery while perusing through the Mongrel documentation. Perhaps an oversight on my part, but arguably also a real...

Managing EC2 Reservations with Ruby

over 4 years ago by Ilya Grigorik on igvita.com.
Over the course of past couple of weeks the guys (and gals!) at Amazon have hosted a number of great ‘AWS Start-Up‘ events to evangelize their...

Hands on MySQL Backup & Migration

over 4 years ago by Ilya Grigorik on igvita.com.
Everybody talks about doing it, but very few developers follow through - you guessed it, data backups! Perhaps it’s a matter of getting burnt at...

Boosting ActiveRecord Performance

over 4 years ago by Ilya Grigorik on igvita.com.
ActiveRecord is arguably one of the best ORM wrappers out there. And as any Rails developer will likely tell you, it’s also the backbone of the entire...

Testing RDDB: RESTful Ruby Database

~4 years ago by Ilya Grigorik on igvita.com.
The release of RDDB generated a lot of buzz in the community. Another creation by Anthony Eden, a prolific Ruby coder, RDDB is a document-oriented, RESTful...

Ruby Web-Services with Facebook’s Thrift

~4 years ago by Ilya Grigorik on igvita.com.
Facebook’s Thrift framework made a nice splash in the news on Wednesday with an official announcement of the move to the Apache Incubator. This is...

Ruby Web-Services with Facebook’s Thrift

~4 years ago by Ilya Grigorik on igvita.com.
Facebook's Thrift framework made a nice splash in the news on Wednesday with an official announcement of the move to the Apache Incubator. This is certainly...