Get the latest tech news

Ask questions of SQLite databases and CSV/JSON files in your terminal


I built a new plugin for my sqlite-utils CLI tool that lets you ask human-language questions directly of SQLite databases and CSV/JSON files on your computer. It’s called sqlite-utils-ask. Here’s …

I built a new plugin for my sqlite-utils CLI tool that lets you ask human-language questions directly of SQLite databases and CSV/JSON files on your computer. If you add the-e/--examples option it will also include five common values for each of the text columns in that schema with an average length less than 32 characters. Then I ran the actual numbers and found that gpt-4o-mini is cheap enough that even without caching a 4,000 token prompt (that’s a pretty large SQL schema) should cost less than a tenth of a cent.

Get the Android app

Or read this on Hacker News

Read more on:

Photo of questions

questions

Photo of terminal

terminal

Photo of SQLite

SQLite

Related news:

News photo

Alibaba releases Qwen with Questions, an open reasoning model that beats o1-preview

News photo

Show HN: TeaTime – distributed book library powered by SQLite, IPFS and GitHub

News photo

SQLite’s Use of Tcl (2017)