Question

Closed. This question is seeking recommendations for books, tools, software libraries, and more. It does not meet Stack Overflow guidelines. It is not currently accepting answers.

We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations.

Closed 1 year ago.

Improve this question

I am looking for something similar to MySQL Proxy. The purpose is to modify incoming queries on the server. I am not looking for alternative ways to achieve the same. My best guess at the moment is to modify GridSQL, but this adds complexity and it takes time. I have asked this question before in a vastly different way and got no relevant results, so I deleted that question and added this one.

Edit: It is important that the client can continue to utilize the PostgreSQL protocol, so the package I am looking for needs to communicate using it.

Answer 1

You might take a look at sqlrelay which has the ability to route and filter queries.

http://sqlrelay.sourceforge.net/sqlrelay/router.html

If you want to rewrite the queries I think sqlrelay falls short.

You might otherwise look into PostgreSQL s rules, which can be used to substitute or rewrite queries:

http://www.postgresql.org/docs/8.4/interactive/rules.html

Answer 2

You can refer to the following postgresql-aync driver project.

https://github.com/mauricio/postgresql-async

友情链接