Re: [sqlite] Putting images into SQLite.

2009-12-06 Thread Bruce Robertson
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] Local data structures vs sqlite

2009-11-05 Thread Bruce Robertson
On Nov 5, 2009, at 5:44 PM, Jean-Christophe Deschamps wrote: > Hi John, > >> I wouldn't use SQLite for most in memory data that never needs to be >> stored on disk > > Even this depends entirely on your context. Of course if only a > simple > lookup in a table is more or less all you ever

Re: [sqlite] LAN and exclusive lock

2009-10-21 Thread Bruce Robertson
I'm addicted to amazingly powerful solutions done in minutes; using the one-stop-shopping Lowe's Hardware of data solutions has its own addictive powers. Depends on how you value your time. On Oct 21, 2009, at 9:58 AM, Jan wrote: > thx bruce, but I am addicted to open-source. > &

Re: [sqlite] "Bad CPU type in executable"?

2009-08-05 Thread Bruce Robertson
Exactly. > Thank you both. Sorry about the top-posting - my experience on other > lists is that top-posting is preferred. > > Jimmy Verner > www.vernerlegal.com > >> >> You're top-posting, it's evil, the thread is becoming messy. That >> said... >> >> It's apparent your DB3 file is the

Re: [sqlite] Updating a database by email

2009-07-12 Thread Bruce Robertson
> We use a system of updating an Sqlite database buit use port 80 to send > data in XML format. > > Is there a reason you have access to the email port and not the HTTP > port 80? It is very complex to identify a missing email but using port > 80 and HTTP the process is almost trivial > > Our

Re: [sqlite] prepare peformances

2008-06-09 Thread Bruce Robertson
//Binds variables > > sqlite3_step//Executes statement > > sqlite3_reset //Readies compiled statement for binding to vars > until finished > sqlite3_finalize //Destroys compiled statement > sqlite3_close > > > Bruce Robertson wrote: &g

Re: [sqlite] prepare peformances

2008-06-09 Thread Bruce Robertson
Can somebody point me to documentation or examples of sqlite prepare statements and their purose? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] graph question

2008-06-09 Thread Bruce Robertson
> David Baird wrote: >> >> Okay, just built SQLite 3.5.9 and group_concat does in fact work: >> >> select group_concat(t, ' ') from w where f=1; > > You forgot the parent value at the beginning. Also, the OP may want to > do this for several parents which can be accomplished by grouping the

[sqlite] SQLite Analyzer OSX

2008-06-01 Thread Bruce Robertson
I see that SQLite3 Analyzer for OSX is listed on the download page but no instructions are provided and when unzipped it does nothing. What are we supposed to do with this? ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Saving an in-memory database to file

2008-06-01 Thread Bruce Robertson
>> On Sat, May 31, 2008 at 9:48 PM, Bruce Robertson <[EMAIL PROTECTED]> wrote: >>> Here's a more basic example. This is really just a shell script formatting >>> problem and it must be really simple. I'm trying to use \n as new line. The >>> result I wan

Re: [sqlite] Saving an in-memory database to file

2008-06-01 Thread Bruce Robertson
> On Sat, May 31, 2008 at 9:48 PM, Bruce Robertson <[EMAIL PROTECTED]> wrote: >> Here's a more basic example. This is really just a shell script formatting >> problem and it must be really simple. I'm trying to use \n as new line. The >> result I want from the echo st

Re: [sqlite] Saving an in-memory database to file

2008-05-31 Thread Bruce Robertson
;; echo $x > On Sat, May 31, 2008 at 8:30 PM, Bruce Robertson <[EMAIL PROTECTED]> wrote: >> An example of how to do this with the shell would be helpful. >> >> Oddly enough I can do it with applescript; but I can't do it with some other >> shell tools I'm trying t

Re: [sqlite] Saving an in-memory database to file

2008-05-31 Thread Bruce Robertson
recIDNamestatusMarker 1 one 3 2 Line A Line B Line C 3 22 tw22o 12 Record IDNAME 1 one 2 Line A Line B Line C 22 tw22o recID = 2 Name = Line A Line B Line C statusMarker = 3 recID = 1 Name = one statusMarker = 3 recID = 22 Name = tw22o statusMark

Re: [sqlite] Saving an in-memory database to file

2008-05-31 Thread Bruce Robertson
t; VALUES('36780001', '02.1.02', '', '2000', '3'); Etc > On Fri, May 30, 2008 at 09:24:29PM -0700, Bruce Robertson scratched on the > wall: >> Well, an interesting illustration of basic sqlite; but no relation to the >> question being asked. > > Actually, it is a good ans

Re: [sqlite] Saving an in-memory database to file

2008-05-30 Thread Bruce Robertson
Well, an interesting illustration of basic sqlite; but no relation to the question being asked. > On 5/30/08, Mark Stewart <[EMAIL PROTECTED]> wrote: >> >> Is there a recommended way to save an in-memory database to a file? Is >> there >> a way to access the underlying in-memory data