<@U04UQ68083H> Does Ory Keto have support for sqli...
# ory-copilot
c
@chilly-king-10285 Does Ory Keto have support for sqlite? Can you provide an example configuration in a docker-compose file?
c
A message from kapa.ai
Ory Keto requires a production-grade database such as PostgreSQL, MySQL, or CockroachDB for its operations. It is explicitly mentioned in the documentation that SQLite should not be used in production ([source](https://www.ory.sh/docs/keto/guides/production)). As for the docker-compose configuration, while there isn't a specific example for Ory Keto in the provided extracts, there is a general example of a docker-compose setup that includes a PostgreSQL service and a service for a hypothetical Ory project. You can use this as a reference to create a docker-compose file for Ory Keto, replacing the necessary parts with your specific Ory Keto configuration:
Copy code
yaml version: "3.7"      volumes:    postgres-db:      services:    postgresd:    image: postgres:9.6    ports:    - "5432:5432"    volumes:    - type: volume    source: postgres-db    target: /var/lib/postgresql/data    read_only: false    environment:    - PGDATA=/var/lib/postgresql/data/pgdata    - POSTGRES_PASSWORD=secret    - POSTGRES_USER=kratos       keto-migrate:    image: keto    build:    context: ../keto    dockerfile: ./.docker/Dockerfile-build    environment:    - DSN=<postgres://keto:secret@postgresd:5432/keto?sslmode=disable&max_conns=20&max_idle_conns=4>    volumes:    - type: bind    source: path-to-keto-config    target: /etc/config/keto    command: migrate sql -e --yes    depends_on:    - postgresd       keto:    image: keto    build:    context: ../keto    dockerfile: ./.docker/Dockerfile-build    depends_on:    - keto-migrate    ports:    - "4433:4433" # public    - "4434:4434" # admin    command: serve -c /etc/config/keto/keto.yml --watch-courier --dev    volumes:    - type: bind    source: path-to-keto-config    target: /etc/config/keto
Please replace
path-to-keto-config
with the actual path to your Ory Keto configuration file and adjust the other settings as necessary for your environment ([source](https://www.ory.sh/docs/kratos/debug/debug-docker-delve-ory-kratos)).