2.1. Database backend specifics

Most important issues when dealing with BLOBs using statement strings:

PROBLEM 1: Character escaping is required. This is costly for large data blocks.

PROBLEM 2: Entire SQL statement string needs to be created and then it should be sent in one go (is this true?). This not only costs more of memory and time but also complicates multithread access and makes user-visible feedback (e.g. using progress bar widget) for large data blocks hard to implement.

Alternative could be to use specific functions for given backends, where data is not copied but is transfered using IO streams. See below.