this agreement. For questions on how to compile and use CEROD,
please use the same email address that you used to enter into the NDA
in the first place. Thank you.
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
have a C program you can post that demonstrates the problem?
>>>
>>> Dan.
>>>
>>>
>>>
>>> ~/sqlite/tipbld$ ./sqlite3
>>> SQLite version 3.6.20
>>> Enter ".help" for instructions
>>> Enter SQL statements terminated with a ";"
>>> sqlite> CREATE TABLE foo(i text);
>>> sqlite> INSERT INTO foo VALUES('a');
>>> sqlite> INSERT INTO foo VALUES('B');
>>> sqlite> INSERT INTO foo VALUES('c');
>>> sqlite> CREATE VIEW foo_view AS SELECT i FROM foo;
>>> sqlite> SELECT i FROM foo ORDER BY i COLLATE nocase;
>>> a
>>> B
>>> c
>>> sqlite> SELECT i FROM foo_view ORDER BY i COLLATE nocase;
>>> a
>>> B
>>> c
>>> sqlite> SELECT i FROM foo ORDER BY i;
>>> B
>>> a
>>> c
>>> sqlite> SELECT i FROM foo_view ORDER BY i;
>>> B
>>> a
>>> c
>>> sqlite>
>>>
>>>
>>>
>>> ___
>>> sqlite-users mailing list
>>> sqlite-users@sqlite.org
>>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>>
>>
>>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
D. Richard Hipp
d...@hwaci.com
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
e data
> is not reflected in the table after the update statement is
> complete. I
> didn't look at the vdbe.
> anyone seen this behavior?
>
> thanks
> ___
> sqlite-users mailing list
> sq
turn? 1, 2, or 3?
D. Richard Hipp
[EMAIL PROTECTED]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
table implementation (other than the
ones
that are included with SQLite - such as FTS1-3) that will be broken
by an
API change, please let me know. And please also advice me how much of
a hardship a change would be for you.
D. Richard H
, it is often
a good idea to run your GUI in a separate process from your
compute engine so that long computations don't free the display.
D. Richard Hipp
[EMAIL PROTECTED]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
l to [EMAIL PROTECTED]
------
---
D. Richard Hipp
[EMAIL PROTECTED]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
NOT operator '~' have the highest precedence?
SQLite version 3.5.2
Enter ".help" for instructions
sqlite> select ~1 - ~5;
-8
sqlite> select (~1) - (~5);
4
That would be a bug in lemon...
D. Richard Hipp
[EMAIL PROTECTED]
-
On Nov 17, 2007, at 5:12 PM, D. Richard Hipp wrote:
On Nov 17, 2007, at 4:58 PM, Joe Wilson wrote:
I'm having difficulty with Lemon's operator precedence.
That would be a bug in lemon...
I was wrong. Turns out the bug was in the SQLite grammar
file parse.y. It was assignin
erator precedence as the SQL standard
requires. If I am wrong about that, please correct me and I will
change it.
On the other hand, changing the operator precedence to agree with
MySQL or MSSQL is not something we are interested in doing if they
are using a non-standard precedence.
D. Richar
system.
On Linux systems that typically use Doug Lea's malloc, there is
no measurable performance difference. But I have had some
people running embedded systems tell me that using the
malloc-free SQLite results in a significant speed boost. Your
mileage may vary.
D. Richard Hipp
[EMAIL PROT
On Nov 19, 2007, at 12:36 PM, James Dennett wrote:
-Original Message-
From: John Stanton [mailto:[EMAIL PROTECTED]
Sent: Monday, November 19, 2007 7:36 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Memory Usage
Not only applicable to real time systems. If you want a program to
connection. SQLite
contains its own mutexes to serialize access.
D. Richard Hipp
[EMAIL PROTECTED]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
same database within the same process
and use them independently and locking should work correctly. You
should not have to change anything. It should just work.
D. Richard Hipp
[EMAIL PROTECTED]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
ng like 30 ms.
Tried to index also 'ModifiedDate' but it didn't help.
What am i doing wrong?
Thanks,
Ofir Neuman.
D. Richard Hipp
[EMAIL PROTECTED]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
ously here.
D. Richard Hipp
[EMAIL PROTECTED]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
ze a GLOB where the right parameter is
a literal string. It will not do so if the right parameter is a
parameter. http://www.sqlite.org/optoverview.html#like_opt
D. Richard Hipp
[EMAIL PROTECTED]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
nt is sometimes imperfectly executed, but it is my goal.
If that means that SQLite is uncompetitive, then so be it.
D. Richard Hipp
[EMAIL PROTECTED]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
SQLite is very thorough, but I have found that users
can be very creative in stressing SQLite in ways that I would
have never imagined, and have not developed tests for.
D. Richard Hipp
[EMAIL PROTECTED]
-
To unsubscribe
test SQLite and the thoroughness of the test suite. Not much
is likely to slip through the cracks.
D. Richard Hipp
[EMAIL PROTECTED]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
work on and less error prone. An entire class of errors (stack
overflow) such as the recent ticket #2832 (which could cause
database corruption) will become impossible since the VM will
no longer have a stack to overflow.
D. Richard Hipp
[EMAIL PROTECTED
On Jan 13, 2008, at 7:53 PM, Gerry Snyder wrote:
Joe Wilson wrote:
--- "D. Richard Hipp" <[EMAIL PROTECTED]> wrote:
There are people on this mailing list (ex: Joe Wilson) who appear
to read every line of every change that we make to SQLite, within
minutes of making them,
is reason. But sometimes, when you want the
text of your SQL statement to be under program control, you want
to use "..." instead. Just be very sure you know exactly what you
are doing whenever you use "..."
D. Richard Hipp
[EMAIL PROTECTED]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
]
--
---
D. Richard Hipp
[EMAIL PROTECTED]
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
This is the initial test message for the new SQLite mailing list, using
GNU mailman now instead of ezmlm.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite
ver implemented it, having never seen any benefit
for such a thing. Can you explain why you think strict affinity mode
might be beneficial to you? If somebody can provide a good
enough rational to justify strict affinity mode, we might just put it
ntil you login. Userid="anonymous"
Password="anonymous". Then click on the link again.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
o instead of saying:
sqlite3_prepare $::DB ...
we can now say:
sqlite3_prepare db ...
which is much more convenient. However, the test scripts have been
generated incrementally over the past 8 years and most of them have not
been upgraded to take advantage of the ne
ewer
database with an historic version of SQLite - that would be
forwards compatibility. SQLite is generally forwards compatible,
except when the newer database uses features which were
added later.
The added feature is probably a descending index.
D. Richard Hipp
[EMAIL PROTECTED]
_
m all tomorrow.
But mem5 is high on the list of memory allocators to keep
since it can, under some circumstances, guarantee not to
fragment memory, which is a desirable property for
embedded systems.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-us
On Apr 1, 2008, at 2:37 PM, Richard Klein wrote:
>>
> Fair enough. But can I assume that mem5 *does* currently
> work, as far as you know? (I'd really like to use it, as
> I'm using SQLite on an embedded system.)
>
mem5 works as far as I know.
D. R
s to the db inside callback
>
> sqlite3_prepare((sqlite3*)data_arg_3, [...])
>
> , an error SQLITE_MISUSE is returned to me
SQLite is not reentrant through the update hook.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sq
en which uses some
memory and at least one file descriptor. If you really are never
going to
use the database again (or at least not soon) it is better to call
sqlite3_close() too.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlit
On Apr 3, 2008, at 3:39 PM, Steven Fisher wrote:
> Can Final be called without Step first being called?
Yes.
>
>
> If Step is called, will Final always be called?
Yes
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
brary on
disk. Different strokes for different folks, I guess...
Anyway, you can fix the problem by either using the
precompiled binaries, or downloading the latest from
CVS.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite
27;ll try to figure out some way
to have pointers from the English-language pages over to the
translated pages.
This same offer applies to anybody else who wants translate SQLite
documentation into any other living language.
D. Richard Hipp
[EMAIL PROTECTED]
___
>
> Thank you for your answer D. Richard,
>
> So I continue the translation and I will see fossil for future.
> Can you take a ticket for this evolution ?
>
We can work with you to import your translation whenever
you are ready.
D. Richard Hip
alendar
refer to two different people named Julius. The Julian Day Number
Julian is Julius Scaliger, the father of the guy who invented
the julian day number in 1583. Julian in Julian Calendar refers to
Julius Caesar, the Roman emperor.
The date and time routines in SQLite use the Gregorian calend
On Apr 7, 2008, at 6:27 PM, Dennis Cote wrote:
> D. Richard Hipp wrote:
>>
>> See http://en.wikipedia.org/wiki/Julian_day
>>
>> Note that "Julian" in Julian Day Number and Julian Calendar
>> refer to two different people named Julius. The Julian D
o C-savvy but can blunder my way around. (am reading a
> basic C tutorial right now).
>
You might be interested in sqlite3_auto_extension
http://www.sqlite.org/c3ref/auto_extension.html
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
On Apr 8, 2008, at 12:57 PM, dark0s dark0s wrote:
> Hi all, I'd like write extension for sqlite3 creating soundex
> function like below:
>
SQLite already contains a soundex function. You just have to recompile
using -DSQLITE_SOUNDEX=1
D. Richard Hipp
[E
u ignore this advice and decide to use the BTree routines directly,
and your code breaks or malfunctions due to some unseen subtly or
some future change, then the rule is: "No Tears".
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
nerator. But you should know that we are not through
changing
it yet and more big changes could appear in future releases. The
virtual
machine in SQLite is not an API and we make positively zero effort to
maintain
backwards compatibility from one point release to the next.
D. Richard Hi
ot; in front of the
column name). The plus sign is a no-op - it generates no code
and returns the value of its operand unchanged even if the value
is a string. But it also disables the term as a candidate for using
indices.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
LOCKED errors and I came across
> that page. Are these the only times you can get SQLITE_LOCKED errors?
If you are in the middle of a SELECT statement and from the same
database connection you try to DROP one of the tables that is being
read, the DROP statement will return SQLITE_LOCKED.
D
be able to DROP a table out from
under a reader.
I am not aware of any reason why you cannot retry an SQLITE_LOCKED
error after a delay, however. Have you actually tried doing that?
Is it giving you trouble?
D. Richard Hipp
[EMAIL PROTECTED]
___
sqli
SQLITE_MISUSE
> being returned.
>
Did you call sqlite3_reset() before each retry?
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
into every new database
you create
with the same schema.
Some database engines benefit from running ANALYZE periodically. SQLite
does not, in general.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.o
On Apr 14, 2008, at 4:53 PM, D. Richard Hipp wrote:
>
> On Apr 14, 2008, at 4:47 PM, Steve Topov wrote:
>> I can open the file with 3.3.5. I did not try to dump it and recreate
>> with 3.5.6.
>>
>
> With version 3.5.5, please do this:
>
> sqlite3 you
On Apr 14, 2008, at 4:47 PM, Steve Topov wrote:
> I can open the file with 3.3.5. I did not try to dump it and recreate
> with 3.5.6.
>
With version 3.5.5, please do this:
sqlite3 yourdatabasefile.db .schema >schema.txt
then email me schema.txt file.
D. Richard Hipp
[EMA
On Apr 14, 2008, at 6:58 PM, Steve Topov wrote:
> 1.8 Meg
>
email it to me, please.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
roblems on MacOSX using
SQLite version 3.4.0, 3.5.6, 3.5.7 and the latest in CVS. I ran
PRAGMA integrity_check
using all four versions of SQLite and all return "ok".
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sq
one can have a write transaction open
and one or more others can have a read transaction open, but
you cannot have two or more write transactions active at once
and all of the read transactions will need to close prior to the
write transaction committing (otherwise the writer g
ros you much
compile from canonical sources using a unix-like development
environment.
The reason for this is that SQLite includes several code files that
contain automatically generated code. And the generated code
depends on which OMIT macros are present.
D. Richard Hipp
[EMA
. Richard Hipp
[EMAIL PROTECTED]
P.S.: As I type this, two test failures have emerged in the new
release: utf16-bind-6.4 and utf16-bind-7.4. Both failures are
benign. The fault is actually in the test script, not in SQLite itself.
The test script in these cases assumes a UTF8 database and
hence
shell.c code.
>
> Was this intended ?
>
There are a dozen different build products in the latest release.
I'm sorry that the one you wanted is not there. Perhaps we can find
time to add it later.
D. Richard Hipp
[EMAIL PROTECTED]
___
sql
ubject: Re: [sqlite] SQLite>=3.5.6 does not open database file
>
> I am on Windows XP using sqlite 3.5.6 dll created from the source.
Why don't you try the pre-compiled DLLs off of the website.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite
It is doing a nested
> table scan instead of using the index for the left join.
>
Likely this has to do with ticket #3015.
http://www.sqlite.org/cvstrac/tktview?tn=3015
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-
owners.owner_id = pets.owner_id
instead if what you have. In other words, put the
table on the left side of the join before the equals
sign instead of after it.
It shouldn't make any difference. SQLite should
generate exactly the same code regardless of
whether you say A=B or B=
an multiple pages.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
p would be appreciated
>
What value are you passing as the 4th argument to
sqlite3_open_v2()? (I assume you are using sqlite3_open_v2()
since that seems the mostly likely way to get this error.)
D. Richard Hipp
[EMAIL PROTECTED]
___
sqli
here ORT.person_id = register.person_id
and ORT.document_id = register. document_id);
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
k string - this would appear to be the problem!
> errorCode = sqlite3_open_v2("data/texts.db", &dataBase,
> SQLITE_OPEN_READONLY, "");
>
A null pointer (aka zero). 0. Very different from an
empty string.
D. Richard Hipp
[EMAIL PROTECTED]
__
mailing list if you think it would help.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
FWIW, I'll be happy to give write access to the documentation
repository (http://www.sqlite.org/docsrc/) and even a
prestigious "sqlite.org" email alias to anybody who is
willing to step up and make some improvements and
updates to the current documentation.
D. Richard Hipp
[
ext easily in f.i. SQLiteSpy.
>
Perhaps: SELECT CAST(b AS TEXT) FROM table
Really I suppose it depends on what SQLiteSpy is using to
determine that the column type is BLOB. If you can subversion
that mechanism into thinking the column type is TEXT, then
it should just work.
D
I suggest
you use a C compiler instead. Surely Visual Studio must
include a C compiler.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ateView referenced in function _yy_reduce
>
> Are there any workarounds for these, or will
> I have to remove the above OMIT options?
>
> Thanks,
> - Richard
> ___
> sqlite-users mailing list
> s
AGER_PRAGMAS
the cache_size pragma is omitted. A feature of the PRAGMA
command is that unrecognized pragmas are silently ignored.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
;>>>>>> more
>>>>>>> than N*2 sec and dies on my SQLITE_BUSY asserts :/
>>>>>>>
>>>>>>> So, I am wondering, is there any ideas how to avoid this?
>>>>>>>
>>>>>>
>>>>>> ___
>>>>>> sqlite-users mailing list
>>>>>> sqlite-users@sqlite.org
>>>>>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>> ___
>>>> sqlite-users mailing list
>>>> sqlite-users@sqlite.org
>>>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>>>
>>>
>>>
>>>
>>> --
>>> Alexander Batyrshin aka bash
>>> bash = Biomechanica Artificial Sabotage Humanoid
>>> ___
>>>
>>> sqlite-users mailing list
>>> sqlite-users@sqlite.org
>>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>>
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>
>
>
> --
> Alexander Batyrshin aka bash
> bash = Biomechanica Artificial Sabotage Humanoid
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Apr 25, 2008, at 9:19 AM, Eric Minbiole wrote:
>> This works great but when I upgraded from 3.5.7 to 3.5.8 the speed of
>> this select went from 0.2s to around 1 minute. And 3.5.8 is stealing
>> ALOT more memory.
>
> D. Richard Hipp had a very helpful work-around for t
n. Is that correct? If so, what options are
> defined when it is being built? If not, how is it built?
>
> TIA
> Dennis Cote
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/li
work on version 3.6.0.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
mode
Before you rush out and try this on 3.5.8, please note that it is
currently only available in CVS HEAD.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
. The lack of a configuration file is a feature, not a bug.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> tclsh8.5 [~/tmp/tcltk]dbcomm eval "SELECT a_string FROM something"
> Version V8.5
>
> Why so much parentheses? A list, nested in a list, nested in a list?
> But why?
I get just {Version V8.5} when I try this.
D. Richard Hipp
[EMAIL PROTECTED]
On May 3, 2008, at 12:30 AM, Roger Binns wrote:
>
> I would like a #define of the current version number.
http://www.sqlite.org/c3ref/c_version.html
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.or
at is just the nature of binary files. I don't
think any SCM system is able to diff or merge arbitrary binary files.
There may be modules for diffing and merging specific binary files
formats (ex: DOC files) but not arbitrary binary files nor likely
SQLite database files. So take ca
e core SQLite, btw. It is
part of the CLI. You can find the code by searching for "import" in
the shell.c source file.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
IST mode nearly as carefully as we have the existing DELETE mode.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
orage (SD card). Has
> anyone ported
> this before to an embedded system without an OS?
>
I have doubts that you will be able to get SQLite to work on anything
less than a 32-bit processor.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-u
the correctness of the
database. In PERSIST journaling mode, you never know and you delete
the file at your peril.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On May 8, 2008, at 2:54 AM, C M wrote:
> How likely (or possible) is it to corrupt or in some way screw up an
> SQlite database if one is doing an UPDATE and it fails? (computer goes
> out, etc.) Thank you.\
http://www.sqlite.org/atomiccommit.html
D. Richard Hipp
[EMAIL
format
1 databases to be used as the default.
FWIW, SQLite version 3.3.0 was released over 2 years ago on January
10, 2006.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailma
older
database will continue to be readable and writable by newer versions
of SQLite.
The only time this will cause a problem is when you create a new
database file using SQLite 3.6.0 or later and then try to read or
write that file using a different version of SQLite that is more than
2
; than one thread (it is failing in worker thread).
> sqlite3_step() returns SQLITE_MISUSE , but _sqlite3_errmsg() returns
> "database is locked".
> What can be the problem?
What does sqlite3_threadsafe() return?
D. Richard Hipp
[EMAIL PROTECTED]
for
sqlite3_transfer_bindings(), though. You are using
sqlite3_prepare_v2() in place of sqlite3_prepare() I trust. You
should be if you are not since applications that use
sqlite3_prepare_v2() are less prone to bugs in error handling logic
(by virtue of the fact that they can essential
r when you stop
one undoable entry and start a new one is: you are idle (no pending
events) and you are not holding a grab.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
anybody have any thoughts on this proposed behavior changes for
the sqlite3_close() interface?
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On May 13, 2008, at 8:02 PM, Scott Hess wrote:
> On Tue, May 13, 2008 at 4:51 PM, D. Richard Hipp <[EMAIL PROTECTED]>
> wrote:
>> The currently documented behavior of sqlite3_close() is that when it
>> called on a database connection that has unfinalized prepared
&g
ges in the VFS layer used to tie SQLite into the
underlying operating system.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On May 14, 2008, at 1:59 PM, Petite Abeille wrote:
> Hello,
>
> On May 14, 2008, at 7:17 PM, D. Richard Hipp wrote:
>
>> There is also a new *experimental* PRAGMA called "journal_mode"
>> which can provide performance improvements under some circumstances.
&
On May 14, 2008, at 2:14 PM, Petite Abeille wrote:
>
> On May 14, 2008, at 8:10 PM, D. Richard Hipp wrote:
>
>> Works for me. Did you compile the shell yourself or use the prebuilt
>> binary?
>
> I did compile it myself. Any additional configuration(s) one should
&g
ysically resides on a remote
machine, you should probably use a client/server database engine with
the server located on the same machine where the data lives.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
ht
=-=-=-=-=-=-=-=-=
> Check out PHPenguin, a lightweight and versatile
> PHP/MySQL, AJAX & DHTML development framework.
> http://phpenguin.bigskypenguin.com/
> _______
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/c
r VARCHAR(4) NOT NULL DEFAULT '0',
> endyear VARCHAR(4) NOT NULL DEFAULT '0',
> options TEXT NOT NULL,
> productcodesize VARCHAR(10),
> productdesc VARCHAR(200),
> pattern VARCHAR(10)
> );
What does this show:
SELECT DISTINCT typeof(startyear) FROM bsp_opti
On May 19, 2008, at 9:16 PM, Skip Evans wrote:
> D. Richard Hipp wrote:
>> What does this show:
>>
>>SELECT DISTINCT typeof(startyear) FROM bsp_options;
>>SELECT DISTINCT typeof(endyear) FROM bsp_options;
>>
> I pasted those two statements into the
qlite for blobclo is
> 10 but why i get this error
>
That limit can be lowered at compile-time and in more recently
versions at run-time. Perhaps turbogears is lowering the limit on you.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite
umn to NULL I get a constraint error.
>
REPLACE INTO foo(bar) VALUES(?)
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
OK. How about:
INSERT INTO foo(bar) VALUES(coalesce(?,'default-value'));
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
201 - 300 of 1805 matches
Mail list logo