Re: [sqlite] Comparison of SQLite applications for Mac

2008-05-06 Thread BareFeet
Dennis Cote wrote: >> 2. Know of another application that should be included. >> > You may want to include the free SQLite Manager add on for Firefox. > See > https://addons.mozilla.org/en-US/firefox/addon/5817 for additional > information. > > It provides a general database browser and editor

Re: [sqlite] PRAGMA journal_mode not implemented?

2008-05-06 Thread Scott Hess
On Tue, May 6, 2008 at 7:41 PM, D. Richard Hipp <[EMAIL PROTECTED]> wrote: >> Since PERSIST is likely to be faster than DELETE on >> most platforms, is there ever a reason *not* to use >> it? > > In PERSIST mode, you have two files associated with your database > instead of one. Whenever you

Re: [sqlite] Cannot get amalgamation built from CVS to compile

2008-05-06 Thread Matthew L. Creech
In the latest CVS, you should now also be able to do what you intended in the first place. Namely: ./configure make sqlite3.c I thought about it, and there's no good reason to inline the auto-generated config.h file in to the amalgamation like we were doing, so now it keeps it as an #include

Re: [sqlite] Porting into a microcontroller, minimum requirements

2008-05-06 Thread D. Richard Hipp
On May 6, 2008, at 8:43 PM, Andrew Cunningham wrote: > Hi, > > I was wondering if anyone has any basic guide lines on embedding > SQLite into > a microcontroller. For example, I am considering using an 8/16 bit > processor > with 1 MB flash, 1 MB SRAM and 2 GB data storage (SD card). Has

Re: [sqlite] PRAGMA journal_mode not implemented?

2008-05-06 Thread D. Richard Hipp
> > > Since PERSIST is likely to be faster than DELETE on > most platforms, is there ever a reason *not* to use > it? > In PERSIST mode, you have two files associated with your database instead of one. Whenever you move, copy, or rename the database file you *must* also move, copy or rename

[sqlite] Porting into a microcontroller, minimum requirements

2008-05-06 Thread Andrew Cunningham
Hi, I was wondering if anyone has any basic guide lines on embedding SQLite into a microcontroller. For example, I am considering using an 8/16 bit processor with 1 MB flash, 1 MB SRAM and 2 GB data storage (SD card). Has anyone ported this before to an embedded system without an OS? Thanks,

Re: [sqlite] PRAGMA journal_mode not implemented?

2008-05-06 Thread Bob Ebert
I've previously used the existence of a -journal file as a quick check to see if there were transactions in progress. With the new pragma that check doesn't work any more, so it's harder to know whether the DB was in a clean state at the last power off without looking inside the -journal file.

Re: [sqlite] PRAGMA journal_mode not implemented?

