System.Data.SQLite

Hi everyone. I have a database that stores large music files as BLOB fields. The problem is that the .net provider loads the entire BLOB field into memory which causes my application to to use too much memory (and eventually crash). Is there a way to tune the .net provider so that I can load and write BLOB fields in chunks ? If not - can I use some other method ? Thanks in advance Liron

Hi everyone Problerm solved. I'm using the chunking sqlite API functions directly. Here is the sample file for those of you who are interested. Liron

This question was also recored as feature request here. I'd like to get some feedback on the proposed patch (which is not tested at all) and maybe finish it and push for merging, if there is enough interest.

Hi The code is attached to my previous post. However - this is not a patch to the .net provider. I didn't have time to do this.. Instead I simply added a separate class for handling BLOB chunking. I think that the .net provider is incomplete without support for BLOB chunking of some sort, but I understand that its all about priorities and effort. If you have the time and the know-how to do this properly then I think it will be a very positive addition. Liron