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 lin
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 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 contr
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': No such file or
directory
We tracked ba
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': No
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 othe
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 i
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 di
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 a
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 the
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
i
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 I
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
> are
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 ad
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 WHE
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
# cat
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 PR
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 l
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 can't
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
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.
An
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,
An
>
>
> 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
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
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 tha
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 move,
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
Hi Dimitri,
thank you for the tipp.
No I found out, what the problem is. It was a permission problem.
There was no corresponding message, but using another PREFIX for the libraries
solved the problem.
Thank you.
BR
Martin
-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL
28 matches
Mail list logo