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

2008-05-31 Thread Mark Stewart
Jay A. Kreibich-2 wrote: > > Of course, I assume Mark wants to do this via code. That will > require poking around the shell code to see how the ".dump" command > is implemented within the command shell. > Yes, I'm trying to do this using the C API. I'll have a look through the .dump

Re: [sqlite] get the actual database size.

2008-05-31 Thread Aladdin Lampé
> From: [EMAIL PROTECTED] > Date: Fri, 30 May 2008 20:26:14 +0200 > Would sqlite3_analyzer work for you? > It produces both a human readable report as well as a table > definition and insert statements to feed to sqlite3 command > line tool. Where can we download the source of this tool "sqlite3

Re: [sqlite] Insert / Update images using MS VBScript

2008-05-31 Thread Lauri Ojansivu
2008/5/31 MoDementia <[EMAIL PROTECTED]>: > I have spent most of the day searching for examples in VBscript to add / > update an image into a database without luck. > > If anyone has a snippet of code they could share I would be most grateful. > > I have either an image as an object in the script a

[sqlite] SQLite3 file format

2008-05-31 Thread Aladdin Lampé
Hi! I remember a message from DRH about SQLite's roadmap for 2008, stating that the file format specification would be explained and released in itself. Are you still working on that? Thank you and have a nice day, Aladdin _ Carolin

Re: [sqlite] get the actual database size.

2008-05-31 Thread D. Richard Hipp
On May 31, 2008, at 6:54 AM, Aladdin Lampé wrote: > >> From: [EMAIL PROTECTED] >> Date: Fri, 30 May 2008 20:26:14 +0200 > >> Would sqlite3_analyzer work for you? >> It produces both a human readable report as well as a table >> definition and insert statements to feed to sqlite3 command >> line t

Re: [sqlite] SQLite3 file format

2008-05-31 Thread D. Richard Hipp
On May 31, 2008, at 7:41 AM, Aladdin Lampé wrote: > > Hi! > I remember a message from DRH about SQLite's roadmap for 2008, > stating that the file format specification would be explained and > released in itself. > Are you still working on that? Yes D. Richard Hipp [EMAIL PROTECTED]

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

2008-05-31 Thread John Stanton
I wonder why you do not just use a file in the first place. Sqlite caches data in memory so a file based database and memory based perform much the same. Mark Stewart wrote: > > > Jay A. Kreibich-2 wrote: > >> Of course, I assume Mark wants to do this via code. That will >> require poking

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

2008-05-31 Thread Mark Stewart
John Stanton-3 wrote: > > I wonder why you do not just use a file in the first place. Sqlite > caches data in memory so a file based database and memory based perform > much the same. > For this app, I didn't want to ask the user to enter a filename for a new document before they decided to

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

2008-05-31 Thread John Stanton
Mark Stewart wrote: > > John Stanton-3 wrote: > >>I wonder why you do not just use a file in the first place. Sqlite >>caches data in memory so a file based database and memory based perform >>much the same. >> > > > For this app, I didn't want to ask the user to enter a filename for a new >

Re: [sqlite] Insert / Update images using MS VBScript

2008-05-31 Thread MoDementia
Thanks for the reply. However I am restricted to VBscript rather than visual basic. I will try to convert the syntax but I'm not confident that all the functions will be available in VBscript. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lauri Ojansivu

Re: [sqlite] Insert / Update images using MS VBScript

2008-05-31 Thread Lauri Ojansivu
2008/6/1 MoDementia <[EMAIL PROTECTED]>: > Thanks for the reply. > However I am restricted to VBscript rather than visual basic. > > I will try to convert the syntax but I'm not confident that all the > functions will be available in VBscript. If you run into any problems, reply to this sqlite-use

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

2008-05-31 Thread Keith Goodman
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 to use. > > My problem has to do with how to pass mul

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

2008-05-31 Thread Bruce Robertson
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 to use. My problem has to do with how to pass multiple lines to a single command. I'm sure it's quite simple but I keep poking around n

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

2008-05-31 Thread Bruce Robertson
No, I'm trying to do what I said I'm trying to do. Pass a series of commands to a single sqlite action and get back all the results. Here's a little more representative example done as applescript. I'm trying to generalize it so I can use it with some other command line tools (FileMaker shell sc

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

2008-05-31 Thread Keith Goodman
On Sat, May 31, 2008 at 8:57 PM, Keith Goodman <[EMAIL PROTECTED]> wrote: > 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

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

2008-05-31 Thread Bruce Robertson
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 statement is as follows but I can't figure out how to set x to get there. A B C D set x="A\nB\nC\nD"; echo $x > On

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

2008-05-31 Thread Keith Goodman
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 statement is as follows but I can't fi