askrobots / dbbasic-admin
Public
An admin interface that builds itself from the dbbasic modules you install; its pages follow file paths, like CGI.
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> |