perf: optimize SQLite with WAL mode and performance pragmas #41

	name: CI

	on:
	pull_request:
	branches: [master]
	push:
	branches: [master]

	env:
	CARGO_TERM_COLOR: always

	jobs:
	backend:
	name: Backend Checks
	runs-on: ubuntu-latest
	defaults:
	run:
	working-directory: backend

	steps:
	- uses: actions/checkout@v4

	- name: Install Rust toolchain
	uses: dtolnay/rust-toolchain@stable
	with:
	components: rustfmt, clippy

	- name: Cache cargo registry
	uses: actions/cache@v4
	with:
	path: \|
	~/.cargo/registry
	~/.cargo/git
	backend/target
	key: ${{ runner.os }}-cargo-${{ hashFiles('backend/Cargo.lock') }}
	restore-keys: \|
	${{ runner.os }}-cargo-

	- name: Check formatting
	run: cargo fmt --all -- --check

	- name: Clippy
	run: cargo clippy --all-targets --all-features -- -D warnings

	- name: Check
	run: cargo check --all-targets

	- name: Build
	run: cargo build --release

	frontend:
	name: Frontend Checks
	runs-on: ubuntu-latest
	defaults:
	run:
	working-directory: frontend

	steps:
	- uses: actions/checkout@v4

	- name: Setup Node.js
	uses: actions/setup-node@v4
	with:
	node-version: 22
	cache: npm
	cache-dependency-path: frontend/package-lock.json

	- name: Install dependencies
	run: npm ci

	- name: Lint
	run: npm run lint

	- name: Type check
	run: npx tsc --noEmit

	- name: Build
	run: npm run build

Provide feedback