Re: [sqlite] Putting images into SQLite.

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.

Re: [sqlite] Putting images into SQLite.

>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,

Re: [sqlite] Putting images into SQLite.

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

Re: [sqlite] Putting images into SQLite.

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?

Re: [sqlite] Putting images into SQLite.

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

Re: [sqlite] Putting images into SQLite.

>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

Re: [sqlite] Putting images into SQLite.

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.

Re: [sqlite] Putting images into SQLite.

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

Re: [sqlite] Putting images into SQLite.

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

Re: [sqlite] Putting images into SQLite.

>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 >

Re: [sqlite] Putting images into SQLite.

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

Re: [sqlite] Putting images into SQLite.

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

Re: [sqlite] Putting images into SQLite.

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

Re: [sqlite] Putting images into SQLite.

> > 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

Re: [sqlite] Putting images into SQLite.

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] Putting images into SQLite.

>From what I read, it is necessary to have a programmatic interface to put images into a database. True? --- 3.14159265358979323846264338327950 Let the spirit of pi spread 2884197169399375105820974944592307 all around the world!