jet icon indicating copy to clipboard operation
jet copied to clipboard

Please add a PGX adapter

Open veqryn opened this issue 1 year ago • 86 comments
trafficstars

Is your feature request related to a problem? Please describe. Right now the default for Jet is to let postgres arrays get generated into golang strings. You can override the generated types, but then you'd also have to implement your own scan/value functions too. Using PGX directly (github.com/jackc/pgx/v5) lets us do things like scanning postgres arrays directly to a slice ([]int64), and many other great features. Unfortunately, Jet only accepts the standard library database/sql interface, which forces us to use github.com/jackc/pgx/v5/stdlib

Describe the solution you'd like Other scanning libraries such as scany and ksql provide an adapter that lets their library use both the standard library interface and also PGX directly. It would be great if Jet provided similar.

veqryn avatar Sep 04 '24 18:09 veqryn