Utilities

Command-line scripts for building and preparing SQLite files for SQLite Browser.

SQLite Browser opens existing SQLite files. Use these scripts in utilities/ when you need to create one from your data, merge several into one, or add extra columns before browsing.


Creating an SQLite file directly from a BIDS dataset

Index a BIDS dataset with bids2table, including JSON sidecar metadata, into a SQLite file using bids2db.py.

Concatenating SQLite files

Use db_concatenate.py to stack the same table from several SQLite files into one.

Enriching an SQLite database with a TSV join

Use db_join.py to join a TSV or CSV file into an existing SQLite database table.

Creating an SQLite file from Parquet files

Convert Parquet files into a browsable SQLite database using parquets2db.py.