Skip to main content

A command line client to duckdb

Project description

gadwall - Command Line Client to duckdb

gadwall is a pure Python based command line to duckdb

image from wikimedia

Usage

$ python -m gadwall stocks.ddb 
Welcome to the gadwall, a duckdb shell. Type help or ? to list commands.

duckdb> ?

Documented commands (type help <topic>):
========================================
db  help  quit  schema

Undocumented commands:
======================
EOF

duckdb> db
stocks.ddb
duckdb> schema
stocks
duckdb> schema stocks
0 date TIMESTAMP False None False
1 symbol VARCHAR False None False
2 open FLOAT False None False
3 high FLOAT False None False
4 low FLOAT False None False
5 close FLOAT False None False
6 adj_close FLOAT False None False
7 volume INTEGER False None False
duckdb> SELECT symbol, MAX(close) FROM stocks GROUP BY symbol;
GOOG 1827.989990234375
MSFT 231.64999389648438
ORCL 65.30000305175781
duckdb> quit

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

gadwall-0.2.0.tar.gz (3.2 kB view hashes)

Uploaded source

Built Distribution

gadwall-0.2.0-py3-none-any.whl (3.4 kB view hashes)

Uploaded py3

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Huawei Huawei PSF Sponsor Microsoft Microsoft PSF Sponsor NVIDIA NVIDIA PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page