I'm looking for a software library that can act as a proxy in front of a database. It should cache the results of all incoming SQL queries to reduce round-trips to the database server. When an UPDATE
or INSERT
query is sent, the proxy should invalidate the cache (the proxy should parse SQL queries). I also need to run it on multiple machines, with all proxy instances communicating to invalidate the cache simultaneously. Can you recommend a library that does this? ChatGPT can't.
>>Click here to continue<<