pgbouncer-rr-patch | Adds query routing and rewriting extensions to pgbouncer | Browser Plugin library

by awslabs C Version: Current License: Non-SPDX

X-Ray Key Features Code Snippets Community Discussions(1)Vulnerabilities Install Support

kandi X-RAY | pgbouncer-rr-patch Summary

pgbouncer-rr-patch is a C library typically used in Plugin, Browser Plugin applications. pgbouncer-rr-patch has no bugs, it has no vulnerabilities and it has low support. However pgbouncer-rr-patch has a Non-SPDX License. You can download it from GitHub.

Adds query routing and rewriting extensions to pgbouncer

Support

Quality

Security

License

Reuse

Support

pgbouncer-rr-patch has a low active ecosystem.

It has 258 star(s) with 49 fork(s). There are 41 watchers for this library.

It had no major release in the last 6 months.

There are 12 open issues and 30 have been closed. On average issues are closed in 86 days. There are 1 open pull requests and 0 closed requests.

It has a neutral sentiment in the developer community.

The latest version of pgbouncer-rr-patch is current.

Quality

pgbouncer-rr-patch has no bugs reported.

Security

pgbouncer-rr-patch has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

License

pgbouncer-rr-patch has a Non-SPDX License.

Non-SPDX licenses can be open source with a non SPDX compliant license, or non open source licenses, and you need to review them closely before use.

Reuse

pgbouncer-rr-patch releases are not available. You will need to build from source code and install.

Installation instructions, examples and code snippets are available.

Top functions reviewed by kandi - BETA

kandi's functional review helps you automatically verify the functionalities of the libraries and avoid rework.
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of pgbouncer-rr-patch

Get all kandi verified functions for this library.

pgbouncer-rr-patch Key Features

No Key Features are available at this moment for pgbouncer-rr-patch.

pgbouncer-rr-patch Examples and Code Snippets

No Code Snippets are available at this moment for pgbouncer-rr-patch.

Community Discussions

Trending Discussions on pgbouncer-rr-patch

pgbouncer-rr is failing in query rewrite

QUESTION

pgbouncer-rr is failing in query rewrite

Asked 2019-Feb-07 at 21:14

I am using pgbouncer-rr to do query rewrite in a redshift cluster (pgbouncer calls rewrite_query.py to do the rewrites and here is the link for more info on this project - https://github.com/awslabs/pgbouncer-rr-patch). Pgbouncer-rr is based on pgbouncer and its code is merged into pgbouncer and started. I have been using it successfully to rewrite queries, but I am running into an issue when I am trying to convert an insert statement into unload to external table.

The execution flow is pgbouncer -> rewrite.c -> pycall.c -> rewrite_query.py

In the python module I write the orig and converted sql and here is how it looks in the log - so python module is able to do the conversion without any issues.

...

ANSWER

Answered 2019-Feb-07 at 21:14

This was due to the python object type getting changed from str to Unicode. I am using sqlparse do to parsing and this module was converting the variable to unicode and was failing PyString_Check check. To fix the issue, after the call to sqlparse, I converted the encoding of the variable to ascii in python (version is 2.7.15) - varname.encode("ascii")

Source https://stackoverflow.com/questions/54454898

Community Discussions, Code Snippets contain sources that include Stack Exchange Network

Vulnerabilities

No vulnerabilities reported

Install pgbouncer-rr-patch

Install Download and install pgbouncer-rr by running the following commands (Amazon Linux/RHEL/CentOS):. Configure Create a configuration file, using ./pgbouncer-example.ini as a starting point, adding your own database connections and python routing rules / rewrite query functions. Set up user authentication - see authentication file format. NOTE: the recently added pgbouncer auth_query feature will unfortunately not work with Amazon Redshift.

Support

For any new features, suggestions and bugs create an issue on GitHub. If you have any questions check and ask questions on community page Stack Overflow .

Find more information at: