Process

A closer look at selected projects, their constraints, implementation details, tests, and visual checks.

Open source tool

Edit database tables and join data across sources without leaving Neovim.

Dadbod Grip stages table edits, exposes generated SQL for review, and sends the batch as one transaction script. A CLI error can leave an earlier statement committed, so the database must be inspected before retry. DuckDB can join PostgreSQL, MySQL, SQLite, MotherDuck, and local or HTTPS files in one query.

Dadbod Grip in Neovim with schema navigation, a query editor, staged grid changes, and generated SQL.

Deep dive

How Dadbod Grip turns Neovim into a data workbench

Case: dadbod-grip.nvim

Make edits and federation inspectable.

- ALTER TABLE users ADD last_seen_at TIMESTAMP;
+ ALTER TABLE users ADD last_seen_at TIMESTAMPTZ;
+ CREATE INDEX idx_users_last_seen_at
+   ON users (last_seen_at DESC);
DecisionShow the generated mutation SQL before apply, then inspect database state after any CLI error.