askrobots / dbbasic Public

Model-config web apps: describe the app in configuration instead of writing code. Built on Polars and DuckDB.

0 downloads

dbbasic/static/mockup_config.html
Download zip
Clone
Clone with git
git clone https://gitstable.com/git/askrobots/dbbasic.git
HTTPS
https://gitstable.com/git/askrobots/dbbasic.git
SSH
ssh://git@gitstable.com:2222/askrobots/dbbasic.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 DBBasic crate engine logo and update README 0d628db 1 year, 2 months ago History
mockup_config.html · 17.5 KB · 503 lines
1<!DOCTYPE html>
2<html lang="en">
3<head>
4 <meta charset="UTF-8">
5 <meta name="viewport" content="width=device-width, initial-scale=1.0">
6 <title>DBBasic Config Editor - Everything is Config</title>
7 <style>
8 * {
9 margin: 0;
10 padding: 0;
11 box-sizing: border-box;
12 }
13
14 body {
15 font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Roboto, 'Helvetica Neue', Arial, sans-serif;
16 background: #1e1e1e;
17 color: #d4d4d4;
18 height: 100vh;
19 display: flex;
20 flex-direction: column;
21 }
22
23 .header {
24 background: #2d2d30;
25 border-bottom: 1px solid #3e3e42;
26 padding: 0.75rem 1.5rem;
27 display: flex;
28 justify-content: space-between;
29 align-items: center;
30 }
31
32 .logo {
33 font-family: 'Times New Roman', Times, serif;
34 font-size: 20px;
35 font-weight: bold;
36 color: #fff;
37 }
38
39 .config-status {
40 display: flex;
41 align-items: center;
42 gap: 1rem;
43 }
44
45 .status-indicator {
46 width: 8px;
47 height: 8px;
48 border-radius: 50%;
49 background: #4CAF50;
50 animation: pulse 2s infinite;
51 }
52
53 @keyframes pulse {
54 0% { opacity: 1; }
55 50% { opacity: 0.5; }
56 100% { opacity: 1; }
57 }
58
59 .main-container {
60 display: flex;
61 flex: 1;
62 overflow: hidden;
63 }
64
65 .file-tree {
66 width: 250px;
67 background: #252526;
68 border-right: 1px solid #3e3e42;
69 padding: 1rem;
70 overflow-y: auto;
71 }
72
73 .tree-header {
74 text-transform: uppercase;
75 font-size: 11px;
76 color: #858585;
77 margin-bottom: 1rem;
78 font-weight: 600;
79 }
80
81 .tree-item {
82 padding: 0.5rem;
83 cursor: pointer;
84 border-radius: 4px;
85 margin-bottom: 0.25rem;
86 display: flex;
87 align-items: center;
88 gap: 0.5rem;
89 }
90
91 .tree-item:hover {
92 background: #2a2d2e;
93 }
94
95 .tree-item.active {
96 background: #094771;
97 }
98
99 .tree-icon {
100 width: 16px;
101 height: 16px;
102 opacity: 0.8;
103 }
104
105 .editor-container {
106 flex: 1;
107 display: flex;
108 flex-direction: column;
109 }
110
111 .editor-tabs {
112 background: #2d2d30;
113 border-bottom: 1px solid #3e3e42;
114 display: flex;
115 overflow-x: auto;
116 }
117
118 .tab {
119 padding: 0.75rem 1.5rem;
120 border-right: 1px solid #3e3e42;
121 cursor: pointer;
122 display: flex;
123 align-items: center;
124 gap: 0.5rem;
125 white-space: nowrap;
126 }
127
128 .tab:hover {
129 background: #2a2d2e;
130 }
131
132 .tab.active {
133 background: #1e1e1e;
134 border-bottom: 2px solid #4CAF50;
135 }
136
137 .editor {
138 flex: 1;
139 padding: 2rem;
140 overflow-y: auto;
141 font-family: 'Monaco', 'Menlo', 'Ubuntu Mono', monospace;
142 font-size: 14px;
143 line-height: 1.6;
144 }
145
146 .yaml-key {
147 color: #9cdcfe;
148 }
149
150 .yaml-value {
151 color: #ce9178;
152 }
153
154 .yaml-comment {
155 color: #6a9955;
156 font-style: italic;
157 }
158
159 .yaml-array {
160 color: #d7ba7d;
161 }
162
163 .line-number {
164 color: #858585;
165 margin-right: 2rem;
166 user-select: none;
167 display: inline-block;
168 width: 30px;
169 text-align: right;
170 }
171
172 .preview-panel {
173 width: 400px;
174 background: #252526;
175 border-left: 1px solid #3e3e42;
176 padding: 1.5rem;
177 overflow-y: auto;
178 }
179
180 .preview-header {
181 font-size: 12px;
182 text-transform: uppercase;
183 color: #858585;
184 margin-bottom: 1rem;
185 }
186
187 .preview-content {
188 background: #1e1e1e;
189 border-radius: 4px;
190 padding: 1rem;
191 margin-bottom: 1rem;
192 }
193
194 .metric {
195 display: flex;
196 justify-content: space-between;
197 padding: 0.5rem 0;
198 border-bottom: 1px solid #3e3e42;
199 }
200
201 .metric:last-child {
202 border-bottom: none;
203 }
204
205 .metric-label {
206 color: #858585;
207 }
208
209 .metric-value {
210 color: #4CAF50;
211 font-weight: bold;
212 }
213
214 .action-bar {
215 background: #2d2d30;
216 border-top: 1px solid #3e3e42;
217 padding: 1rem 1.5rem;
218 display: flex;
219 justify-content: space-between;
220 align-items: center;
221 }
222
223 .btn {
224 padding: 0.5rem 1rem;
225 border: none;
226 border-radius: 4px;
227 font-weight: 500;
228 cursor: pointer;
229 transition: all 0.2s;
230 }
231
232 .btn-primary {
233 background: #4CAF50;
234 color: white;
235 }
236
237 .btn-primary:hover {
238 background: #45a049;
239 }
240
241 .btn-secondary {
242 background: #3e3e42;
243 color: #d4d4d4;
244 }
245
246 .btn-secondary:hover {
247 background: #4e4e52;
248 }
249
250 .performance-info {
251 color: #858585;
252 font-size: 12px;
253 }
254 </style>
255</head>
256<body>
257 <div class="header">
258 <div style="display: flex; align-items: center; gap: 1rem;">
259 <div class="logo">DBBasic</div>
260 <span style="color: #858585; font-size: 14px;">Config Editor</span>
261 </div>
262 <div class="config-status">
263 <div class="status-indicator"></div>
264 <span style="font-size: 14px;">All configs valid</span>
265 </div>
266 <div>
267 <button class="btn btn-secondary">Validate</button>
268 <button class="btn btn-primary">Apply Changes</button>
269 </div>
270 </div>
271
272 <div class="main-container">
273 <div class="file-tree">
274 <div class="tree-header">Configuration Files</div>
275 <div class="tree-item active">
276 <span class="tree-icon">📄</span>
277 <span>main.dbbasic</span>
278 </div>
279 <div class="tree-item">
280 <span class="tree-icon">📄</span>
281 <span>tables.yaml</span>
282 </div>
283 <div class="tree-item">
284 <span class="tree-icon">📄</span>
285 <span>views.yaml</span>
286 </div>
287 <div class="tree-item">
288 <span class="tree-icon">📄</span>
289 <span>workflows.yaml</span>
290 </div>
291 <div class="tree-item">
292 <span class="tree-icon">📄</span>
293 <span>agents.yaml</span>
294 </div>
295 <div class="tree-item">
296 <span class="tree-icon">📄</span>
297 <span>integrations.yaml</span>
298 </div>
299 </div>
300
301 <div class="editor-container">
302 <div class="editor-tabs">
303 <div class="tab active">
304 <span>📄</span>
305 <span>main.dbbasic</span>
306 </div>
307 <div class="tab">
308 <span>📄</span>
309 <span>tables.yaml</span>
310 </div>
311 </div>
312 <div class="editor">
313 <div>
314 <span class="line-number">1</span><span class="yaml-comment"># DBBasic Configuration - Everything is just config</span>
315 </div>
316 <div>
317 <span class="line-number">2</span><span class="yaml-comment"># This replaces 50,000 lines of traditional code</span>
318 </div>
319 <div>
320 <span class="line-number">3</span>
321 </div>
322 <div>
323 <span class="line-number">4</span><span class="yaml-key">name:</span> <span class="yaml-value">"E-Commerce Platform"</span>
324 </div>
325 <div>
326 <span class="line-number">5</span><span class="yaml-key">version:</span> <span class="yaml-value">"2.0"</span>
327 </div>
328 <div>
329 <span class="line-number">6</span><span class="yaml-key">performance:</span> <span class="yaml-value">"402M rows/sec"</span>
330 </div>
331 <div>
332 <span class="line-number">7</span>
333 </div>
334 <div>
335 <span class="line-number">8</span><span class="yaml-comment"># Tables - Your data structure</span>
336 </div>
337 <div>
338 <span class="line-number">9</span><span class="yaml-key">tables:</span>
339 </div>
340 <div>
341 <span class="line-number">10</span> <span class="yaml-key">customers:</span>
342 </div>
343 <div>
344 <span class="line-number">11</span> <span class="yaml-key">schema:</span> <span class="yaml-array">[id, email, name, created, lifetime_value]</span>
345 </div>
346 <div>
347 <span class="line-number">12</span> <span class="yaml-key">indexes:</span> <span class="yaml-array">[email, created]</span>
348 </div>
349 <div>
350 <span class="line-number">13</span> <span class="yaml-key">validation:</span>
351 </div>
352 <div>
353 <span class="line-number">14</span> <span class="yaml-key">email:</span> <span class="yaml-value">"valid_email"</span>
354 </div>
355 <div>
356 <span class="line-number">15</span> <span class="yaml-key">lifetime_value:</span> <span class="yaml-value">"positive_number"</span>
357 </div>
358 <div>
359 <span class="line-number">16</span>
360 </div>
361 <div>
362 <span class="line-number">17</span> <span class="yaml-key">orders:</span>
363 </div>
364 <div>
365 <span class="line-number">18</span> <span class="yaml-key">schema:</span> <span class="yaml-array">[id, customer_id, total, status, created]</span>
366 </div>
367 <div>
368 <span class="line-number">19</span> <span class="yaml-key">workflow:</span> <span class="yaml-array">[draft, confirmed, processing, shipped, delivered]</span>
369 </div>
370 <div>
371 <span class="line-number">20</span> <span class="yaml-key">relations:</span>
372 </div>
373 <div>
374 <span class="line-number">21</span> <span class="yaml-key">customer_id:</span> <span class="yaml-value">"customers.id"</span>
375 </div>
376 <div>
377 <span class="line-number">22</span>
378 </div>
379 <div>
380 <span class="line-number">23</span> <span class="yaml-key">products:</span>
381 </div>
382 <div>
383 <span class="line-number">24</span> <span class="yaml-key">schema:</span> <span class="yaml-array">[id, sku, name, price, stock, category]</span>
384 </div>
385 <div>
386 <span class="line-number">25</span> <span class="yaml-key">computed:</span>
387 </div>
388 <div>
389 <span class="line-number">26</span> <span class="yaml-key">in_stock:</span> <span class="yaml-value">"stock > 0"</span>
390 </div>
391 <div>
392 <span class="line-number">27</span> <span class="yaml-key">low_stock:</span> <span class="yaml-value">"stock < 10"</span>
393 </div>
394 <div>
395 <span class="line-number">28</span>
396 </div>
397 <div>
398 <span class="line-number">29</span><span class="yaml-comment"># Views - How you query data</span>
399 </div>
400 <div>
401 <span class="line-number">30</span><span class="yaml-key">views:</span>
402 </div>
403 <div>
404 <span class="line-number">31</span> <span class="yaml-key">dashboard:</span>
405 </div>
406 <div>
407 <span class="line-number">32</span> <span class="yaml-key">revenue_today:</span> <span class="yaml-value">"SUM(orders.total) WHERE DATE(created) = TODAY"</span>
408 </div>
409 <div>
410 <span class="line-number">33</span> <span class="yaml-key">orders_pending:</span> <span class="yaml-value">"COUNT(*) FROM orders WHERE status = 'processing'"</span>
411 </div>
412 <div>
413 <span class="line-number">34</span> <span class="yaml-key">low_stock_alert:</span> <span class="yaml-value">"SELECT * FROM products WHERE stock < 10"</span>
414 </div>
415 <div>
416 <span class="line-number">35</span>
417 </div>
418 <div>
419 <span class="line-number">36</span><span class="yaml-comment"># Agents - Autonomous operations</span>
420 </div>
421 <div>
422 <span class="line-number">37</span><span class="yaml-key">agents:</span>
423 </div>
424 <div>
425 <span class="line-number">38</span> <span class="yaml-key">inventory_manager:</span>
426 </div>
427 <div>
428 <span class="line-number">39</span> <span class="yaml-key">schedule:</span> <span class="yaml-value">"every 1 hour"</span>
429 </div>
430 <div>
431 <span class="line-number">40</span> <span class="yaml-key">task:</span> <span class="yaml-value">"Check low stock and create purchase orders"</span>
432 </div>
433 <div>
434 <span class="line-number">41</span> <span class="yaml-key">ai_model:</span> <span class="yaml-value">"gpt-4"</span>
435 </div>
436 </div>
437 </div>
438
439 <div class="preview-panel">
440 <div class="preview-header">Live Preview</div>
441
442 <div class="preview-content">
443 <h3 style="margin-bottom: 1rem;">Configuration Impact</h3>
444 <div class="metric">
445 <span class="metric-label">Lines of Config</span>
446 <span class="metric-value">41</span>
447 </div>
448 <div class="metric">
449 <span class="metric-label">Replaces Code</span>
450 <span class="metric-value">~50,000 lines</span>
451 </div>
452 <div class="metric">
453 <span class="metric-label">Tables Defined</span>
454 <span class="metric-value">3</span>
455 </div>
456 <div class="metric">
457 <span class="metric-label">Views Created</span>
458 <span class="metric-value">3</span>
459 </div>
460 <div class="metric">
461 <span class="metric-label">Agents Active</span>
462 <span class="metric-value">1</span>
463 </div>
464 </div>
465
466 <div class="preview-content">
467 <h3 style="margin-bottom: 1rem;">Performance</h3>
468 <div class="metric">
469 <span class="metric-label">Processing Speed</span>
470 <span class="metric-value">402M rows/sec</span>
471 </div>
472 <div class="metric">
473 <span class="metric-label">Query Latency</span>
474 <span class="metric-value">0.002ms</span>
475 </div>
476 <div class="metric">
477 <span class="metric-label">Memory Usage</span>
478 <span class="metric-value">124 MB</span>
479 </div>
480 </div>
481
482 <div class="preview-content">
483 <h3 style="margin-bottom: 1rem;">Validation</h3>
484 <div style="color: #4CAF50; margin-bottom: 0.5rem;">✓ All schemas valid</div>
485 <div style="color: #4CAF50; margin-bottom: 0.5rem;">✓ No circular dependencies</div>
486 <div style="color: #4CAF50; margin-bottom: 0.5rem;">✓ Queries optimized</div>
487 <div style="color: #4CAF50;">✓ Ready to deploy</div>
488 </div>
489 </div>
490 </div>
491
492 <div class="action-bar">
493 <div class="performance-info">
494 Auto-save enabled | Last saved: 2 seconds ago | Config is 99.8% smaller than equivalent code
495 </div>
496 <div>
497 <button class="btn btn-secondary">Preview</button>
498 <button class="btn btn-secondary">Test</button>
499 <button class="btn btn-primary">Deploy Instantly</button>
500 </div>
501 </div>
502</body>
503</html>