An admin interface that builds itself from the dbbasic modules you install; its pages follow file paths, like CGI.

0 downloads

Download zip
Clone
Clone with git
git clone https://gitstable.com/git/askrobots/dbbasic-admin.git
HTTPS
https://gitstable.com/git/askrobots/dbbasic-admin.git
SSH
ssh://git@gitstable.com:2222/askrobots/dbbasic-admin.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 automatic TSV discovery and admin handlers 5e2fd8f 1 year, 1 month ago History
metrics.html · 25.2 KB · 617 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>System Metrics - DBBASIC Studio</title>
7 <link rel="stylesheet" href="../../static/css/admin.css">
8</head>
9<body>
10 <div class="studio-container">
11 <header class="studio-header">
12 <div class="logo">
13 <span class="logo-icon">⚡</span>
14 <span class="logo-text">DBBASIC Studio</span>
15 </div>
16 <div class="header-actions">
17 <span class="project-name">myblog/</span>
18 <button class="btn-icon" title="Deploy">🚀</button>
19 <button class="btn-icon" title="Settings">⚙️</button>
20 </div>
21 </header>
22
23 <div class="studio-layout">
24 <nav class="sidebar">
25 <a href="../../index.html" class="nav-item">
26 <span class="nav-icon">📊</span>
27 <span class="nav-label">Dashboard</span>
28 </a>
29 <a href="code.html" class="nav-item">
30 <span class="nav-icon">💻</span>
31 <span class="nav-label">Code</span>
32 </a>
33 <a href="database.html" class="nav-item">
34 <span class="nav-icon">🗄️</span>
35 <span class="nav-label">Database</span>
36 </a>
37 <a href="posts/list.html" class="nav-item">
38 <span class="nav-icon">📝</span>
39 <span class="nav-label">Posts</span>
40 </a>
41 <a href="users/list.html" class="nav-item">
42 <span class="nav-icon">👥</span>
43 <span class="nav-label">Users</span>
44 </a>
45 <div class="nav-divider"></div>
46 <a href="metrics.html" class="nav-item active">
47 <span class="nav-icon">📈</span>
48 <span class="nav-label">Metrics</span>
49 </a>
50 <a href="analytics.html" class="nav-item">
51 <span class="nav-icon">📊</span>
52 <span class="nav-label">Analytics</span>
53 </a>
54 <a href="jobs.html" class="nav-item">
55 <span class="nav-icon">⏰</span>
56 <span class="nav-label">Jobs</span>
57 </a>
58 <a href="logs.html" class="nav-item">
59 <span class="nav-icon">📋</span>
60 <span class="nav-label">Logs</span>
61 </a>
62 <a href="deploy.html" class="nav-item">
63 <span class="nav-icon">🚀</span>
64 <span class="nav-label">Deploy</span>
65 </a>
66 <a href="settings.html" class="nav-item">
67 <span class="nav-icon">⚙️</span>
68 <span class="nav-label">Settings</span>
69 </a>
70 </nav>
71
72 <main class="main-content">
73 <div class="content-header">
74 <div>
75 <h1>System Metrics</h1>
76 <div class="breadcrumb">Home / Metrics</div>
77 </div>
78 <div class="header-actions">
79 <select class="filter-select">
80 <option>Last Hour</option>
81 <option selected>Last 24 Hours</option>
82 <option>Last 7 Days</option>
83 <option>Last 30 Days</option>
84 </select>
85 <button class="btn-secondary">⟳ Refresh</button>
86 </div>
87 </div>
88
89 <!-- Live Status -->
90 <div class="card">
91 <h2>Live Status</h2>
92 <div class="live-metrics">
93 <div class="live-metric">
94 <div class="live-metric-icon">🔴</div>
95 <div class="live-metric-content">
96 <div class="live-metric-label">Status</div>
97 <div class="live-metric-value" style="color: var(--color-success)">Healthy</div>
98 </div>
99 </div>
100 <div class="live-metric">
101 <div class="live-metric-icon">⏱️</div>
102 <div class="live-metric-content">
103 <div class="live-metric-label">Uptime</div>
104 <div class="live-metric-value">14d 3h 24m</div>
105 </div>
106 </div>
107 <div class="live-metric">
108 <div class="live-metric-icon">📡</div>
109 <div class="live-metric-content">
110 <div class="live-metric-label">Active Connections</div>
111 <div class="live-metric-value">23</div>
112 </div>
113 </div>
114 <div class="live-metric">
115 <div class="live-metric-icon">⚡</div>
116 <div class="live-metric-content">
117 <div class="live-metric-label">Requests/sec</div>
118 <div class="live-metric-value">42</div>
119 </div>
120 </div>
121 </div>
122 </div>
123
124 <!-- CPU Usage -->
125 <div class="card">
126 <div class="metric-header">
127 <h2>CPU Usage</h2>
128 <div class="metric-current">Current: <strong>23.4%</strong></div>
129 </div>
130 <div class="chart-container">
131 <svg class="metrics-chart" viewBox="0 0 800 200">
132 <!-- Grid lines -->
133 <line x1="0" y1="50" x2="800" y2="50" stroke="#e2e8f0" stroke-width="1"/>
134 <line x1="0" y1="100" x2="800" y2="100" stroke="#e2e8f0" stroke-width="1"/>
135 <line x1="0" y1="150" x2="800" y2="150" stroke="#e2e8f0" stroke-width="1"/>
136
137 <!-- CPU usage line -->
138 <polyline
139 points="0,180 50,170 100,165 150,160 200,150 250,145 300,140 350,135 400,130 450,125 500,130 550,140 600,145 650,148 700,150 750,155 800,150"
140 fill="none"
141 stroke="#3b82f6"
142 stroke-width="2"
143 />
144
145 <!-- Area under curve -->
146 <polygon
147 points="0,180 50,170 100,165 150,160 200,150 250,145 300,140 350,135 400,130 450,125 500,130 550,140 600,145 650,148 700,150 750,155 800,150 800,200 0,200"
148 fill="rgba(59, 130, 246, 0.1)"
149 />
150
151 <!-- Data points -->
152 <circle cx="800" cy="150" r="4" fill="#3b82f6"/>
153 </svg>
154 <div class="chart-labels">
155 <span>24h ago</span>
156 <span>Now</span>
157 </div>
158 </div>
159 <div class="metric-stats">
160 <div class="stat">
161 <span class="stat-label">Average</span>
162 <span class="stat-value">18.2%</span>
163 </div>
164 <div class="stat">
165 <span class="stat-label">Peak</span>
166 <span class="stat-value">42.1%</span>
167 </div>
168 <div class="stat">
169 <span class="stat-label">Min</span>
170 <span class="stat-value">5.3%</span>
171 </div>
172 </div>
173 </div>
174
175 <!-- Memory Usage -->
176 <div class="card">
177 <div class="metric-header">
178 <h2>Memory Usage</h2>
179 <div class="metric-current">Current: <strong>1.2 GB / 4 GB (30%)</strong></div>
180 </div>
181 <div class="chart-container">
182 <svg class="metrics-chart" viewBox="0 0 800 200">
183 <line x1="0" y1="50" x2="800" y2="50" stroke="#e2e8f0" stroke-width="1"/>
184 <line x1="0" y1="100" x2="800" y2="100" stroke="#e2e8f0" stroke-width="1"/>
185 <line x1="0" y1="150" x2="800" y2="150" stroke="#e2e8f0" stroke-width="1"/>
186
187 <polyline
188 points="0,160 50,158 100,155 150,153 200,150 250,148 300,145 350,143 400,142 450,140 500,138 550,140 600,142 650,145 700,143 750,142 800,140"
189 fill="none"
190 stroke="#10b981"
191 stroke-width="2"
192 />
193
194 <polygon
195 points="0,160 50,158 100,155 150,153 200,150 250,148 300,145 350,143 400,142 450,140 500,138 550,140 600,142 650,145 700,143 750,142 800,140 800,200 0,200"
196 fill="rgba(16, 185, 129, 0.1)"
197 />
198
199 <circle cx="800" cy="140" r="4" fill="#10b981"/>
200 </svg>
201 <div class="chart-labels">
202 <span>24h ago</span>
203 <span>Now</span>
204 </div>
205 </div>
206 <div class="metric-stats">
207 <div class="stat">
208 <span class="stat-label">Average</span>
209 <span class="stat-value">1.1 GB</span>
210 </div>
211 <div class="stat">
212 <span class="stat-label">Peak</span>
213 <span class="stat-value">1.8 GB</span>
214 </div>
215 <div class="stat">
216 <span class="stat-label">Available</span>
217 <span class="stat-value">2.8 GB</span>
218 </div>
219 </div>
220 </div>
221
222 <!-- Disk I/O -->
223 <div class="card">
224 <div class="metric-header">
225 <h2>Disk I/O</h2>
226 <div class="metric-current">Read: <strong>12 MB/s</strong> • Write: <strong>8 MB/s</strong></div>
227 </div>
228 <div class="chart-container">
229 <svg class="metrics-chart" viewBox="0 0 800 200">
230 <line x1="0" y1="50" x2="800" y2="50" stroke="#e2e8f0" stroke-width="1"/>
231 <line x1="0" y1="100" x2="800" y2="100" stroke="#e2e8f0" stroke-width="1"/>
232 <line x1="0" y1="150" x2="800" y2="150" stroke="#e2e8f0" stroke-width="1"/>
233
234 <!-- Read -->
235 <polyline
236 points="0,170 100,165 200,160 300,155 400,150 500,155 600,160 700,158 800,160"
237 fill="none"
238 stroke="#f59e0b"
239 stroke-width="2"
240 />
241
242 <!-- Write -->
243 <polyline
244 points="0,180 100,178 200,175 300,172 400,170 500,172 600,175 700,173 800,175"
245 fill="none"
246 stroke="#8b5cf6"
247 stroke-width="2"
248 />
249 </svg>
250 <div class="chart-labels">
251 <span>24h ago</span>
252 <span>Now</span>
253 </div>
254 </div>
255 <div class="metric-legend">
256 <div class="legend-item">
257 <span class="legend-color" style="background: #f59e0b;"></span>
258 <span>Read</span>
259 </div>
260 <div class="legend-item">
261 <span class="legend-color" style="background: #8b5cf6;"></span>
262 <span>Write</span>
263 </div>
264 </div>
265 </div>
266
267 <!-- Network -->
268 <div class="card">
269 <div class="metric-header">
270 <h2>Network Traffic</h2>
271 <div class="metric-current">In: <strong>45 Mbps</strong> • Out: <strong>120 Mbps</strong></div>
272 </div>
273 <div class="chart-container">
274 <svg class="metrics-chart" viewBox="0 0 800 200">
275 <line x1="0" y1="50" x2="800" y2="50" stroke="#e2e8f0" stroke-width="1"/>
276 <line x1="0" y1="100" x2="800" y2="100" stroke="#e2e8f0" stroke-width="1"/>
277 <line x1="0" y1="150" x2="800" y2="150" stroke="#e2e8f0" stroke-width="1"/>
278
279 <!-- Incoming -->
280 <polyline
281 points="0,150 100,148 200,145 300,143 400,140 500,138 600,140 700,142 800,145"
282 fill="none"
283 stroke="#06b6d4"
284 stroke-width="2"
285 />
286
287 <!-- Outgoing -->
288 <polyline
289 points="0,120 100,118 200,115 300,112 400,110 500,112 600,115 700,118 800,120"
290 fill="none"
291 stroke="#ec4899"
292 stroke-width="2"
293 />
294 </svg>
295 <div class="chart-labels">
296 <span>24h ago</span>
297 <span>Now</span>
298 </div>
299 </div>
300 <div class="metric-legend">
301 <div class="legend-item">
302 <span class="legend-color" style="background: #06b6d4;"></span>
303 <span>Incoming</span>
304 </div>
305 <div class="legend-item">
306 <span class="legend-color" style="background: #ec4899;"></span>
307 <span>Outgoing</span>
308 </div>
309 </div>
310 </div>
311
312 <!-- Process Info -->
313 <div class="card">
314 <h2>Process Information</h2>
315 <div class="table-container">
316 <table class="data-table">
317 <thead>
318 <tr>
319 <th>Process</th>
320 <th>PID</th>
321 <th>CPU %</th>
322 <th>Memory</th>
323 <th>Uptime</th>
324 <th>Status</th>
325 </tr>
326 </thead>
327 <tbody>
328 <tr>
329 <td><code>myblog-worker-1</code></td>
330 <td>12345</td>
331 <td>8.2%</td>
332 <td>256 MB</td>
333 <td>14d 3h</td>
334 <td><span class="badge badge-green">Running</span></td>
335 </tr>
336 <tr>
337 <td><code>myblog-worker-2</code></td>
338 <td>12346</td>
339 <td>7.8%</td>
340 <td>242 MB</td>
341 <td>14d 3h</td>
342 <td><span class="badge badge-green">Running</span></td>
343 </tr>
344 <tr>
345 <td><code>myblog-worker-3</code></td>
346 <td>12347</td>
347 <td>6.9%</td>
348 <td>238 MB</td>
349 <td>14d 3h</td>
350 <td><span class="badge badge-green">Running</span></td>
351 </tr>
352 <tr>
353 <td><code>myblog-worker-4</code></td>
354 <td>12348</td>
355 <td>7.5%</td>
356 <td>245 MB</td>
357 <td>14d 3h</td>
358 <td><span class="badge badge-green">Running</span></td>
359 </tr>
360 </tbody>
361 </table>
362 </div>
363 </div>
364
365 <!-- System Info -->
366 <div class="card">
367 <h2>System Information</h2>
368 <div class="info-grid-large">
369 <div class="info-card">
370 <div class="info-card-label">Operating System</div>
371 <div class="info-card-value">Ubuntu 24.04 LTS</div>
372 </div>
373 <div class="info-card">
374 <div class="info-card-label">Kernel</div>
375 <div class="info-card-value">6.8.0-45-generic</div>
376 </div>
377 <div class="info-card">
378 <div class="info-card-label">CPU</div>
379 <div class="info-card-value">4 cores @ 2.4 GHz</div>
380 </div>
381 <div class="info-card">
382 <div class="info-card-label">Total Memory</div>
383 <div class="info-card-value">4 GB</div>
384 </div>
385 <div class="info-card">
386 <div class="info-card-label">Disk Space</div>
387 <div class="info-card-value">142 GB / 160 GB</div>
388 </div>
389 <div class="info-card">
390 <div class="info-card-label">Python Version</div>
391 <div class="info-card-value">3.12.1</div>
392 </div>
393 </div>
394 </div>
395
396 <!-- Data Source -->
397 <div class="card">
398 <h2>Metrics Data Source</h2>
399 <div class="data-source">
400 <div class="data-source-icon">📄</div>
401 <div class="data-source-info">
402 <div class="data-source-title">data/metrics/system.tsv</div>
403 <div class="data-source-description">
404 System metrics collected every 60 seconds using Unix tools:
405 <code>vmstat</code>, <code>iostat</code>, <code>netstat</code>
406 </div>
407 <div class="data-source-meta">
408 23,456 data points • Updated 30s ago
409 </div>
410 </div>
411 <button class="btn-secondary-small">View Raw Data</button>
412 </div>
413 </div>
414 </main>
415
416 <aside class="ai-assistant">
417 <div class="ai-header">
418 <span class="ai-icon">🤖</span>
419 <span class="ai-title">AI Assistant</span>
420 <button class="ai-toggle">−</button>
421 </div>
422
423 <div class="ai-content">
424 <div class="ai-messages">
425 <div class="ai-message ai-message-assistant">
426 <div class="message-content">
427 I can help analyze system performance, identify bottlenecks, or optimize resource usage. What would you like to know?
428 </div>
429 </div>
430 </div>
431
432 <div class="ai-suggestions">
433 <div class="suggestion-title">Try asking:</div>
434 <button class="suggestion-btn">"Why is CPU high?"</button>
435 <button class="suggestion-btn">"Optimize memory usage"</button>
436 <button class="suggestion-btn">"Set up alerts"</button>
437 </div>
438
439 <div class="ai-input">
440 <textarea placeholder="Ask AI about metrics..." rows="3"></textarea>
441 <button class="btn-primary">Send</button>
442 </div>
443 </div>
444 </aside>
445 </div>
446 </div>
447
448 <style>
449 .live-metrics {
450 display: grid;
451 grid-template-columns: repeat(4, 1fr);
452 gap: 1.5rem;
453 }
454
455 .live-metric {
456 display: flex;
457 align-items: center;
458 gap: 1rem;
459 padding: 1.5rem;
460 background: var(--color-bg);
461 border-radius: 0.5rem;
462 }
463
464 .live-metric-icon {
465 font-size: 2rem;
466 }
467
468 .live-metric-label {
469 font-size: 0.875rem;
470 color: var(--color-text-muted);
471 margin-bottom: 0.25rem;
472 }
473
474 .live-metric-value {
475 font-size: 1.5rem;
476 font-weight: 700;
477 }
478
479 .metric-header {
480 display: flex;
481 justify-content: space-between;
482 align-items: center;
483 margin-bottom: 1.5rem;
484 }
485
486 .metric-current {
487 font-size: 0.875rem;
488 color: var(--color-text-muted);
489 }
490
491 .chart-container {
492 margin-bottom: 1rem;
493 }
494
495 .metrics-chart {
496 width: 100%;
497 height: 200px;
498 }
499
500 .chart-labels {
501 display: flex;
502 justify-content: space-between;
503 font-size: 0.75rem;
504 color: var(--color-text-muted);
505 margin-top: 0.5rem;
506 }
507
508 .metric-stats {
509 display: grid;
510 grid-template-columns: repeat(3, 1fr);
511 gap: 1rem;
512 padding-top: 1rem;
513 border-top: 1px solid var(--color-border);
514 }
515
516 .stat {
517 display: flex;
518 flex-direction: column;
519 gap: 0.25rem;
520 }
521
522 .stat-label {
523 font-size: 0.75rem;
524 color: var(--color-text-muted);
525 }
526
527 .stat-value {
528 font-size: 1.125rem;
529 font-weight: 600;
530 }
531
532 .metric-legend {
533 display: flex;
534 gap: 1.5rem;
535 padding-top: 1rem;
536 border-top: 1px solid var(--color-border);
537 }
538
539 .legend-item {
540 display: flex;
541 align-items: center;
542 gap: 0.5rem;
543 font-size: 0.875rem;
544 }
545
546 .legend-color {
547 width: 1rem;
548 height: 1rem;
549 border-radius: 0.25rem;
550 }
551
552 .info-grid-large {
553 display: grid;
554 grid-template-columns: repeat(3, 1fr);
555 gap: 1rem;
556 }
557
558 .info-card {
559 padding: 1rem;
560 background: var(--color-bg);
561 border-radius: 0.5rem;
562 }
563
564 .info-card-label {
565 font-size: 0.75rem;
566 color: var(--color-text-muted);
567 margin-bottom: 0.5rem;
568 }
569
570 .info-card-value {
571 font-size: 1rem;
572 font-weight: 600;
573 }
574
575 .data-source {
576 display: flex;
577 gap: 1rem;
578 padding: 1.5rem;
579 background: var(--color-bg);
580 border-radius: 0.5rem;
581 }
582
583 .data-source-icon {
584 font-size: 2rem;
585 }
586
587 .data-source-info {
588 flex: 1;
589 }
590
591 .data-source-title {
592 font-weight: 600;
593 font-family: monospace;
594 margin-bottom: 0.5rem;
595 }
596
597 .data-source-description {
598 font-size: 0.875rem;
599 color: var(--color-text-muted);
600 margin-bottom: 0.5rem;
601 line-height: 1.6;
602 }
603
604 .data-source-description code {
605 background: var(--color-surface);
606 padding: 0.125rem 0.375rem;
607 border-radius: 0.25rem;
608 font-size: 0.75rem;
609 }
610
611 .data-source-meta {
612 font-size: 0.75rem;
613 color: var(--color-text-muted);
614 }
615 </style>
616</body>
617</html>