Read JASP project files (.jasp) as SQL tables — data, column metadata and analysis registry
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 jasp_ext FROM community;
LOAD jasp_ext;
About jasp_ext
The jasp_ext extension reads JASP project files (.jasp) directly as SQL tables.
A .jasp file is a ZIP archive containing internal.sqlite (the real data), analyses.json
(analysis registry) and resources/N/jaspResults.json (per-analysis results). Data lives in
DataSet / DataSet_N tables where every logical column is stored as a pair of physical
columns (Column_{id}_DBL value, Column_{id}_INT categorical code). The extension maps
these back to logical typed columns:
| JASP column type | DuckDB type | source |
|---|---|---|
| scale | DOUBLE |
_DBL REAL value, nan → NULL |
| ordinal | DOUBLE |
_DBL code |
| nominal | VARCHAR | Labels[_INT] |
| nominalText | VARCHAR |
_DBL text value |
Table functions:
| function | description |
|---|---|
read_jasp(path) |
all data rows (typed), from the default DataSet |
read_jasp(path, dataset) |
a specific DataSet_N
|
read_jasp_columns(path [, dataset]) |
column metadata (id, name, columnType) |
read_jasp_analyses(path) |
one row per registered analysis |
Example:
SELECT * FROM read_jasp('/path/to/project.jasp');
SELECT * FROM read_jasp_columns('/path/to/project.jasp');
SELECT * FROM read_jasp_analyses('/path/to/project.jasp');
Install: INSTALL jasp_ext FROM community;
Source: alitrack/duckdb_jasp
Added Functions
| function_name | function_type | description | comment | examples |
|---|---|---|---|---|
| read_jasp | table | NULL | NULL | |
| read_jasp_analyses | table | NULL | NULL | |
| read_jasp_columns | 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 | typed_value |
|---|---|---|---|---|---|
| temp_directory | Set the directory to which temporary files are written. | VARCHAR | GLOBAL | [] | post.db.tmp |