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. > > SQLite can handle whatever your file system can handle. Probably 4TB, if > your OS will handle that much. However there are a number of limits involved > in what it does. You're probably interested in sections 12 and 13 of > > http://www.sqlite.org/limits.html > >> Can somebody explain me the meaning of terabyte scalability with respect >> to DB's. > > The question is too vague for me. You're going to have to explain what you > want to do. > >> 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. It doesn't care whether they are video or music or any other binary format, no matter how vague or obscure or digitally restricted it might be. > SQLite is a database system which reads and writes its own database files, > which contain data of various types. AVCHD files are video files which > contain video information. Due to restrictions on the licensing associated > with AVCHD you may not extract AVCHD information and use it as data in other > files, licensed tools will handle it only if it's in a file of its own. So > even though SQLite (and many other DBMSs) could conceivably handle AVCHD data > as BLOBs, the tools should refused to handle raw data. > > Again, what is it you actually want to do ? > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Puneet Kishor http://www.punkish.org Carbon Model http://carbonmodel.org Charter Member, Open Source Geospatial Foundation http://www.osgeo.org Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor Nelson Institute, UW-Madison http://www.nelson.wisc.edu ----------------------------------------------------------------------- Assertions are politics; backing up assertions with evidence is science ======================================================================= _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
