Connect Python to AWS Databases - Redshift - to - Memcached
This episode shows a basic example of moving data from a redshift database (optimized for reads) to memcached (further optimized for reads to sub-millisecond reads).
Redshift is a data warehouse and memcached is a memory-cache (that can accelerate reads by bypassing looking up data in the server's hard-drive and instead has it stored in 'ram') .
A real-world is to take a data subset and attach it temporarily to the more expensive caching service for the sub-millisecond response times (ideal for interactive websites for example).
This is just to demo how to use an SDK for Python to move data between databases, but also to facilitate computation. on that data. It's a python script that populates the Redshift database to begin with, that is then read into Memcached.