Search Shortcut cmd + k | ctrl + k
quackstore

QuackStore - Smart Block-Based Caching for Remote Files. Speed up repeated queries on remote data with intelligent block-level caching.

Compatibility Matrix

This table covers all DuckDB releases that have not reached end-of-life, including LTS releases, and shows the 2 most recent patch releases of each. Older patch releases are not listed, but the extension may be available for them as well.

Platform 1.4.4 1.4.5 1.5.5 1.5.6 2.0.0
Linux AMD64
Linux ARM64
macOS AMD64
macOS ARM64
Windows AMD64
Windows ARM64
WebAssembly

Installing and Loading

INSTALL quackstore FROM community;
LOAD quackstore;

About quackstore

See README.md

Added Functions

function_name function_type description comment examples
quackstore_clear_cache table NULL NULL  
quackstore_evict_files table NULL NULL  

Overloaded Functions

This extension does not add any function overloads.

Added Types

This extension does not add any types.

Added Settings

name description input_type scope aliases
quackstore_cache_enabled Turn cache ON or OFF BOOLEAN GLOBAL []
quackstore_cache_path Cache path VARCHAR GLOBAL []
quackstore_cache_size Cache size (bytes) UBIGINT GLOBAL []
quackstore_data_mutable Whether data is mutable (affects cache invalidation) BOOLEAN GLOBAL []