Stack Abuse: Working with Redis in Python with Django

Introduction Data is increasingly becoming a valuable commodity in the current era of technology and this necessitates the optimization of storage and access to this data. There are quite a few notable solutions for the storage of data, including Relational Database Management Systems (RDBMS) such as MySQL and PostgreSQL, which store data in a structured format using rows and columns and the relationships within the data. Apart from RDBMS, there are key-value stores that store data based on unique keys and values like a dictionary. Key-value databases fall under the…

Read More

Peter Bengtsson: How much faster is Redis at storing a blob of JSON compared to PostgreSQL?

tl;dr; Redis is 16 times faster and reading these JSON blobs.* In Song Search when you’ve found a song, it loads some affiliate links to Amazon.com. (In case you’re curious it’s earning me lower double-digit dollars per month). To avoid overloading the Amazon Affiliate Product API, after I’ve queried their API, I store that result in my own database along with some metadata. Then, the next time someone views that song page, it can read from my local database. With me so far? The other caveat is that you can’t…

Read More