Clojurians Log v2
Clojure programming
Channels
Apps
sql 2026-07-24
valerauko 2026-07-24T10:38:54.561559Z
Is there some "nice" way to make the postgres JDBC driver "preload" all the table information in a schema at once, to avoid the metadata fetch query when a table is referenced first? https://github.com/seancorfield/next-jdbc/issues/275 I imagine I can achieve this by first querying information_schema for all the tables and then building a select 1 = 1 from ... with all the tables listed, but I wondered if there's something less hacky-smelling
igrishaev 2026-07-24T11:21:19.973119Z
Personally I think it's easier to use namespaced aliases in sql like:
select
id as "user/id",
name as "user/name",
profile_id as "user/profile-id"
from
usersigrishaev 2026-07-24T11:22:52.572999Z
Under the hood, jdbc.next will just turn "user/id" into a keyword without fetching extra information. There is no need to replace _ with - as well