Installing zsql
zsql is one static binary with no runtime to install: the command line, the planner that turns a spec into SQL, and the server your applications call. The installer puts it on your machine and keeps it current.
Install
curl -fsSL https://0sql.io/install.sh | sh
Works on macOS (Apple silicon and Intel) and Linux (x86_64 and arm64). To update, run it again. The releases it reads are on GitHub, with a SHA256SUMS beside each.
Check it
$ zsql --version
zsql 0.6.5
$ zsql --help
zsql: a semantic model, and the SQL it plans (0sql.io)
...
zsql <command> --help prints the flags of one command; the complete list is the command reference.
From source
The source is MIT licensed at github.com/stratasite/0sql. It is a Rust workspace; cargo build --release -p zsql-cli builds the same binary. The default build includes the server, which needs a C compiler for the SQLite behind accounts; --no-default-features is the slim build that plans and talks to a server but is not one.
Next steps
- Quickstart: a project, the first SQL and a running server in a few minutes
- Running the server:
zsql serve, accounts, production - zsql CLI: the typical loop and every command