[Good First Issue] Add SQLite mode for local development without Docker

[pixelstrade-dev]

Description

Currently CAIMS requires PostgreSQL via Docker. Adding SQLite support would make local development much easier for contributors.

What to do

1. Add a SQLite provider option in prisma/schema.prisma
2. 2. Create a migration script for SQLite
3. 3. Add CAIMS_DB_PROVIDER env variable to switch between PostgreSQL and SQLite
4. 4. Update lib/db/client.ts to handle both providers
5. 5. Document the SQLite setup in README

Skills needed

• Prisma ORM
• • SQLite basics
• • • TypeScript

References

• Current schema: apps/web/prisma/schema.prisma
• • Prisma SQLite docs: https://www.prisma.io/docs/concepts/database-connectors/sqlite