heuermh/eider

eider

Command line tools for DuckDB.

<br/

Photo from https://www.rayhennessy.com

Etymology

Steller's eider (Polysticta stelleri) is a migrating Arctic diving duck that breeds along the coastlines of Alaska. It is the rarest, smallest, and fastest flying of the eider species.

https://en.wikipedia.org/wiki/Steller%27seider

Hacking eider

Install

• JDK 17 or later, https://openjdk.java.net
• Apache Maven 3.6.3 or later, https://maven.apache.org

To build

$ mvn package

$ export PATH=$PATH:`pwd`/target/appassembler/bin

Using eider

Usage

$ eider --help
USAGE
  eider [-hV] [--preserve-whitespace] [--skip-history] [--verbose] [-i=<queryPath>] [-q=<query>] [-u=<url>] [-p=<String=String>]...
        [COMMAND]

OPTIONS
  -u, --url=<url>                    JDBC connection URL, defaults to "jdbc:duckdb:".
  -q, --query=<query>                Inline SQL query, if any.
  -i, --query-path=<queryPath>       SQL query input path, default stdin.
  -p, --parameters=<String=String>   Query template parameters, in KEY=VALUE format. Specify multiple times if necessary.
      --preserve-whitespace          Preserve whitespace in SQL query.
      --skip-history                 Skip writing query to history file.

-h, --help Show this help message and exit. -V, --version Print version information and exit.

COMMANDS help Display help information about the specified command. generate-completion Generate bash/zsh completion script for eider.

### SQL queries

SQL queries can be provided inline via the `-q`/`--query` option