https://www.sqlite.org/queryplanner.html
contains the text "The process is illustrated by figure 2 below." where
the "figure 2" part links to
https://www.sqlite.org/queryplanner.html#fig2
DocSrc: https://www.sqlite.org/docsrc/artifact/ce9ee7160e98d868?ln=100
The link to the image does not
ext/misc/json1.c uses the following functions from the C library:
isalnum(): http://www.sqlite.org/src/artifact/541004e47235cefc?ln=564
isspace(): http://www.sqlite.org/src/artifact/541004e47235cefc?ln=635
isdigit(): http://www.sqlite.org/src/artifact/541004e47235cefc?ln=829
Existing source code
sqlite3rbu.c uses sprintf(), which SQLite3 uses nowhere else:
http://www.sqlite.org/src/artifact/d37e1ca2d13e439c?ln=2643
Could you replace this with sqlite3_mprintf(), just like one function above?
http://www.sqlite.org/src/artifact/d37e1ca2d13e439c?ln=2625-2628
Ralf
sqlite3rbu.c intermingles variable declaration and code, which is not
with ANSI C here:
http://www.sqlite.org/src/artifact/d37e1ca2d13e439c?ln=623-624
Declaring zSql before calling va_start() solves the problem for me:
char *zSql;
va_start(ap, zFmt);
zSql = sqlite3_vmprintf(zFmt, ap);
Warning: sqlite3rbu.c 3528: void functions may not return a value in
function rbuVfsDlClose.
http://www.sqlite.org/src/artifact/d37e1ca2d13e439c?ln=3526-3529
Looks like the return value is not needed.
Ralf
From fts5aux.test 2.3 I conclude that the FTS5 xColumnSize() function
accepts negative column values and returns the total token size of all
columns from the current row:
https://www.sqlite.org/src/artifact/8c687c948cc98e9a?ln=64-66
Indeed, this is also in source:
This SQL
SELECT fts5_expr();
results in an AV here:
https://sqlite.org/src/artifact/56dcbcbdc9029dd7?ln=145
Reason is that fts5ExprFunction() does not check for at least one
argument to fts5_expr() here:
http://sqlite.org/src/artifact/56dcbcbdc9029dd7?ln=1886
Ralf
As per the documentation, extra arguments to the Porter stemmer are
handed on to the underlying tokenizer:
http://www.sqlite.org/docsrc/artifact/9eca0ea509ae3e4d?ln=544-546
Example syntax a few lines below:
http://www.sqlite.org/docsrc/artifact/9eca0ea509ae3e4d?ln=556
However, the code
SQLite 3.8.1 compiled with SQLITE_OMIT_FLAG_PRAGMAS #defined calls
sqlite3_busy_timeout() for all flag pragmas.
Example:
PRAGMA legacy_file_format=100;
should do nothing but sets
sqlite3_busy_timeout(db, 100);
The change was introduced here:
On 23.01.2014 11:28, dean gwilliam wrote:
More specifically...is there the equivalent of that powerbasic include
file for D5 i.e. that enables you to access the dll's function calls
unchanged?
Failing that...anything that will let me work with the latest sqlite 3 dll
The meaner and leaner...the
On 24.01.2014 10:06, Max Vlasov wrote:
BCC 5.5 (freely downloadable) compiles any version of sqlite3 to
object files linkable to Delphi 5 and later, the only drawback I
noticed is that for memory-intensive operations (memory databases) the
performance is twice as worst comparing to the dll on
On 09.05.2014 12:36, Carlos Ferreira wrote:
I am using a win32 DLL built "sqlite-dll-win32-x86-3071700" . the DLL is
from 20-5-2013.
I am using it with Delphi, and it works fine for what I need.
I need however a 64 bits version of the DLL.
SQLite3 for Delphi, both Win32 and Win64, with many
On 09.05.2014 13:50, Carlos Ferreira wrote:
XE6 itself seems to native have access to both...
FireDAC only, and outdated by 2 months at the day of release. Delphi XE5
SQLite is still at 3.7.17, almost one year behind.
DISQLite3 has always been up to date for years and Delphi versions back
internal (*.obj) and extenal
(*.dll).
Visit the DISQLite3 Internet site for latest information and updates:
http://www.yunqa.de/delphi/
Copyright (c) 2011 Ralf Junker, Delphi Inspiration <del...@yunqa.de>
---
For me, this test from test/exists.test fails if both database
connections are opened in WAL mode, that is if "PRAGMA journal_mode=WAL"
is issued right after each DB is opened.
# TABLE objects.
#
do_test{
sql1 { DROP TABLE IF EXISTS t1 }
sql2 { CREATE TABLE t1(x) }
sql1
The test passes well if I recreate the database file anew just prior to
running it so it acts upon an empty database.
If this is what is intended, I apologize for the false alarm.
Ralf
On 10.04.2011 10:28, Ralf Junker wrote:
> For me, this test from test/exists.test fails if both datab
For me, this test from test/exists.test fails if both database
connections are opened in WAL mode, that is if "PRAGMA journal_mode=WAL"
is issued right after each DB is opened.
# TABLE objects.
#
do_test{
sql1 { DROP TABLE IF EXISTS t1 }
sql2 { CREATE TABLE t1(x) }
sql1
VACUUM with multiplex does not delete chunks on Windows (fossil [8ce2b74a82]).
It seems this is because the file handle(s) are still held open by the
multiplex layer when xDelete is triggered. Since Windows can not delete open
files, they are kept.
I have not investigated this in depth, but
On 17.09.2015 20:14, Scott Hess wrote:
> The problem is that there are LOCALE settings where tolower() does things C
> programmers don't expect. I think tr_TR was one case, the handling of 'I'
> (Google "tr_tr locale bug" and you'll see lots of people hitting the same
> general problem). It
My implementation of
http://www.sqlite.org/src/artifact/400384798349d658?ln=94-96
returns "corrupt" plus a trailing zero, that is 8 characters in total.
Maybe this line
http://www.sqlite.org/src/artifact/4fdbc0a321e3a1d7?ln=5364
should be corrected to
sqlite3Fts5BufferSet(, , 7,
These 2 lines seem to serve no purpose. Also, they are not indented like
the reset of the code. This makes me think they might have been left in
from debugging:
http://www.sqlite.org/src/artifact/b271b19dd28d3501?ln=3819-3820
Ralf
Hello Pavan,
>Can we store/retrieve Japanese/korean characters in sqlite db ?
Yes, you can well do so, as others have already pointed out.
If you are also looking for a Unicode GUI SQLite database manager to display
and edit Japanese / Korean character databases, you might want to have a look
Hello Pavan,
>Thanks for the link. My OS is Linux. Is there something available on these
>lines for linux ?
SQLiteSpy apparently runs on Linux with the help of wine, but I have not tested
this myself: http://www.winehq.com/
Ralf
Hello Ralf Junker,
>>Thanks for the link. My OS is Linux. Is there something available on these
>>lines for linux ?
>
>SQLiteSpy apparently runs on Linux with the help of wine, but I have not
>tested this myself: http://www.winehq.com/
Here is a small re
Hello Developers,
I notice that you are about to release version 3.4.0 shortly. I have just
created ticked #2415 which I believe breaks existing code. Are there any chance
that you find the time to look at it prior to 3.4.0?
Ralf
>I'm having a problem saving strings into a colum from a Delphi application
>because they might contain the ( ' ) single quote character:
>
>Is there a function I should call either in SQLite or Delphi before running
>the SQL query?
Why don't you use the '%q' operator of SQLite's
>Question, does the %q operator offer any advantages over calling QuotedStr ?
Yes: The %q operator just duplicates internal quotes, it does insert quotes at
the beginning and the end of the string like QuotedStr does. You can can still
use sqlite3_mprintf's %Q operator for that.
Ralf
>The rowid is the standard SQLite rowid, so it does provide an INTEGER
>PRIMARY KEY AUTOINCREMENT column.
>
>The standard way to have non-TEXT information associated with rows in
>an fts table would be a separate table which joins with the fts table
>on rowid.
I have not tested this, but if the
>>The standard way to have non-TEXT information associated with rows in
>>an fts table would be a separate table which joins with the fts table
>>on rowid.
>
>I have not tested this, but if the FTS2 rowid is the standard SQLite rowid, I
>believe that it will be affected by VACUUM change of
Hello Henrik Ræder,
>I'm trying to load the FTS2 extension in Delphi, using the Aducom
>components. Am really close, but still stuck, and thinking it's a problem
>with the parameter to sqlite3_enable_load_extension().
DISQLite3 (http://www.yunqa.de/delphi/sqlite3/) does not expose such problems.
Hello Roberto,
>Might be a typo, but your declaration defines the calling convention as
>'stdcall' (instead of 'cdecl'), was your sqlite3.dll custom built with this
>calling convention? I don't think much of sqlite would work with stdcall.
DISQLite3 intentionally uses the 'register' calling
Hello Joe Wilson,
>Does it support external sqlite loadable extensions?
Loadable extensions are currently omitted. FTS1 and FTS2 extensions are
provided as built-in modules. User-aware collations sequences using the Windows
sorting functions are provided in place of the ICU extension. Full
Hello Joe Wilson,
>Your product is not useful to a few users like me who require custom
>sqlite functions for their databases.
I am not sure I understand currectly. Only loadable extensions are currently
omited from DISQLite3.
sqlite3_create_function() is very well available in DISQLite3 Pro
>Does DISQLite have its own implementation of FTS, so not using FTS2 at
>all?
DISQLite3 uses the original full text search modules, adapted to Delphi. Both
FTS1 and FTS2 are already compiled in, and can both be used by the same
application (like SQLiteSpy does).
>Does it use the same
Hello Zlatko Matic,
>How about Lazarus version of DISQLite3? :)
DISQLite3 is Delphi only at the moment, maybe later! ;-)
Ralf
-
To unsubscribe, send email to [EMAIL PROTECTED]
DISQLite3 does not use SQLite.NET.
As I read Sam, he did not say so. He just compared the two to support his
argument that "loadable extensions are not required to create custom functions
and having access to source is not required for custom functions either".
Ralf
>I was not aware that
This one just came to my mind:
CREATE TABLE (rowid INTEGER PRIMARY KEY, t TEXT);
This promotes "rowid" to a visible column "rowid" which does not change during
a VACUUM. "rowid" is already a reserved word in SQLite. Maybe this option is
even compatible to FTS2?
Ralf
>ext/fts3.c in the
llbacks, before I try?
Regards,
Ralf
>On 8/31/07, Ralf Junker <[EMAIL PROTECTED]> wrote:
>> This one just came to my mind:
>>
>> CREATE TABLE (rowid INTEGER PRIMARY KEY, t TEXT);
>>
>> This promotes "rowid" to a visible column "rowid"
>Isn't it time to drop the Win9X support from the default build?
I do not believe that just because Win9x is missing a single required call
justifies dropping support for it altogether!
>I'm thinking that any optimization should be enabled for the majority of
>users. Or if it's not really an
Hello Andre du Plessis,
If you are using Delphi, FTS3 is already included in the latest DISQLite3 (Pro
and Personal). Download is available from http://www.yunqa.de/delphi/.
The source code is available from CVS. You will find FTS3 in the /ext/
directory.
Ralf
>Fts3 which everyone is talking
I am writing to ask for help about how to solve The Lemon parser conflicts.
As part of a larger grammar, I am need to implement this regular expression in
Lemon:
(.+|'.+')+
I tried lots of grammars, but all of them generated Lemon warnings.
Maybe someone could have a look at the grammar
Richard,
this helped me greatly! I also derived from your example that I can use
multiple characters without conflicts like this:
---
doc ::= inline_list.
// List of allowed characters. Add more as you like.
c ::= CHAR.
c ::= SPACE.
// The c character repeat.
chars ::= c.
chars
Richard,
this helped me greatly! I also derived from your example that I can use
multiple characters without conflicts like this:
---
doc ::= inline_list.
// List of allowed characters. Add more as you like.
c ::= CHAR.
c ::= SPACE.
// The c character repeat.
chars ::= c.
chars
Hello,
I wonder if it is possible to retrieve bound host parameters from a prepared
SQL statement? I am thinking of the opposite of the sqlite3_bind... family of
functions like:
int sqlite3_bound_int (sqlite3_stmt*, int*);
int sqlite3_bound_double (sqlite3_stmt*, double*);
They would be
>> I wonder if it is possible to retrieve bound host parameters from a prepared
>> SQL statement? I am
>> thinking of the opposite of the sqlite3_bind... family of functions like:
>>
>> int sqlite3_bound_int (sqlite3_stmt*, int*);
>> int sqlite3_bound_double (sqlite3_stmt*, double*);
>
Hello Dan Kennedy,
>> True, but we would need to access unsupported API to do so.
>> And as we know only too well, unsupported API is subject to
>> change without notice any time ;-). Therefore I would rather
>> not write these myself but ask for the possibility to add them
>> to the library
Hello Joe Wilson,
>> True, but we would need to access unsupported API to do so. And as we know
>> only too well,
>> unsupported API is subject to change without notice any time ;-). Therefore
>> I would rather not
>> write these myself but ask for the possibility to add them to the library
>>
>But to do so seems likely to require an incompatible change to the
>virtual-table interface.
Could I kindly request an addition to the incompatible change to the
virtual-table interface?
I would very much appreciate a corresponding function to
function xRowID(
pCursor:
Hello,
I wonder if sqlite3_reset() can ever fail. In particular, does sqlite3_reset()
always reset the statement even if it returns an error code?
>From the documentation and mailing list, my understanding is that
>sqlite3_reset() errors always relate to the latest (or possibly ongoing) VM
Imagine that a SQLite3 database opened in a custom application with a
registered a collation sequence named "unknown" has created the following table:
CREATE TABLE a (b COLLATE unknown);
Now open this table in the default SQLite3 CLI. Up to here, everything works as
expected.
Now some
>> Imagine that a SQLite3 database opened in a custom application with a
>> registered a collation sequence named "unknown" has created the following
>> table:
>>
>> CREATE TABLE a (b COLLATE unknown);
>>
>> Now open this table in the default SQLite3 CLI. Up to here, everything works
>> as
I am trying to write a Wiki parser with Lemon. The Lemon features suite my
needs perfectly, but I am unfortunately stuck with the problem of parsing
conflicts.
All conflicts seem caused by repeat constructs like this:
text ::= textpiece.
text ::= text textpiece.
The complete grammar
Many thanks, Joe,
>Your grammar is ambiguous. The text tokens run together for
>various rules because the grammar lacks clear separators between
>them.
OK, I begin to understand. The "clear separators" need to be TERMINALs, right?
I believed that these were imlicit because there are TEXT and
Hello Trevor Talbot,
>> Trevor, I am not sure what you mean by "subselect on its own". Is this what
>> you are looking for?
>
>> sqlite> SELECT * FROM (SELECT * FROM a);
>> SQL error: no such collation sequence: unknown
>
>Yes, exactly. I was curious to see if it made any kind of difference.
Joe Wilson <[EMAIL PROTECTED]> wrote:
>The following grammar may be clearer to you:
Yes, it is many thanks! I believe I am making progress! At least I can see the
picture much clearer now and was able to come up with the following grammar
with just one conflict unsolved:
%left NEWLINE.
DRH wrote:
>Legacy applications should continue to work. You might get a
>compiler warning about a type mismatch on the 2nd parameter to
>sqlite3_trace(). But calling a 2-parameter function with 3
>parameters is suppose to be harmless in C.
Harmless in C, but not so in other languages. I
Roger Binns wrote:
>The biggest problem with the trace api is that there is no way to find
>out what the bound parameters were. If an application follows best
>practise using bound parameters all over then the trace api is rather
>useless.
Thanks for bringing this up again. There was a thread
Hello Bharath Booshan L,
yes, with SQLiteSpy you can do this:
drop table if exists t;
create table t (id integer primary key, filepath text);
insert into t values (1, '/Volumes/Backup/MyMovies/MyMovie.mp4');
insert into t values (2, '/Volumes/Backup/MyMovies/Hello.mp4');
insert into t values (3,
Hello Nicolas Williams,
>I suppose that to make this generic so that users can replace the
>regexp, like, and glob functions would require some new interfaces.
I believe so, too. The like and glob optimization is part of where.c and
outside the reach of sqlite3_create_function().
>SQLite would
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.
Ralf
-
To unsubscribe, send email
Different tasks require different approaches. Therefore DISQLite3 offers three
levels of abstraction to Delphi developers:
1. The full SQLite3 API, all contained in a single Delphi unit. Best suited to
all who like direct access to the SQLite3 interface or want to write their own,
app-specific
SQLiteSpy 1.5.4 is released. Changes include:
* Updated to SQLite3 3.3.6.
* The schema tree view did not automatically reflect if a table was emptied or
initial records were being added.
* The default text encoding for newly generated database files is now UTF-8.
* Fixed a nasty bug which
Hello C.Peachment,
>1. SQLiteSpy is able to read and work with database files
>formatted by versions of Sqlite earlier than 3.3.6 but it also
>appears to change the database format rather than leave
>it as it was found.
>
>I use php version 5.1.4 including Sqlite version 3.2.8.
>There is a
D.Richard Hipp <[EMAIL PROTECTED]> wrote:
>Perhaps it would be sufficient to take snapshots of the wiki and
>ship that with each release?
Yes, shipping wiki snapshots with each build should be fine.
Even better: A versioned wiki - so users of legacy versions can edit and
improve documentation
Hello C.Peachment,
>It appears that VACUUM is not the only SQL command to cause
>this behaviour. I had done a number of INSERT and UPDATE
>commands before closing the database and attempting to use
>it with PHP. The VACUUM command was not used.
I am surprised to read this. I would be interested
Hello All,
I have played with the new Virtual Table interface from CVS and found some
shortcommings for the current implementation of the xRowID method:
int (*xRowid)(sqlite3_vtab_cursor*, sqlite_int64 *pRowid);
As far as I understand, this function is called by SQLite whenever it needs a
>> 2. In case the virtual table implementation needs to allocate memory in
>> order to uniquely
>> describe a row/item, this memory needs to be freed when no longer used. As I
>> see it, there is no
>> such method in the Virtual Table implementation.
>
>Maybe the transaction part of the virtual
Hello,
I have a few remarks concerning the Virtual Table interface as it is currently
defined in CVS. I am very enthusiastic about the Virtual Table concept but can
see a few limitations. Time permitting, I kindly ask the core developers to
give a short feedback that they have taken notice of
Lattest cvs sqlite version:
If SQLITE_OMIT_TRIGGER is set, linker complains about an unresolved
_sqlite3ExprCodeAndCache symbol.
sqlite3ExprCodeAndCache is defined in expr.c and wrapped with #ifndef
SQLITE_OMIT_TRIGGER.
However, references in
insert.c, line 536
update.c, line 348 and
>> Is it safe (or even required?) to change sqliteInt.h to
>>
>> #ifndef SQLITE_OMIT_TRIGGER
>> void sqlite3ExprCodeAndCache(Parse*, Expr*);
>> #else
>> # define sqlite3ExprCodeAndCache(A,B)
>> #endif
>>
>
>The suggested change will probably fail. You can find out
>by running:
>
>
I want to use this SQL query to retrieve the offsets information for a single
FTS1 result:
select rowid, offsets (x) from x where Content match 'search' and rowid = 1;
Surprisingly, the query fails due to
Error 1: unable to use function MATCH in the requested context.
It seems that MATCH
Hello [EMAIL PROTECTED],
> I am using SQliteSpy 1.5.5 for to execute de sql statement for fill the
>table.
SQLiteSpy is fully Unicode enabled, including the SQL editor. Hence, it
correctly stores text in whatever UTF format your database uses. This includes
tilde as well as French accented
Hello Scott Hess,
>http://www.sqlite.org/cvstrac/tktview?tn=2046 should fix this for fts1 and
>fts2.
I have just tested them in both fts1 and fts2 and the reported problems no
longer show! Many thanks for the fixes!
Please allow me to report some (compiler-independent) compiler warnings about
Hello Nicolas Williams,
>No, but having built-in functions that can do codeset conversion would
>be nice.
SQLiteSpy can do this: http://www.yunqa.de/delphi/sqlitespy/
-
To unsubscribe, send email to [EMAIL PROTECTED]
>Were you saying there was a driver to connect to both Interbase
dbExpress. The Delphi help has all the details.
>and SQLite like an ODBC driver?
DISQLite3 (http://www.yunqa.de/delphi/sqlite3/) gives direct access to SQLite,
using the original SQLite API as you know it. Component wrappers or
Hello Michael Hooker,
>I shall try using a Delphi wrapper later on, DiSQLite3 will probably be the
>one I will choose, but so far I'm struggling to understand the examples
>because the author has chosen to use a maze of separate units and an
>unfamiliar set of external third party components to
I recently receive this error message when checking out from CVS:
cvs checkout: dying gasps from www.sqlite.org unexpected
I am using the latest stable CVS.exe for Windows from
http://ftp.gnu.org/non-gnu/cvs/binary/stable/x86-woe/cvs-1-11-22.zip
I am running these commands:
cvs -d
>> Can somebody who understands or regularly uses windows please
>> look into it for me.
>
>It seems like changing
>nByte = GetFullPathNameW(zWide, 0, 0, ) + 1;
>to
>nByte = GetFullPathNameW(zWide, 0, 0, ) + 3;
>corrects the problem.
Not a solution to the problem, but a small optimization
Hello Scott Hess,
>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 for those fixes, they really work - as tested with sensitive German
umlauts like 'ÄÖÜäöü'.
Btw: Are there any
>For select, update, insert, or delete is there a way to get the number
>of rows affected?
http://www.sqlite.org/capi3ref.html#sqlite3_changes
Ralf
-
To unsubscribe, send email to [EMAIL PROTECTED]
>I plan to release 3.3.12 later today or tomorrow.
>If you know about any unreported problems, please
>get those bug reports in quickly. Tnx.
My vote for ticket #2183: It causes SQLite to crash with an access violation. I
am keeping my fingers crossed ...
Regards,
Ralf
Hello Rob Richardson,
>The only tool I have for examining and manipulating SQLite databases is
>SQLiteSpy. If I want to change data in that program, I have to write an
>SQL statement. Every other database editor I've seen lets a use do
>simple things from a grid.
As the author of SQLiteSpy:
>> The SQLite library lacks certain API required to implement cell
>> editing: Most notably, there is no functionality to retrieve
>> the exact origin (table, row and column) of a cell, which must
>> be known to store back the modified value.
>
>See:
>
>
Hello Robert Simpson,
>For the SQLite ADO.NET wrapper, I actually wrote two functions into the core
>engine to help me retrieve key information. My requirements were a little
>more complex than just getting rowid, but here's what I did to get me that
>far at least:
>
>Given a sqlite_stmt pointer
Hello Nemanja Corlija,
>>PS: For anyone interested: The new SQLiteSpy with table cell editing is now
>>available at http://www.yunqa.de/delphi/sqlitespy/
>Ralf, thanks SQLiteSpy. Download link is not working though.
Thanks for reporting the problem. The link is now fixed and working all right.
Hello Mikey C,
>If anyone is having problems downloading the file (which is large as it
>contains debug & release binaries and all the obj files), please email me at
>[EMAIL PROTECTED] and I'll email just the raw source code only.
Would it be possible to upload just the raw source code as a
>> > So make the wiki available for download. ;)
>>
>> I would like this too. ;)
>>
>> Often I'm working without an internet connection and a having a local
>> copy of the Wiki would be extremely useful.
>>
>
>Been working on this for years. Literally. I just never seem to
>find the time to
Hello jp,
with DISQLite3, I use the the following colation callback function without
problems:
function SQLite3_Compare_System_NoCase_Ansi(
UserData: Pointer;
l1: Integer; const s1: Pointer;
l2: Integer; const s2: Pointer): Integer;
begin
Result := CompareStringA(LOCALE_SYSTEM_DEFAULT,
Hello jp,
>Thanks Ralf, that seems to be more stable - the process is not crashing
>anymore (ran it twice, no errors).
Glad to read this!
>Pardon my ignorance - I am still using cdecl, how can I use 'register'?
>Doesn't sqlite expects cdecl?
There is no ignorance involved: The sqlite3.dll of
I wonder if there is some effort already under way to allow custom tokenizers
by SQLite's full text search?
I know that custom tokenizers are already on the developer's todo-list, but I
would be interested to know if some progess has already been made.
Custom tokenizers would be able solve a
>But what about:
>
>I am very interested to know if it would be possible to use an FTS indexing
>module to store the inverted index only, but
>not the document's text. This would safe disk space if the text to index is
>stored on disk rather than inside the database.
This is possible with just
Ion Silvestru wrote:
>Just a question: did you eliminated stop-words in your tests?
No, I did not eliminate any stop-words. The two test runs were equal except for
the small changes in FTS 2.
My stop words question was not intended for source code but for human language
texts.
Ralf
Hello Scott,
I was hoping that you would read my message, many thanks for your reply!
>UPDATE and DELETE need to have the previous document text, because the
>docids are embedded in the index, and there is no docid->term index
>(or, put another way, the previous document text _is_ the
Scott Hess wrote:
>>I am optimistic that the proper implementation will use even less than 50%:
>
>Indeed :-).
Glad to read this ;-)
>>I found that _not_ adding the original text turned out to be a great time
>>saver. This makes sense if we know that the original text is about 4 times
>>the
This is SQLite 3.6.23.1 compiled with SQLITE_ENABLE_UPDATE_DELETE_LIMIT
(plus a few others, which should not matter to the problem).
The UPDATE ... LIMIT clause works fine when applied to tables, but
suppresses any updates when applied to a view with an update trigger.
Here is some example
Related to constraint violations, an error message returned by
sqlite3_errmsg() changes to the better after calling sqlite3_reset() or
sqlite3_finalize().
Example code is below, here is the output:
sqlite3_step: 19 constraint failed
sqlite3_reset:19 t.c may not be NULL
SQLite 3.7.2 has a regression with journal_mode=off and
locking_mode=exclusive. Here is the SQL reproduce:
drop table if exists t1;
PRAGMA locking_mode=exclusive;
pragma locking_mode;
CREATE TABLE t1(a PRIMARY KEY, b);
PRAGMA journal_mode = off;
BEGIN;
INSERT INTO t1 VALUES(13,
On 27.08.2010 18:58, Noah Hart wrote:
> http://www.sqlite.org/pragma.html#pragma_journal_mode states
>
> The OFF journaling mode disables the atomic commit and rollback capabilities
> of SQLite. The ROLLBACK command no longer works; it behaves in an undefined
> way. Applications must avoid using
On 11.09.2010 20:42, Stef Mientki wrote:
> is there a program that converts sqlite database from windows-1252 to utf-8?
Yes, SQLiteSpy does this:
* Open database file
* Menu Execute -> Text to Unicode Conversion.
* Select tables and columns to convert.
* Choose database codepage.
* Press OK to
Check-in [876845661a] (http://www.sqlite.org/src/info/876845661a) is
incomplete: fts2_tokenizer.c still contains calls to isalnum() and
tolower() for FTS2.
FTS1 also #includes , just in case you care to remove it from
SQLite completely. The changes are just like for FTS2.
Ralf
1 - 100 of 273 matches
Mail list logo
