as far as we all know, it can be done, in that, yes, blobs can be stored in SQLite.
As you yourself have realized, and as the creator of SQLite has confirmed, SQLite is not the right tool for that. That said, why don't you just do it and see what problem you encounter. That itself might be valid finding for your study and for those to whom you have to prove this unorthodox and inefficient application of SQLite. Good luck. On 3/17/07, Dimitris Servis <[EMAIL PROTECTED]> wrote:
Hello Richard, I have to admit you're right. Probably not any DBMS is the right tool for that... However I have to prove it can be done, though I of course favor a relational tables solution. thanks a lot!!!! -- dimitris 2007/3/18, [EMAIL PROTECTED] <[EMAIL PROTECTED]>: > > "Dimitris P. Servis" <[EMAIL PROTECTED]> wrote: > > Hi all, > > > > I want to do the following; save a set of 100-200 (or even more) binary > > files into a single DB file. The binary files are of 100-200 (or a bit > > more :-) ) MB each. > > SQLite is not really the right tool for that. > -- > D. Richard Hipp <[EMAIL PROTECTED]> > > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > > ----------------------------------------------------------------------------- > >
-- Puneet Kishor http://punkish.eidesis.org/ Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/ Open Source Geospatial Foundation http://www.osgeo.org/education/ --------------------------------------------------------------------- collaborate, communicate, compete ===================================================================== ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
