Project Bank

The platform follows a modern, server-first architecture to minimize client-side JavaScript and maximize performance and security:

• Identity Layer: Utilizes Auth.js with the Drizzle Adapter. Currently configured with Google Workspace SSO and a strict Zero-Trust Domain Guard. Structurally designed to seamlessly hot-swap to Corporate OIDC (e.g., OneLogin / Microsoft Entra ID) via environment variables.

• Data Access: Next.js Server Actions handle all mutations (e.g., upvoting, commenting, creating projects) securely on the server with zero-trust authentication.

• Database Schema: Standardized pluralized tables (users, accounts, sessions, projects, upvotes, comments, project_requests) with strict referential integrity (cascading deletes).

• Concurrency & Integrity: Upvotes and Wishlist requests utilize idempotent ledger tables with composite primary keys to completely eliminate race conditions.

• Query Optimization: Feed retrieval leverages conditional LEFT JOIN architecture to prevent N+1 bottlenecks. Dashboard views utilize concurrent fetching (Promise.all) to render multiple data streams (Tech Radar, InnerSource, Incubator) at the speed of the single slowest query.

• State Management: Admin controls and moderation queues utilize high-performance, URL-driven state (searchParams) to offload filtering, debounced searching, and pagination directly to PostgreSQL, keeping Node.js memory footprints negligible.