zsh-sqlite

Bring sqlite to zsh

Install

First, install it with your plugin manager

zinit

zinit ice nocompletions
zinit light Aloxaf/zsh-sqlite

Then, build it with zsqlite-build

# By default, zsh-sqlite will build against current zsh version. And it will ask you to
# rebuild it everytime your zsh update. However, you can pin the zsh version it use
# by setting something like `ZSQLITE_ZSH_SRC_VERSION=5.8.1`.
zsqlite-build

Build dependencies

• basic build tools(autoconf, make, gcc, ...)
• ncurses
• sqlite3

Usage

• zsqlite_open [-r] [-t MS] HANDLE_VAR FILENAME

  • -r: read-only
  • -t MS: set sqlite3 busy timeout, default is 10

• zsqlite_close HANDLE_VAR

  • HANDLE_VAR: set the variable name to store the database handle

• zsqlite [-rhq] [-t MS] [-s SEP] [-v VAR] FILENAME SQL [PARAMETERS..]

• zsqlite_exec [-h] [-s SEP] [-v VAR] HANDLE_VAR SQL [PARAMETERS..]

  • -r: read-only
  • -s SEP: set the separator between columns, default is '|'
  • -h: show column headers
  • -v VAR: set the variable name to store the result
  • -q: quote the result

Examples

> zsqlite ':memory:' 'SELECT 1'
1

> zsqlite_open DB ':memory:'
> zsqlite_exec DB 'CREATE TABLE Person(name TEXT, age INT)'
> zsqlite_exec DB 'INSERT INTO Person VALUES ("Alice", 20), ("Bob", 21)'
> zsqlite_exec DB 'SELECT * FROM Person'
Alice|20
Bob|21

> zsqlite_exec -s ":" -h DB 'SELECT * FROM Person WHERE age > ?' 10
name:age
Alice:20
Bob:21

> zsqlite_exec -v OUT_VAR DB 'SELECT * FROM Person'
> echo $OUT_VAR
OUT_VAR_name OUT_VAR_age

> echo $OUT_VAR_name
Alice Bob

> echo $OUT_VAR_age
20 21

> zsqlite_close DB