Convert SQLITE to JSON

Turn SQLITE files into JSON files. One JSON file per table, named after it: an array with one object per row, with 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 JSON file for each table in your database.Each row becomes an object, with numbers and nulls typed.

  1. What you get

    One JSON file per table, named after the table. Each file holds an array with one object per row.

    Numbers come out as JSON numbers and nulls as JSON nulls, so the values keep their types.

  2. What it leaves behind

    Views are skipped. Only tables are written.

    Binary values become escaped text.

  3. When a conversion fails

    A table with text stored in a number column fails. A file that cannot be parsed stops with input_corrupted.

    To go the other way, use JSON to SQLITE.

SQLITE and JSON.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 · JSON

JSON

JSON, the data format of every API.

Extensions
.json
MIME type
application/json
Kind
Text and data

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

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

Questions.What people ask about SQLITE to JSON.

01OF 04

Yes. Each table becomes one JSON file named after it, with one object per row.

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

They become escaped text in the JSON file.

It stops with input_corrupted when the file could not be parsed.

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