Local hosting with docker compose

[waterworthd-cim]

I'm trying to get better-chatbot running locally using docker and I'm running into issues with postgres

I've followed the

I'm probably misreading but I've followed the instructions in Quick Start (Docker Compose Version) (https://github.com/cgoinglove/better-chatbot?tab=readme-ov-file#quick-start-docker-compose-version-)

pnpm i
pnpm docker-compose:up

I'm confused about what exactly I need to put into the .env file and where it should be located - the README.md states "Enter only the LLM PROVIDER API key(s) you want to use in the .env file at the project root." which I've done - but pnpm docker-compose:up fails becasue it's expecting a .env file in the docker folder.

I copied it there and docker build suceeds but then when I look at the logs I see

better-chatbot-1  |  ✓ Ready in 205ms
better-chatbot-1  | ⏳ Running PostgreSQL migrations...
better-chatbot-1  | ❌ PostgreSQL migrations failed. check the postgres instance is running. undefined
better-chatbot-1  | TypeError: Cannot read properties of undefined (reading 'query')
better-chatbot-1  |     at <unknown> (.next/server/chunks/4720.js:1:31245)
better-chatbot-1  |     at Object.startActiveSpan (.next/server/chunks/4720.js:1:9260)
better-chatbot-1  |     at <unknown> (.next/server/chunks/4720.js:1:31075)
better-chatbot-1  |     at Object.startActiveSpan (.next/server/chunks/4720.js:1:9260)
better-chatbot-1  |     at g.execute (.next/server/chunks/4720.js:1:30829)
better-chatbot-1  |     at <unknown> (.next/server/chunks/4720.js:1:42254)
better-chatbot-1  |     at Object.startActiveSpan (.next/server/chunks/4720.js:1:9260)
better-chatbot-1  |     at p.execute (.next/server/chunks/4720.js:1:42091)
better-chatbot-1  |     at C.migrate (.next/server/chunks/4720.js:7:13)
better-chatbot-1  |     at n (.next/server/chunks/4950.js:1:1242)

The env.example file also contains

POSTGRES_URL=postgres://your_username:your_password@localhost:5432/your_database_name

But I assumed this is when you BYO your won db - is this incorrect, is there some additional PG config required? ASsuming POSTGRES_URL is also used what should I set for the user/pwd/db name?

And is BETTER_AUTH_SECRET required or optional?

[waterworthd-cim]

After purging all docker images/containers/network etcI ended up following "Quick Start (Local Version)" i.e.

pnpm i
pnpm docker:pg
pnpm build:local && pnpm start

That seemed to work - it used postgres:latest rather than postgres:17 but I'm not sure that was the issue or not