title: A good blobstore / memcache solution
body: <p>Setting up a data warehousing mining project on a Linux cloud server. The primary language is Python .</p>
  
  <p>Would like to use this pattern for querying on data and storing data:</p>
  
  <ul>
  <li><strong>SQL Database</strong> - SQL database is used to query on data. However, the SQL database stores only fields that need to be searched on, it does NOT store the "blob" of data itself. Instead it stores a key that references that full "blob" of data in the a key-value Blobstore. </li>
  <li><strong>Blobstore</strong> - A key-value Blobstore is used to store actual "documents" or "blobs" of data.</li>
  </ul>
  
  <p>The issue that we are having is that we would like more frequently accessed blobs of data to be automatically stored in RAM. We were planning to use Redis for this. However, we would like a solution that automatically tries to get the data out of RAM first, if it can't find it there, then it goes to the blobstore.</p>
  
  <p>Is there a good library or ready-made solution for this that we can use without rolling our own? Also, any comments and criticisms about the proposed architecture would also be appreciated.</p>
  
  <p>Thanks so much!</p>