|
|
|
|
|
|
by kardianos
24 days ago
|
|
|
What posgresql needs is a new wire format. (pgwire4) I've been slopping together a POC to probe the edges of what can be done as just an extension. So far I have a framed protocol with inline cancellation, named parameters, out-of-query text language selector, ad-hoc pg/PLSQL execution with cache (no need for prepare), multiple result sets, streaming large results, and more flexible bulk upload. In other words, with this extension you can query: ```
select * from T1;
select * from T2;
``` And return them both in PG/PLSQL or straight SQL. The existing pgwire3 protocol is one of the worst things to work with in postgresql. |
|
|