VAULT_POST_COMPRESSION_QUERIES

Documentation for eth_defi.feed.database.VAULT_POST_COMPRESSION_QUERIES data.

VAULT_POST_COMPRESSION_QUERIES = {'full_text': "\n        SELECT DISTINCT compression\n        FROM pragma_storage_info('posts')\n        WHERE column_name = 'full_text'\n            AND segment_type = 'VARCHAR'\n            AND persistent\n    ", 'raw_payload': "\n        SELECT DISTINCT compression\n        FROM pragma_storage_info('posts')\n        WHERE column_name = 'raw_payload'\n            AND segment_type = 'VARCHAR'\n            AND persistent\n    "}

Per-column storage inspection queries for Zstandard-compressed post content.