So all this talk about Rails (not) scaling got me thinking. If the database is the next bottleneck after you’ve beefed up your pack of Mongrels, just remove it—and replace it with Twitter!

That’s right. A Twitter-based ActiveRecord store.

I expect the plugin to work something like this:

development:
  adapter: mysql
  database: sockr_development
  username: root
  password:
  host: localhost

test:
  adapter: mysql
  database: sockr_test
  username: root
  password:
  host: localhost

production:
  adapter: twitter
  username: sockr_production
  password: web2point0h

(Note here how I’m still using a traditional RDBMS for development and test environments. Kicking in Twitter here would be quite silly, as we don’t need the scalability for just our local user as we’re developing. We really need it for production!)

That’s it! The plugin would take care of marshaling your ActiveRecord objects into 140 byte chunks and sending it off to Twitter HQ for cold storage.

Keep your eyes peeled for the plugin, coming soon!