[yunqa.de] Re: Store compressed brotli bytes in sqlite

  • From: Delphi Inspiration <delphi@xxxxxxxx>
  • To: yunqa@xxxxxxxxxxxxx
  • Date: Fri, 29 Jan 2021 09:53:57 +0100

On 28.01.2021 19:55, lucdesa@xxxxxxxxxx wrote:

Is there a way to store a compressed brotli tbytes in sqlite with disqlite ?

Yes. DISQLite3 can store any type of binary data, including brotli compressed TBytes. Like for most other databases, the SQLite data type for binary data is BLOB (binary large object).

There are a few SQLite Delphi projects in the DISQLite3 Demo directory which involve BLOB operations:

  - DISQLite3_BLOB_and_Streams
  - DISQLite3_Incremental_Blob
  - DISQLite3_Image_Bitmap
  - DISQLite3_RichEdit

For BLOB documentation, search the the DISQLite3.chm for "BLOB".

Delphi Inspiration mailing list

Other related posts: