Convert SQLITE to JSONL

Turn SQLITE files into JSONL files. One JSON Lines file per table, named after it, with one object per row and numbers and nulls typed.

Converted in an isolated sandbox on our serversDeleted after 24 hours

Drop SQLITE files on the dialor turn it to pick what to do

One JSONL file for each table.Every table in the database becomes its own file of JSON objects, one per row.

  1. What you get

    Each table is written to a separate JSONL file named after the table. Every row becomes one object on its own line, with the column names as keys.

    Numbers stay numbers and nulls stay nulls, so the values keep their types instead of turning into text.

  2. What is left out

    Views are skipped. Only tables produce files.

    Binary values become escaped text. If a table holds blobs, you get text in their place.

  3. When a conversion fails

    A table with text stored in a number column fails the conversion. Check that column before you convert.

    A file that cannot be parsed stops with input_corrupted. This happens when the file is not a readable database.

SQLITE and JSONL.What each format is.

The formats

From · SQLITE

SQLite Database

A whole relational database in one file. Tables, indexes and views.

Extensions
.sqlite .sqlite3 .db
MIME type
application/vnd.sqlite3
Kind
Text and data
To · JSONL

JSON Lines

JSON Lines, one JSON object per line, the format of logs and datasets.

Extensions
.jsonl .ndjson
MIME type
application/jsonl
Kind
Text and data

In your code.The same SQLITE to JSONL conversion through the API, for your app or your agent.

terminal
$ cv convert report.sqlite report/ --to jsonl
$ cv convert report.sqlite report/ --to jsonl

Questions.What people ask about SQLITE to JSONL.

01OF 04

One or more files. Each table gets its own JSONL file, named after the table.

No. Views are skipped, and only tables are written out.

Binary values become escaped text in the JSONL file.

Yes. JSONL to SQLITE goes the other way.

More conversions.Other ways in and out of SQLITE and JSONL.