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
analytics.html · 30.4 KB · 773 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>Analytics - 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">
47 <span class="nav-icon">📈</span>
48 <span class="nav-label">Metrics</span>
49 </a>
50 <a href="analytics.html" class="nav-item active">
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>Web Analytics</h1>
76 <div class="breadcrumb">Home / Analytics</div>
77 </div>
78 <div class="header-actions">
79 <select class="filter-select">
80 <option>Today</option>
81 <option>Yesterday</option>
82 <option selected>Last 7 Days</option>
83 <option>Last 30 Days</option>
84 <option>This Month</option>
85 </select>
86 <button class="btn-secondary">⬇️ Export</button>
87 </div>
88 </div>
89
90 <!-- Key Metrics -->
91 <div class="analytics-grid">
92 <div class="card analytics-card">
93 <div class="analytics-icon">👁️</div>
94 <div class="analytics-content">
95 <div class="analytics-label">Page Views</div>
96 <div class="analytics-value">124,567</div>
97 <div class="analytics-change positive">+12.3% vs last week</div>
98 </div>
99 </div>
100
101 <div class="card analytics-card">
102 <div class="analytics-icon">👤</div>
103 <div class="analytics-content">
104 <div class="analytics-label">Unique Visitors</div>
105 <div class="analytics-value">8,923</div>
106 <div class="analytics-change positive">+8.7% vs last week</div>
107 </div>
108 </div>
109
110 <div class="card analytics-card">
111 <div class="analytics-icon">⏱️</div>
112 <div class="analytics-content">
113 <div class="analytics-label">Avg. Session</div>
114 <div class="analytics-value">3m 42s</div>
115 <div class="analytics-change negative">-2.1% vs last week</div>
116 </div>
117 </div>
118
119 <div class="card analytics-card">
120 <div class="analytics-icon">📈</div>
121 <div class="analytics-content">
122 <div class="analytics-label">Bounce Rate</div>
123 <div class="analytics-value">42.3%</div>
124 <div class="analytics-change positive">-3.2% vs last week</div>
125 </div>
126 </div>
127 </div>
128
129 <!-- Traffic Over Time -->
130 <div class="card">
131 <h2>Traffic Over Time</h2>
132 <div class="chart-container">
133 <svg class="analytics-chart" viewBox="0 0 800 250">
134 <!-- Grid -->
135 <line x1="0" y1="50" x2="800" y2="50" stroke="#e2e8f0" stroke-width="1"/>
136 <line x1="0" y1="100" x2="800" y2="100" stroke="#e2e8f0" stroke-width="1"/>
137 <line x1="0" y1="150" x2="800" y2="150" stroke="#e2e8f0" stroke-width="1"/>
138 <line x1="0" y1="200" x2="800" y2="200" stroke="#e2e8f0" stroke-width="1"/>
139
140 <!-- Visitors line -->
141 <polyline
142 points="0,200 100,180 200,160 300,140 400,120 500,130 600,110 700,90 800,80"
143 fill="none"
144 stroke="#3b82f6"
145 stroke-width="3"
146 />
147
148 <!-- Page views line -->
149 <polyline
150 points="0,180 100,160 200,140 300,120 400,100 500,110 600,90 700,70 800,60"
151 fill="none"
152 stroke="#10b981"
153 stroke-width="3"
154 />
155
156 <!-- Area fills -->
157 <polygon
158 points="0,200 100,180 200,160 300,140 400,120 500,130 600,110 700,90 800,80 800,250 0,250"
159 fill="rgba(59, 130, 246, 0.1)"
160 />
161 </svg>
162 <div class="chart-labels">
163 <span>7 days ago</span>
164 <span>Today</span>
165 </div>
166 </div>
167 <div class="metric-legend">
168 <div class="legend-item">
169 <span class="legend-color" style="background: #3b82f6;"></span>
170 <span>Unique Visitors</span>
171 </div>
172 <div class="legend-item">
173 <span class="legend-color" style="background: #10b981;"></span>
174 <span>Page Views</span>
175 </div>
176 </div>
177 </div>
178
179 <!-- Live Now -->
180 <div class="card live-card">
181 <div class="live-header">
182 <h2>🔴 Live Right Now</h2>
183 <div class="live-count">23 active users</div>
184 </div>
185
186 <div class="live-activity">
187 <div class="live-user">
188 <div class="live-user-avatar">US</div>
189 <div class="live-user-info">
190 <div class="live-user-location">🇺🇸 New York, US</div>
191 <div class="live-user-page">/blog/getting-started-with-dbbasic</div>
192 </div>
193 <div class="live-user-time">2s ago</div>
194 </div>
195
196 <div class="live-user">
197 <div class="live-user-avatar">UK</div>
198 <div class="live-user-info">
199 <div class="live-user-location">🇬🇧 London, UK</div>
200 <div class="live-user-page">/blog/unix-philosophy-web-apps</div>
201 </div>
202 <div class="live-user-time">5s ago</div>
203 </div>
204
205 <div class="live-user">
206 <div class="live-user-avatar">DE</div>
207 <div class="live-user-info">
208 <div class="live-user-location">🇩🇪 Berlin, Germany</div>
209 <div class="live-user-page">/</div>
210 </div>
211 <div class="live-user-time">12s ago</div>
212 </div>
213
214 <div class="live-user">
215 <div class="live-user-avatar">JP</div>
216 <div class="live-user-info">
217 <div class="live-user-location">🇯🇵 Tokyo, Japan</div>
218 <div class="live-user-page">/blog/tsv-files-database</div>
219 </div>
220 <div class="live-user-time">18s ago</div>
221 </div>
222
223 <div class="live-user">
224 <div class="live-user-avatar">CA</div>
225 <div class="live-user-info">
226 <div class="live-user-location">🇨🇦 Toronto, Canada</div>
227 <div class="live-user-page">/about</div>
228 </div>
229 <div class="live-user-time">25s ago</div>
230 </div>
231 </div>
232 </div>
233
234 <!-- Top Pages -->
235 <div class="card">
236 <h2>Top Pages</h2>
237 <div class="table-container">
238 <table class="data-table">
239 <thead>
240 <tr>
241 <th>Page</th>
242 <th>Views</th>
243 <th>Unique</th>
244 <th>Avg. Time</th>
245 <th>Bounce Rate</th>
246 </tr>
247 </thead>
248 <tbody>
249 <tr>
250 <td>
251 <div class="page-cell">
252 <div class="page-title">/blog/getting-started-with-dbbasic</div>
253 <div class="page-path">Getting Started with DBBASIC</div>
254 </div>
255 </td>
256 <td><strong>12,456</strong></td>
257 <td>8,234</td>
258 <td>4m 23s</td>
259 <td>38.2%</td>
260 </tr>
261 <tr>
262 <td>
263 <div class="page-cell">
264 <div class="page-title">/</div>
265 <div class="page-path">Home</div>
266 </div>
267 </td>
268 <td><strong>8,923</strong></td>
269 <td>7,456</td>
270 <td>2m 12s</td>
271 <td>52.1%</td>
272 </tr>
273 <tr>
274 <td>
275 <div class="page-cell">
276 <div class="page-title">/blog/tsv-files-database</div>
277 <div class="page-path">TSV Files as a Database</div>
278 </div>
279 </td>
280 <td><strong>6,234</strong></td>
281 <td>4,123</td>
282 <td>5m 34s</td>
283 <td>34.5%</td>
284 </tr>
285 <tr>
286 <td>
287 <div class="page-cell">
288 <div class="page-title">/blog/unix-philosophy-web-apps</div>
289 <div class="page-path">Unix Philosophy for Web Apps</div>
290 </div>
291 </td>
292 <td><strong>4,567</strong></td>
293 <td>3,234</td>
294 <td>6m 12s</td>
295 <td>28.3%</td>
296 </tr>
297 <tr>
298 <td>
299 <div class="page-cell">
300 <div class="page-title">/about</div>
301 <div class="page-path">About</div>
302 </div>
303 </td>
304 <td><strong>2,345</strong></td>
305 <td>1,892</td>
306 <td>1m 45s</td>
307 <td>45.6%</td>
308 </tr>
309 </tbody>
310 </table>
311 </div>
312 </div>
313
314 <!-- Traffic Sources -->
315 <div class="analytics-row">
316 <div class="card">
317 <h2>Traffic Sources</h2>
318 <div class="sources-chart">
319 <div class="source-item">
320 <div class="source-info">
321 <span class="source-label">Direct</span>
322 <span class="source-value">42.3%</span>
323 </div>
324 <div class="source-bar">
325 <div class="source-fill" style="width: 42.3%; background: #3b82f6;"></div>
326 </div>
327 <div class="source-count">5,245 visits</div>
328 </div>
329
330 <div class="source-item">
331 <div class="source-info">
332 <span class="source-label">Organic Search</span>
333 <span class="source-value">28.7%</span>
334 </div>
335 <div class="source-bar">
336 <div class="source-fill" style="width: 28.7%; background: #10b981;"></div>
337 </div>
338 <div class="source-count">3,564 visits</div>
339 </div>
340
341 <div class="source-item">
342 <div class="source-info">
343 <span class="source-label">Social Media</span>
344 <span class="source-value">18.2%</span>
345 </div>
346 <div class="source-bar">
347 <div class="source-fill" style="width: 18.2%; background: #f59e0b;"></div>
348 </div>
349 <div class="source-count">2,256 visits</div>
350 </div>
351
352 <div class="source-item">
353 <div class="source-info">
354 <span class="source-label">Referral</span>
355 <span class="source-value">10.8%</span>
356 </div>
357 <div class="source-bar">
358 <div class="source-fill" style="width: 10.8%; background: #8b5cf6;"></div>
359 </div>
360 <div class="source-count">1,338 visits</div>
361 </div>
362 </div>
363 </div>
364
365 <div class="card">
366 <h2>Top Referrers</h2>
367 <div class="referrers-list">
368 <div class="referrer-item">
369 <div class="referrer-name">news.ycombinator.com</div>
370 <div class="referrer-count">1,234 visits</div>
371 </div>
372 <div class="referrer-item">
373 <div class="referrer-name">reddit.com/r/programming</div>
374 <div class="referrer-count">892 visits</div>
375 </div>
376 <div class="referrer-item">
377 <div class="referrer-name">twitter.com</div>
378 <div class="referrer-count">567 visits</div>
379 </div>
380 <div class="referrer-item">
381 <div class="referrer-name">dev.to</div>
382 <div class="referrer-count">423 visits</div>
383 </div>
384 <div class="referrer-item">
385 <div class="referrer-name">github.com</div>
386 <div class="referrer-count">312 visits</div>
387 </div>
388 </div>
389 </div>
390 </div>
391
392 <!-- Devices & Browsers -->
393 <div class="analytics-row">
394 <div class="card">
395 <h2>Devices</h2>
396 <div class="device-stats">
397 <div class="device-item">
398 <div class="device-icon">💻</div>
399 <div class="device-info">
400 <div class="device-label">Desktop</div>
401 <div class="device-percent">62.4%</div>
402 </div>
403 </div>
404 <div class="device-item">
405 <div class="device-icon">📱</div>
406 <div class="device-info">
407 <div class="device-label">Mobile</div>
408 <div class="device-percent">32.1%</div>
409 </div>
410 </div>
411 <div class="device-item">
412 <div class="device-icon">📲</div>
413 <div class="device-info">
414 <div class="device-label">Tablet</div>
415 <div class="device-percent">5.5%</div>
416 </div>
417 </div>
418 </div>
419 </div>
420
421 <div class="card">
422 <h2>Top Browsers</h2>
423 <div class="browser-list">
424 <div class="browser-item">
425 <span class="browser-name">Chrome</span>
426 <span class="browser-percent">54.2%</span>
427 </div>
428 <div class="browser-item">
429 <span class="browser-name">Safari</span>
430 <span class="browser-percent">23.8%</span>
431 </div>
432 <div class="browser-item">
433 <span class="browser-name">Firefox</span>
434 <span class="browser-percent">12.4%</span>
435 </div>
436 <div class="browser-item">
437 <span class="browser-name">Edge</span>
438 <span class="browser-percent">7.3%</span>
439 </div>
440 <div class="browser-item">
441 <span class="browser-name">Other</span>
442 <span class="browser-percent">2.3%</span>
443 </div>
444 </div>
445 </div>
446 </div>
447
448 <!-- Data Source -->
449 <div class="card">
450 <h2>Analytics Data</h2>
451 <div class="data-source">
452 <div class="data-source-icon">📄</div>
453 <div class="data-source-info">
454 <div class="data-source-title">data/analytics/pageviews.tsv</div>
455 <div class="data-source-description">
456 Privacy-first analytics. No cookies, no tracking across sites. Data collected from server logs:
457 <code>tail -f /var/log/nginx/access.log | awk ...</code>
458 </div>
459 <div class="data-source-meta">
460 124,567 pageviews • Updated in real-time
461 </div>
462 </div>
463 <button class="btn-secondary-small">View Raw Data</button>
464 </div>
465 </div>
466 </main>
467
468 <aside class="ai-assistant">
469 <div class="ai-header">
470 <span class="ai-icon">🤖</span>
471 <span class="ai-title">AI Assistant</span>
472 <button class="ai-toggle">−</button>
473 </div>
474
475 <div class="ai-content">
476 <div class="ai-messages">
477 <div class="ai-message ai-message-assistant">
478 <div class="message-content">
479 I can analyze traffic patterns, suggest content improvements, or help optimize SEO. What would you like to know?
480 </div>
481 </div>
482 </div>
483
484 <div class="ai-suggestions">
485 <div class="suggestion-title">Try asking:</div>
486 <button class="suggestion-btn">"Why is bounce rate high?"</button>
487 <button class="suggestion-btn">"Suggest popular topics"</button>
488 <button class="suggestion-btn">"Improve SEO"</button>
489 </div>
490
491 <div class="ai-input">
492 <textarea placeholder="Ask AI about analytics..." rows="3"></textarea>
493 <button class="btn-primary">Send</button>
494 </div>
495 </div>
496 </aside>
497 </div>
498 </div>
499
500 <style>
501 .analytics-grid {
502 display: grid;
503 grid-template-columns: repeat(4, 1fr);
504 gap: 1.5rem;
505 margin-bottom: 2rem;
506 }
507
508 .analytics-card {
509 display: flex;
510 align-items: center;
511 gap: 1rem;
512 padding: 1.5rem;
513 }
514
515 .analytics-icon {
516 font-size: 2.5rem;
517 }
518
519 .analytics-label {
520 font-size: 0.875rem;
521 color: var(--color-text-muted);
522 margin-bottom: 0.5rem;
523 }
524
525 .analytics-value {
526 font-size: 2rem;
527 font-weight: 700;
528 margin-bottom: 0.25rem;
529 }
530
531 .analytics-change {
532 font-size: 0.875rem;
533 font-weight: 500;
534 }
535
536 .analytics-change.positive {
537 color: var(--color-success);
538 }
539
540 .analytics-change.negative {
541 color: var(--color-danger);
542 }
543
544 .analytics-chart {
545 width: 100%;
546 height: 250px;
547 }
548
549 .live-card {
550 border: 2px solid var(--color-primary);
551 }
552
553 .live-header {
554 display: flex;
555 justify-content: space-between;
556 align-items: center;
557 margin-bottom: 1.5rem;
558 }
559
560 .live-count {
561 font-size: 1.125rem;
562 font-weight: 600;
563 color: var(--color-primary);
564 }
565
566 .live-activity {
567 display: flex;
568 flex-direction: column;
569 gap: 1rem;
570 }
571
572 .live-user {
573 display: flex;
574 align-items: center;
575 gap: 1rem;
576 padding: 1rem;
577 background: var(--color-bg);
578 border-radius: 0.5rem;
579 animation: fadeIn 0.5s;
580 }
581
582 @keyframes fadeIn {
583 from { opacity: 0; transform: translateY(-10px); }
584 to { opacity: 1; transform: translateY(0); }
585 }
586
587 .live-user-avatar {
588 width: 2.5rem;
589 height: 2.5rem;
590 border-radius: 50%;
591 background: var(--color-primary);
592 color: white;
593 display: flex;
594 align-items: center;
595 justify-content: center;
596 font-weight: 600;
597 font-size: 0.875rem;
598 }
599
600 .live-user-info {
601 flex: 1;
602 }
603
604 .live-user-location {
605 font-weight: 500;
606 margin-bottom: 0.25rem;
607 }
608
609 .live-user-page {
610 font-size: 0.875rem;
611 color: var(--color-text-muted);
612 font-family: monospace;
613 }
614
615 .live-user-time {
616 font-size: 0.875rem;
617 color: var(--color-text-muted);
618 }
619
620 .page-cell {
621 display: flex;
622 flex-direction: column;
623 gap: 0.25rem;
624 }
625
626 .page-title {
627 font-family: monospace;
628 font-size: 0.875rem;
629 color: var(--color-primary);
630 }
631
632 .page-path {
633 font-size: 0.75rem;
634 color: var(--color-text-muted);
635 }
636
637 .analytics-row {
638 display: grid;
639 grid-template-columns: repeat(2, 1fr);
640 gap: 1.5rem;
641 margin-bottom: 1.5rem;
642 }
643
644 .sources-chart {
645 display: flex;
646 flex-direction: column;
647 gap: 1.5rem;
648 }
649
650 .source-item {
651 display: flex;
652 flex-direction: column;
653 gap: 0.5rem;
654 }
655
656 .source-info {
657 display: flex;
658 justify-content: space-between;
659 align-items: center;
660 }
661
662 .source-label {
663 font-weight: 500;
664 }
665
666 .source-value {
667 font-weight: 700;
668 color: var(--color-primary);
669 }
670
671 .source-bar {
672 height: 0.5rem;
673 background: var(--color-bg);
674 border-radius: 0.25rem;
675 overflow: hidden;
676 }
677
678 .source-fill {
679 height: 100%;
680 transition: width 0.3s ease;
681 }
682
683 .source-count {
684 font-size: 0.875rem;
685 color: var(--color-text-muted);
686 }
687
688 .referrers-list {
689 display: flex;
690 flex-direction: column;
691 gap: 1rem;
692 }
693
694 .referrer-item {
695 display: flex;
696 justify-content: space-between;
697 align-items: center;
698 padding: 0.75rem;
699 background: var(--color-bg);
700 border-radius: 0.375rem;
701 }
702
703 .referrer-name {
704 font-family: monospace;
705 font-size: 0.875rem;
706 }
707
708 .referrer-count {
709 font-weight: 500;
710 color: var(--color-text-muted);
711 }
712
713 .device-stats {
714 display: flex;
715 gap: 1.5rem;
716 }
717
718 .device-item {
719 flex: 1;
720 display: flex;
721 flex-direction: column;
722 align-items: center;
723 gap: 1rem;
724 padding: 1.5rem;
725 background: var(--color-bg);
726 border-radius: 0.5rem;
727 }
728
729 .device-icon {
730 font-size: 2.5rem;
731 }
732
733 .device-info {
734 text-align: center;
735 }
736
737 .device-label {
738 font-size: 0.875rem;
739 color: var(--color-text-muted);
740 margin-bottom: 0.25rem;
741 }
742
743 .device-percent {
744 font-size: 1.5rem;
745 font-weight: 700;
746 }
747
748 .browser-list {
749 display: flex;
750 flex-direction: column;
751 gap: 1rem;
752 }
753
754 .browser-item {
755 display: flex;
756 justify-content: space-between;
757 align-items: center;
758 padding: 0.75rem;
759 background: var(--color-bg);
760 border-radius: 0.375rem;
761 }
762
763 .browser-name {
764 font-weight: 500;
765 }
766
767 .browser-percent {
768 font-weight: 600;
769 color: var(--color-primary);
770 }
771 </style>
772</body>
773</html>