# example-app-python-psycopg3

**Repository Path**: mirrors_cockroachdb/example-app-python-psycopg3

## Basic Information

- **Project Name**: example-app-python-psycopg3
- **Description**: Simple CRUD application in Python using the psycopg3 driver.
- **Primary Language**: Unknown
- **License**: Apache-2.0
- **Default Branch**: main
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2022-08-11
- **Last Updated**: 2025-12-06

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# example-app-python-psycopg3

This repo has a simple CRUD Python application that uses the [`psycopg3`](https://www.psycopg.org/psycopg3/docs/) driver to talk to a CockroachDB cluster.

For details on creating a CockroachDB cluster and running the code, see [this tutorial](https://www.cockroachlabs.com/docs/stable/build-a-python-app-with-cockroachdb-psycopg3.html).

## Before you begin

To run this example you must have:

- Python 3
- `pip` version 20.3 or greater

## Install the dependencies

In a terminal run the following command:

~~~ shell
pip install -r requirements.txt
~~~

## Set the CockroachDB connection URL

In a terminal set a `DATABASE_URL` environment variable to the connection URL for your CockroachDB cluster.

For example on Mac and Linux:
~~~ shell
export DATABASE_URL='<connection URL>'
~~~

For detailed steps on creating a CockroachDB cluster, see the [tutorial](https://www.cockroachlabs.com/docs/stable/build-a-python-app-with-cockroachdb-psycopg3.html).

## Run the example

To run the example, in a terminal run the following command:

~~~ shell
python3 example.py
~~~