[23-07-2005 1:29, D. Richard Hipp escreveu]
On Fri, 2005-07-22 at 19:15 -0500, Shawn Walker wrote:
Is there a way to have sqlite to call a callback function to read in
strings and blobs?
No.
If your blobs are too big to fit in memory, perhaps you should
consider storing them each in a separate file and then store
just the filename in the database.
I'm currently using a version control system called monotone that
uses sqlite (http://venge.net/monotone).
Most of the time they store file deltas and most files are small,
but there are people that have ideas like using monotone to version
big binary files (there was even a person that wanted to use monotone
to version DVD ISOs :D ).
What I want to say with this is that it seems a use case where having
the possibility to minimize memory usage would be great for them when
handling this type of cases, as one of the advantages of monotone is
exactly having a single database file to hold all the version info.
You could argue that then sqlite is not the right database engine for
the job, but i would think that if sqlite isn't, then what is?
I'm not a monotone developer, just someone with limited info on some
of the sqlite problems they are facing.
Best Regards,
~Nuno Lucas
