Database setup - Epiq AI

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