Database Engine Status
Live storage configuration and scaling status.
Current Active Engine: SQLite Local Engine
Firebase Cloud Firestore: Ready ((default) Database)
Gemini AI Engine: Template Fallback
Quick Operations
Rapid management actions for platform maintainers.
Appearance & Sand Palette Permutations
Switch between curated permutations of the 4 Sand palette colors (Spring Meadow, Teal Waters, Glacial Sky, Morning Mist). All selections strictly satisfy WCAG AAA contrast and synchronize instantly across the student portal and admin panel.
The 4 Sand Palette Colors
Curated Permutations & Unslop Recommendations
Morning Mist Editorial
Recommended • 9.8:1 AAATop Unslop Choice: Light parchment background with deep ink-teal typography looks like a luxury academic journal or bespoke architecture publication (Kinfolk / Monocle style) rather than a dark gamer/AI template.
Teal Waters Nocturne
Dark Mode • 9.8:1 AAAImmersive Dark Focus: Utilizes the rich depth of Teal Waters as the foundation with high-contrast Morning Mist cream typography and luminous lime accents.
Glacial Modernist
Daylight Lab • 8.9:1 AAANordic Laboratory Aesthetic: Cool Glacial Sky tinted canvas with crisp white cards and ink-sharp Teal Waters typography for intensive daytime reading.
Spring Botanical
Renaissance • 9.2:1 AAABotanical Academic Optimism: Fresh Morning Mist with soft Spring tint and vibrant lime accents, celebrating student research acceptances and fellowship offers.
Sand Palette Strict Constraint:
All color options are derived exclusively from the 4 Sand palette colors (#CAFFA6, #204654, #A9E0F1, #F7F9E1).
No extraneous or unapproved colors are injected. Changes persist in app_settings and localStorage.
Firebase Cloud Firestore Integration (350,000+ Scale)
Scale ScholarReach seamlessly from local SQLite to Google Cloud Firestore ((default) database). All verified faculty, registered students, and outreach logs are synchronized securely in the cloud.
scholarreach-36375 (from your Firebase Console URL: console.firebase.google.com/project/scholarreach-36375).
(default) database created in Firebase Console.
firebase-credentials.json in project folder or paste here.
"I Created the Database, Now What?" — Complete 3-Minute Setup Guide
- You Already Created the Firestore Database: You successfully initialized Cloud Firestore
(default)in your Firebase Console for projectscholarreach-36375. - Step 1 (Generate Private Key): In Firebase Console → Project Settings → Service Accounts, click the blue button "Generate new private key".
- Step 2 (Save Key File): Firebase will download a JSON file (e.g.
scholarreach-36375-firebase-adminsdk-xxxx.json). Rename or save this file asfirebase-credentials.jsondirectly in theUniprofproject folder (or paste its text into the box above) and click Save Firebase Credentials. - Step 3 (Populate Database): Click "Sync Faculty to Firebase Firestore". All 1,000 professors and fellowships will immediately stream into your Firestore collections!
- Scaling to 350,000+ Professors from OpenAlex: Click "Batch Ingest 200 from OpenAlex" or run
python scripts/import_openalex_to_firebase.py 5000in terminal to crawl and store thousands of faculty members in your database. - Google & Email Sign-In: Your Firebase project already has Google and Email authentication enabled. Students can sign in seamlessly via the native Google Account Chooser popup with zero third-party branding!
Firebase Spark Plan: 100% Free & Never Pauses (Recommended Cloud Shift)
Google Cloud NativeFirebase Spark Plan is 100% free and never pauses or sleeps. It runs 24/7 forever on Google Cloud with generous monthly quotas:
Zero dormancy, zero auto-pause. Stays reachable indefinitely.
Free 1-click Google OAuth for up to 50,000 monthly active users.
Stores 10,000+ student CV & Academic Transcript PDFs completely free.
Real-time traffic, searches, & crash monitoring included at $0 cost.
3-Step Migration to Firebase:
- Enable Auth: Open Firebase Console → Build → Authentication → Enable Google and Email/Password.
- Enable Firestore: Build → Firestore Database → Create database in Test mode or Production mode.
- Copy Project ID: Go to Project Settings (gear icon) → General → copy Project ID (e.g.
scholarreach-36375) into the input above and click Save & Apply Credentials. ScholarReach will use Firebase Auth and Firestore Cloud sync!
System API & Mail Services
Configure AI drafting keys and global SMTP dispatch servers.
Outreach Pacing & Anti-Spam Guards
Protect student mailbox domain reputations with strict quotas and random jitter delays.
Tier Quotas & Feature Access Governance
Dynamic Plan PolicyDynamically configure daily sending limits for Free and Premium tiers and govern which platform features require a paid upgrade vs remain accessible to free students.
Feature Gate Locks (Require Premium Upgrade)
Checked = Locked behind Premium (free users see upgrade modal). Unchecked = Open 100% Free for all registered students.
Registered User Accounts & Access Control
Platform accounts with zero-knowledge cryptographic authentication and 1-click Free/Premium tier toggles.
| Email Address | Full Name | Access Tier | Provider | Status | Registered Date | Tier & Account Actions |
|---|---|---|---|---|---|---|
| Loading users... | ||||||
Sign-In Audit Trail & Security Log
Immutable record of all login events with timestamps and IP addresses.
| Timestamp (UTC) | Email / User | Auth Provider | IP Address | Status | Failure Reason | User Agent |
|---|---|---|---|---|---|---|
| Loading audit events... | ||||||
Multi-Domain Faculty Directory Management
View, search, edit, or add professors to the database.
| Name | University | Department | Country / Tier | Domains | Actions | |
|---|---|---|---|---|---|---|
| Loading faculty records... | ||||||