A weekly survey for a private community on use, adoption, and experiences with AI coding tools. Heavily influenced by the State of JS surveys.
- Node.js 24+
- pnpm package manager
- PostgreSQL database (Postgres.app or Docker)
-
Create environment file:
cp .env.example .env
-
Install dependencies:
pnpm install
-
Run database migrations:
pnpm db:latest
-
Sync survey configuration:
pnpm db:sync
-
Seed database with sample data:
pnpm db:seed
-
Start development server:
pnpm dev
...and access the survey at http://localhost:3000/
When modifying config.yml, simply update the config and run pnpm db:sync to apply changes. The sync process is designed to migrate questions as the survey evolves over time without creating duplicate data.
When making database schema changes:
- Create a new Kysely migration in
src/server/db/migrations/ - Apply migrations:
pnpm db:latest - Generate TypeScript types:
pnpm db:codegen - Export schema documentation:
pnpm db:schema