xtdb

2025-09-06T17:28:27.634769Z

In xtdb2, Is there any way to preserve exact key name in documents? It seems like probably not, just want to make sure I'm not missing something. I have docs from an external source that use a mix of camel case and kebab case. It seems that the camel case names are downcased internally. I see there's https://docs.xtdb.com/reference/main/xtql/queries.html#_query_options but I don't think that's quite going to do it.

refset 2025-09-07T16:16:48.535179Z

The clojure API probably doesn't handle non-kebab keywords properly (might be a bug, would need to check), but the SQL should work if you double-quote the columns - and you can pass transit params with SQL (which should hopefully cope with a broader range of keyword keys)

👍 1
seancorfield 2025-09-06T18:57:03.266089Z

How are you inserting those docs? next.jdbc? HoneySQL to create the SQL?

seancorfield 2025-09-06T18:59:32.154559Z

(basically, I'm wondering if you're quoting those keys when passing them to XTDB via JDBC)

2025-09-06T21:56:47.234739Z

Ohh I was using xtdb.api/execute-tx with :put-docs, I'll have to try it out with jdbc in a bit