qvd – DuckDB Community Extensions

Search Shortcut cmd + k | ctrl + k

Documentation

qvd

Downloads n/athis week

GitHub stars 0

Extension repository on GitHub

Extension descriptor (YAML)

Read (streaming) and write Qlik QVD files

Maintainer(s): snouhaud

Installing and Loading

INSTALL qvd FROM community;
LOAD qvd;

Example

INSTALL qvd FROM community;
LOAD qvd;

-- Read (streaming, bounded memory)
SELECT * FROM read_qvd('sales.qvd');
SELECT * FROM read_qvd('data/*.qvd');         -- glob

-- Write
COPY (SELECT * FROM sales) TO 'output.qvd' (FORMAT qvd, FIELD_NAMES (a, b));

-- Import
COPY sales FROM 'output.qvd' (FORMAT qvd);

About qvd

100% Rust extension to read and write Qlik QVD files.

Streaming read (bounded memory, ~30-40x less than a naive read) with native typing BIGINT/DOUBLE/VARCHAR/DATE/TIMESTAMP/TIME/ INTERVAL, projection pushdown and multi-file glob.
COPY ... TO (FORMAT qvd) write with FIELD_NAMES option, and COPY tbl FROM 'x.qvd' (FORMAT qvd) import.