Re: [sqlite] System.Data.Sqlite writing chunks to a BLOB

2012-10-18 Thread Mike King 
I'd missed that - The devil is always in the detail (cue Homer Simpson "DOH!")

Thanks again and sorry to be a nuisance


On 18 October 2012 14:35, Richard Hipp  wrote:
> On Thu, Oct 18, 2012 at 9:03 AM, Mike King  wrote:
>
>> At the moment it's difficult to tell but I envisage 3-4gb being the
>> maximum.
>>
>
> The maximum BLOB size in SQLite is 1GB.  So you would do well to store your
> images in separate files.
>
>
>>
>> Cheers,
>>
>> Mike
>>
>> On 18 October 2012 13:17, Joe Mistachkin  wrote:
>> >
>> > Mike King wrote:
>> >>
>> >> Thanks - sorry to be a pain but is this on the roadmap for the future?
>> >> (For the thing I'm playing with this is the difference between storing
>> >> images in the database or storing them in the filesystem).
>> >>
>> >
>> > Out of curiosity, what size images are you dealing with?  Unless they
>> > are really large, any efficiency gains from using incremental BLOB I/O
>> > would probably be minimal.
>> >
>> > Anyhow, I've created a ticket to track this feature request, here:
>> >
>> > http://system.data.sqlite.org/index.html/info/32d482b38b
>> >
>> > Now, it's on the roadmap; however, I'm not sure about the timeline of
>> > getting this implemented.
>> >
>> > --
>> > Joe Mistachkin
>> >
>> > ___
>> > sqlite-users mailing list
>> > sqlite-users@sqlite.org
>> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>
>
>
> --
> D. Richard Hipp
> d...@sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.Data.Sqlite writing chunks to a BLOB

2012-10-18 Thread Richard Hipp 
On Thu, Oct 18, 2012 at 9:03 AM, Mike King  wrote:

> At the moment it's difficult to tell but I envisage 3-4gb being the
> maximum.
>

The maximum BLOB size in SQLite is 1GB.  So you would do well to store your
images in separate files.


>
> Cheers,
>
> Mike
>
> On 18 October 2012 13:17, Joe Mistachkin  wrote:
> >
> > Mike King wrote:
> >>
> >> Thanks - sorry to be a pain but is this on the roadmap for the future?
> >> (For the thing I'm playing with this is the difference between storing
> >> images in the database or storing them in the filesystem).
> >>
> >
> > Out of curiosity, what size images are you dealing with?  Unless they
> > are really large, any efficiency gains from using incremental BLOB I/O
> > would probably be minimal.
> >
> > Anyhow, I've created a ticket to track this feature request, here:
> >
> > http://system.data.sqlite.org/index.html/info/32d482b38b
> >
> > Now, it's on the roadmap; however, I'm not sure about the timeline of
> > getting this implemented.
> >
> > --
> > Joe Mistachkin
> >
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.Data.Sqlite writing chunks to a BLOB

2012-10-18 Thread Mike King 
At the moment it's difficult to tell but I envisage 3-4gb being the maximum.

Cheers,

Mike

On 18 October 2012 13:17, Joe Mistachkin  wrote:
>
> Mike King wrote:
>>
>> Thanks - sorry to be a pain but is this on the roadmap for the future?
>> (For the thing I'm playing with this is the difference between storing
>> images in the database or storing them in the filesystem).
>>
>
> Out of curiosity, what size images are you dealing with?  Unless they
> are really large, any efficiency gains from using incremental BLOB I/O
> would probably be minimal.
>
> Anyhow, I've created a ticket to track this feature request, here:
>
> http://system.data.sqlite.org/index.html/info/32d482b38b
>
> Now, it's on the roadmap; however, I'm not sure about the timeline of
> getting this implemented.
>
> --
> Joe Mistachkin
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.Data.Sqlite writing chunks to a BLOB

2012-10-18 Thread Joe Mistachkin 

Mike King wrote:
> 
> Thanks - sorry to be a pain but is this on the roadmap for the future?
> (For the thing I'm playing with this is the difference between storing
> images in the database or storing them in the filesystem). 
> 

Out of curiosity, what size images are you dealing with?  Unless they
are really large, any efficiency gains from using incremental BLOB I/O
would probably be minimal.

Anyhow, I've created a ticket to track this feature request, here:

http://system.data.sqlite.org/index.html/info/32d482b38b

Now, it's on the roadmap; however, I'm not sure about the timeline of
getting this implemented.

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.Data.Sqlite writing chunks to a BLOB

2012-10-18 Thread Mike King 
Thanks - sorry to be a pain but is this on the roadmap for the future?
(For the thing I'm playing with this is the difference between storing
images in the database or storing them in the filesystem).

Cheers,


On 18 October 2012 11:23, Joe Mistachkin  wrote:
>
> Mike King wrote:
>>
>> That's great to know but is this supported in system.data.sqlite
>> or is there any plans to do so?
>>
>
> It's not being planned yet.
>
> --
> Joe Mistachkin
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.Data.Sqlite writing chunks to a BLOB

2012-10-18 Thread Joe Mistachkin 

Mike King wrote:
> 
> That's great to know but is this supported in system.data.sqlite
> or is there any plans to do so?
> 

It's not being planned yet.

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.Data.Sqlite writing chunks to a BLOB

2012-10-18 Thread Mike King 
That's great to know but is this supported in system.data.sqlite or is
there any plans to do so?

Cheers

On Thursday, 18 October 2012, Simon Slavin wrote:

>
> On 17 Oct 2012, at 11:59pm, Mike King >
> wrote:
>
> > I'm using the latest System.Data.Sqlite with c# and .Net 4.
> >
> > Is there any method of writing to a BLOB in byte array chunks rather
> > than in one big lump? (I can see how using SQLiteDataReader GetBytes I
> > can read a blob back in chunks).
>
> SQLite proves the equivalent routines:
>
> http://www.sqlite.org/c3ref/blob_open.html
> http://www.sqlite.org/c3ref/blob_write.html
> http://www.sqlite.org/c3ref/blob_close.html
>
> I don't know whether System.Data.Sqlite can call them but the underlying
> engine supports what you want.
>
> Simon.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org 
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] System.Data.Sqlite writing chunks to a BLOB

2012-10-17 Thread Simon Slavin 

On 17 Oct 2012, at 11:59pm, Mike King  wrote:

> I'm using the latest System.Data.Sqlite with c# and .Net 4.
> 
> Is there any method of writing to a BLOB in byte array chunks rather
> than in one big lump? (I can see how using SQLiteDataReader GetBytes I
> can read a blob back in chunks).

SQLite proves the equivalent routines:

http://www.sqlite.org/c3ref/blob_open.html
http://www.sqlite.org/c3ref/blob_write.html
http://www.sqlite.org/c3ref/blob_close.html

I don't know whether System.Data.Sqlite can call them but the underlying engine 
supports what you want.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.Sqlite writing chunks to a BLOB

2012-10-17 Thread Mike King 
Hi All,

I'm using the latest System.Data.Sqlite with c# and .Net 4.

Is there any method of writing to a BLOB in byte array chunks rather
than in one big lump? (I can see how using SQLiteDataReader GetBytes I
can read a blob back in chunks).

Best Regards,
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users