As others have said, there are lots of ways to store the image data directly
in the DB with BLOBs, encoding, etc. Alternatively, you could store the
pics separate from the DB and just store the path to the pic file in the DB.
-Shane
On Sun, Dec 6, 2009 at 8:35 PM, Ted Rolle, Jr. wrote:
> Fro
>Could you please give me a step by step on how to do that? Not via a
>small program written in a programming language, but only via the
>sqlite3 shell, as both you and I agree that was the implied intent of
>the OP's question.
Sorry, I'm no vxWorks, Unix, Linux, MacOS, Windows, AS400, Symbian,
On Mon, Dec 7, 2009 at 9:55 AM, Jean-Christophe Deschamps
wrote:
> Hi Puneet,
>
>>Yes, that seems like a reasonable interpretation of the OP's question,
>>one I also understood. One thing I don't understand though,
>>Jean-Christophe, even though one can enter base64 encoded "images"
>>into the db
Hi Puneet,
>Yes, that seems like a reasonable interpretation of the OP's question,
>one I also understood. One thing I don't understand though,
>Jean-Christophe, even though one can enter base64 encoded "images"
>into the db via the sqlite shell, how does one create the base64
>encoded images? One
On Mon, Dec 7, 2009 at 9:15 AM, Jean-Christophe Deschamps
wrote:
>
>>What is "programatically"
>>
>>How, in any meaningful way, is this different than running a shell
>>command (program of an extremely brief size)?
>
> I took the OP's phrasing to mean that he needed a way to do it with
> e.g. com
>What is "programatically"
>
>How, in any meaningful way, is this different than running a shell
>command (program of an extremely brief size)?
I took the OP's phrasing to mean that he needed a way to do it with
e.g. command-line available programs, but in any case without having to
use a prog
Hello Bruce,
Monday, December 7, 2009, 1:20:10 AM, you wrote:
BR> On Dec 6, 2009, at 6:17 PM, Jean-Christophe Deschamps wrote:
>> I was simply replying to the OP's actual question:
>>
> From what I read, it is necessary to have a programmatic interface to
> put images into a database.
On Dec 6, 2009, at 6:17 PM, Jean-Christophe Deschamps wrote:
> I was simply replying to the OP's actual question:
>
From what I read, it is necessary to have a programmatic interface to
put images into a database. True?
>
> So, no, it isn't _necessary_ (but recommended).
What is "p
Hello Ted,
Sunday, December 6, 2009, 8:35:34 PM, you wrote:
>>From what I read, it is necessary to have a programmatic interface to
TRJ> put images into a database. True?
TRJ> ---
TRJ>
TRJ> 3.14159265358979323846264338327950 Let
>You are correct. You proved that it is possible.
>
>part 2: What are the usual and convenient ways of inserting images
>into a sqlite db? answer: Programmatically.
I certainly don't dispute this, and I added to this effect:
> It may not be the prefered way in most application, but it's
> none
>Base64? Then just add it with an .import statement?
>I thought about that with MIME encoding.
No need to use any fancy base64, just plain hex will do.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listin
On Sun, Dec 6, 2009 at 8:07 PM, Jean-Christophe Deschamps
wrote:
>
>> > From what I read, it is necessary to have a programmatic interface to
>> > put images into a database. True?
>>
>>yes, but I am not sure what other kind of interface there could be?
>>You can't imagine putting an image into
On 7 Dec 2009, at 2:09am, Ted Rolle, Jr. wrote:
> Stephan Wehner wrote:
>
> Base64? Then just add it with an .import statement?
> I thought about that with MIME encoding.
On a Mac I've used a script piping the result of the 'hexdump' into commands
for the sqlite3 command-line tool. But it w
On Sun, 6 Dec 2009 17:57:06 -0800
Stephan Wehner wrote:
Base64? Then just add it with an .import statement?
I thought about that with MIME encoding.
Ted
---
3.14159265358979323846264338327950 Let the spirit of pi spread
28841971
> > From what I read, it is necessary to have a programmatic interface to
> > put images into a database. True?
>
>yes, but I am not sure what other kind of interface there could be?
>You can't imagine putting an image into a sqlite db through the
>command line shell application. Of course, you c
On Sun, Dec 6, 2009 at 5:38 PM, P Kishor wrote:
> On Sun, Dec 6, 2009 at 7:35 PM, Ted Rolle, Jr. wrote:
>> From what I read, it is necessary to have a programmatic interface to
>> put images into a database. True?
>>
I've been finding it convenient to use Base64 encoding when storing binary dat
On Sun, Dec 6, 2009 at 7:35 PM, Ted Rolle, Jr. wrote:
> From what I read, it is necessary to have a programmatic interface to
> put images into a database. True?
>
..
yes, but I am not sure what other kind of interface there could be?
You can't imagine putting an image into a sqlite db through t
17 matches
Mail list logo
