<story><title>Readyset: A MySQL and Postgres wire-compatible caching layer</title><url>https://github.com/readysettech/readyset</url></story><parent_chain></parent_chain><comment><author>BrentOzar</author><text>In the Microsoft SQL Server space, several of these vendors have come and gone. My clients have been burned badly by &amp;#x27;em, so a few quick lessons learned:&lt;p&gt;Be aware that there are hundreds of open issues[0] and dozens of pull requests [1], some of which involve clients being unable to connect or not supporting all components of the SQL language. Just because your database supports something, doesn&amp;#x27;t mean your caching layer will.&lt;p&gt;It gets really ugly when a new version of your database comes out, with brand new features and language enhancements, and the caching layer doesn&amp;#x27;t support it. It may take months, or in some cases years, before the caching layer is feature-complete with the underlying database. If you want to use some of those language enhancements, then your app may have to maintain two connection strings - one for the caching layer, and one for direct database queries that the caching layer doesn&amp;#x27;t support.&lt;p&gt;Your support teams need to learn how to diagnose problems with the caching layer. For example, this issue [2] talks about the level of work involved with understanding why newly inserted data isn&amp;#x27;t showing up in selects.&lt;p&gt;I hope they succeed and deliver the concept, because it&amp;#x27;s one of the holy grails of databases.&lt;p&gt;[0]: &lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;github.com&amp;#x2F;readysettech&amp;#x2F;readyset&amp;#x2F;issues&quot;&gt;https:&amp;#x2F;&amp;#x2F;github.com&amp;#x2F;readysettech&amp;#x2F;readyset&amp;#x2F;issues&lt;/a&gt;
[1]: &lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;github.com&amp;#x2F;readysettech&amp;#x2F;readyset&amp;#x2F;pulls&quot;&gt;https:&amp;#x2F;&amp;#x2F;github.com&amp;#x2F;readysettech&amp;#x2F;readyset&amp;#x2F;pulls&lt;/a&gt;
[2]: &lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;github.com&amp;#x2F;readysettech&amp;#x2F;readyset&amp;#x2F;issues&amp;#x2F;39&quot;&gt;https:&amp;#x2F;&amp;#x2F;github.com&amp;#x2F;readysettech&amp;#x2F;readyset&amp;#x2F;issues&amp;#x2F;39&lt;/a&gt;</text></comment>
<story><title>Readyset: A MySQL and Postgres wire-compatible caching layer</title><url>https://github.com/readysettech/readyset</url></story><parent_chain></parent_chain><comment><author>dpcx</author><text>Pretty sure that this is the database that Jon Gjengset[0] was working on as part of his thesis project. There have been several videos shared by him during talks about the system. It&amp;#x27;s a really interesting concept.&lt;p&gt;edit: Here&amp;#x27;s[1] a video where he talks about the concept&lt;p&gt;[0]: &lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;www.youtube.com&amp;#x2F;@jonhoo&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;www.youtube.com&amp;#x2F;@jonhoo&lt;/a&gt;
[1]: &lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;www.youtube.com&amp;#x2F;watch?v=GctxvSPIfr8&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;www.youtube.com&amp;#x2F;watch?v=GctxvSPIfr8&lt;/a&gt;</text></comment>