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