sql

All things SQL and JDBC...
Saikyun 2020-10-16T09:49:15.105800Z

is it possible to get the columns in order/column order of a query? 🙂 since I get the data as hash maps I don't know how to retain column order.

seancorfield 2020-10-16T16:41:47.106600Z

@saikyun If you ask for the results to come back as vectors, the columns (the first vector in the result) will be in natural order.

seancorfield 2020-10-16T16:43:28.107500Z

If you're using next.jdbc, you can also call next.jdbc.result-set/get-column-names on a ResultSetMetaData object to get them in order (or any of its variants).

Saikyun 2020-10-19T10:02:00.116900Z

thanks for the info 🙂

Saikyun 2020-10-19T10:02:13.117100Z

that's exactly what I wanted

seancorfield 2020-10-16T16:45:26.108300Z

(and if you're inside a reducing function operating on rows from plan you can call column-names on the row and get them)

borkdude 2020-10-16T21:26:05.108700Z

People using SQL Server on Windows can now speak to it from babashka using a pod written in C#: https://github.com/xledger/pod_sql_server