SQLiteCompress.jl

Author JuliaAPlavin
Popularity
0 Stars
Updated Last
5 Months Ago
Started In
February 2024

SQLiteCompress.jl

SQLite functions to compress/decompress data in the database.

They are created in just a few lines of code, thanks to SQLite.jl UDF interface and to TranscodingStreams.jl.

Basic usage:

using SQLiteCompress
import SQLite
using DBInterface: execute
using CodecZstd

db = SQLite.DB(":memory:")
register_compression!(db, (ZstdCompressor, ZstdDecompressor))
execute(db, """select decompress(compress("hello"))""")

Performs sanity and consistency check of the compressor-decompressor pair when registering.

Tests cover both happy paths and errors, for a range of codecs and for different SQLite.jl-compatible packages.

See https://aplavin.github.io/SQLiteCompress.jl/examples/notebook.html for benchmarks.

Used By Packages

No packages found.