Jus GoodFun [EMAIL PROTECTED] wrote:
I tried the DSQLITE_MUTEX_NOOP and then a rebuild but still
got the following compile errors, I'm sure I'm missing something
simple...
Try compiling with -DSQLITE_THREADSAFE=0
--
D. Richard Hipp [EMAIL PROTECTED]
Noah Hart [EMAIL PROTECTED] wrote:
The documentation for Triggers defines a trigger step as follows:
trigger-step ::= update-statement | insert-statement |
delete-statement | select-statement
What would be an example of the select-statement?
SELECT statements are useful for the
Alexander Batyrshin [EMAIL PROTECTED] wrote:
Hello,
Is it safe to use this algorithm:
open_db
fork()
sql_do() // both parent and child executes sql statements
close_db
I am not familiar with locking mechanism and I am afraid that if
parent and child will use the same DB handlers it can
A.J.Millan [EMAIL PROTECTED] wrote:
Hello all:
Using Windows XP:
D:\Z\Zator5sqlite3 zdb1
SQLite version 3.5.4
Enter .help for instructions
sqlite .tables
AgEfHolder AgEfemerAgVtHolder AgVtos Usr lnk
AgEfIDt AgPdHolder AgVtIDt Block atm prm
Sam Carleton [EMAIL PROTECTED] wrote:
My application is an apache based kiosk system that displays images.
The SQLite database is used by PHP to track user info, who is logged
in and what they have selected. SQLite is NOT managing anything about
the files. I have a few customers that are
Rob Richardson [EMAIL PROTECTED] wrote:
I'm thinking whether this is a memory leak or not sort of depends on
your definition. If a process is designed to remain open for long
periods of time with little activity, and it ends up taking up 1
gigabyte of memory, that looks an awful lot like a
Peter Weilbacher [EMAIL PROTECTED] wrote:
On Thu, 20 Mar 2008 17:52:21 UTC, drh wrote:
Any additional information you can send, such as the size of
the database file at the point of failure, or the exact line
on which the problem occurs, will be appreciated. (I know the
bug report
Mark Spiegel [EMAIL PROTECTED] wrote:
I'm looking to jump my code port forward from 3.5.1 to 3.5.7.
Clearly I have some memory management work to do since
SQLITE_OMIT_MEMORY_ALLOCATION support has been dropped. None of the
existing allocation implementations look acceptable so I'll have
Shawn Wilsher [EMAIL PROTECTED] wrote:
Hey all,
Mozilla has recently upgraded to sqlite 3.5.7, and we've suddenly
gotten a lot of crashes. The mozilla bug report is here:
https://bugzilla.mozilla.org/show_bug.cgi?id=424163
We haven't looked into it to much, but I figured I'd point it out
Kees Nuyt [EMAIL PROTECTED] wrote:
I know I can't create an invalid view,
because SQLite refuses to create it,
but this seems a problem to me... could SQLite just open the database, and
complain only on the invalid views (i.e. for instance when I open the view
to query the data in it)?
MarcoN [EMAIL PROTECTED] wrote:
Hello, everybody.
I have the following problem: I have an old project that uses a database
created with an older SQLite library version.
Now, since I updated SQLite to 3.5.5, I can't use the database anymore,
because any query on the database tables returns:
Martin Engelschalk [EMAIL PROTECTED] wrote:
Hello All,
I have to select data from a large table (several million records) in
descending order and created an index for that purpose. However, sqlite
seems not to use this index for selecting the data.
In the documentation of the create
MarcoN [EMAIL PROTECTED] wrote:
I actually don't know how to export it, because SQLite Database browser
(that is able to open the database and execute the query) has no way to
export it; SQLiteSpy will not open the database because it is compiled with
a new SQLIte library version
Maybe I
MarcoN [EMAIL PROTECTED] wrote:
Yes, of course I can send you the DB: the file is under 1MB, about 100K if
compressed via .zip
Can I send it to you via e-mail?
Thanks very much for the support
Please send the database directly to my email address shown below.
--
D. Richard Hipp [EMAIL
Steve Topov [EMAIL PROTECTED] wrote:
Hello,
Recently I upgraded SQLite to version 3.5.6 and discovered that my
program cant work anymore with some database files. Sqlite3_open
returns OK, but when I am trying to execute any SQL statement it returns
SQL logic error or missing database.
Joanne Pham [EMAIL PROTECTED] wrote:
Hi All
I ran the following statement:
select datetime(startTime *60, 'unixepoch','-8 hours') , bytesIn from
wanPerfTable where appId = 30 and remoteWXId = 200;
and below is my output.
2007-12-03 11:00:00 20
2007-12-03 11:01:00 5
MarcoN [EMAIL PROTECTED] wrote:
Hello, everybody.
I have the following problem: I have an old project that uses a database
created with an older SQLite library version.
Now, since I updated SQLite to 3.5.5, I can't use the database anymore,
because any query on the database tables returns:
Rich Rattanni [EMAIL PROTECTED] wrote:
All:
I am able to consistently cause the following message during a integrity check
Page xxx is never used
This seems non-critical, since a vacuum clears this up. If someone
has the time could you explain the meaning (besides the obvious),
causes,
Lee Crain [EMAIL PROTECTED] wrote:
I am debating the performance gains to be realized, if any, by indexing a
particular table in a system implementation for which I am responsible.
You are getting way ahead of yourself.
Stop trying to speculate about whether or not an index
or indices will
Igor Tandetnik [EMAIL PROTECTED] wrote:
B V, Phanisekhar [EMAIL PROTECTED] wrote in
message news:[EMAIL PROTECTED]
So is it possible
that SQLITE will give an error when attempting to insert a record even
if there are free ROWID's?
Yes, in theory. If you have close to 2^63-1 rows,
Nicolas Williams [EMAIL PROTECTED] wrote:
Slightly OT: The current SQLite3 test code base makes use of internal
interfaces, which means you can't necessarily test the bits that you
want to install. It'd be nice to be able to test the bits actually
installed.
See
software.simian [EMAIL PROTECTED] wrote:
Just step-in; I'm studying the sqlite code and it would be easier if I could
see the internal in action.
* Compile with -DSQLITE_DEBUG=1
* PRAGMA vdbe_trace=ON;
* PRAGMA vdbe_listing=ON;
--
D. Richard Hipp [EMAIL PROTECTED]
Clay Dowling [EMAIL PROTECTED] wrote:
Severin Müller wrote:
I tried to include sqlite3 in my current C Project. =
=
I downloaded the precompiled library sqlite-3.5.6.so and put it in my pro=
ject.
Then, i downloaded the sqlite source and added sqlite3.h to my project. =
=
Zbigniew Baniewski [EMAIL PROTECTED] wrote:
I'm afraid, I've discovered a bug: there's no possibility to catch the
error database is locked. Even, when one's trying something like:
#v+
if { [catch {sqlite3 dbcomm $fullPathToDatabaseFile} err] } {
puts $err
}
#v-
There'll be no
Scott Hess [EMAIL PROTECTED] wrote:
True, but my code snippet didn't check for NULL. If, for some reason,
SQLite returned a partial statement handle with an error code, then
I'd expect you would want to pass it back to sqlite3_finalize().
Since sqlite3_finalize() explicitly handles NULL, I
Paul Hilton [EMAIL PROTECTED] wrote:
Here is the problem: I want Slot created to disambiguate the Primary Key, So
that for every value of Group the value of Slot starts at 1 and counts up.
These are two different things:
(1) Slot needs to disambiguate the PRIMARY KEY
(2) Slot needs to
Brian Smith [EMAIL PROTECTED] wrote:
When SQLite writes to the log file, it
(1) writes all the data,
(2) fsyncs, then
(3) updates the page count in the header, and finally
(4) fsyncs again.
Isn't it possible to change SQLite so that the steps 3
and 4 are unnecessary?
That depends
Marco Bambini [EMAIL PROTECTED] wrote:
So, is safe so to set PRAGMA synchronous=NORMAL; under MacOS X?
I am told probably not, though Apple has never issued a definitive
statement on the question.
--
D. Richard Hipp [EMAIL PROTECTED]
___
Ralf Junker [EMAIL PROTECTED] wrote:
SQLite does not recognize Z as the zero offset time zone specifier.
SQLite does not currently accept any timezone specifiers, other
than a hard-coded timezone offset:
1981-04-06T14:45:15+01:00
If we start accepting any symbolic timezone names, seems
Raviv Shasha [EMAIL PROTECTED] wrote:
Although I limit the sqlite database to 32768 (32K), the db file which
retrieved is equal to 470K.
What regrading the operations sequence ? Is it correct to first
initialize the sqlite database and then to execute the PRAGMA
max_page_count command or
Joshua Galvez [EMAIL PROTECTED] wrote:
Any help would be appreciated. Even as much as, No, there really is
no way to do this.
No, there really is no way to do this, at least not without some
internal knowledge of what kinds of information Apple is storing
in the data.syncdb file. Maybe you
Dennis Cote [EMAIL PROTECTED] wrote:
Nokia sold 350 million cell phones last year alone. Each of those phones
probably had some embedded database on them. It may even be SQLite for
all I know, but if it is not, then it substantially increases the number
of non-SQLite database deployments.
Nicolas Williams [EMAIL PROTECTED] wrote:
does SQLite know about POSIX file locks on the same files from
other instances of itself?
Yes. That's the whole point of POSIX advisory locking.
--
D. Richard Hipp [EMAIL PROTECTED]
___
sqlite-users mailing
Nicolas Williams [EMAIL PROTECTED] wrote:
On Wed, Feb 20, 2008 at 04:23:29PM +, [EMAIL PROTECTED] wrote:
Nicolas Williams [EMAIL PROTECTED] wrote:
does SQLite know about POSIX file locks on the same files from
other instances of itself?
Yes. That's the whole point of POSIX
David A. Cobb [EMAIL PROTECTED] wrote:
It appears that, given SQLite's Manifest Typing, the appropriate type of
a UUID -- 16bytes, binary -- would be BLOB. One would not want to try
converting the ID to anything, if only for the cost in time.
Can a BLOB be the Primary Key for a table?
Can somebody with the ability to compile and test for wince
please test check-in [4802] for me.
http://www.sqlite.org/cvstrac/chngview?cn=4802
For that matter, is there anybody out there who would like
to become the official wince maintainer for SQLite? If you
are able to compile, test, and
Rael Bauer [EMAIL PROTECTED] wrote:
Hi,
1. with sqlite Is it possible to have a primary key made up of 2 fields?
(If so how...)
(from firebird:
ALTER TABLE table1 ADD CONSTRAINT PK_TABLE1 PRIMARY KEY
(field1,field2);)
2. Is it possible to add a primary key with
Gilles Ganault [EMAIL PROTECTED] wrote:
On Sat, 16 Feb 2008 11:29:29 +1100, BareFeet
[EMAIL PROTECTED] wrote:
If you designate an integer column as also being the primary key,
then SQLite will auto assign its value incrementally each time
you insert a new row, unless you assign a value
Walt [EMAIL PROTECTED] wrote:
Is it feasible to a DataBase on one computer and have multiple
users on a LAN accessing the DataBase at the same time?
This can be made to work. But you will probably be much happier
with a client/server database such as MySQL or PostgreSQL. They
are designed
Kalyani Phadke [EMAIL PROTECTED] wrote:
I have not recompiled sqlite 3 before. I am having trouble to find
documentation.
Could anyone pls tell me how can I compile SQLite3 source code on
windows xp machine. Do I need to download FTS3 files ? Where can I find
those files? How can I add this
Evans, Mark (Tandem) [EMAIL PROTECTED] wrote:
snip...
LIKE operators cannot use indices unless the index is case
insensitive. Use GLOB for case sensitive fields.
Richard - i'm not sure i understand unless the index is case insensitive.
How does that relate to:
sqlite create
Ken [EMAIL PROTECTED] wrote:
Any reason why the functions above could not be exposed as part of the
sqlite3 api suite?
The usually reasons apply: To expose them as part of the sqlite3 api
suite means that they would have to be supported, documented, and
tested forever and it also means
Kalyani Phadke [EMAIL PROTECTED] wrote:
I am using Sqlite 3 as my database. One of my table contains 1280010
rows. Db file size is 562,478KB. I am running DB on Windows XP pro-P4
CPU 3.20GHz 3.19Hz ,2.00GB of RAM )
CREATE TABLE TableA
(
ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
Mau Liste [EMAIL PROTECTED] wrote:
results in: SQL error: no such function: hex
Added by version 3.3.13, one year ago yesterday.
http://www.sqlite.org/releaselog/3_3_13.html
What version are you running?
--
D. Richard Hipp [EMAIL PROTECTED]
Samuel Neff [EMAIL PROTECTED] wrote:
If the images you're storing are larger than the defined page size for the
database (which is most likely the case) then you can get better performance
and reduced memory consumption by storing the images in the file system and
store only paths to the files
Igor Sereda [EMAIL PROTECTED] wrote:
The questions around sqlite3_blob_xxx methods that Roger brought up a couple
of months ago are very interesting for me too, and I haven't seen any reply
to Roger's message. (Roger - do you have any update?)
As far as I can gather from the cited
Kasper Daniel Hansen [EMAIL PROTECTED] wrote:
I have a table with two variables, say A and B (both integers). The
table is rather large - around 2.9 GB on disk. Every combination of
(A,B) occurs only once. I am creating a unique index as
CREATE UNIQUE INDEX ABidx ON abtable (A,B)
It
Lars Aronsson [EMAIL PROTECTED] wrote:
Is there any documentation of how people use SQLite in odd ways in
their everyday activities?
Did you see
http://www.sqlite.org/whentouse.html
The document above is not exactly what you are asking for
since it does not list real-world examples, but
John Stanton [EMAIL PROTECTED] wrote:
That ia a nice idea. To have a pragma which specied the dialect. There
could be strict or ansi and mysql, oracle, sqlserver etc etc.
It would give tighter control over hard to track annoying minor syntax
errors.
And, it would multiple
[EMAIL PROTECTED] wrote:
Hi..
we are using sqlite3.3.4 with Integrity OS. we are facing a problem
where in the VFS memory is getting exhausted due
to large lock/unlock calls made by sqlite. Integrity support team
said that, for each file lock call made by sqlite, a definite amount
Dennis Cote [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] wrote:
There are no lock leaks. But on the other hand, there is not
a one-to-one mapping of lock to unlock calls. unlock is called
more often than lock and there are often attempts to unlock files
that have never been locked,
Brad House [EMAIL PROTECTED] wrote:
they have put traces and identified that for 1000 lock calls
there are only 950 unlock calls, which is a shortage of 50 unlock
calls.
The os_unix.c backend to SQLite makes no attempt to match lock/unlock
calls, because posix does not requires such.
SQLite version 3.5.6 is now available on the website.
http://www.sqlite.org/download.html
There is very little change from version 3.5.5. The reason
for this release is that there was a regression in the virtual
table mechanism that prevented virtual tables from being used
in LEFT OUTER
Two new SQLite mailing lists have been established:
sqlite-announce
sqlite-dev
Additional information and links to pages where you can
sign up can be found at
http://www.sqlite.org/support.html
--
D. Richard Hipp [EMAIL PROTECTED]
___
Felix Radensky [EMAIL PROTECTED] wrote:
Hi,
What is a recommended way of handling signals in daemon
processes using sqlite database ? Is calling sqlite3_interrupt()
in SIGTERM handler considered good enough ?
sqlite3_interrupt() was originally create for the specific
purpose of handling
RB Smissaert [EMAIL PROTECTED] wrote:
Suppose we have a table with some 10 million rows and this table was
analysed, so sqlite_stat1 has the stats of this table then is it worth it to
analyze again after adding say 1000 more rows? The indexing is still the
same, so no indexes are dropped or
L. S. [EMAIL PROTECTED] wrote:
I've been ignoring this issue for a while; the world won't end over this
but...
There is some issue with the newly-designed SQLite web site that
prevents access from my Palm Treo. It used to be accessible, with the
old design.
--
Often I surf, email,
L. S. [EMAIL PROTECTED] wrote:
The page never loads. I get the message, The page download could not
be completed. Please try again later.
Here is the User-Agent header string:
Mozilla/4.0 (compatible; MSIE 6.0; Windows 98; PalmSource/Palm-D052;
Blazer/4.5) 16;320x320
The webserver on
I had been saying in release announcements that no bugs have
been found in the new register-based virtual machine introduced
in SQLite version 3.5.5. That changed with ticket #2927. We
have now observed our first register-VM bug.
http://www.sqlite.org/cvstrac/tktview?tn=2927
There will
Ken [EMAIL PROTECTED] wrote:
Hi all,
I'm getting a sqlite error when running sqlite3_close. The error indicates
that there are open statements.
To the best of my knowledge all statements are closed. I loooked at the
sqlite3_close function and call to close the virtual tables appears
Ken [EMAIL PROTECTED] wrote:
Amalgamation fails to compile when -DSQLITE_OMIT_VIEW is defined.
Neither the nor the preprocessed sources work with -DSQLITE_OMIT macros.
If you need to use -DSQLITE_OMIT, then you will need to compile on
Unix using the original source code.
Both the
Doug Currie [EMAIL PROTECTED] wrote:
Please set the list so default reply is to the list.
http://www.unicom.com/pw/reply-to-harmful.html
One finds various screeds such as the one Doug references
above. And on the configuration screen for GNU mailman,
it strongly recommends that replys
Nicolas Williams [EMAIL PROTECTED] wrote:
On Tue, Feb 05, 2008 at 01:30:01AM +, [EMAIL PROTECTED] wrote:
And yet nearly everyone I know loaths that behavior. The
overwhelming majority of users prefer mailing list replies
to go back to the mailing list *only*.
Users need to learn to
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Got the
sqlite3.exe version 3.5.5 but .explain still doesn't seem to work.nbsp;
Maybe it's me, could someone post a simple example of .explain working?
C:\ sqlite3
SQLite version 3.5.5
Enter .help for instructions
sqlite create table t1(x);
sqlite
Rob Sciuk [EMAIL PROTECTED] wrote:
Dear DRH,
I post the previous (FreeBSD/Ubuntu) and this *ONLY* to exercise the new
3.5.5 bits given the wholsale changes. I hope you find them useful, but
AFAICT, 3.5.5 looks pretty good from a perf/stability standpoint.
In the obscure machine/OS
Zarko Popovski [EMAIL PROTECTED] wrote:
I see also SQLite 5.5.4 version compiled, is there SQLite 3.5.5 precompiled
version for M$ Windows or if there is not drh. please compile it :)
I fixed that problem this morning. When did you last look?
--
D. Richard Hipp [EMAIL PROTECTED
Torsten Blix [EMAIL PROTECTED] wrote:
Hi,
is it safe to do the following in a C program while working with SQLite? I
tried searching the docs but couldn't find any answer.
sqlite3_open();
sqlite3_get_table(...result);
sqlite3_close();
sqlite3_free_table(result);
i.e. freeing the
SQLite version 3.5.5 is now available for download from the
SQLite website:
http://www.sqlite.org/
The big change from version 3.5.4 is that the internal virtual
machine was reworked to use operands in registers rather than
pulling operands from a stack. The virtual machine stack has
now
Rob Sciuk [EMAIL PROTECTED] wrote:
Ran the tests on Freebsd, the make test summary follows:
[delenda = ... Ok]
16 errors out of 38961 tests
Failures on these tests: bind-4.4 bind-4.5 cast-3.14 cast-3.18 cast-3.24
printf-1.7.6 printf-1.8.6 printf-1.9.7 tcl-1.6 vtab6-2.2 vtab6-2.4
Noah Hart [EMAIL PROTECTED] wrote:
With SQLITE_OMIT_VIRTUALTABLE defined, I get a linker fault under VC++
It claims that:
error LNK2001: unresolved external symbol sqlite3VtabBeginParse
That call *is* surrounded by #ifndef SQLITE_OMIT_VIRTUALTABLE. But
the #ifndef is located in parse.y.
Alexander Batyrshin [EMAIL PROTECTED] wrote:
How to get error messages from test? Scroll up and copy-paste? Or
there is some other more handy method?
make test | tee testout.txt
--
D. Richard Hipp [EMAIL PROTECTED]
-
Alexander Batyrshin [EMAIL PROTECTED] wrote:
Here is my make test on Mac OS 10.5.1:
8 errors out of 38117 tests
Failures on these tests: lock4-1.3 vtab6-2.2 vtab6-2.4 vtab6-2.5
vtab6-2.6 vtab6-7.1 vtab6-9.1.1 vtab6-9.2
All memory allocations freed - no leaks
Maximum memory usage: 14161966
David Baird [EMAIL PROTECTED] wrote:
The sqlite3 link is broken from multiple web pages:
http://www.sqlite.org/c3ref/objlist.html
http://www.sqlite.org/c3ref/intro.html
Also, links to sqlite3_stmt are broken. It seems that any link
containing a %20 is broken, e.g.
Ken [EMAIL PROTECTED] wrote:
Solaris 5.8 (solars 8)
make test
Undefined first referenced
symbol in file
sched_yield /var/tmp//cckDMcyL.o
ld: fatal: Symbol referencing errors. No output written to .libs/testfixture
Gilles [EMAIL PROTECTED] wrote:
At 15:40 31/01/2008 -0800, James Dennett wrote:
WHERE col LIKE '123%' or WHERE substr(col,1, 3) = '123'
The optimizer has a decent chance of using an index for LIKE '123%' but
I'd be surprised (and impressed) if it looks inside function calls suchas
We are going to be upgrading the server that runs
the SQLite website this comming Saturday, if all goes
according to plan. We are planning to changes the
operating system from Debian to Ubuntu and the
mailing list manager from ezmlm to GNU mailman.
If everything goes as planned, the outage will
Lee Crain [EMAIL PROTECTED] wrote:
I did expect SQLite to enforce the NOT NULL portion of the SQL
creation statements, no matter what.
SQLite *does* enforce NOT NULL no matter what. I think your
pointers are getting turned into NULLs someplace else, perhaps
somewhere in the QT layer.
A NULL
Lee Crain [EMAIL PROTECTED] wrote:
I've created a table with several fields, 3 of which are created using
these SQL statements:
[description] [varchar](255) NOT NULL DEFAULT ('') COLLATE NOCASE,
[keywords][varchar](255) NOT NULL DEFAULT ('') COLLATE NOCASE,
[metadata]
Felix Radensky [EMAIL PROTECTED] wrote:
Hi,
Is there any limitation on the number of elements in IN clause ?
Can one have, e.g. thousands of elements ? Also, can having
to many elements become inefficient at some point and one
has to use some other technique, i.e. comparing elements one
Samuel R. Neff [EMAIL PROTECTED] wrote:
I don't think it is standard SQL. At the very least, it doesn't work in
MSSQL. Standard is
SELECT * FROM maintable WHERE key IN (select x from stuff);
SQLite shortened version is much nicer.. wish it was standard.
SQLite also accepts the
Nicolas Williams [EMAIL PROTECTED] wrote:
On Mon, Jan 28, 2008 at 10:07:01AM +0100, Ralf Junker wrote:
Hello Bharath Booshan L,
select * from t where filepath regexp '/MyMovie(\.[^\.]+)*$';
Will this query use index, if we had one, on filepath?
No. It will do a full table scan.
Carl Gundel [EMAIL PROTECTED] wrote:
Hey all,
I'm thinking about upgrading to v3.5.4 the latest SQLite from v3.4.0 for the
next release of Run BASIC, and I'm wondering about a couple of things:
1) Do I need to change the way I make calls to the database engine? Is the
API the same? I
P Kishor [EMAIL PROTECTED] wrote:
Most folks though install their own version of SQLite under the
/usr/local tree ...
Why do people feel like they need SQLite to be a seperately
library? It is *designed* to be statically linked.
--
D. Richard Hipp [EMAIL PROTECTED]
Lothar Scholz [EMAIL PROTECTED] wrote:
Hello,
The example for question 11 in the FAQ has this code for dropping an
existing table column 'c'
BEGIN TRANSACTION;
CREATE TEMPORARY TABLE t1_backup(a,b);
INSERT INTO t1_backup SELECT a,b FROM t1;
DROP TABLE t1;
CREATE TABLE t1(a,b);
INSERT
Mina R Waheeb [EMAIL PROTECTED] wrote:
Hi,
I have few questions regarding the limitation of multiple databases with
SQLite.
I have a large number of SQLite DB files with the same structure i
need to query them all (looking for speed), I have tried ATTACH method
and its working fine but
Pierre8r [EMAIL PROTECTED] wrote:
Hello,
One SQLite database on my PC.
Two softwares.
May one software write to the SQLite database while a other read the
same SQLite database ?
Your programs cannot be reading and writing at exactly the
same instant in time. But both programs can have
Dennis Cote [EMAIL PROTECTED] wrote:
SQLite seems to do the following:
The glob syntax supports the following patterns:
? - matches any single character
* - matches zero or more characters
[seq] - matches any single character in seq
[!seq] - matches any single
Mark Riehl [EMAIL PROTECTED] wrote:
I'm working with version 3.5.2 under Linux. I've got a database that
is being shared between two processes and I'm running into issues with
the journal file that doesn't go away. When that happens, one process
appears to have the lock on the database and
[EMAIL PROTECTED] wrote:
This appears to be slightly different than normal *nix globbing since
SQLite uses '^' rather than '!' for the set inversion (if my reading of
the source is correct).
GLOB is suppose to exactly mimic Unix, except that SQLite does not
break pattern matching at /
Alexander Batyrshin [EMAIL PROTECTED] wrote:
On Jan 21, 2008 12:58 AM, Alexander Batyrshin [EMAIL PROTECTED] wrote:
On Jan 20, 2008 11:32 PM, [EMAIL PROTECTED] wrote:
Alexander Batyrshin [EMAIL PROTECTED] wrote:
Hello everyone.
I've discover performance degradation due to update
Alexander Batyrshin [EMAIL PROTECTED] wrote:
Hello All,
I've found that SQLite-3.5.4 doesnt use index in this situation:
sqlite create table t1 (id int primary key, val int);
sqlite create table t2 (id unique, val int primary key);
sqlite explain query plan update t1 set val = (select
John Elrick [EMAIL PROTECTED] wrote:
If we are ignoring trailing spaces, then by definition:
' ' = ''
and for that matter:
' ' = ' '
Good point. I added these as test cases for the new RTRIM
collation. http://www.sqlite.org/cvstrac/chngview?cn=4735
--
D. Richard Hipp
Fowler, Jeff [EMAIL PROTECTED] wrote:
I'm curious to know how many of you agree with Darren's
sentiments on this issue
Changing the behavior of SQLite to ignore trailing
spaces is not an option for SQLite version 3, since
to do so would result in a incompatible file format
All indices
Alexander Batyrshin [EMAIL PROTECTED] wrote:
Hello everyone.
I've discover performance degradation due to update 3.3.17 - 3.5.4.
This SQL query work very slowly:
DELETE FROM
population_stamp
WHERE
town_id IN (
SELECT DISTINCT town_id FROM population_stamp
Lothar Scholz [EMAIL PROTECTED] wrote:
Another question, how would you realiable represent contrl characters
in the range 1-31 in a string? It is not really good to add them as
plain code in text files and SQLite does not have C like backslash
quoting. Especially the automatic %R%N-%N
Lothar Scholz [EMAIL PROTECTED] wrote:
Hello,
I have to write an sqlite syntax highligher for an editor
and at the moment i use the following token BNF syntax.
ident := '_' | letter ( letter | '_' | digit )*
Is this correct?
This is correct depending on your definition of letter
and
Lothar Scholz [EMAIL PROTECTED] wrote:
Hello,
Dumping a database with images i run into the 1 million byte per
SQL statement limit. I thought that the usual way to backup a database
is the sqlite.exe and dump and eval method.
Shouldn't this limit be dynamic instead of hard wired into a
Jerry Krinock [EMAIL PROTECTED] wrote:
My query:
DELETE FROM `table1` WHERE (`id`=1 OR `id`=2 OR `id`=3 OR ... OR `id`=N)
using the C API. When N exceeds 999, I get an error stating that the
maximum depth of 1000 has been exceeded, and this is documented in
Fowler, Jeff [EMAIL PROTECTED] wrote:
Yes - I've looked over the current date functions. I would propose a
single function addition that's hugely valuable in the business world.
SQL Server has a function called datediff for date arithmetic. It
accepts three parameters. The first indicates the
Fowler, Jeff [EMAIL PROTECTED] wrote:
Hello All,
SQLite newbie here. I've looked through the email archives and website
trying to find out how to compute the difference in months between two
given dates. Each date is in -MM-DD HH:MM:SS format.
The best I've been able to come up with
1 - 100 of 1511 matches
Mail list logo