Structure binding about pgx

[jackc]

Scan makes this easy enough to do by hand.

[elumalai]

@jackc Scan works for simple structs. Code generation from sql definition won't work, since most of the queries are not that straight forward. Right now we are doing the scan manually. It is not really convenient if the table has more columns. Also restructuring the fields eats up lot of time if we introduce columns later.

Any possibilities to reconsider ?

[jackc]

I'm not sure if this belongs in the database driver layer or not. Seems like their are multiple approaches and perhaps it belongs in a library that sits above pgx.

I'm currently experimenting with using code generation to make CRUD easier (pgxdata - definitely not usable yet). That may become useful at some point.

I'm not a fan of using reflection for structure binding, so I don't see that landing in core pgx.

Any particular approach you were looking for?

[elumalai]

I agree with you concern about reflection. We avoided reflection as much as possible in our application and scanning fields manually. But after some period of time, we felt majority of our code base is for scanning. Most of the database queries involves multiple tables, I am not sure about the code generation approach either.