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 DB, and displaying
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 speed
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 files, databases are
>> for handle data.
>>
>
> Well,
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 pedantic, you say files I say data (sun
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 s
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 know more about this BLOB su
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 fil
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 th
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.
_
Hi All,
I would like to know more about this BLOB support in SQLite. Some of my
queries are:
1. One of my colleague suggested that using BLOB support for storing
images in the DB is a good idea, whereas storing AVCHD data(huge
size) as blobs is not a good idea. I need a bit more cl
SQLite supports the blob datatype, but one can access a blob value only
as a whole. Is support planned to partially read or write a blob value?
For example in an Oracle database one can select a blob reference from a
table and can then operate on this blob reference: reading or writing
parts of
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 like
Mrs. Brisby wrote:
[...] I really would like to see user-defined "structures"- but I
suspect this will have to wait for SQLite 3.0 or whenever we get
non-null-terminating values...
You can do that now. The (experimental) sqlite_bind() API available
in 2.8.7 allows you to insert arbitrary binary da
13 matches
Mail list logo