Cool! I'm interested in trying Crux with an existing Postgres DB....

@U07TTE6RH perfect scenario 🙂

@U899JBRPF: As a Crux newbie, I'll likely need to wait until the JDBC support is documented....

Docs are there, let us know if you have any issues https://juxt.pro/crux/docs/configuration.html#_jdbc_nodes

Also I posted some instructions for Postgres here last week:

(ns crux-jdbc-example
  (:require [crux.api :as crux])
  (:import (crux.api Crux ICruxAPI)))

(def opts {:dbtype "postgresql"
           :port 5432
           :dbname "postgres"
           :user "postgres"
           :kv-backend "crux.kv.memdb.MemKv"
           :db-dir "kv-store"})

(def node (Crux/startJDBCNode opts))

can confirm that things seem to work well using postgres with a rocks-kv (at least for my simple testing)

I got a good nip on the postgres schema change though 😀

@U19EVCEBV oops, sorry, yeah that probably deserved to be noted in the changelog at the very least...

😎

I was playing with about 100K random(ish) entities, performance seemed decent enough.

I also wiped the rocks store and let it rebuild, and that seemed to work correctly as well.