Redshift with Django What it is and how to use it from our favourite web framework 

Redshift is Postgresql* *kind of 

If it looks like a duck, swims like a duck, and quacks like a duck... 

Redshift is an “OLAP” version of Postgresql Have to average 1 billion values? In under 1 min? Mostly append to tables? No transactio ns or referential integrity? Yes Yes Yes Yes No No No No I don’t know 

Rows Columns Redshift has a column disk layout vs Postgres rows layout 

Performance comparison Column-oriented Row-oriented Aggregate on a single column Fast Slow SELECT on many columns table Fast Slow INSERT/UPDATE on single rows Slow Fast SELECT single row Slow Fast 

Do not try this at home - Build a CRUD app on Redshift (low performance) - Use Django ORM on Redshift (common ops have low performance) - Use Django migrations on Redshift (types are slightly different) - Columns are NULLable by default - Optimize it (or change tables) like you would on Postgresql 

No content

Multiple databases configuration in Django 

Raw queries 

Thanks! Any questions, you can find me at: http://flagzeta.org @flagZ “Federico Marani” on Google