Skip to content
Profile photo of Pablo Viniegra Picazo
Español
ShortcutD

Selected project09 · 10

09 / 106 tech

SQLito

SQLito: Keyboard-first SQLite client for the terminal: SQL is the interface; history, autocomplete and the results table only keep you in flow.
SQLito
Problem
Working with SQLite from the terminal usually means a heavyweight GUI or a bare REPL, with no history, autocomplete or schema inspection.
Decision
I built a TUI client with Ink and Clean Architecture where SQL is the protagonist and the chrome (table, prompt, palette) only keeps you in flow.
Challenge
Fitting synchronous execution, persistent history, viewport and alternate screen into a cold start under 1500 ms.
Result
Published on npm as @pablo-v/sqlito v1.2.0, with history, favourites, CSV export, command palette and themes.

Remote session

terminal@pablo.dev

Connecting to terminal@pablo.dev…