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

# Database setup

## PostgreSQL

AIDA uses PostgreSQL for the primary datastore for user data and app data. 

The PostgreSQL database is launched with docker compose. 

```
docker-compose up -d
```

#### Enable SSL

The PostgreSQL database has SSL mode enabled and requires valid certificates.

```
volumes:
    - ./postgres/certs/server.crt:/var/lib/postgresql/server.crt
    - ./postgres/certs/server.key:/var/lib/postgresql/server.key
```

## Solr

AIDA uses Solr for indexing case documents, including text and metadata. 

Solr is running in a Solr Cloud mode with Zookeeper. You can scale up/down the Solr cluster by adding/removing Solr nodes in the docker compose.

SSL is enabled in Solr and requires valid certificates. You can mount your own certificate in docker compose:

```
volumes:
  - ./solr/certs/solr-ssl.keystore.p12:/certs/solr-ssl.keystore.p12
```

### Qdrant

AIDA uses Qdrant for storing vector embeddings for case documents to support semantic search. Qdrant can be launched via docker compose. 

TSL configuration:

```
volumes:
  - ./qdrant/tls/cert.pem:/qdrant/tls/cert.pem
  - ./qdrant/tls/key.pem:/qdrant/tls/key.pem
```