> ## Documentation Index
> Fetch the complete documentation index at: https://cockroachlabs.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Advanced Example Applications Overview

export const InternalLink = ({version, path = "", children, ...props}) => {
  let detectedVersion = version || "stable";
  if (typeof window !== 'undefined' && !version) {
    const match = window.location.pathname.match(/\/docs\/([^/]+)/);
    if (match) {
      detectedVersion = match[1];
    }
  }
  const normalizedPath = path.startsWith("/") ? path.slice(1) : path;
  return <a href={`/docs/${detectedVersion}/${normalizedPath}`} {...props}>
      {children}
    </a>;
};

The examples in this section show you how to build simple applications using CockroachDB.

Click the links in the tables below to see simple but complete example applications for each supported language and library combination.

If you are looking to do a specific task such as connect to the database, insert data, or run multi-statement transactions, see [this list of tasks](#tasks).

<Note>
  Applications may encounter incompatibilities when using advanced or obscure features of a driver or ORM with **partial** support. If you encounter problems, please <InternalLink path="support-resources">contact Support</InternalLink>.

  Note that tools with <InternalLink path="community-tooling">**community-level** support</InternalLink> have been tested or developed by the CockroachDB community, but are not officially supported by Cockroach Labs. If you encounter problems with using these tools, please contact the maintainer of the tool with details.
</Note>

## JavaScript/TypeScript

| Driver/ORM Framework                                 | Support level | Example apps                                                                                                                                                                                                                                                             |
| ---------------------------------------------------- | ------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| [node-postgres](https://www.npmjs.com/package/pg)    | Full          | <InternalLink path="deploy-lambda-function">AWS Lambda</InternalLink><br /><InternalLink path="build-a-nodejs-app-with-cockroachdb">Simple CRUD</InternalLink>                                                                                                           |
| [Sequelize](https://www.npmjs.com/package/sequelize) | Full          | <InternalLink path="build-a-nodejs-app-with-cockroachdb-sequelize">Simple CRUD</InternalLink>                                                                                                                                                                            |
| [Knex.js](https://knexjs.org/)                       | Full          | <InternalLink path="build-a-nodejs-app-with-cockroachdb-knexjs">Simple CRUD</InternalLink>                                                                                                                                                                               |
| [Prisma](https://prisma.io)                          | Full          | <InternalLink path="build-a-nodejs-app-with-cockroachdb-prisma">Simple CRUD</InternalLink><br /><InternalLink path="deploy-app-netlify">React Web App (Netlify)</InternalLink><br /><InternalLink path="deploy-app-vercel">React Web App (Next.js/Vercel)</InternalLink> |
| [TypeORM](https://www.npmjs.com/package/typeorm)     | Full          | <InternalLink path="build-a-typescript-app-with-cockroachdb">Simple CRUD</InternalLink>                                                                                                                                                                                  |

## Python

| Driver/ORM Framework                                               | Support level | Example apps                                                                                                                                                            |
| ------------------------------------------------------------------ | ------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| [psycopg2](https://www.psycopg.org/docs/install.html)              | Full          | <InternalLink path="build-a-python-app-with-cockroachdb">Simple CRUD</InternalLink><br /><InternalLink path="deploy-lambda-function">AWS Lambda</InternalLink>          |
| [psycopg3](https://www.psycopg.org/psycopg3/docs/)                 | Full          | <InternalLink path="build-a-python-app-with-cockroachdb-psycopg3">Simple CRUD</InternalLink>                                                                            |
| [asyncpg](https://magicstack.github.io/asyncpg/current/index.html) | Partial       | <InternalLink path="build-a-python-app-with-cockroachdb-asyncpg">Simple CRUD</InternalLink>                                                                             |
| [SQLAlchemy](https://www.sqlalchemy.org/)                          | Full          | <InternalLink path="build-a-python-app-with-cockroachdb-sqlalchemy">Simple CRUD</InternalLink><br /><InternalLink path="movr">Multi-region Flask Web App</InternalLink> |
| [Django](https://pypi.org/project/Django/)                         | Full          | <InternalLink path="build-a-python-app-with-cockroachdb-django">Simple CRUD</InternalLink>                                                                              |

## Go

| Driver/ORM Framework                            | Support level | Example apps                                                                            |
| ----------------------------------------------- | ------------- | --------------------------------------------------------------------------------------- |
| [pgx](https://github.com/jackc/pgx/releases)    | Full          | <InternalLink path="build-a-go-app-with-cockroachdb">Simple CRUD</InternalLink>         |
| [GORM](https://github.com/jinzhu/gorm/releases) | Full          | <InternalLink path="build-a-go-app-with-cockroachdb-gorm">Simple CRUD</InternalLink>    |
| [pq](https://github.com/lib/pq)                 | Full          | <InternalLink path="build-a-go-app-with-cockroachdb-pq">Simple CRUD</InternalLink>      |
| [upper/db](https://github.com/upper/db)         | Full          | <InternalLink path="build-a-go-app-with-cockroachdb-upperdb">Simple CRUD</InternalLink> |

## Java

| Driver/ORM Framework                    | Support level | Example apps                                                                                                                                                                                                                                                                             |
| --------------------------------------- | ------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| [JDBC](https://jdbc.postgresql.org/)    | Full          | <InternalLink version="cockroachcloud" path="quickstart">Quickstart</InternalLink><br /><InternalLink path="build-a-java-app-with-cockroachdb">Simple CRUD</InternalLink><br /><InternalLink path="build-a-spring-app-with-cockroachdb-jdbc">Roach Data (Spring Boot App)</InternalLink> |
| [Hibernate](https://hibernate.org/orm/) | Full          | <InternalLink path="build-a-java-app-with-cockroachdb-hibernate">Simple CRUD</InternalLink><br /><InternalLink path="build-a-spring-app-with-cockroachdb-jpa">Roach Data (Spring Boot App)</InternalLink>                                                                                |
| [jOOQ](https://www.jooq.org/)           | Full          | <InternalLink path="build-a-java-app-with-cockroachdb-jooq">Simple CRUD</InternalLink>                                                                                                                                                                                                   |

## Ruby

| Driver/ORM Framework                                    | Support level | Example apps                                                                                   |
| ------------------------------------------------------- | ------------- | ---------------------------------------------------------------------------------------------- |
| [pg](https://rubygems.org/gems/pg)                      | Full          | <InternalLink path="build-a-ruby-app-with-cockroachdb">Simple CRUD</InternalLink>              |
| [Active Record](https://rubygems.org/gems/activerecord) | Full          | <InternalLink path="build-a-ruby-app-with-cockroachdb-activerecord">Simple CRUD</InternalLink> |

## C\#

| Driver/ORM Framework              | Support level | Example apps                                                                        |
| --------------------------------- | ------------- | ----------------------------------------------------------------------------------- |
| [Npgsql](https://www.npgsql.org/) | Full          | <InternalLink path="build-a-csharp-app-with-cockroachdb">Simple CRUD</InternalLink> |

## Rust

| Driver/ORM Framework                                       | Support level | Example apps                                                                      |
| ---------------------------------------------------------- | ------------- | --------------------------------------------------------------------------------- |
| [Rust-Postgres](https://github.com/sfackler/rust-postgres) | Partial       | <InternalLink path="build-a-rust-app-with-cockroachdb">Simple CRUD</InternalLink> |

## See also

Reference information:

* <InternalLink path="install-client-drivers">Client drivers</InternalLink>
* <InternalLink path="third-party-database-tools">Third-Party Tools Supported by Cockroach Labs</InternalLink>
* <InternalLink path="community-tooling">Third-Party Tools Supported by the Community</InternalLink>
* <InternalLink path="connection-parameters">Connection parameters</InternalLink>
* <InternalLink path="transactions">Transactions</InternalLink>
* <InternalLink path="performance-best-practices-overview">Performance best practices</InternalLink>

<a id="tasks" />

Specific tasks:

* <InternalLink path="connect-to-the-database">Connect to the Database</InternalLink>
* <InternalLink path="insert-data">Insert Data</InternalLink>
* <InternalLink path="query-data">Query Data</InternalLink>
* <InternalLink path="update-data">Update Data</InternalLink>
* <InternalLink path="delete-data">Delete Data</InternalLink>
* <InternalLink path="make-queries-fast">Optimize Statement Performance</InternalLink>
* <InternalLink path="run-multi-statement-transactions">Run Multi-Statement Transactions</InternalLink>
* <InternalLink path="query-behavior-troubleshooting">Troubleshoot SQL Statements</InternalLink>