Setting up a database

Docker Dev Environment

Once your dev containers are running and you are inside the chatbot_server container, it is easy to create a development database.

First, install dependencies.

pnpm install

Then, create the database.

pnpm db:create

Finally, run the migrations to build the most current schema.

pnpm db:migrate

You can also delete the whole database, which is sometimes useful. Simply run

pnpm db:drop

Note: Any data that was saved will be lost and unrecoverable!