From 66b79706e886432ffa7c134ec39a87f43c43f3c1 Mon Sep 17 00:00:00 2001 From: Bertrand Yuan Date: Mon, 27 Apr 2026 23:47:07 +0800 Subject: docs: update README with Docker DATABASE_URL example Added an example for the DATABASE_URL configuration in the Docker section of the README. Included instructions for creating the PostgreSQL schema before running migrations to ensure proper setup for the application. Signed-off-by: Bertrand Yuan --- README | 29 +++++++++++++++++++++++------ README.rst | 16 ++++++++++++++-- 2 files changed, 37 insertions(+), 8 deletions(-) diff --git a/README b/README index 1460ae7..13c5e94 100644 --- a/README +++ b/README @@ -59,7 +59,10 @@ docker run -d \ postgres:15.1 Then, copy .env.example to .env and fill in the required environment variables -that suit your setup. +that suit your setup. For the Docker command above, DATABASE_URL should look +like this: + +postgresql://admin:YOUR_PASSWORD_HERE@localhost:5432/db Generate authentication key: This project uses Better Auth. A secure key of at least 32 characters must be provided. @@ -75,11 +78,25 @@ Run installation of react-syntax-highlighter dependencies: pnpm add react-syntax-highlighter pnpm add -D @types/react-syntax-highlighter -Run Payload CMS migrations: pnpm payload migrate -Run database migrations: pnpm db:push -(optional: SKIP_ENV_VALIDATION=1 pnpm db:push) -Start the development server: pnpm dev -(optional SKIP_ENV_VALIDATION=1 pnpm dev) +Create the Payload PostgreSQL schema before running Payload migrations: +pnpm tsx scripts/create-payload-schema.mts + +Run Payload CMS migrations: +pnpm payload:migrate + +Run database migrations: +pnpm db:push + +If OAuth environment variables are not configured locally, skip validation for +database push and development startup: +SKIP_ENV_VALIDATION=1 pnpm db:push + +Start the development server: +pnpm dev + +Or, with local env validation skipped: +SKIP_ENV_VALIDATION=1 pnpm dev + Open Core Modules diff --git a/README.rst b/README.rst index b1d35aa..2feab19 100644 --- a/README.rst +++ b/README.rst @@ -70,13 +70,25 @@ Run the following command to start a Postgres instance: Then copy ``.env.example`` to ``.env`` and fill in the required environment variables for your setup. +For the Docker command above, ``DATABASE_URL`` should look like this: + +.. code-block:: bash + + postgresql://admin:YOUR_PASSWORD_HERE@localhost:5432/db + .. code-block:: bash pnpm install - pnpm payload migrate + pnpm tsx scripts/create-payload-schema.mts + pnpm payload:migrate pnpm db:push -Optional: +The ``scripts/create-payload-schema.mts`` step creates the PostgreSQL +``payload`` schema required by ``payload.config.ts`` before Payload migrations +create tables inside it. + +If OAuth environment variables are not configured locally, skip validation for +database push and development startup: .. code-block:: bash -- cgit v1.2.3