sql

DenisMc 2025-07-30T16:28:10.984559Z

qq on next.jdbc usage, which I am using with honeysql to good effect. I have a number of postgres enums in my schema, and they need to be cast using next.jdbc.types/as-other to work as parameters (or when inserting or whatever) - this all works fine. I’m wondering if there is a straightforward way to automatically cast :keywords that are passed in as parameters to a next.jdbc statement, so that these are assumed to be enums - saving me the trouble of doing the manual as-other conversion whenever I encounter them? I’d like to convert keywords to SCREAMING_SNAKE_CASE_STRING and then do the as-other conversion - and of course I’d like it to work in both directions, for reads as well to automatically make this transformation.

seancorfield 2025-07-30T16:34:04.068649Z

SettableParameter and ReadableColumn are the protocols for doing that sort of automated conversion. Just be aware that they are global and affect all next.jdbc operations in your application.

👍 1