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
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
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
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
>
>
> 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
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,
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.
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
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
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
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
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
#
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
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
>
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
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
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
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
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
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
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
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':
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
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
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
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
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
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
___
28 matches
Mail list logo
