Replace sqlite with postgres #1958

	name: CI

	on:
	push:
	branches: [main]
	pull_request:
	branches: [main]

	jobs:
	ci:
	name: CI
	runs-on: ubuntu-latest

	steps:
	- name: Checkout code
	uses: actions/checkout@v4

	- name: Setup Node.js
	uses: actions/setup-node@v4
	with:
	node-version: "23"

	- name: Setup pnpm
	uses: pnpm/action-setup@v4
	with:
	version: latest

	- name: Setup Deno
	uses: denoland/setup-deno@v1
	with:
	deno-version: v1.x

	- name: Get pnpm store directory
	shell: bash
	run: \|
	echo "STORE_PATH=$(pnpm store path --silent)" >> $GITHUB_ENV

	- name: Setup pnpm cache
	uses: actions/cache@v4
	with:
	path: ${{ env.STORE_PATH }}
	key: ${{ runner.os }}-pnpm-store-${{ hashFiles('**/pnpm-lock.yaml') }}
	restore-keys: \|
	${{ runner.os }}-pnpm-store-

	- name: Install dependencies
	run: pnpm install --frozen-lockfile

	- name: Format check
	run: pnpm format:check

	- name: Lint check
	run: pnpm lint

	- name: Type check
	run: pnpm type-check

	- name: Build web client
	run: pnpm build
	env:
	VITE_LIVESTORE_SYNC_URL: wss://anode-docworker.rgbkrk.workers.dev/api

	- name: Run tests
	run: pnpm test --run

	- name: Validate preview worker build
	run: pnpm wrangler deploy --dry-run --env preview

	- name: Validate production worker build
	run: pnpm wrangler deploy --dry-run --env production

Provide feedback