Replacing Relational DB with Redis: a Case Study

By Anton Berezin (‎Grrrr‎) from Copenhagen.pm
Date: Sunday, 19 June 2011 10:00
Duration: 40 minutes
Target audience: Intermediate
Language: English
Tags: databases redis

You can find more information on the speaker's site:


While relational databases represent a valuable and
versatile tool, they have their problems. For many
workloads the performance offered by many RDBMSes
does not cut it.

This talk considers one such case, and walks
through the implementation of one possible solution,
namely the replacement of a PostgreSQL instance
with an in-memory key-value store Redis.

The general steps necessary for such conversion
are defined and elaborated upon.

The limitations of using Redis instead of an RDBMS
are discussed as well.

As a bonus, using Redis as a message bus
is described. An implementation of a
generic queue for watching Best Practical's Request
Tracker's transactions is used as an illustration.


Attended by: Christoffer Sawicki, Bengt Ericsson, Henrik Tougaard (‎htoug‎), Florian Ragwitz (‎rafl‎), Felix Antonius Wilhelm Ostmann (‎Sadrak‎), Lars Thegler (‎tagg‎), Kaare Rasmussen, Anton Berezin (‎Grrrr‎), Søren Lund (‎slu‎), Casper Warming (‎warming‎),