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?
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?
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}})right, apologies - yes, v1 has no support for connection via Postgres (and isn't likely to, I'm afraid)
Cool, thanks for your answer. We have to rely on REPL commands until our app migrates to xtdb v2.
yep - let @taylor.jeremydavid or me know if you need a hand with that migration 🙂
Sure, we are on the planning phase I will surely reach out to you guys if we need any help here.
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 😅