Downloads n/athis week

GitHub stars 0

Extension repository on GitHub

Extension descriptor (YAML)

A collection of virtual filesystems for working with scalars

Installing and Loading

INSTALL scalarfs FROM community;
LOAD scalarfs;

Example

LOAD scalarfs;

-- Read JSON from a variable
SET VARIABLE config = '{"debug": true, "port": 8080}';
SELECT * FROM read_json('variable:config');

-- Read CSV from inline content
SELECT * FROM read_csv('data+varchar:name,score
Alice,95
Bob,87');

-- Write query results to a variable
COPY (SELECT * FROM my_table WHERE active) TO 'variable:exported' (FORMAT json);
SELECT getvariable('exported');

About scalarfs

DuckDB's file functions (read_csv, read_json, COPY TO, etc.) expect file paths. scalarfs bridges the gap when your content is already in memory, allowing the same functions to work with:

Variables — Store data in DuckDB variables and read/write them as files Inline literals — Embed content directly in your queries without temporary files

Note: This extension was written primarily using Claude and Claude Code as an exercise in AI-driven development.

Added Functions