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

Selected project09 / 10

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.
SQLito: Keyboard-first SQLite client for the terminal: SQL is the interface; history, autocomplete and the results table only keep you in flow.
SQLito
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: SQLite from the terminal with history, favourites and CSV export, no GUI needed.

Remote session

terminal@pablo.dev

Connecting to terminal@pablo.dev…