Skip to content

Commit cf5bf46

Browse files
committed
Publish roadmap.
1 parent 4d061fe commit cf5bf46

File tree

1 file changed

+37
-0
lines changed

1 file changed

+37
-0
lines changed

TODO.md

Lines changed: 37 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,37 @@
1+
Features that sooner or later will be added to `ngx_postgres`:
2+
3+
* Make sure that we work-around `bytea` data corruption that takes place
4+
when using 9.0+ database with older client library or vice-versa.
5+
6+
* Add support for SSL connections to the database.
7+
8+
* Add support for dropping of idle keep-alived connections to the
9+
database.
10+
11+
* Add support for sending mulitple queries in one go (transactions,
12+
multiple SELECTs, etc), this will require changes in the processing
13+
flow __and__ RDS format.
14+
15+
* Add `postgres_escape_bytea` or `postgres_escape_binary`.
16+
17+
* Use `PQescapeStringConn()` instead of `PQescapeString()`, this will
18+
require lazy-evaluation of the variables after we acquire connection,
19+
but before we send query to the database.
20+
Notes: Don't break `$postgres_query`.
21+
22+
* Cancel long-running queries using `PQcancel()`.
23+
24+
* Detect client library version using `PQlibVersion()` (PostgreSQL 9.1+)
25+
or exports (for older releases):
26+
27+
8.0.0 -> PQcancel 122
28+
8.1.0 -> PQregisterThreadLock 125
29+
8.1.4 -> PQescapeByteaConn 127
30+
8.2.0 -> PQsendDescribePortal 136
31+
8.3.0 -> PQconnectionNeedsPassword 140
32+
8.4.0 -> PQinitOpenSSL 153
33+
8.5.x -> PQinitOpenSSL 153
34+
9.0.0 -> PQconnectStartParams 157
35+
9.1.x -> PQlibVersion 160
36+
37+
* Detect server version using `PQserverVersion()`.

0 commit comments

Comments
 (0)