hello - Wolfram from deepstream was asking me why i wanted to use cockroach, and i answered “referential integrity” and here was his reply:
deepstream doesn’t use relational constructs. In relational databases it’s basically just independent tables with two columns each - one for key, one for value. The ones that work best are the ones that provide support for binary json - searchable JSON docs a la Postgres or MySQL or pub/sub as Postgres provides.
it is my impression that cockroachDB will handle just about everything that Postgres will. We now have a deepstream–>cockroachDB connector written but not yet tested.
any suggestions how i might reply? this was on the deepstream slack page.