小鹹書 Actress Wiki — XHS-Style Discovery Platform
| Group | Tables | Purpose |
|---|---|---|
| Content | sources, products, versions, downloads, threads | Scraped forum content |
| Actress | actresses, actress_aliases, actress_images | Wiki profiles & images |
| Auth | users, user_oauth, user_sessions | Authentication |
| Credits | user_credits, votes, user_voted_pairs | Vote mode & economy |
| Behaviors | user_behaviors, user_downloads, likes | Activity tracking |
| WHMCS | whmcs_users, whmcs_sync_log | VPN shop sync |
| Layer | Technology | Status |
|---|---|---|
| Scraping | Python 3.12, Playwright, BeautifulSoup4, curl_cffi | ✓ Active |
| Database | SQLite xxs.db (48 tables) | ✓ 10,948 threads |
| Backend API | FastAPI (Python) | ◯ In Progress |
| Frontend | Vanilla JS SPA + Glassmorphism CSS | ✓ Done |
| Image Pipeline | 9,414 cached (82%) | ✓ Done |
| Auth | SQLite sessions + OAuth (Google, GitHub) | ◯ In Progress |
| SSL | ZeroSSL 90-day (acme.sh auto-renewal) | ✓ Active |
| CDN | Cloudflare (DNS) | ✓ Active |