Revision history [back]

One possible approach to compressing larger BLOBs without inlining them is to use a database feature called "LOB storage." This feature allows database administrators to assign a separate storage area for large objects like BLOBs. These storage areas can have different compression settings from the main database, allowing for better compression ratios for BLOBs.

Another approach is to use external compression tools or libraries to compress the BLOBs before storing them in the database. This can be done using file compression tools like gzip or using database-specific compression libraries.

Finally, some databases offer built-in compression options that can be used for large objects like BLOBs. For example, Microsoft SQL Server has a feature called "PAGE compression" that can be used to compress large objects stored in the database. Other databases like Oracle and PostgreSQL also have similar compression options.