juxt

Alex Whitt 2021-07-16T00:12:49.017100Z

Hey there. I'm curious about how crux interacts with your new sql layer. I understand that you can configure column names as either strings or keywords, correct? Is that a meaningful difference when it comes to doing a sql query? For instance will I SELECT column_name or SELECT :column_name if the column is inserted as a keyword?

Steven Deobald 2021-07-16T00:29:03.018600Z

As per https://opencrux.com/reference/1.17.1/sql.html#table-definitions you'll do SELECT column_name or SELECT table.column_name even if the attribute is a keyword. Since you still have to ingest with EDN, it's probably wise to keep the attributes as keywords, regardless. I'm not actually sure if string attributes are supported — I've never seen anyone try to do that.

Alex Whitt 2021-07-16T00:32:54.019400Z

Perfect, thank you

Steven Deobald 2021-07-16T00:29:48.019300Z

It's probably worth noting you're likely to get faster replies (to Crux questions) from a wider audience in #xtdb or Zulip, btw. 🙂

Alex Whitt 2021-07-16T00:33:50.019800Z

Oh, didn't know there was a separate channel

🙂 1