Re: [sqlite] BLOB Support

On Wed, Jun 16, 2010 at 10:04 AM, Teg wrote: > Hello Sam, > > I store multiple gigs of image files, some as large as 2-3 megs in > Sqlite DB's. For pretty much the same reason, the convenience of > having them in one package. For my requirements, extracting the images > from the

Re: [sqlite] BLOB Support

Hello Sam, I store multiple gigs of image files, some as large as 2-3 megs in Sqlite DB's. For pretty much the same reason, the convenience of having them in one package. For my requirements, extracting the images from the DB, and displaying them isn't a bottleneck. It's fast enough. Search

Re: [sqlite] BLOB Support

On Wed, Jun 16, 2010 at 8:34 AM, P Kishor wrote: > On Wed, Jun 16, 2010 at 7:23 AM, Andreas Henningsson > wrote: >> Do some testing to find out if it suits the application you develop. >> But just in general .. file systems are build to handle

Re: [sqlite] BLOB Support

On Wed, Jun 16, 2010 at 7:23 AM, Andreas Henningsson wrote: > Do some testing to find out if it suits the application you develop. > But just in general .. file systems are build to handle files, databases are > for handle data. > Well, at the risk of being

Re: [sqlite] BLOB Support

Do some testing to find out if it suits the application you develop. But just in general .. file systems are build to handle files, databases are for handle data. I don't think BLOB in SQlite will increasing the performance compared to store the files in the file system. Some SQlite APIs do not

Re: [sqlite] BLOB Support

for some reason, I remember you asking the same question not too long ago, and getting a bunch of answers. I recall chipping in with an answer myself. DIdn't any of those answers help? On Wed, Jun 16, 2010 at 1:58 AM, Navaneeth Sen B wrote: > Hi All, > I would like to

Re: [sqlite] BLOB Support

On 16 Jun 2010, at 8:14am, Navaneeth Sen B wrote: > I am using SQLite. > > Thanks > Sen > > ** > > On 6/16/2010 12:40 PM, Simon Slavin wrote: >> On 16 Jun 2010, at 7:58am, Navaneeth Sen B wrote: >> >>> 3. What is the difference produced in storing the

Re: [sqlite] BLOB Support

Hi Simon, I am using SQLite. Thanks Sen ** On 6/16/2010 12:40 PM, Simon Slavin wrote: > On 16 Jun 2010, at 7:58am, Navaneeth Sen B wrote: > > >>3. What is the difference produced in storing the file inside DB(not >> in blob format) and storing

Re: [sqlite] BLOB Support

On 16 Jun 2010, at 7:58am, Navaneeth Sen B wrote: > 3. What is the difference produced in storing the file inside DB(not > in blob format) and storing the same file in BLOB format in the DB? What tool are you expecting to use to store the file inside the DB ? Simon.

Re: [sqlite] BLOB support and SQLite 3.0

On Mon, 2003-12-15 at 09:37, D. Richard Hipp wrote: >(2) The ".dump" command will only show the binary data through >the first \000 character. If the binary data contains no >\000 characters, the ".dump" command might segfault. Add an SQL function like TOCHAR or something