Shox96 is a compression technique for Short Strings. It can achieve upto 65% compression. This technique is available for compressing text columns in SQLite as loadable extension in the repository https://github.com/siara-cc/Shox96_Sqlite_UDF.
Output screenshot: https://github.com/siara-cc/Shox96_Sqlite_UDF/blob/master/output.png?raw=true To find out more about Shox96 click: https://github.com/siara-cc/Shox96 To find out how Shox96 works click: https://github.com/siara-cc/Shox96/blob/master/Shox96_Article_0_2_0.pdf?raw=true P.S.: The compressor and decompressor are built for short strings using less memory suitable for constrained environments such as Arduino Uno and ESP8266. So may not be as fast as Zip or GZip. Related projects: Sqlite3 Library for ESP32 https://github.com/siara-cc/esp32_arduino_sqlite3_lib Sqlite3 Library for ESP8266 https://github.com/siara-cc/esp_arduino_sqlite3_lib Sqlite3 Library for ESP-IDF https://github.com/siara-cc/esp32-idf-sqlite3 Storing compressed Shox96 text content in Arduino Flash Memory https://github.com/siara-cc/Shox96_Arduino_Progmem_lib Shox96 Compression Library for Arduino https://github.com/siara-cc/Shox96_Arduino_lib _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users