On Mon, Mar 29, 2010 at 10:33:53AM -0500, P Kishor scratched on the wall:
> On Mon, Mar 29, 2010 at 10:26 AM, Simon Slavin <slav...@bigfraud.org> wrote:
> >
> > On 29 Mar 2010, at 3:36pm, Navaneeth Sen B wrote:
> >
> >> Does that mean it cannot support data sizes greater than 1TB.

> >> I would also like to know whether SQLite can handle *.mts* files(AVCHD).
> 
> Well, if by "SQLite can handle" the OP wants to know whether or not
> SQLite "can store" *.mts* files, then, yes... SQLite is capable of
> storing any binary blobs.

  Rows and BLOBs are limited to 2GB; less by default.  It isn't unusual
  for an MTS file to be larger than this.  So while there isn't a format
  issue, there is an environment issue.

  Personally, the idea of putting large MTS files into an SQLite
  database as BLOBs seems like a very Bad Idea.  If you just want
  single-file bundles, something like TAR or ZIP or some other generic
  "container" seems much more likely to work, but I still don't really
  see the point.  If you want a meta-filesystem (filesystem-in-a-file),
  find a product that does that.

   -j

-- 
Jay A. Kreibich < J A Y  @  K R E I B I.C H >

"Our opponent is an alien starship packed with atomic bombs.  We have
 a protractor."   "I'll go home and see if I can scrounge up a ruler
 and a piece of string."  --from Anathem by Neal Stephenson
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to