Railway Deploy v5
The Auto-Migrator for Raw SQL — Bringing Alembic-like experience to apps using plain .sql files
Overview
This is the latest evolution in our Railway deployment standards. v5 introduces a fully automated migration system for Flask applications that use raw SQL scripts (no ORM).
Current Deployment Standards (v2–v5)
v2
Legacy: Manual SQL inside run.py with SQLAlchemy
v2v2
Flask-Migrate / Alembic — The ORM gold standard
v3
Node.js + TypeScript + Drizzle ORM (manual-migrate.js)
v4
Pure Python (pg8000) — Solves C-compilation issues
v5
Auto-Migrator for Raw SQL — Automatic tracking & execution of .sql migration files
Why v5?
v4 (pg8000) fixed compilation problems but required manually editing start.sh for each migration.
v5 brings the convenience of Alembic-style auto-tracking to raw SQL workflows.
Perfect for BMOS and any other Flask + raw SQL projects.
Key Features of v5
- Automatic detection and execution of new migration files
- Idempotent & version-tracked migrations
- Non-interactive — safe for Railway
- Clear logging and rollback safety
- Clean separation between migration logic and app startup
Download Full Guides
v5 Standard:
📥 Download railwaydeploy5.mdStandards Comparison (v2–v5):
📊 Download railwaydeploycomparison.mdSee Also
- Railway Deploy v2/v2v2 (Python/Flask)
- Railway Deploy v3 (Node.js + Drizzle)
- Railway Deploy v4 (Pure Python pg8000)
- Mailgun Setup for HeadlessDomains Reseller Partners — Configure MAILGUN_API_KEY, MAILGUN_DOMAIN, etc. so customers receive login codes
Comments
Approved comments appear below. Log in once with GFAVIP — it applies across the whole site. GFAVIP login
View comments archive