xtdb

2025-04-28T10:52:28.826189Z

We wanted to login/connect to XTDB directly as we are doing it for Postgres. I went thru official docs and I asked AI as well. The answer is, there is no such support yet. Is my above assertion correct? Is there any way to access data of XTDB directly (via query without using REPL) like we do in Postgres?

jarohen 2025-04-28T10:57:19.150909Z

yes, once you have XT up and running, connect using your usual Postgres tooling, as if it were Postgres - what have you tried so far?

2025-04-28T11:25:00.881699Z

I didn’t try anything specifically. I forgot to mention that we are using V1. I can only see tx_events table in our Postgres DB that is related to xtdb I am pasting the xtdb node initialization config here:

(defmethod ig/prep-key ::node [_ {{:keys [database-host
                                          database-port
                                          database-name
                                          database-user
                                          database-password]} :jdbc
                                  index-store :xtdb-dir}]
  {:xtdb.jdbc/connection-pool {:dialect
                               {:xtdb/module 'xtdb.jdbc.psql/->dialect}
                               :db-spec {:host database-host
                                         :port database-port
                                         :dbname database-name
                                         :user database-user
                                         :password database-password}}
   :xtdb/tx-log {:xtdb/module 'xtdb.jdbc/->tx-log
                 :connection-pool :xtdb.jdbc/connection-pool}
   :xtdb/document-store {:xtdb/module 'xtdb.jdbc/->document-store
                         :connection-pool :xtdb.jdbc/connection-pool}
   :rocks-db-module {:xtdb/module 'xtdb.rocksdb/->kv-store
                     :db-dir (io/file index-store)}
   :xtdb/index-store {:kv-store :rocks-db-module}})

jarohen 2025-04-28T11:27:33.893119Z

right, apologies - yes, v1 has no support for connection via Postgres (and isn't likely to, I'm afraid)

2025-04-28T11:30:24.018469Z

Cool, thanks for your answer. We have to rely on REPL commands until our app migrates to xtdb v2.

jarohen 2025-04-28T11:30:58.402529Z

yep - let @taylor.jeremydavid or me know if you need a hand with that migration 🙂

2025-04-28T11:33:47.022969Z

Sure, we are on the planning phase I will surely reach out to you guys if we need any help here.

👌 2
jarohen 2025-04-28T15:01:20.660679Z

Afternoon folks 👋 Following on from the b7 release last week, a blog on what different shapes of bitemporal data look like in the wild. As always, let us know what you think - especially if you can think of a bitemporal shape I've missed, because then we have more work to do 😅