Why Explicit SQL Over Implicit Cell Mutations
Developers migrating from older GUI tools often wonder: "Why doesn’t VloamDb allow double-clicking grid cells to edit database rows directly?"
This is VloamDb’s core engineering principle. Direct in-place cell editing introduces catastrophic hazards in real-world production systems:
No Explicit Transactions or Review
Typos mutate data immediately without explicit transaction boundaries or peer review.
Full-Table Overwrite Without Primary Keys
Without a primary key, GUI tools generate fragile WHERE clauses that can accidentally overwrite an entire table.
VloamDb’s Safe Workflow
Right-click cells to "Copy as UPDATE". VloamDb crafts a deterministic SQL statement for you to review and safely execute.
Three Execution Modes & Stopping Queries
VloamDb features a purpose-built SQL editor with intelligent syntax parsing and three execution workflows:
| Mode | macOS Shortcut | Windows Shortcut | Scope |
|---|---|---|---|
| Run Statement | ⌘ + Enter | Ctrl + Enter | Auto-detects statement boundary at cursor position; runs only that query. |
| Run Selection | ⌘ + Enter | Ctrl + Enter | When text is highlighted, executes only the selected snippet. |
| Run Full Script | ⌘ + ⇧ + Enter | Ctrl + Shift + Enter | Executes all statements in the active script file sequentially. |
If a slow unindexed query hangs, the Run icon switches to a red Stop button. Click it to cancel query execution immediately.
Multi-Result Tabs Without Overwriting
In legacy tools, running a new query immediately overwrites your previous result set, forcing tedious re-runs when cross-referencing datasets.
VloamDb organizes multiple query results into parallel tabs ("Result 1", "Result 2"). Compare outputs side by side without re-running queries.
Database-Scoped Scripts & Directory Tree
VloamDb features a local, organized SQL script repository:
- Scoped to Active Database:Scripts are scoped per database and persisted in local SQLite. Safe against crashes.
- Nested Folders & Drag-and-Drop:Create multi-level folders to organize scripts and drag to reorder.
- Ephemeral Drafts vs Saved Scripts:Console tabs created via "+" are scratchpads; press <kbd>⌘S</kbd> / <kbd>Ctrl+S</kbd> to persist them.
SQL Snippets: Placeholders & Tab Navigation
Snippets drastically accelerate repetitive DDL and DML authoring. Type a trigger prefix (e.g. <code>addcol</code>, <code>sel</code>, <code>page</code>) and press <kbd>Tab</kbd> or Enter to expand.
| Placeholder Syntax | Behavior | Example |
|---|---|---|
$1, $2, $3 | Cursor stops. Tab moves forward to $2, Shift+Tab moves backward. | WHERE `id` = $1 AND `status` = $2 |
${1:defaultValue} | Placeholder with preselected default value. | LIMIT ${1:10} OFFSET ${2:0} |
$0 | Final exit stop when all placeholders are filled. | SELECT * FROM $1;$0 |
Navigate to "Settings > Snippets" to view built-in templates and register custom team snippets.
Execution History & Calendar Recall
When debugging incidents, you frequently need to recall "that slow query executed earlier today".
VloamDb provides a dedicated Query History drawer with custom calendar navigation, time pickers, and a "Now" shortcut. Double-click any query row to load it back into the active console.