← All Projects

SCDB

Development Roadmap — Alpha

13

Total

0

Active

0

Bugs

0

Features

13

Done

100%

Progress

Development Progress

100%

Completed

13
Feature Critical Release

SCDB v1.0 Launch — Star Citizen Database

Launched starcitizen.freaklabs.dev — a full-featured Star Citizen Database with 300+ ships, weapon stats, side-by-side vehicle comparison, and an interactive loadout builder. Built on a PHP API proxy/cache layer connecting to the Star Citizen Wiki API v2, with a JARVIS HUD tactical interface theme matching the freaklabs.dev design language.

Completed
Feature High Backend

PHP API proxy layer for Star Citizen Wiki API

Built 7 PHP API proxy endpoints that fetch data from the Star Citizen Wiki API v2 with server-side caching, search filtering, and security headers. Endpoints cover ships, weapons, vehicle comparison, and loadout management.

Completed
Feature High API

Ship listing and detail API endpoints

Created ships.php (paginated listing with search by name/manufacturer/role) and ship.php (single vehicle detail by slug) proxy endpoints.

Completed
Feature High API

Weapon listing and detail API endpoints

Created weapons.php (paginated listing filtered by type: WeaponGun, WeaponMissile, WeaponTorpedo, WeaponEMP, MissileLauncher with search) and weapon.php (single item detail by UUID).

Completed
Feature High API

Vehicle comparison API endpoint

Built compare.php endpoint that accepts 2-4 comma-separated vehicle slugs and returns their full data side-by-side for comparison.

Completed
Feature High API

Loadout save/load API with rate limiting

Created loadout.php endpoint supporting GET (load by ID) and POST (save new). Includes rate limiting at 10 saves per IP per hour via the cache table, random 12-char hex IDs, and shareable URLs.

Completed
Feature Medium Backend

Cron-driven data sync endpoint

Built sync.php for full pre-cache sync of all vehicles and weapon items. Protected by X-Sync-Key header, outputs plain-text progress for cron logging, and paginates through all API pages.

Completed
Enhancement Medium Security

API security hardening via .htaccess

Added .htaccess rules for the api/ directory: disabled directory listing, restricted HTTP methods, disabled error display, and added security headers.

Completed
Feature High Frontend

Ship database with 300+ vehicles

Browse the full Star Citizen fleet — over 300 ships and ground vehicles with detailed specs including manufacturer, role, crew size, cargo capacity, speed, weapons, and components. Paginated listing with real-time search by name, manufacturer, or role.

Completed
Feature High Frontend

Weapon database with type filtering

Complete weapon catalog covering guns, missiles, torpedoes, EMP devices, and missile launchers. Filter by weapon type, search by name, and view full stats including damage, fire rate, range, and ammo.

Completed
Feature High Frontend

Side-by-side vehicle comparison tool

Compare 2 to 4 ships or vehicles side-by-side with full spec breakdowns. Highlights differences across dimensions, speed, weapons, shields, and components to help with purchase and loadout decisions.

Completed
Feature High Frontend

Interactive loadout builder

Build and share custom ship loadouts — swap weapons, shields, and components, then save with a shareable URL. Rate-limited save endpoint with unique hex IDs for bookmarking and sharing builds.

Completed
Feature Medium UI/UX

JARVIS HUD tactical interface theme

Full JARVIS-inspired heads-up display theme with Orbitron and Rajdhani fonts, cyan accent palette, glassmorphism panels, scan-line overlays, and animated UI elements — matching the freaklabs.dev design language across all pages.

Completed