drogon
drogon copied to clipboard
drogonframework
Support postgresql asynchronous notification (LISTEN command).
TODOS:
- Forgot to handle concurrent query!!!
- Need to handle LISTEN query failure caused by too many queued quries.
- LISTEN and NOTIFY commands don't take parameter placeholders ($1), the whole sql must be plain text. Need to handle character escaping.
GREAT !!!
This is really a useful feature. Now to create a real time applications one must use other messaging libraries or create and extra column in every table in DB called "last_modified_time" and check the table periodically to figure out has the table changed or not. With PostgreSQL notifications mechanism one can avoid all this hell and use PostgreSQL itself as a messaging library and have your data in application synchronized with DB also.
I would appreciate if you accept this PR. Thanks!!!
