sql

All things SQL and JDBC...
kulminaator 2020-01-31T19:02:47.048100Z

btw. some feedback to cockroachdb ... gave it a few hours of testing , it actually feels pretty nice. postgresql driver's just worked. and the db feels like an elasticsearch cluster (you can add and remove nodes at will and the system nicely manages the data according to your changes). not as performant on a single node as postgresql, but i wasn't expecting that anyway.

kulminaator 2020-01-31T20:33:09.049Z

probably comes with a similar set of problems too (compared to elasticsearch and other clustered storage systems - split brain, awkward data relocation etc.) 🙂

adamfeldman 2020-02-02T19:41:49.053200Z

IIUC CockroachDB handles data relocation automatically — check out their detailed blog and docs. In testing I’ve found it very robust (and they also did a Jepsen analysis — https://jepsen.io/analyses/cockroachdb-beta-20160829)

kulminaator 2020-02-02T20:38:55.053400Z

elastic does it automatically as well, but sometimes this backfires badly 🙂

kulminaator 2020-02-02T22:04:21.053600Z

but i agree based on initial testing, it felt that it handled weird happenings ok

kulminaator 2020-01-31T20:38:59.049900Z

i have had my eye on yugabyte too which has similar properties and is also an sql database. if anyone has experiences with that one, including accessing from java/clojure, i'm all ears 🙂