# django-pg-rls

**Repository Path**: opensource77/django-pg-rls

## Basic Information

- **Project Name**: django-pg-rls
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: main
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2025-05-22
- **Last Updated**: 2025-05-22

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

Django Postgres Row-Level-Security
==================================

Building multi-tenant application with using database "shared" pattern.

## Concepts

* Avoid multiple schema/database for high-performance.
* Protecting data from other tenant.

references:

* https://pganalyze.com/blog/postgres-row-level-security-django-python

## Usage

### boot

```
$ docker-compose up
```
### DB migration

```
$ docker-compose exec dj python3 manage.py migrate
```

### access

* http://localhost:8000/admin/
    * Tenant1: ID/PW: haru
    * Tenant2: ID/PW: terada
    * Admin: ID/PW: admin

### containers

* dj (django)
    * http://localhost:8000/
* db (postgres)
    * ID/password: `root`/`root`

### DB console
```
$ docker-compose exec db psql -U db
```