Example DBBasic apps (an API, a blog and a microblog) and a template for new DBBasic modules.

0 downloads

dbbasic-examples/2025-10-10_1614_studio-deploy-ideas.txt
Download zip
Clone
Clone with git
git clone https://gitstable.com/git/askrobots/dbbasic-examples.git
HTTPS
https://gitstable.com/git/askrobots/dbbasic-examples.git
SSH
ssh://git@gitstable.com:2222/askrobots/dbbasic-examples.git

Cloning needs no sign-in. Pushing over HTTPS asks for your username and an access token. SSH needs your key under SSH keys.

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
1DBBASIC Studio & Deploy Ideas
2==============================
3Date: 2025-10-10
4Time: 16:14
5
6STUDIO (COMPLETED PROTOTYPE)
7-----------------------------
8Commands: dbbasic studio / dbbasic admin
9Port: 3001
10Package: dbbasic-studio (installed)
11
12Features 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
21Status: Basic version working, needs polish
22
23DEPLOY (TODO)
24-------------
25Approach: SSH-first (no API dependencies)
26
27Commands:
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
32What 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
39What 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
46Why 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
54Competitors we beat:
55- Heroku/Railway/Render ($25+/month)
56- Capistrano (complex Ruby config)
57- Docker (overkill)
58- Manual deployment (error-prone)
59
60VPS 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
66NEXT STEPS
67----------
68Build more demo apps first:
69- microblog (Twitter-like)
70- api (REST API)
71- shop (E-commerce)
72- intranet (Basecamp-like)
73
74This will reveal:
75- What modules we actually need
76- Common patterns to abstract
77- Deploy requirements
78- Studio features that matter
79
80Then come back to:
811. Polish studio UI
822. Build deploy command
833. Add AI code generation
844. Create video demos