docs(dev): update setup guide for PostgreSQL-based local stack
- Updated `.env.example` to default to PostgreSQL, Redis, MinIO, and OpenSearch for local development.
- Enhanced local development guide with updated commands and dependency configurations.
- Detailed fallback to SQLite and lightweight configurations for simpler setups.
- Clarified Docker Compose usage for fully containerized local stacks.
feat(seed_dev_data): add optional dev admin creation flag for streamlined local setup
- Introduced `--with-dev-admin` option to the `seed_dev_data` command for creating a bootstrap admin user (`dev-admin`).
- Updated documentation to reflect changes and simplify local development setup.
- Enhanced glossary and language policy seeding with new terms and update handling.