A database in TSV text files: data you can read, fast inserts, and an optional Rust speed-up.

0 downloads

dbbasic-tsv/templates/admin/database.html
Download zip
Clone
Clone with git
git clone https://gitstable.com/git/askrobots/dbbasic-tsv.git
HTTPS
https://gitstable.com/git/askrobots/dbbasic-tsv.git
SSH
ssh://git@gitstable.com:2222/askrobots/dbbasic-tsv.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 launch announcement for dbbasic-tsv v1.0.1 1c9b0b8 1 year, 1 month ago History
database.html · 16.3 KB · 501 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>Database - dbbasic-tsv</title>
7 <style>
8 :root {
9 --primary: #3b82f6;
10 --primary-dark: #2563eb;
11 --secondary: #64748b;
12 --success: #10b981;
13 --danger: #ef4444;
14 --bg: #f8fafc;
15 --surface: #ffffff;
16 --border: #e2e8f0;
17 --text: #0f172a;
18 --text-muted: #64748b;
19 }
20
21 * { margin: 0; padding: 0; box-sizing: border-box; }
22
23 body {
24 font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Roboto, sans-serif;
25 color: var(--text);
26 background: var(--bg);
27 line-height: 1.6;
28 padding: 2rem;
29 }
30
31 .container { max-width: 1200px; margin: 0 auto; }
32
33 h1 { font-size: 1.875rem; font-weight: 700; margin-bottom: 0.5rem; }
34 .breadcrumb { font-size: 0.875rem; color: var(--text-muted); margin-bottom: 2rem; }
35
36 .card {
37 background: var(--surface);
38 border: 1px solid var(--border);
39 border-radius: 0.5rem;
40 padding: 1.5rem;
41 margin-bottom: 1.5rem;
42 }
43
44 .card h2 { font-size: 1.25rem; font-weight: 600; margin-bottom: 1rem; }
45
46 /* Tables Grid */
47 .db-tables-grid {
48 display: grid;
49 grid-template-columns: repeat(auto-fill, minmax(300px, 1fr));
50 gap: 1rem;
51 }
52
53 .db-table-card {
54 border: 1px solid var(--border);
55 border-radius: 0.5rem;
56 padding: 1rem;
57 }
58
59 .db-table-header {
60 display: flex;
61 align-items: flex-start;
62 gap: 0.75rem;
63 margin-bottom: 0.75rem;
64 }
65
66 .db-table-icon { font-size: 1.5rem; }
67
68 .db-table-info { flex: 1; }
69 .db-table-info h3 { margin: 0; font-size: 1rem; }
70 .db-table-meta { font-size: 0.75rem; color: var(--text-muted); }
71
72 .db-table-columns {
73 display: flex;
74 flex-wrap: wrap;
75 gap: 0.375rem;
76 margin-bottom: 0.75rem;
77 }
78
79 .column-tag {
80 padding: 0.25rem 0.5rem;
81 background: var(--bg);
82 border-radius: 0.25rem;
83 font-size: 0.75rem;
84 font-family: monospace;
85 }
86
87 .db-table-actions { display: flex; gap: 0.5rem; }
88
89 /* Query Builder */
90 .query-builder {
91 background: var(--bg);
92 border-radius: 0.5rem;
93 padding: 1rem;
94 margin-bottom: 1rem;
95 }
96
97 .form-row {
98 display: grid;
99 grid-template-columns: 1fr 1fr;
100 gap: 1rem;
101 margin-bottom: 1rem;
102 }
103
104 .form-group label {
105 display: block;
106 font-weight: 500;
107 margin-bottom: 0.5rem;
108 font-size: 0.875rem;
109 }
110
111 .form-input, .form-select {
112 width: 100%;
113 padding: 0.625rem;
114 border: 1px solid var(--border);
115 border-radius: 0.375rem;
116 font-size: 0.875rem;
117 }
118
119 .form-actions {
120 display: flex;
121 gap: 0.75rem;
122 justify-content: flex-end;
123 }
124
125 .btn-primary {
126 background: var(--primary);
127 color: white;
128 border: none;
129 padding: 0.625rem 1.25rem;
130 border-radius: 0.375rem;
131 font-weight: 500;
132 cursor: pointer;
133 }
134
135 .btn-primary:hover { background: var(--primary-dark); }
136
137 .btn-secondary {
138 background: var(--surface);
139 color: var(--text);
140 border: 1px solid var(--border);
141 padding: 0.625rem 1.25rem;
142 border-radius: 0.375rem;
143 font-weight: 500;
144 cursor: pointer;
145 }
146
147 .btn-secondary-small {
148 background: var(--surface);
149 color: var(--text);
150 border: 1px solid var(--border);
151 padding: 0.375rem 0.75rem;
152 border-radius: 0.25rem;
153 font-size: 0.875rem;
154 font-weight: 500;
155 cursor: pointer;
156 text-decoration: none;
157 }
158
159 /* Query Preview */
160 .query-preview {
161 background: #1e293b;
162 color: #e2e8f0;
163 border-radius: 0.375rem;
164 padding: 0.75rem 1rem;
165 }
166
167 .query-preview-header {
168 display: flex;
169 justify-content: space-between;
170 align-items: center;
171 margin-bottom: 0.5rem;
172 font-size: 0.75rem;
173 color: #94a3b8;
174 }
175
176 .query-preview pre {
177 margin: 0;
178 font-family: monospace;
179 font-size: 0.875rem;
180 }
181
182 /* Results */
183 .query-results {
184 border-top: 1px solid var(--border);
185 padding-top: 1rem;
186 }
187
188 .results-header {
189 display: flex;
190 justify-content: space-between;
191 align-items: center;
192 margin-bottom: 1rem;
193 font-weight: 500;
194 }
195
196 .table-container { overflow-x: auto; }
197
198 .data-table {
199 width: 100%;
200 border-collapse: collapse;
201 }
202
203 .data-table th {
204 text-align: left;
205 padding: 0.75rem;
206 font-size: 0.875rem;
207 font-weight: 600;
208 color: var(--text-muted);
209 border-bottom: 1px solid var(--border);
210 }
211
212 .data-table td {
213 padding: 1rem 0.75rem;
214 font-size: 0.875rem;
215 border-bottom: 1px solid var(--border);
216 }
217
218 /* Storage */
219 .storage-bar {
220 height: 1.5rem;
221 background: var(--bg);
222 border-radius: 0.5rem;
223 overflow: hidden;
224 margin-bottom: 0.5rem;
225 }
226
227 .storage-fill {
228 height: 100%;
229 background: var(--primary);
230 }
231
232 .storage-info {
233 display: flex;
234 justify-content: space-between;
235 font-size: 0.875rem;
236 color: var(--text-muted);
237 margin-bottom: 1.5rem;
238 }
239
240 .storage-breakdown {
241 display: flex;
242 flex-direction: column;
243 gap: 0.75rem;
244 }
245
246 .storage-item {
247 display: flex;
248 justify-content: space-between;
249 font-size: 0.875rem;
250 }
251 </style>
252</head>
253<body>
254 <div class="container">
255 <h1>Database</h1>
256 <div class="breadcrumb">dbbasic-tsv / Database</div>
257
258 <!-- Tables Overview -->
259 <div class="card">
260 <h2>Tables</h2>
261 <div class="db-tables-grid" id="tables-grid">
262 <p>Loading tables...</p>
263 </div>
264 </div>
265
266 <!-- Query Interface -->
267 <div class="card">
268 <h2>Query Data</h2>
269 <div class="query-builder">
270 <div class="query-form">
271 <div class="form-row">
272 <div class="form-group">
273 <label>Table</label>
274 <select class="form-select" id="query-table">
275 <option value="">Select table...</option>
276 </select>
277 </div>
278 <div class="form-group">
279 <label>Columns</label>
280 <input type="text" class="form-input" id="query-columns" placeholder="* (all)" value="*">
281 </div>
282 </div>
283 <div class="form-row">
284 <div class="form-group">
285 <label>Where</label>
286 <input type="text" class="form-input" id="query-where" placeholder="e.g., id=123">
287 </div>
288 <div class="form-group">
289 <label>Limit</label>
290 <input type="number" class="form-input" id="query-limit" value="10">
291 </div>
292 </div>
293 <div class="form-actions">
294 <button class="btn-secondary" onclick="clearQuery()">Clear</button>
295 <button class="btn-primary" onclick="runQuery()">Run Query</button>
296 </div>
297 </div>
298
299 <div class="query-preview">
300 <div class="query-preview-header">
301 <span>Python:</span>
302 </div>
303 <pre><code id="query-code">table.query()</code></pre>
304 </div>
305 </div>
306
307 <div class="query-results" id="query-results" style="display: none;">
308 <div class="results-header">
309 <span id="results-count">Results (0 rows)</span>
310 <button class="btn-secondary-small">Export CSV</button>
311 </div>
312 <div class="table-container">
313 <table class="data-table" id="results-table">
314 <thead><tr></tr></thead>
315 <tbody></tbody>
316 </table>
317 </div>
318 </div>
319 </div>
320
321 <!-- Storage Stats -->
322 <div class="card">
323 <h2>Storage</h2>
324 <div id="storage-stats">
325 <p>Loading storage stats...</p>
326 </div>
327 </div>
328 </div>
329
330 <script>
331 // Load tables on page load
332 async function loadTables() {
333 try {
334 const res = await fetch('/admin/api/tables');
335 const tables = await res.json();
336
337 const grid = document.getElementById('tables-grid');
338 const select = document.getElementById('query-table');
339
340 if (tables.length === 0) {
341 grid.innerHTML = '<p>No tables found in data/ directory</p>';
342 return;
343 }
344
345 grid.innerHTML = tables.map(t => `
346 <div class="db-table-card">
347 <div class="db-table-header">
348 <div class="db-table-icon">📊</div>
349 <div class="db-table-info">
350 <h3>${t.name}.tsv</h3>
351 <div class="db-table-meta">${t.rows} rows • ${t.size}</div>
352 </div>
353 </div>
354 <div class="db-table-columns">
355 ${t.columns.slice(0, 4).map(c => `<div class="column-tag">${c}</div>`).join('')}
356 ${t.columns.length > 4 ? `<div class="column-tag">+${t.columns.length - 4} more</div>` : ''}
357 </div>
358 <div class="db-table-actions">
359 <a href="#" class="btn-secondary-small" onclick="viewTable('${t.name}'); return false;">View Data</a>
360 </div>
361 </div>
362 `).join('');
363
364 select.innerHTML = '<option value="">Select table...</option>' +
365 tables.map(t => `<option value="${t.name}">${t.name}</option>`).join('');
366 } catch (e) {
367 console.error('Failed to load tables:', e);
368 }
369 }
370
371 // Load storage stats
372 async function loadStorage() {
373 try {
374 const res = await fetch('/admin/api/storage');
375 const stats = await res.json();
376
377 const container = document.getElementById('storage-stats');
378 const usedPct = (stats.used_mb / stats.total_mb * 100).toFixed(1);
379
380 container.innerHTML = `
381 <div class="storage-bar">
382 <div class="storage-fill" style="width: ${usedPct}%"></div>
383 </div>
384 <div class="storage-info">
385 <span>${stats.used_mb} MB used of ${stats.total_mb} MB</span>
386 <span>${(100 - usedPct).toFixed(1)}% free</span>
387 </div>
388 <div class="storage-breakdown">
389 ${stats.tables.map(t => `
390 <div class="storage-item">
391 <span>📊 ${t.name}</span>
392 <span>${t.size}</span>
393 </div>
394 `).join('')}
395 </div>
396 `;
397 } catch (e) {
398 console.error('Failed to load storage:', e);
399 }
400 }
401
402 // Update query preview
403 function updateQueryPreview() {
404 const table = document.getElementById('query-table').value;
405 const columns = document.getElementById('query-columns').value || '*';
406 const where = document.getElementById('query-where').value;
407 const limit = document.getElementById('query-limit').value;
408
409 let code = `${table}.query(`;
410 if (where) {
411 const [key, val] = where.split('=').map(s => s.trim());
412 code += `${key}="${val}"`;
413 }
414 code += `)`;
415 if (limit) code += `.limit(${limit})`;
416
417 document.getElementById('query-code').textContent = code;
418 }
419
420 // Run query
421 async function runQuery() {
422 const table = document.getElementById('query-table').value;
423 if (!table) {
424 alert('Select a table first');
425 return;
426 }
427
428 const where = document.getElementById('query-where').value;
429 const limit = document.getElementById('query-limit').value;
430
431 try {
432 const params = new URLSearchParams({ table, limit });
433 if (where) params.set('where', where);
434
435 const res = await fetch(`/admin/api/query?${params}`);
436 const data = await res.json();
437
438 displayResults(data);
439 } catch (e) {
440 console.error('Query failed:', e);
441 alert('Query failed: ' + e.message);
442 }
443 }
444
445 // Display query results
446 function displayResults(data) {
447 const results = document.getElementById('query-results');
448 const count = document.getElementById('results-count');
449 const table = document.getElementById('results-table');
450
451 if (data.rows.length === 0) {
452 results.style.display = 'block';
453 count.textContent = 'No results';
454 table.innerHTML = '';
455 return;
456 }
457
458 results.style.display = 'block';
459 count.textContent = `Results (${data.rows.length} rows)`;
460
461 const thead = table.querySelector('thead tr');
462 const tbody = table.querySelector('tbody');
463
464 thead.innerHTML = data.columns.map(c => `<th>${c}</th>`).join('');
465 tbody.innerHTML = data.rows.map(row => `
466 <tr>${data.columns.map(c => `<td>${row[c] || ''}</td>`).join('')}</tr>
467 `).join('');
468 }
469
470 // View table
471 function viewTable(name) {
472 document.getElementById('query-table').value = name;
473 document.getElementById('query-where').value = '';
474 document.getElementById('query-limit').value = '10';
475 updateQueryPreview();
476 runQuery();
477 }
478
479 // Clear query
480 function clearQuery() {
481 document.getElementById('query-table').value = '';
482 document.getElementById('query-columns').value = '*';
483 document.getElementById('query-where').value = '';
484 document.getElementById('query-limit').value = '10';
485 updateQueryPreview();
486 document.getElementById('query-results').style.display = 'none';
487 }
488
489 // Event listeners
490 document.getElementById('query-table').addEventListener('change', updateQueryPreview);
491 document.getElementById('query-columns').addEventListener('input', updateQueryPreview);
492 document.getElementById('query-where').addEventListener('input', updateQueryPreview);
493 document.getElementById('query-limit').addEventListener('input', updateQueryPreview);
494
495 // Initialize
496 loadTables();
497 loadStorage();
498 updateQueryPreview();
499 </script>
500</body>
501</html>