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.
Applications may encounter incompatibilities when using advanced or obscure features of a driver or ORM with partial support. If you encounter problems, please open an issue with details to help us make progress toward full support.
Note that tools with community-level support 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.
JavaScript/TypeScript
| Driver/ORM Framework | Support level | Example apps |
|---|---|---|
| node-postgres | Full | AWS Lambda Simple CRUD |
| Sequelize | Full | Simple CRUD |
| Knex.js | Full | Simple CRUD |
| Prisma | Full | Simple CRUD React Web App (Netlify) React Web App (Next.js/Vercel) |
| TypeORM | Full | Simple CRUD |
Python
| Driver/ORM Framework | Support level | Example apps |
|---|---|---|
| psycopg2 | Full | Simple CRUD AWS Lambda |
| psycopg3 | Full | Simple CRUD |
| SQLAlchemy | Full | Simple CRUD Multi-region Flask Web App |
| Django | Full | Simple CRUD |
Go
| Driver/ORM Framework | Support level | Example apps |
|---|---|---|
| pgx | Full | Simple CRUD |
| GORM | Full | Simple CRUD |
| pq | Full | Simple CRUD |
| upper/db | Full | Simple CRUD |
Java
| Driver/ORM Framework | Support level | Example apps |
|---|---|---|
| JDBC | Full | Quickstart Simple CRUD Roach Data (Spring Boot App) |
| Hibernate | Full | Simple CRUD Roach Data (Spring Boot App) |
| jOOQ | Full | Simple CRUD |
Ruby
| Driver/ORM Framework | Support level | Example apps |
|---|---|---|
| pg | Full | Simple CRUD |
| Active Record | Full | Simple CRUD |
C#
| Driver/ORM Framework | Support level | Example apps |
|---|---|---|
| Npgsql | Partial | Simple CRUD |
Rust
| Driver/ORM Framework | Support level | Example apps |
|---|---|---|
| Rust-Postgres | Partial | Simple CRUD |
See also
Reference information:
- Client drivers
- Third-Party Tools Supported by Cockroach Labs
- Third-Party Tools Supported by the Community
- Connection parameters
- Transactions
- Performance best practices
Specific tasks:
- Connect to the Database
- Insert Data
- Query Data
- Update Data
- Delete Data
- Optimize Statement Performance
- Run Multi-Statement Transactions
- Error Handling and Troubleshooting
Was this helpful?
