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
settings.html · 28.4 KB · 704 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>Settings - 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="jobs.html" class="nav-item">
47 <span class="nav-icon">⏰</span>
48 <span class="nav-label">Jobs</span>
49 </a>
50 <a href="logs.html" class="nav-item">
51 <span class="nav-icon">📋</span>
52 <span class="nav-label">Logs</span>
53 </a>
54 <a href="deploy.html" class="nav-item">
55 <span class="nav-icon">🚀</span>
56 <span class="nav-label">Deploy</span>
57 </a>
58 <a href="settings.html" class="nav-item active">
59 <span class="nav-icon">⚙️</span>
60 <span class="nav-label">Settings</span>
61 </a>
62 </nav>
63
64 <main class="main-content">
65 <div class="content-header">
66 <div>
67 <h1>Settings</h1>
68 <div class="breadcrumb">Home / Settings</div>
69 </div>
70 <div class="header-actions">
71 <button class="btn-primary">Save Changes</button>
72 </div>
73 </div>
74
75 <!-- Settings Navigation Tabs -->
76 <div class="settings-tabs">
77 <button class="settings-tab active">General</button>
78 <button class="settings-tab">Database</button>
79 <button class="settings-tab">Security</button>
80 <button class="settings-tab">Email</button>
81 <button class="settings-tab">AI</button>
82 <button class="settings-tab">Advanced</button>
83 </div>
84
85 <!-- General Settings -->
86 <div class="card">
87 <h2>General Settings</h2>
88
89 <div class="form-group">
90 <label for="site_name">Site Name</label>
91 <input type="text" id="site_name" class="form-input" value="My Blog">
92 </div>
93
94 <div class="form-group">
95 <label for="site_url">Site URL</label>
96 <input type="url" id="site_url" class="form-input" value="https://myblog.com">
97 <div class="form-hint">Your site's public URL</div>
98 </div>
99
100 <div class="form-group">
101 <label for="site_description">Site Description</label>
102 <textarea id="site_description" class="form-textarea" rows="3">A simple blog built with DBBASIC</textarea>
103 </div>
104
105 <div class="form-group">
106 <label for="timezone">Timezone</label>
107 <select id="timezone" class="form-select">
108 <option>UTC</option>
109 <option selected>America/New_York</option>
110 <option>America/Los_Angeles</option>
111 <option>Europe/London</option>
112 <option>Asia/Tokyo</option>
113 </select>
114 </div>
115
116 <div class="form-group">
117 <label for="language">Language</label>
118 <select id="language" class="form-select">
119 <option selected>English</option>
120 <option>Spanish</option>
121 <option>French</option>
122 <option>German</option>
123 </select>
124 </div>
125 </div>
126
127 <!-- Database Settings -->
128 <div class="card">
129 <h2>Database Configuration</h2>
130
131 <div class="setting-item">
132 <div class="setting-info">
133 <div class="setting-label">Database Type</div>
134 <div class="setting-description">DBBASIC uses TSV files by default. Fast, simple, grep-able.</div>
135 </div>
136 <div class="setting-value">
137 <span class="badge badge-blue">TSV Files</span>
138 </div>
139 </div>
140
141 <div class="setting-item">
142 <div class="setting-info">
143 <div class="setting-label">Data Directory</div>
144 <div class="setting-description">Location where TSV files are stored</div>
145 </div>
146 <div class="setting-value">
147 <code>data/</code>
148 </div>
149 </div>
150
151 <div class="setting-item">
152 <div class="setting-info">
153 <div class="setting-label">Auto Backup</div>
154 <div class="setting-description">Automatically backup database files daily</div>
155 </div>
156 <div class="setting-value">
157 <label class="toggle">
158 <input type="checkbox" checked>
159 <span class="toggle-slider"></span>
160 </label>
161 </div>
162 </div>
163
164 <div class="setting-item">
165 <div class="setting-info">
166 <div class="setting-label">Backup Retention</div>
167 <div class="setting-description">How long to keep backup files</div>
168 </div>
169 <div class="setting-value">
170 <select class="form-select" style="width: 150px;">
171 <option>7 days</option>
172 <option selected>30 days</option>
173 <option>90 days</option>
174 <option>1 year</option>
175 </select>
176 </div>
177 </div>
178 </div>
179
180 <!-- Security Settings -->
181 <div class="card">
182 <h2>Security</h2>
183
184 <div class="setting-item">
185 <div class="setting-info">
186 <div class="setting-label">Authentication</div>
187 <div class="setting-description">Using PAM (Unix system authentication)</div>
188 </div>
189 <div class="setting-value">
190 <span class="badge badge-green">Active</span>
191 </div>
192 </div>
193
194 <div class="setting-item">
195 <div class="setting-info">
196 <div class="setting-label">Session Timeout</div>
197 <div class="setting-description">Automatically log out inactive users</div>
198 </div>
199 <div class="setting-value">
200 <select class="form-select" style="width: 150px;">
201 <option>15 minutes</option>
202 <option>30 minutes</option>
203 <option selected>1 hour</option>
204 <option>4 hours</option>
205 <option>Never</option>
206 </select>
207 </div>
208 </div>
209
210 <div class="setting-item">
211 <div class="setting-info">
212 <div class="setting-label">Two-Factor Authentication</div>
213 <div class="setting-description">Require 2FA for admin access</div>
214 </div>
215 <div class="setting-value">
216 <label class="toggle">
217 <input type="checkbox">
218 <span class="toggle-slider"></span>
219 </label>
220 </div>
221 </div>
222
223 <div class="setting-item">
224 <div class="setting-info">
225 <div class="setting-label">IP Whitelist</div>
226 <div class="setting-description">Restrict admin access to specific IPs</div>
227 </div>
228 <div class="setting-value">
229 <button class="btn-secondary-small">Configure</button>
230 </div>
231 </div>
232
233 <div class="setting-item">
234 <div class="setting-info">
235 <div class="setting-label">Failed Login Attempts</div>
236 <div class="setting-description">Lock account after failed attempts</div>
237 </div>
238 <div class="setting-value">
239 <select class="form-select" style="width: 150px;">
240 <option>3 attempts</option>
241 <option selected>5 attempts</option>
242 <option>10 attempts</option>
243 <option>Disabled</option>
244 </select>
245 </div>
246 </div>
247 </div>
248
249 <!-- Email Settings -->
250 <div class="card">
251 <h2>Email Configuration</h2>
252
253 <div class="form-group">
254 <label for="smtp_host">SMTP Host</label>
255 <input type="text" id="smtp_host" class="form-input" value="smtp.example.com">
256 </div>
257
258 <div class="form-row">
259 <div class="form-group">
260 <label for="smtp_port">SMTP Port</label>
261 <input type="number" id="smtp_port" class="form-input" value="587">
262 </div>
263 <div class="form-group">
264 <label for="smtp_encryption">Encryption</label>
265 <select id="smtp_encryption" class="form-select">
266 <option>None</option>
267 <option selected>TLS</option>
268 <option>SSL</option>
269 </select>
270 </div>
271 </div>
272
273 <div class="form-group">
274 <label for="smtp_username">SMTP Username</label>
275 <input type="text" id="smtp_username" class="form-input" value="noreply@myblog.com">
276 </div>
277
278 <div class="form-group">
279 <label for="smtp_password">SMTP Password</label>
280 <input type="password" id="smtp_password" class="form-input" value="••••••••">
281 </div>
282
283 <div class="form-group">
284 <label for="from_email">From Email</label>
285 <input type="email" id="from_email" class="form-input" value="noreply@myblog.com">
286 </div>
287
288 <div class="form-group">
289 <label for="from_name">From Name</label>
290 <input type="text" id="from_name" class="form-input" value="My Blog">
291 </div>
292
293 <button class="btn-secondary">Send Test Email</button>
294 </div>
295
296 <!-- AI Settings -->
297 <div class="card">
298 <h2>AI Assistant Configuration</h2>
299
300 <div class="setting-item">
301 <div class="setting-info">
302 <div class="setting-label">AI Provider</div>
303 <div class="setting-description">Choose your AI provider</div>
304 </div>
305 <div class="setting-value">
306 <select class="form-select" style="width: 200px;">
307 <option selected>Anthropic (Claude)</option>
308 <option>OpenAI (GPT-4)</option>
309 <option>Local (Ollama)</option>
310 </select>
311 </div>
312 </div>
313
314 <div class="form-group">
315 <label for="ai_api_key">API Key</label>
316 <input type="password" id="ai_api_key" class="form-input" value="sk-ant-••••••••">
317 <div class="form-hint">Your Anthropic API key (stored securely)</div>
318 </div>
319
320 <div class="setting-item">
321 <div class="setting-info">
322 <div class="setting-label">Auto-Apply Changes</div>
323 <div class="setting-description">Automatically apply AI-generated code</div>
324 </div>
325 <div class="setting-value">
326 <label class="toggle">
327 <input type="checkbox" checked>
328 <span class="toggle-slider"></span>
329 </label>
330 </div>
331 </div>
332
333 <div class="setting-item">
334 <div class="setting-info">
335 <div class="setting-label">Show Code Previews</div>
336 <div class="setting-description">Display code before applying</div>
337 </div>
338 <div class="setting-value">
339 <label class="toggle">
340 <input type="checkbox" checked>
341 <span class="toggle-slider"></span>
342 </label>
343 </div>
344 </div>
345
346 <div class="setting-item">
347 <div class="setting-info">
348 <div class="setting-label">Conversation History</div>
349 <div class="setting-description">How long to keep AI conversations</div>
350 </div>
351 <div class="setting-value">
352 <select class="form-select" style="width: 150px;">
353 <option>1 day</option>
354 <option>7 days</option>
355 <option selected>30 days</option>
356 <option>Forever</option>
357 </select>
358 </div>
359 </div>
360 </div>
361
362 <!-- Advanced Settings -->
363 <div class="card">
364 <h2>Advanced Settings</h2>
365
366 <div class="setting-item">
367 <div class="setting-info">
368 <div class="setting-label">Debug Mode</div>
369 <div class="setting-description">Show detailed error messages and logs</div>
370 </div>
371 <div class="setting-value">
372 <label class="toggle">
373 <input type="checkbox">
374 <span class="toggle-slider"></span>
375 </label>
376 </div>
377 </div>
378
379 <div class="setting-item">
380 <div class="setting-info">
381 <div class="setting-label">Log Level</div>
382 <div class="setting-description">Minimum log level to record</div>
383 </div>
384 <div class="setting-value">
385 <select class="form-select" style="width: 150px;">
386 <option>DEBUG</option>
387 <option selected>INFO</option>
388 <option>WARNING</option>
389 <option>ERROR</option>
390 </select>
391 </div>
392 </div>
393
394 <div class="setting-item">
395 <div class="setting-info">
396 <div class="setting-label">Cache Enabled</div>
397 <div class="setting-description">Enable in-memory caching for performance</div>
398 </div>
399 <div class="setting-value">
400 <label class="toggle">
401 <input type="checkbox" checked>
402 <span class="toggle-slider"></span>
403 </label>
404 </div>
405 </div>
406
407 <div class="setting-item">
408 <div class="setting-info">
409 <div class="setting-label">Cache TTL</div>
410 <div class="setting-description">How long to keep cached data</div>
411 </div>
412 <div class="setting-value">
413 <select class="form-select" style="width: 150px;">
414 <option>1 minute</option>
415 <option>5 minutes</option>
416 <option selected>15 minutes</option>
417 <option>1 hour</option>
418 </select>
419 </div>
420 </div>
421
422 <div class="form-group">
423 <label for="max_upload_size">Max Upload Size (MB)</label>
424 <input type="number" id="max_upload_size" class="form-input" value="10">
425 </div>
426
427 <div class="form-group">
428 <label for="workers">Worker Processes</label>
429 <input type="number" id="workers" class="form-input" value="4">
430 <div class="form-hint">Number of concurrent worker processes</div>
431 </div>
432 </div>
433
434 <!-- Config Files -->
435 <div class="card">
436 <h2>Configuration Files</h2>
437 <div class="config-files">
438 <div class="config-file">
439 <div class="config-file-icon">⚙️</div>
440 <div class="config-file-info">
441 <div class="config-file-name">config.py</div>
442 <div class="config-file-path">Application configuration</div>
443 </div>
444 <button class="btn-secondary-small">Edit</button>
445 </div>
446
447 <div class="config-file">
448 <div class="config-file-icon">📄</div>
449 <div class="config-file-info">
450 <div class="config-file-name">.env</div>
451 <div class="config-file-path">Environment variables</div>
452 </div>
453 <button class="btn-secondary-small">Edit</button>
454 </div>
455
456 <div class="config-file">
457 <div class="config-file-icon">🔧</div>
458 <div class="config-file-info">
459 <div class="config-file-name">systemd/myblog.service</div>
460 <div class="config-file-path">Systemd service configuration</div>
461 </div>
462 <button class="btn-secondary-small">Edit</button>
463 </div>
464 </div>
465 </div>
466
467 <!-- Danger Zone -->
468 <div class="card danger-zone">
469 <h2>⚠️ Danger Zone</h2>
470
471 <div class="danger-action">
472 <div class="danger-info">
473 <div class="danger-title">Clear Cache</div>
474 <div class="danger-description">Remove all cached data</div>
475 </div>
476 <button class="btn-danger-outline">Clear Cache</button>
477 </div>
478
479 <div class="danger-action">
480 <div class="danger-info">
481 <div class="danger-title">Reset Settings</div>
482 <div class="danger-description">Restore all settings to defaults</div>
483 </div>
484 <button class="btn-danger-outline">Reset Settings</button>
485 </div>
486
487 <div class="danger-action">
488 <div class="danger-info">
489 <div class="danger-title">Delete All Data</div>
490 <div class="danger-description">Permanently delete all posts, users, and data</div>
491 </div>
492 <button class="btn-danger-outline">Delete Data</button>
493 </div>
494 </div>
495 </main>
496
497 <aside class="ai-assistant">
498 <div class="ai-header">
499 <span class="ai-icon">🤖</span>
500 <span class="ai-title">AI Assistant</span>
501 <button class="ai-toggle">−</button>
502 </div>
503
504 <div class="ai-content">
505 <div class="ai-messages">
506 <div class="ai-message ai-message-assistant">
507 <div class="message-content">
508 I can help you configure settings, explain options, or optimize your setup. What would you like to know?
509 </div>
510 </div>
511 </div>
512
513 <div class="ai-suggestions">
514 <div class="suggestion-title">Try asking:</div>
515 <button class="suggestion-btn">"Set up email notifications"</button>
516 <button class="suggestion-btn">"Configure backups"</button>
517 <button class="suggestion-btn">"Optimize performance"</button>
518 </div>
519
520 <div class="ai-input">
521 <textarea placeholder="Ask AI about settings..." rows="3"></textarea>
522 <button class="btn-primary">Send</button>
523 </div>
524 </div>
525 </aside>
526 </div>
527 </div>
528
529 <style>
530 .settings-tabs {
531 display: flex;
532 gap: 0.5rem;
533 margin-bottom: 2rem;
534 border-bottom: 1px solid var(--color-border);
535 overflow-x: auto;
536 }
537
538 .settings-tab {
539 padding: 0.75rem 1.5rem;
540 background: none;
541 border: none;
542 border-bottom: 2px solid transparent;
543 cursor: pointer;
544 font-weight: 500;
545 color: var(--color-text-muted);
546 transition: all 0.15s;
547 white-space: nowrap;
548 }
549
550 .settings-tab:hover {
551 color: var(--color-text);
552 }
553
554 .settings-tab.active {
555 color: var(--color-primary);
556 border-bottom-color: var(--color-primary);
557 }
558
559 .setting-item {
560 display: flex;
561 justify-content: space-between;
562 align-items: center;
563 padding: 1.5rem 0;
564 border-bottom: 1px solid var(--color-border);
565 }
566
567 .setting-item:last-child {
568 border-bottom: none;
569 }
570
571 .setting-info {
572 flex: 1;
573 }
574
575 .setting-label {
576 font-weight: 500;
577 margin-bottom: 0.25rem;
578 }
579
580 .setting-description {
581 font-size: 0.875rem;
582 color: var(--color-text-muted);
583 }
584
585 .setting-value {
586 display: flex;
587 align-items: center;
588 }
589
590 .toggle {
591 position: relative;
592 display: inline-block;
593 width: 48px;
594 height: 24px;
595 }
596
597 .toggle input {
598 opacity: 0;
599 width: 0;
600 height: 0;
601 }
602
603 .toggle-slider {
604 position: absolute;
605 cursor: pointer;
606 top: 0;
607 left: 0;
608 right: 0;
609 bottom: 0;
610 background-color: var(--color-border);
611 transition: 0.3s;
612 border-radius: 24px;
613 }
614
615 .toggle-slider:before {
616 position: absolute;
617 content: "";
618 height: 18px;
619 width: 18px;
620 left: 3px;
621 bottom: 3px;
622 background-color: white;
623 transition: 0.3s;
624 border-radius: 50%;
625 }
626
627 .toggle input:checked + .toggle-slider {
628 background-color: var(--color-primary);
629 }
630
631 .toggle input:checked + .toggle-slider:before {
632 transform: translateX(24px);
633 }
634
635 .config-files {
636 display: flex;
637 flex-direction: column;
638 gap: 1rem;
639 }
640
641 .config-file {
642 display: flex;
643 align-items: center;
644 gap: 1rem;
645 padding: 1rem;
646 background: var(--color-bg);
647 border-radius: 0.5rem;
648 }
649
650 .config-file-icon {
651 font-size: 1.5rem;
652 }
653
654 .config-file-info {
655 flex: 1;
656 }
657
658 .config-file-name {
659 font-weight: 500;
660 font-family: monospace;
661 margin-bottom: 0.25rem;
662 }
663
664 .config-file-path {
665 font-size: 0.875rem;
666 color: var(--color-text-muted);
667 }
668
669 .danger-zone {
670 border: 2px solid var(--color-danger);
671 }
672
673 .danger-zone h2 {
674 color: var(--color-danger);
675 }
676
677 .danger-action {
678 display: flex;
679 justify-content: space-between;
680 align-items: center;
681 padding: 1.5rem 0;
682 border-bottom: 1px solid var(--color-border);
683 }
684
685 .danger-action:last-child {
686 border-bottom: none;
687 }
688
689 .danger-info {
690 flex: 1;
691 }
692
693 .danger-title {
694 font-weight: 500;
695 margin-bottom: 0.25rem;
696 }
697
698 .danger-description {
699 font-size: 0.875rem;
700 color: var(--color-text-muted);
701 }
702 </style>
703</body>
704</html>