askrobots / dbbasic-examples
Public
Example DBBasic apps (an API, a blog and a microblog) and a template for new DBBasic modules.
danq9
Add official module template for creating DBBasic packages
17cf88a
1 year, 1 month ago
History
2025-10-10_1614_studio-deploy-ideas.txt · 1.9 KB · 84 lines
| 1 | DBBASIC Studio & Deploy Ideas |
| 2 | ============================== |
| 3 | Date: 2025-10-10 |
| 4 | Time: 16:14 |
| 5 | |
| 6 | STUDIO (COMPLETED PROTOTYPE) |
| 7 | ----------------------------- |
| 8 | Commands: dbbasic studio / dbbasic admin |
| 9 | Port: 3001 |
| 10 | Package: dbbasic-studio (installed) |
| 11 | |
| 12 | Features built: |
| 13 | - Auto-discover TSV tables |
| 14 | - REST API for data access |
| 15 | - Beautiful admin UI from prototype |
| 16 | - Dashboard with stats |
| 17 | - Database browser |
| 18 | - Code editor, deployment tools |
| 19 | - AI assistant sidebar |
| 20 | |
| 21 | Status: Basic version working, needs polish |
| 22 | |
| 23 | DEPLOY (TODO) |
| 24 | ------------- |
| 25 | Approach: SSH-first (no API dependencies) |
| 26 | |
| 27 | Commands: |
| 28 | dbbasic deploy setup user@server.com # One-time server setup |
| 29 | dbbasic deploy user@server.com # Deploy code |
| 30 | dbbasic deploy rollback user@server.com # Rollback to previous |
| 31 | |
| 32 | What setup does: |
| 33 | - Install Python, pip, nginx |
| 34 | - Create systemd service |
| 35 | - Configure nginx reverse proxy |
| 36 | - Setup SSL with Let's Encrypt (optional) |
| 37 | - Create /var/www/appname structure |
| 38 | |
| 39 | What deploy does: |
| 40 | - rsync code to server |
| 41 | - rsync data/ (TSV files) |
| 42 | - pip install requirements.txt |
| 43 | - Restart systemd service |
| 44 | - Keep last 3 releases for rollback |
| 45 | |
| 46 | Why this wins: |
| 47 | - Works with ANY VPS ($5/month) |
| 48 | - No vendor lock-in |
| 49 | - Simple SSH + rsync |
| 50 | - No Docker complexity |
| 51 | - No database migrations (TSV!) |
| 52 | - Zero-downtime restarts |
| 53 | |
| 54 | Competitors we beat: |
| 55 | - Heroku/Railway/Render ($25+/month) |
| 56 | - Capistrano (complex Ruby config) |
| 57 | - Docker (overkill) |
| 58 | - Manual deployment (error-prone) |
| 59 | |
| 60 | VPS Recommendations: |
| 61 | - DigitalOcean ($6/month, 15 regions) |
| 62 | - Hetzner (€4.15/month, best value EU) |
| 63 | - Linode ($5/month, 11 regions) |
| 64 | - Vultr ($6/month, 32 regions) |
| 65 | |
| 66 | NEXT STEPS |
| 67 | ---------- |
| 68 | Build more demo apps first: |
| 69 | - microblog (Twitter-like) |
| 70 | - api (REST API) |
| 71 | - shop (E-commerce) |
| 72 | - intranet (Basecamp-like) |
| 73 | |
| 74 | This will reveal: |
| 75 | - What modules we actually need |
| 76 | - Common patterns to abstract |
| 77 | - Deploy requirements |
| 78 | - Studio features that matter |
| 79 | |
| 80 | Then come back to: |
| 81 | 1. Polish studio UI |
| 82 | 2. Build deploy command |
| 83 | 3. Add AI code generation |
| 84 | 4. Create video demos |