Tips¶
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¶
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
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