Yes I know and fts3 is enabled by default but I need to be able to
load fts2 as an external extension for legacy support.
---
Marco Bambini
http://www.sqlabs.net
http://www.sqlabs.net/blog/
http://www.sqlabs.net/realsqlserver/
On Oct 8, 2008, at 6:15 AM, Alexandre Courbot wrote:
> Any reason
Any reason why you don't want to use fts3 instead?
Using fts2 means potential big consistency issues if you run vacuum on
your database. Moreover, fts3 should just compile and run smoothly on
latest versions.
Alex.
___
sqlite-users mailing list
sqlite-u
So I’m in the process of liberating my GIS data on a shoestring budget with
the SQLite / SpatiaLite combo, all test connections to my database (through
Christian Werner’s ODBC driver) are going great, but then I run into major
difficulties returning ADODB RecordSet’s in ArcMap VBA on any Text fiel
Are there any plans to put record locking in Sqlite?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Dan wrote:
>http://www.sqlite.org/faq.html#q17
Just for the record, compiling with GCC on 64 bit Linux with -Wall
results in about 20 'variable may be used uninitialized in this
function', although I believe they are all because the compiler doesn
I agree with Michael. Some of these warnings can be stopped with trivially
small code modifications, and they do try to prevent human error. Consider
this line (from my 3.5.9 amalgamation):
X1 = 365.25*(Y+4716); //X1 is an int
Which produces the following warning in VC++2008:
warning C4244: '='
I was able to compile fts1 as a loadable extension but I am having a
lot of issue with fts2.
The first issue is a duplicate sqlite_api symbol found in fts2.c and
fts2_tokenizer.c (due to the SQLITE_EXTENSION_INIT1 macro used in both
files).
I solved the issue using a:
extern sqlite3_api_routi
Dan,
While I do understand the position chosen by SQLite, these warnings do try
to prevent human error. In case of Visual C++, Microsoft has added lots of
tests in order to make porting code from 32-bits to 64-bits easier. And
those
problems Mark wrote about were certainly reported as warnings si
> The flood of warnings is a pain. SQLite dev claims they are all
> spurious, but with so many I wouldn't venture to guess how they can
> tell.
http://www.sqlite.org/faq.html#q17
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite
Not sure why the Win32 DLL is not compatible. I would think it should
be. You might want to work that out first. Can you elaborate?
As for compiling with the WDK, it can be done. The amalgamated source
is best.
The flood of warnings is a pain. SQLite dev claims they are all
spurious, but
"Shawn Anderson" <[EMAIL PROTECTED]> schrieb im
Newsbeitrag news:[EMAIL PROTECTED]
> I've read many things, some conflicting, about concurrent
> users on a Sqlite database.
> The feeling I get is that Sqlite is good for a standalone desktop
> database, but should not be used in a concurrent user
Thank you. You are right, it is type I am looking for.
Have a super one!
Merv
Timothy A. Sawyer wrote:
> You're asking for the column type, not the value. If you open the database
> with sqlite3 there is a command that you can use that shows the SQL commands
> that created the table. The .help f
I'm using SQLite in a commercial application where the db is used as a
document, often located at a network share (windows only).
The db is used as a multiuser document where many users can connect and
read/write to the db simultaneously, and it's working perfect.
Although, mostly the users will
"Shawn Anderson" <[EMAIL PROTECTED]> wrote
in message news:[EMAIL PROTECTED]
> I've read many things, some conflicting, about concurrent users on a
> Sqlite database.
> The feeling I get is that Sqlite is good for a standalone desktop
> database, but should not be used in a concurrent user situatio
Hi,
I've read many things, some conflicting, about concurrent users on a Sqlite
database.
The feeling I get is that Sqlite is good for a standalone desktop database, but
should not be used in a concurrent user situation (like a website with many
users).
Is there a definitive answer?
thanks!
_
"Alexey Pechnikov" <[EMAIL PROTECTED]>
wrote in message news:[EMAIL PROTECTED]
> "Allow INDEXED BY and NOT INDEXED to be used in UPDATE and DELETE
> statements." http://www.sqlite.org/cvstrac/chngview?cn=5772
>
> In test script I can see queries like
> "SELECT * FROM t1 NOT INDEXED WHERE b = 10 ORD
Thanks guys for the responses.
My program only needs the database as long as the process still exists so I
don't need to copy it on a database file.
The memory resident option ":memory:" is perfect.
Thanks again.
Mihai Limbasan wrote:
>
> Ribeiro, Glauber wrote:
>> You probably want to open y
Hello!
"Allow INDEXED BY and NOT INDEXED to be used in UPDATE and DELETE statements."
http://www.sqlite.org/cvstrac/chngview?cn=5772
In test script I can see queries like
"SELECT * FROM t1 NOT INDEXED WHERE b = 10 ORDER BY rowid"
"DELETE FROM t1 INDEXED BY i1 WHERE a = 5 AND b = 10"
But I can't
18 matches
Mail list logo