2008-05-06 Thread Richard Klein
Bob Ebert wrote: > Is journal_mode a future optimization? The atomic commit documentation > (http://sqlite.org/atomiccommit.html) as well as the pragma docs > (http://www.sqlite.org/pragma.html) make tantalizing references to this > potentially useful optimization, but I've searched the 3.5.1 and

[sqlite] PRAGMA journal_mode not implemented?

2008-05-06 Thread Bob Ebert
Is journal_mode a future optimization? The atomic commit documentation (http://sqlite.org/atomiccommit.html) as well as the pragma docs (http://www.sqlite.org/pragma.html) make tantalizing references to this potentially useful optimization, but I've searched the 3.5.1 and 3.5.8 sources and I

Re: [sqlite] Cannot get amalgamation built from CVS to compile

2008-05-06 Thread Samuel Neff
Matthew, Thanks! After deleting everthing and re-checking out from cvs, using the pre-build makefile worked great. Best regards, Sam On Tue, May 6, 2008 at 4:46 PM, Matthew L. Creech <[EMAIL PROTECTED]> wrote: > > If you want to create a generic amalgamation (without pre-defined > features

Re: [sqlite] multiple updates

2008-05-06 Thread David Bicking
For one sql statement try: update Contacts set age = case id when 1 then 30 when 2 then 30 when 3 then 20 when 4 then 10 end where id in (1,2,3,4); David --- On Tue, 5/6/08, cedric tuboeuf <[EMAIL PROTECTED]> wrote: > From: cedric tuboeuf <[EMAIL

[sqlite] problems with performance uclinux + sqlite

2008-05-06 Thread Jorge Pereira
Hi Folks, Somebody there use sqlite + uclinux + arm7? my problems it's about slow time on querys (select/update/insert), my env below! # sqlite 3.5.7 # options for build: ./configure --prefix=$PWD/outdir --disable-tcl --host=arm-elf --enable-static --enable-releasemode --enable-threadsafe #

Re: [sqlite] multiple updates

2008-05-06 Thread Jay A. Kreibich
On Tue, May 06, 2008 at 04:26:55PM -0400, cedric tuboeuf scratched on the wall: > Is there a way of doing that in one single shot : > UPDATE Contacts SET Age = 30 WHERE ID = 1; UPDATE Contacts SET Age = 30 > WHERE ID = 2; UPDATE Contacts SET Age = 20 WHERE ID = 3; UPDATE Contacts SET > Age = 10

Re: [sqlite] Cannot get amalgamation built from CVS to compile

2008-05-06 Thread Matthew L. Creech
On Tue, May 6, 2008 at 4:38 PM, Samuel Neff <[EMAIL PROTECTED]> wrote: > > we ran > > configure > make sqlite3.c > > and got an amalgamation with those types defined using unmodified sources > from CVS. Are you saying the types should not be defined? No - you got what I'd expect: #defines

Re: [sqlite] Cannot get amalgamation built from CVS to compile

2008-05-06 Thread Samuel Neff
On Tue, May 6, 2008 at 2:42 PM, Matthew L. Creech <[EMAIL PROTECTED]> wrote: > > > By default things like HAVE_GMTIME_R aren't defined, so you'd have to > add those to your CPPFLAGS or something if you wanted to build a > generic amalgamation with those features included. The datatypes that >

Re: [sqlite] multiple updates

2008-05-06 Thread P Kishor
On 5/6/08, cedric tuboeuf <[EMAIL PROTECTED]> wrote: > Is there a way of doing that in one single shot : > UPDATE Contacts SET Age = 30 WHERE ID = 1; UPDATE Contacts SET Age = 30 > WHERE ID = 2; UPDATE Contacts SET Age = 20 WHERE ID = 3; UPDATE Contacts SET > Age = 10 WHERE ID = 4; > > I knwo

[sqlite] multiple updates

2008-05-06 Thread cedric tuboeuf
Is there a way of doing that in one single shot : UPDATE Contacts SET Age = 30 WHERE ID = 1; UPDATE Contacts SET Age = 30 WHERE ID = 2; UPDATE Contacts SET Age = 20 WHERE ID = 3; UPDATE Contacts SET Age = 10 WHERE ID = 4; I knwo I can process one a the time, but I would like to know why my query

Re: [sqlite] Cannot get amalgamation built from CVS to compile

2008-05-06 Thread Matthew L. Creech
On Tue, May 6, 2008 at 11:22 AM, Brad House <[EMAIL PROTECTED]> wrote: > We ran into the same problem here. It seems as though maybe the > amalgamation is hand-edited for distribution to remove the contents > of the config.h to be system agnostic. When we built ours from CVS, > we just did

Re: [sqlite] Question about sqlite3_busy_timeout

2008-05-06 Thread Shane Harrelson
This may be fixed by ticket 3030: http://www.sqlite.org/cvstrac/tktview?tn=3030 On 5/6/08, Hans Guijt <[EMAIL PROTECTED]> wrote: > > Hi all, > > > I have a simple question: on my SQLite database I set > sqlite3_busy_timeout() to a generous 1 milliseconds, but sometimes > it doesn't wait _at

Re: [sqlite] Cannot get amalgamation built from CVS to compile

2008-05-06 Thread Brad House
We ran into the same problem here. It seems as though maybe the amalgamation is hand-edited for distribution to remove the contents of the config.h to be system agnostic. When we built ours from CVS, we just did the same hand-edit and packaged it and it compiled fine on the dozen or so OS's we

Re: [sqlite] Cannot get amalgamation built from CVS to compile

2008-05-06 Thread Matthew L. Creech
On Tue, May 6, 2008 at 10:49 AM, Samuel Neff <[EMAIL PROTECTED]> wrote: > > Is this related to a change in the CVS source or is there something we're > doing wrong in building the amalgamation? > > We're building the amalgmation on Fedora Core release 4 (Stentz), > 2.6.17-1.2142_FC4smp #1 SMP

[sqlite] Question about sqlite3_busy_timeout

2008-05-06 Thread Hans Guijt
Hi all, I have a simple question: on my SQLite database I set sqlite3_busy_timeout() to a generous 1 milliseconds, but sometimes it doesn't wait _at all_, but immediately returns with "database is locked". This seems to happen only when the database is recovering from a power failure; in

Re: [sqlite] Cannot get amalgamation built from CVS to compile

2008-05-06 Thread Darko Miletic
Samuel Neff wrote: > We're trying to build an amalgamation from CVS to use within our application > for the first time. However, when we try to compile we get an error on this > line: > > > #ifdef HAVE_STDINT_H > #include > #endif > > fatal error C1083: Cannot open include file: 'stdint.h':

Re: [sqlite] splite database under version control (subversion)?

2008-05-06 Thread Jay A. Kreibich
On Sun, May 04, 2008 at 10:36:47PM +0200, M. Emal Alekozai scratched on the wall: > Hi, > > In the BIG db I have worked on there is a table that log every insert/update > > on specific and important tables and a log of every sql statement execute > > but I haven't ever see a db under version

Re: [sqlite] import files with more than 2GB?

2008-05-06 Thread Dan
On May 6, 2008, at 3:38 PM, Michael Lackhoff wrote: > On 5 May 2008 at 11:50, D. Richard Hipp wrote: > >> The code to do an import is not part of the core SQLite, btw. It is >> part of the CLI. You can find the code by searching for "import" in >> the shell.c source file. > > I think I somehow

Re: [sqlite] import files with more than 2GB?

2008-05-06 Thread Michael Lackhoff
On 5 May 2008 at 11:50, D. Richard Hipp wrote: > The code to do an import is not part of the core SQLite, btw. It is > part of the CLI. You can find the code by searching for "import" in > the shell.c source file. I think I somehow managed to get it working. All I had to do is add this

Re: [sqlite] install on Mac

2008-05-06 Thread Stephen Tucker
No I'm not. Thanks for pointing this out, Tom Good god. Its there, under Terminal! On 06/05/2008, at 4:22 PM, BareFeet wrote: > Hi Stephen, > >> I'm a recent (4 days) convert from XP to Mac OS Leopard. What a >> great system > > Welcome aboard :-) > >> I've downloaded latest SQLite3 for Mac

Re: [sqlite] install on Mac

2008-05-06 Thread BareFeet
Hi Stephen, > I'm a recent (4 days) convert from XP to Mac OS Leopard. What a > great system Welcome aboard :-) > I've downloaded latest SQLite3 for Mac but it came as .bin not .dmg. Are you aware that SQLite is already installed in Mac OS X (SQLite version 3.4 in Leopard)? Tom BareFeet

Re: [sqlite] install on Mac

2008-05-06 Thread P Kishor
On 5/6/08, Stephen Tucker <[EMAIL PROTECTED]> wrote: > I'm a recent (4 days) convert from XP to Mac OS Leopard. What a great > system > > I've downloaded latest SQLite3 for Mac but it came as .bin not .dmg. > Can someone tell me how to install this? Run from "Terminal"? > > Apol if this is a

[sqlite] install on Mac

2008-05-06 Thread Stephen Tucker
I'm a recent (4 days) convert from XP to Mac OS Leopard. What a great system I've downloaded latest SQLite3 for Mac but it came as .bin not .dmg. Can someone tell me how to install this? Run from "Terminal"? Apol if this is a stupid question ___