Convert ZST to SQLITE

Turn ZST archives into SQLITE. The Zstandard layer is removed and the bytes inside are written as they were.

Converted in an isolated sandbox on our serversDeleted after 24 hours

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

Unpack a SQLite database from ZST.The Zstandard layer comes off. The database inside is written as it was.

  1. What you get

    One file. The Zstandard layer is removed and the bytes inside are written unchanged, so the tables, indexes and views in the SQLite database are the ones that went in.

    The result can use the extension sqlite, sqlite3 or db.

  2. What you must ask for

    Ask for the format you know is inside the ZST file. Anything else is refused. This conversion does not turn other kinds of data into a database. It takes the compression off a file that is already a SQLite database.

  3. When it stops

    The conversion stops with input_corrupted when the file could not be parsed. It stops with unsupported_elements when the file holds something the target cannot carry, or when some inputs cannot become the format the join takes.

    To go the other way, use SQLITE to ZST.

ZST and SQLITE.What each format is.

The formats

From · ZST

Zstandard

A single file compressed with Zstandard, fast to compress and to decompress.

Extensions
.zst
MIME type
application/zstd
Kind
Archives
To · 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

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

terminal
$ cv convert archive.zst archive.sqlite
$ cv convert archive.zst archive.sqlite

Questions.What people ask about ZST to SQLITE.

01OF 04

No. The bytes inside the ZST file are written as they were. Nothing in the tables, indexes or views is rewritten.

No. Ask for the format you know is inside. Anything else is refused.

No. This conversion has no options. It removes the Zstandard layer and returns one file.

The file holds something the target cannot carry, or some inputs cannot become the format the join takes. The conversion stops with unsupported_elements in that case.

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