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
database.html · 15.1 KB · 313 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 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="database.html" class="nav-item active">
30 <span class="nav-icon">🗄️</span>
31 <span class="nav-label">Database</span>
32 </a>
33 <a href="posts/list.html" class="nav-item">
34 <span class="nav-icon">📝</span>
35 <span class="nav-label">Posts</span>
36 </a>
37 <a href="users/list.html" class="nav-item">
38 <span class="nav-icon">👥</span>
39 <span class="nav-label">Users</span>
40 </a>
41 <div class="nav-divider"></div>
42 <a href="jobs.html" class="nav-item">
43 <span class="nav-icon">⏰</span>
44 <span class="nav-label">Jobs</span>
45 </a>
46 <a href="logs.html" class="nav-item">
47 <span class="nav-icon">📋</span>
48 <span class="nav-label">Logs</span>
49 </a>
50 <a href="deploy.html" class="nav-item">
51 <span class="nav-icon">🚀</span>
52 <span class="nav-label">Deploy</span>
53 </a>
54 </nav>
55
56 <main class="main-content">
57 <div class="content-header">
58 <div>
59 <h1>Database</h1>
60 <div class="breadcrumb">Home / Database</div>
61 </div>
62 <div class="header-actions">
63 <button class="btn-primary">+ New Table</button>
64 </div>
65 </div>
66
67 <!-- Database Overview -->
68 <div class="card">
69 <h2>Tables</h2>
70 <div class="db-tables-grid">
71 <div class="db-table-card">
72 <div class="db-table-header">
73 <div class="db-table-icon">📝</div>
74 <div class="db-table-info">
75 <h3>posts.tsv</h3>
76 <div class="db-table-meta">145 rows • 12.4 KB</div>
77 </div>
78 <button class="btn-icon">⋮</button>
79 </div>
80 <div class="db-table-columns">
81 <div class="column-tag">id</div>
82 <div class="column-tag">title</div>
83 <div class="column-tag">body</div>
84 <div class="column-tag">author_id</div>
85 <div class="column-tag">+3 more</div>
86 </div>
87 <div class="db-table-actions">
88 <a href="#" class="btn-secondary-small">View Data</a>
89 <button class="btn-secondary-small">Schema</button>
90 </div>
91 </div>
92
93 <div class="db-table-card">
94 <div class="db-table-header">
95 <div class="db-table-icon">👥</div>
96 <div class="db-table-info">
97 <h3>users.tsv</h3>
98 <div class="db-table-meta">23 rows • 2.1 KB</div>
99 </div>
100 <button class="btn-icon">⋮</button>
101 </div>
102 <div class="db-table-columns">
103 <div class="column-tag">id</div>
104 <div class="column-tag">email</div>
105 <div class="column-tag">name</div>
106 <div class="column-tag">role</div>
107 <div class="column-tag">+2 more</div>
108 </div>
109 <div class="db-table-actions">
110 <a href="#" class="btn-secondary-small">View Data</a>
111 <button class="btn-secondary-small">Schema</button>
112 </div>
113 </div>
114
115 <div class="db-table-card">
116 <div class="db-table-header">
117 <div class="db-table-icon">💬</div>
118 <div class="db-table-info">
119 <h3>comments.tsv</h3>
120 <div class="db-table-meta">892 rows • 45.2 KB</div>
121 </div>
122 <button class="btn-icon">⋮</button>
123 </div>
124 <div class="db-table-columns">
125 <div class="column-tag">id</div>
126 <div class="column-tag">post_id</div>
127 <div class="column-tag">author</div>
128 <div class="column-tag">body</div>
129 <div class="column-tag">+1 more</div>
130 </div>
131 <div class="db-table-actions">
132 <a href="#" class="btn-secondary-small">View Data</a>
133 <button class="btn-secondary-small">Schema</button>
134 </div>
135 </div>
136
137 <div class="db-table-card">
138 <div class="db-table-header">
139 <div class="db-table-icon">🖼️</div>
140 <div class="db-table-info">
141 <h3>uploads.tsv</h3>
142 <div class="db-table-meta">67 rows • 3.8 KB</div>
143 </div>
144 <button class="btn-icon">⋮</button>
145 </div>
146 <div class="db-table-columns">
147 <div class="column-tag">id</div>
148 <div class="column-tag">filename</div>
149 <div class="column-tag">path</div>
150 <div class="column-tag">size</div>
151 </div>
152 <div class="db-table-actions">
153 <a href="#" class="btn-secondary-small">View Data</a>
154 <button class="btn-secondary-small">Schema</button>
155 </div>
156 </div>
157 </div>
158 </div>
159
160 <!-- Query Interface -->
161 <div class="card">
162 <h2>Query Data</h2>
163 <div class="query-builder">
164 <div class="query-form">
165 <div class="form-row">
166 <div class="form-group">
167 <label>Table</label>
168 <select class="form-select">
169 <option>posts</option>
170 <option>users</option>
171 <option>comments</option>
172 <option>uploads</option>
173 </select>
174 </div>
175 <div class="form-group">
176 <label>Columns</label>
177 <input type="text" class="form-input" placeholder="* (all)" value="title, author_id, created_at">
178 </div>
179 </div>
180 <div class="form-row">
181 <div class="form-group">
182 <label>Where</label>
183 <input type="text" class="form-input" placeholder="e.g., published = true">
184 </div>
185 <div class="form-group">
186 <label>Limit</label>
187 <input type="number" class="form-input" value="10">
188 </div>
189 </div>
190 <div class="form-actions">
191 <button class="btn-secondary">Clear</button>
192 <button class="btn-primary">Run Query</button>
193 </div>
194 </div>
195
196 <!-- Raw Command Preview -->
197 <div class="query-preview">
198 <div class="query-preview-header">
199 <span>Command:</span>
200 <button class="btn-icon-small">📋 Copy</button>
201 </div>
202 <pre><code>$ grep -E "^[^\t]*\t.*\ttrue\t" data/posts.tsv | head -10 | cut -f1,2,7</code></pre>
203 </div>
204 </div>
205
206 <!-- Results -->
207 <div class="query-results">
208 <div class="results-header">
209 <span>Results (10 rows)</span>
210 <button class="btn-secondary-small">Export CSV</button>
211 </div>
212 <div class="table-container">
213 <table class="data-table">
214 <thead>
215 <tr>
216 <th>title</th>
217 <th>author_id</th>
218 <th>created_at</th>
219 </tr>
220 </thead>
221 <tbody>
222 <tr>
223 <td>Getting Started with DBBASIC</td>
224 <td>1</td>
225 <td>2025-01-15 10:30:00</td>
226 </tr>
227 <tr>
228 <td>Building a Blog in 5 Minutes</td>
229 <td>2</td>
230 <td>2025-01-14 14:20:00</td>
231 </tr>
232 <tr>
233 <td>TSV Files as a Database</td>
234 <td>3</td>
235 <td>2025-01-13 09:15:00</td>
236 </tr>
237 </tbody>
238 </table>
239 </div>
240 </div>
241 </div>
242
243 <!-- Database Stats -->
244 <div class="card">
245 <h2>Storage</h2>
246 <div class="storage-stats">
247 <div class="storage-bar">
248 <div class="storage-fill" style="width: 14.2%"></div>
249 </div>
250 <div class="storage-info">
251 <span>142 MB used of 1 GB</span>
252 <span>85.8% free</span>
253 </div>
254 </div>
255
256 <div class="storage-breakdown">
257 <div class="storage-item">
258 <span class="storage-label">📝 Posts data</span>
259 <span class="storage-value">12.4 KB</span>
260 </div>
261 <div class="storage-item">
262 <span class="storage-label">👥 Users data</span>
263 <span class="storage-value">2.1 KB</span>
264 </div>
265 <div class="storage-item">
266 <span class="storage-label">💬 Comments data</span>
267 <span class="storage-value">45.2 KB</span>
268 </div>
269 <div class="storage-item">
270 <span class="storage-label">🖼️ Uploads</span>
271 <span class="storage-value">138 MB</span>
272 </div>
273 <div class="storage-item">
274 <span class="storage-label">📋 Logs</span>
275 <span class="storage-value">4.2 MB</span>
276 </div>
277 </div>
278 </div>
279 </main>
280
281 <aside class="ai-assistant">
282 <div class="ai-header">
283 <span class="ai-icon">🤖</span>
284 <span class="ai-title">AI Assistant</span>
285 <button class="ai-toggle">−</button>
286 </div>
287
288 <div class="ai-content">
289 <div class="ai-messages">
290 <div class="ai-message ai-message-assistant">
291 <div class="message-content">
292 I can help you manage your database. Try asking me to create tables, add columns, or query data.
293 </div>
294 </div>
295 </div>
296
297 <div class="ai-suggestions">
298 <div class="suggestion-title">Try asking:</div>
299 <button class="suggestion-btn">"Create a tags table"</button>
300 <button class="suggestion-btn">"Add slug column to posts"</button>
301 <button class="suggestion-btn">"Show all posts from last week"</button>
302 </div>
303
304 <div class="ai-input">
305 <textarea placeholder="Ask AI about your database..." rows="3"></textarea>
306 <button class="btn-primary">Send</button>
307 </div>
308 </div>
309 </aside>
310 </div>
311 </div>
312</body>
313</html>