Clojurians Log v2

e.g. basic case - sending your XTQL queries through next.jdbc:

(require '[next.jdbc :as jdbc]
         '[xtdb.next.jdbc :as xt-jdbc])

(jdbc/execute! xt-node [(xt-jdbc/xtql '(-> (from ...) ...))])

;; before, for comparison

(require '[xtdb.api :as xt])

(xt/q xt-node '(-> (from ...) ...))

(cc @taylor.jeremydavid)

xt-jdbc/xtql would just be a helper - expands to the following XT SQL extension (but you're still writing data-oriented queries, so no injection attacks)

XTQL $$ (-> (from ...) ...) $$

then, because everything's 'just a relation', you can inline this within larger SQL queries:

FROM XTQL $$ (-> (from ...) (...)) $$
WHERE ...
SELECT ...
ORDER BY ...

> but also, behind the scenes, because the APIs (xtdb.api and pgwire) are starting to diverge a little on this one, we'd likely either move to having the Clojure API calling next.jdbc on your behalf - or, if it's such a small layer that it's not worth a layer, we may look to deprecate it entirely (maintaining the ability to create small throwaway XT nodes for unit tests, of course, because that's awesome)

From a HoneySQL / language spec / parsing p.o.v., I'm very interested in this.

@seancorfield in HoneySQL, I might consider adding something like [:xtql '(-> (from ...) ...)] , implementation being (fn [xtql] (format "XTQL $$ %s $$" (pr-str xtql)))?

otherwise, it should be opaque within the SQL string

Interesting suggestion...

obv you're way better placed to decide what'd be idiomatic HoneySQL 🙂 example above just to show that it's a simple transformation

I created a GH issue about it. I'll see what else comes up in this thread.

@dpsutton yep, we've implemented just about enough of Postgres that it seems to handle XT pretty well 😊 tempted to try adding some valid-time/system-time smarts to Metabase given it's Clojure, some form of timeline sliders or history UI or something. one for a hack day 🙂

although tbh its graphing is already pretty good - might 'just' be the syntactic awareness of the SQL:2011 temporal additions

querying XTQL through Metabase 😊 (in flight)

XTQL can also be a subquery in a bigger SQL query (because everything's just relations)

Woah. This is really cool

Is this using the Postgres driver?

Hey @wes there's no special support just yet in either the standard library or indexes. What kind of functionality do you need? Simple proximity? Polygon intersections?