Clojurians Log v2

Have you tested https://github.com/igrishaev/pg2 with XTDB via pgwire?

we've not; we should 🙂

I should say it's still relatively early days for the pgwire driver as yet - we get the simple stuff right but whenever you get a tool to connect using a Postgres connection string it then makes a lot of assumptions about the amount of Postgres-specific SQL/metadata available. We're chewing through these but it's mostly a game of trying each individual tool and seeing what queries it runs 😅 If anyone's got any favourite tools, give us a shout and we can try to prioritise those ones

Since you don't have a JDBC driver, the choices from Clojure as far as SQL is concerned are: • next.jdbc.xt -- faking the API to somewhat pretend it's like JDBC (which I don't think is a good solution long term -- lots of pieces in next.jdbc don't work properly this way) • pg2 -- as above • xtdb.api -- which is kind of its own weird interface The first two sort of make XTDB look like "any other database" to some extent; the latter accepts that it's a unique thing with its own custom integration code

(writing and using next.jdbc.xt made me realize just how thin a wrapper next.jdbc is around JDBC 🙂 and how many assumptions about JDBC it makes)

you should be able to use next.jdbc using the Postgres JDBC driver and a Postgres connection string?

The PG JDBC driver expects to connect to port 5432 by default and I hadn't thought about whether that's a pgwire endpoint 🙂

seems ok in practice - quite a lot of our pgwire tests run through next.jdbc 🙂

Ah, good to know... Then I think I will deprecate next.jdbc.xt then...