Tips

NewSql

https://en.wikipedia.org/wiki/NewSQL

Support SQL and Postgres

https://www.cockroachlabs.com/docs/stable/sql-feature-support.html

https://www.cockroachlabs.com/docs/v2.1/cockroachdb-in-comparison.html

https://www.cockroachlabs.com/blog/why-postgres/

https://www.cockroachlabs.com/docs/v2.1/migrate-from-postgres.html

Performance best practice

https://www.cockroachlabs.com/docs/stable/performance-best-practices-overview.html

Join

https://www.cockroachlabs.com/docs/stable/joins.html

https://www.cockroachlabs.com/docs/stable/joins.html#performance-best-practices

Support Django

https://github.com/cockroachdb/cockroachdb-python/pull/14

Support k8s

https://www.cockroachlabs.com/docs/v2.1/orchestrate-cockroachdb-with-kubernetes-multi-cluster.html

Scale

https://www.cockroachlabs.com/docs/stable/frequently-asked-questions.html#how-does-cockroachdb-scale

https://www.cockroachlabs.com/docs/stable/multi-active-availability.html

https://www.cockroachlabs.com/docs/stable/high-availability.html

Performance

https://www.cockroachlabs.com/blog/cockroachdb-2dot1-performance/

Deploy multi-node cluster using HAProxy load balancer

Deploy a secure multi-node CockroachDB cluster on multiple machines, using HAProxy load balancers to distribute client traffic.

https://www.cockroachlabs.com/docs/stable/deploy-cockroachdb-on-premises.html

Adapting SQLAlchemy to CockroachDB

CockroachDB is similar enough to PostgreSQL that SQLAlchemy’s built-in PostgreSQL dialect gets us most of the way there, but we still need a few tweaks that can be found in our cockroachdb python package.

https://www.cockroachlabs.com/blog/building-application-cockroachdb-sqlalchemy-2/

https://www.cockroachlabs.com/docs/stable/build-a-python-app-with-cockroachdb-sqlalchemy.html

SqlAlchemy Best Practice

https://www.cockroachlabs.com/docs/stable/build-a-python-app-with-cockroachdb-sqlalchemy.html#best-practices