On 2/2/07, Dennis Cote <[EMAIL PROTECTED]> wrote:
[EMAIL PROTECTED] wrote:
> The problem is, not many network filesystems work correctly.
I'm sure someone knows which versions of NFS have working file locking,
at least under Linux.
I doubt it is this easy. You need to line up a bunch of thing
I'd be _extremely_ leery of doing this on a network store. In theory,
it should work just fine, but bridging theory and practice may very
well cost you many sleepless nights. sqlite is in many ways easier
than mysql, but mysql isn't _that_ much harder to use, and it just
won't have this class of
On 1/24/07, Ralf Junker <[EMAIL PROTECTED]> wrote:
Hello Scott Hess,
Btw: Are there any chances that ticket #2183 could make it into 3.3.12?
It is about a nasty crash which happens to FTS2 compiled with
SQLITE_OMIT_SHARED_CACHE when many records are inserted.
Even though FTS2 is n
BTW, http://www.sqlite.org/cvstrac/chngview?cn=3596 fixed a sort of
nasty fts1/2 bug. Just in case you were looking for something else to
pick up :-).
Thanks,
scott
On 1/23/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Sandeep Suresh <[EMAIL PROTECTED]> wrote:
> I got sqlite-source-3.3.11.
Sorry for the delay. CVS change 3596 fixes this problem for fts1 and fts2.
-scott
On 1/12/07, Scott Hess <[EMAIL PROTECTED]> wrote:
http://www.sqlite.org/cvstrac/tktview?tn=2166
I'm probably not going to be back on this until Monday or Tuesday,
unfortunately.
-scott
On 1/1
http://www.sqlite.org/cvstrac/tktview?tn=2166
I'm probably not going to be back on this until Monday or Tuesday,
unfortunately.
-scott
On 1/12/07, Scott Hess <[EMAIL PROTECTED]> wrote:
[Find attached the file I'm using to debug this.]
I think I've found the differenc
[Find attached the file I'm using to debug this.]
I think I've found the difference causing this, but I don't understand
why it matters. It all should apply to fts2, the code in question
didn't change in a way likely to change this.
When an insert is done against an fts1 table, index_insert() i
OK, there's definite meat, here. I have other reports of users seeing
this problem. It's specifically related to doing UPDATE against an
fts1 or fts2 table. INSERT and DELETE both work fine. As far as I
can tell, UPDATE may have never worked, or may have worked only in
specific circumstances.
like the problem is an ascii/unicode problem.
>> > what happens is that i call sqlite3_column_text16 and get back an ASCII
>> > string...
>> > i haven't touched the rest of my code so let me ask if something's
>> changed
>> > in this latest releas
s like the problem is an ascii/unicode problem.
> what happens is that i call sqlite3_column_text16 and get back an ASCII
> string...
> i haven't touched the rest of my code so let me ask if something's changed
> in this latest release ?
>
>
> Scott Hess wrote:
>
AIL PROTECTED]> wrote:
i'm linking with it and calling the api directly.
i think that sqlite3.exe doesn't have fts1 support in it.
John Stanton wrote:
>
> How are you calling Sqlite? Have you tried sqlite3.exe?
>
> ohadp wrote:
>> Scott Hess <[EMAIL PROTECTED
On 1/11/07, ohadp <[EMAIL PROTECTED]> wrote:
Scott Hess <[EMAIL PROTECTED]> writes:
> CREATE VIRTUAL TABLE t USING fts1(content);
> INSERT INTO t (rowid, content) VALUES (1, 'this is a test');
> UPDATE t SET content = 'that was a test' WHERE rowid
On 1/11/07, Ohad Eder-Pressman <[EMAIL PROTECTED]> wrote:
inserts work
once i update my fts1 table and then select data from it, i get gibberish.
anybody seen something like this ?
Anything is possible - suggest you indicate the version you're using,
and provide an SQL script which demonstrate
On 12/13/06, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
"Scott Hess" <[EMAIL PROTECTED]> writes:
> On 12/13/06, RB Smissaert <[EMAIL PROTECTED]> wrote:
>> Trying to find the fastest way to determine if a table has no rows.
>>
>> I think this wi
On 12/13/06, RB Smissaert <[EMAIL PROTECTED]> wrote:
Trying to find the fastest way to determine if a table has no rows.
I think this will do:
SELECT (SELECT ROWID FROM table limit 1) IS NOT NULL;
If a table has rows then the result should be 1.
What's wrong with "SELECT COUNT(*) FROM table;"?
On 12/8/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
I appreciate the insight, but I'm not sure it helps with my situation.
This is what I'm trying to accomplish:
1. User selects 1 or more fields from a table using basic "SELECT fields
FROM table" syntax, and the result is retrieved using sq
On 12/7/06, Nuno Lucas <[EMAIL PROTECTED]> wrote:
On 12/7/06, Da Martian <[EMAIL PROTECTED]> wrote:
> Ok, that does answer one of my questions I think. If I passed something not
> in UTF-8 to sqlite would it return it exactly the same way I passed it in?
> From your statement of chaos below I ass
On 11/29/06, Ralf Junker <[EMAIL PROTECTED]> wrote:
* SQLITE_EXTENSION_INIT1
If I compile both fts1 and fts2 into the same executable with
-DSQLITE_CORE=1
-DSQLITE_ENABLE_FTS1=1
-DSQLITE_ENABLE_FTS2=1
I receive a linker warning that sqlite3_api is defined in both fts1.c and
fts2.c.
The
http://www.sqlite.org/cvstrac/tktview?tn=2046 should fix this for fts1 and fts2.
-scott
On 11/21/06, Ralf Junker <[EMAIL PROTECTED]> wrote:
Hello Scott Hess,
>>Not directly related to the format change, but did you have a chance
>>to look at ticket #2046?
>
>Yes,
thousands of characters, so not likely for most
natural language texts).
I have no further plans that will require changes to fts2's storage
format. I hope there aren't any bugs designed in :-).
-scott
On 11/13/06, Scott Hess <[EMAIL PROTECTED]> wrote:
http://www.sqlite.org/cvs
On 10/31/06, Bryan Oakley <[EMAIL PROTECTED]> wrote:
Given that, is there a reliable, portable way to copy a memory db to
disk, when that db makes use of the FTS1 module?
I've been pondering this, and nothing good came of it :-).
My best suggestion would be to modify your copy system to first
On 11/14/06, Vikram Bhandoh <[EMAIL PROTECTED]> wrote:
I'm using fts2 to index some documents. And I want to get a list of all the
distinct terms that are in those documents. Is there a seperate table which
holds the terms or is there a function maybe like snippet, offset?
Just to clarify - you
m (see the email snippet below).
I'm going to try to get a couple other format-changes checked in this
week, in the hopes of getting the fts2 file format frozen.
Thanks,
scott
On 10/12/06, Scott Hess <[EMAIL PROTECTED]> wrote:
Caveats: It uses a new storage format, and there is cur
On 11/7/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
* You never get an SQLITE_SCHEMA error. sqlite3_prepare_v2
retains the original SQL and automatically reprepares and
rebinds it following a schema change.
Does this part of the change require a new API at all?
* sqlite3_step(
On 10/30/06, Joe Wilson <[EMAIL PROTECTED]> wrote:
If you have only one index, then pre-sorting your large datasets prior to
inserting with the default sqlite cache will yield twice as good insert
performance as not pre-sorting your data and using a huge cache.
This stands to reason since you're
In some database systems, it can be beneficial to use "NOT NULL" as
much as possible when defining tables. It usually allows for a
slightly tighter storage encoding, and also allows some optimizations
to occur.
AFAICT, in sqlite it only seems important for constraining the data
appropriately. F
On 10/12/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote:
That's very cool... What i am wondering is if is there any way to
download the complete tarball of that folder...
thanks.
On 10/13/06, Scott Hess <[EMAIL PROTECTED]> wrote:
> I've checked a new vers
I've checked a new version of the full-text search module into
ext/fts2 under CVS. fts2 uses a very different style of storage from
fts1, and is much much faster for insertions (25x faster inserting the
Enron email database, for instance). The interface is identical, you
just refer to fts2 inste
401 - 428 of 428 matches
Mail list logo
