Join GitHub today
GitHub is home to over 50 million developers working together to host and review code, manage projects, and build software together.
Sign upGitHub is where the world builds software
Millions of developers and companies build, ship, and maintain their software on GitHub — the largest and most advanced development platform in the world.
Decompression of blobs #4979
Decompression of blobs #4979
Comments
|
Sound too specific. There are dozens of different compression algorithms moreover it is not clear how particular data types should be compressed (e.g. numbers, timestamps) - in some binary format, plain text or somehow else. |
The most popular are: deflate, lzma, lzma2, brotli, zstd. Data stream type can be either determined by header, or can be provided (some compression libs allow to put raw data without any container headers).
Compression algorythms usually work on binary data. So the transformation proposed is |
|
I think this can be easily (relatively) implemented as a custom value transformer ( |
serge-rider
added
feature request
help wanted
good first issue
and removed
question
labels
|
I'd like to tackle this issue if it is still relevant. |
|
Is this issue still open? |
Sometimes it is needed to store compressed data in the DB. Unfortunately not all the DBs have built-in compression and FUSE compressed FSes are not available for every OS. So it may make sense to store compressed binary blobs in the DB.
Unfortunately when one sees them in DBeaver he sees them compressed, but often they are needed uncompressed. So it'd be nice to have a feature to decompress the contents of certain columns.
This may be done by injecting an external function into SQL doing decompression.