I want to rename the primary key column as :db/id in the result set, is there a simple global way?

@doglooksgood Not really. Neither next.jdbc nor clojure.java.jdbc know anything about your primary keys. If you always follow a naming convention in every table, you could write a builder to do it I guess.

@seancorfield thanks!

:db/id feels like a domain-level distinction that you're trying to create so perhaps you need to think about separating your domain representation from your persistence representation? In the latter, qualifying columns by the database table name makes sense and may or may not make sense in the domain model so some sort of translation layer would be appropriate. Depends what you are trying to do I guess.

@seancorfield make sense, I'm start rethinking this problem. It seems :db/id is not a good name.

I think there's definitely value in distinguishing your :person/id from your :address/id for example...

I wonder how this might work with next jdbc?

https://r2dbc.io/2019/12/02/r2dbc-0-8-0-goes-ga

Non blocking jdbc

Oracle formally stopped their official work on an async version of JDBC recently saying that fibers were the right solution. This seems to be something a lot less official?

It's not compatible with JDBC so none of the Clojure wrappers for JDBC will work with it right @dharrigan?

Yeah, it's a community driven project.