SQLite integration

The SQLite integration combines SQLite‘s transactional storage with TsFile’s compression for historical time-series data. Applications read and write through a logical table: mutable data stays in SQLite, while sealed data is stored in TsFile and remains queryable through the same table.

Features

• Create a writable table with a declared schema, or initialize one from an existing TsFile.
• Seal data into TsFile through SQL. Sealed rows remain readable but cannot be updated or deleted.
• Query an existing TsFile as a read-only table.
• Export a table to an independent TsFile, including its hot data.

Documentation and source

For build instructions, SQL examples, and transaction semantics, see the user guides:

• English user guide
• 中文使用手册
• Source code
• Mailing-list discussion