>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
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
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
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,
>> > 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 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
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 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
>> 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 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:
>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
>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]
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
>> 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
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
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
>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 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]
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 [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
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
>> 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:
>
>
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
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
>> 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 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
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
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,
>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
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
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
>sqlite_master is it. there are no others.
How about sqlite_temp_master? Or database.sqlite_master for connected
databases?
Hello Dennis Cote,
>This should probably be fixed when your proposal is implemented.
I just pray and hope that it will ...
Ralf
Hello Dennis,
please ignore my previous response - it is all wrong because I used the wrong
table definitions and data (see below for corrections). My appologies for this,
and thanks for holding on to sqlite3_column_rowid.
>I like your proposal, and I understand what you want it for (at least
Hello Dennis Cote,
> SELECT c1, c2, c3 FROM a NATURAL JOIN b;
> SELECT c1, c2, c3 FROM a JOIN b USING(c1);
>
>There is no way to know which table the c1 column value is associated with
>(technically the selected columns in such joins don't belong to either table
>according to the SQL standard)
>What does it do with queries that are pulling data from multiple tables? How
>about computed column data?
>
>Consider these queries:
>
> SELECT a.c2, b.c3 FROM a, b WHERE a.c1 = b.c1;
For field a.c2:
* sqlite3_column_rowid(0) returns RowID for field 'a2' in table 'a' from
which the
Hello to all,
I would like to propose a new API function:
long long int sqlite3_column_rowid(sqlite3_stmt*, int iCol);
As the name implies, this function would return the RowID for a given column
after sqlite3_step has returned SQLITE_DATA. The RowID would be valid for the
database and
I second this.
>I think real problem is that you have a function
>called "column_type" which doesn't actually return
>the type of a column. This is counter-intutive.
A more telling name for sqlite3_column_type would probably be sqlite3_cell_type.
>If you could make it return the column
Hello Preston & Chrystie,
I can reproduce the error with SQLiteSpy.
I think it you should create a bug report ticket on www.sqlite.org, if you have
not already done so.
Regards,
Ralf
>Hi all,
>I recently upgraded my project from 3.2.2 to 3.3.5 (or if you look at
>my last post 3.4.5 ;) and
Is there more information available on saving and loading prepared statements
and omitting the parser from the library?
Thanks & Regards,
Ralf
>the parser can be completely omitted from the SQLite library,
>reducing the library footprint to as small as 60KiB.
>That can be very helpful for
>Would it be useful to have recursive DELETE triggers
>even without recursive INSERT or UPDATE triggers?
Recursive DELETE triggers would certainly be usefull and have in fact already
been asked for on this list occasionally. They would allow to move referential
integrity of hierarchical data
Hello Richard,
in case of stating the obvious: Thanks for your answer! It is always my
pleasure reading your explanations on SQLite: Quick, precise, and right up to
the point!
Ralf
>> While I understand from the FAQ that it might be problematic to use more
>> than one thread with
Hello Rob Lohman,
SQLite is multithreaded since 3.3.1. Still, threre are restrictions:
"When shared-cache mode is enabled, a database connection may only be used by
the thread that called sqlite3_open() to create it. If another thread attempts
to use the database connection, in most cases an
Hello Ludovic Ferrandis,
thanks, but this is not quite true for the latest version:
http://www.sqlite.org/faq.html#q8 reads:
"The restriction on moving database connections across threads was relaxed
somewhat in version 3.3.1. With that and subsequent versions, it is safe to
move a connection
Hello,
I am using SQLite compiled with SQLITE_ENABLE_MEMORY_MANAGEMENT on Win32.
I execute the following psydocode, all with same DB handle:
* In application's main thread: sqlite3_open
* Create a new thread
* In new thread: sqlite3_close
This creates an access violation in pager.c, lines 2065
>But I do not think that DOS has the ability
>to automatically delete a file when it is closed, so the
>files remain on disk after SQLite has finished with them.
Just a thought:
Wouldn't it possible to have SQLite thoughtfully delete all files it creates
when closing the database instead of
Hello Joe Wilson,
I want to thank you and everybody else to share their thoughts on SQLiteSpy and
let you know that I very much value your feedback. I initially wrote SQLiteSpy
for my own personal needs only, but it has since then certainly improved thanks
to the responses I have received by
Hello Nahor,
there is no need for you to use SQLiteSpy 1.4 to create SQLite 3.2.x compatible
database files. You can do so with the latest version of SQLiteSpy as well.
Here's how to do so:
1. Create a new database as usual.
2. Execute the following two SQL statements:
PRAGMA
Hello Joe Wilson,
the build-in database engine is a much praised feature of SQLiteSpy. It
simplifies the life of many users, and mine as well, since there can be no
incompatabilities with wrong DLLs and versions.
I am sorry that you can not use SQLiteSpy with your custom DLL. Maybe you would
Hello,
the new SQLiteSpy 1.5.1 has just been released. SQLiteSpy is a single-exe
database manager for SQLite with the complete SQLite library already build in.
SQLiteSpy is the ideal tool for developers as well as customers who want to
explore the insides of their SQLite databases.
SQLiteSpy
Hello John,
look here for SQLiteSpy, a popular SQLite GUI for Windows 32:
http://www.yunqa.de/delphi/sqlitespy/
SQLiteSpy aims to take the philosophy behind SQLite to the GUI level:
* Ease of use: SQLiteSpy comes as a single *.exe file,
with no installation required
* Simplicity:
Hello Miha Vrhovnik,
my DISQLite3 package for Delphi contains a unit named DISQLite3Collations.pas
which contains various collation callback functions to implement Unicode /
WideString and ANSI string comparisons, both with and without case sensitivity,
based on the current user's locale:
Hello Allan, Mark,
I am not sure, but I don't think recursive delete triggers apply to your
web-page example.
I was looking for recursive delete triggers because the information I need to
store in a single table is hierarchical in a sense that a record can refer to
another record in the same
Hello [EMAIL PROTECTED],
Thank you! I am very much looking forward to recursive delete triggers for just
the very purpose you mentioned!
Regards,
Ralf
>Not at this time. Though work is underway to change this.
>We need recusive delete triggers in order to implement
>cascadinig deletes for
Hello René Tegel,
>May i add to that that 'order by' also seems involved, see below. This can
>lead to really unexpected errors... "order by 1.0 * b / c" as workaround
>solves it btw.
Thanks for pointing this out.
I am sure we will be able to come up with even more examples where the
Hello DRH,
>> 3. If the division of INTEGERs can not be stored as an INTEGER
>>(i.e. if a % b != 0), the result should be returned as a REAL.
>>
>
>create table t1( a integer, b integer);
>insert into t1 values(5,2);
>update t1 set a=a/b;
>
>If your rule above was in force, this would leave
Hello Jay Sprenkle,
>I guess if you're going to use sqlite you're going to have to
>force typing explicitly if you're doing math with the sql engine.
Quite right, but even with explicit typing there are cases where SQLite3 can
not be instructed to store REAL numbers as REALs:
C:\>sqlite3
The following table sums up the division findings from other SQL engines:
|SELECT 5 / 2 | SELECT 5.0 / 2 | SELECT 5 / 2.0 | SELECT 5.0 / 2.0
--
SQLite3| 2 | 2.5| 2.5| 2.5
Hello Dennis & Jay,
thanks for your detailed answers. I do understand your arguments and they make
good sense for typed DB engines, but for the case of SQLite3 I dare to differ.
>This can be fixed by checking the column affinity for a value when it is
>stored. If an integer value is being
Hello Eno Thereska,
>Is there a version for Linux? So far I have only found slqbrowser being
>useful/free free Linux.
No, SQLiteSpy is only available for Win32.
>Sqlitespy for windows looks pretty nice, btw.
Thanks, it's much appreciated.
Regards,
Ralf
Hello Koen,
have you tried SQLiteSpy? It has a nice schema tree and multiple, tabbed SQL
edits to execute commands and queries. Data retrieval is very fast, the memory
requirements low.
SQLiteSpy is freeware for personal use. Commercial users are kindly asked for a
small dontaion. Download
>I don't like using the MSLU because its a dependency that up until now SQLite
>has not had. Since the unicows.dll is not part of a standard Windows
>installation, it would require developers to redistribute that DLL in addition
>to the sqlite DLL.
I very much agree with Robert for the
1. You are still passing UTF-8 strings to Win95/98/ME file. No Windows version
(not Win95 nor NT) accepts UTF-8 strings, especially not those ending with ...A
and ...W.
The only functions taking any other codepages are a few functions which
especially deal with strings and codepage
The new update of SQLiteSpy has just been released.
SQLiteSpy is a graphical SQLite3 database browser, explorer and analyzer for
Windows 32 platforms.
SQLiteSpy features a database schema tree, full Unicode support, type colored
data grids, regular expression support, and more.
SQLiteSpy is
Hello DRH,
there is a documentation error in lang_expr.html. The current HTML reads:
"A CAST expression changes the datatype of the into the type specified by . can
be any non-empty type name that if valid for the type in a column definition of
a CREATE TABLE statement."
The in the TCL
Hello Clark Christensen,
SQLiteSpy executes the query "select date('2005-08-19');" with no problems.
SQLiteSpy is a free SQLite3 database manager and is similar to EXP. To
testdrive SQLiteSpy, download your copy from
http://www.yunqa.de/delphi/sqlitespy/
Regards,
Ralf
>If appropriate for
Hello L. S.,
you can create a HTML version by running the TCL scripts which are part of the
tarball sources.
I have compiled a MS Windows HTML Help document from these. The Help file is
part of DISQLite3, a Delphi wrapper of SQLite3. Even if you do not use Delphi,
you might still be
Hello Brown, Dave,
I don't receive any errors executing your SQL script with my SQLiteSpy database
explorer, which uses version 3.2.2 of the SQLite library.
Maybe you have accidentally inserted a newline into your script which
terminates the "--" comment?
Regards,
Ralf
PS: SQLiteSpy home:
SQLite stores text as UTF-8 - this is the default and it can be changed to
UTF16, but you would probably encounter similar problems.
"ü" is the UTF-8 representation of "ü" - to retrieve and display the German
Umlaut you must decode the UTF-8 encoded text to its Unicode representation.
For
asy. See:
>
>http:/lazarus.freepascal.org
>
>Matt
>
>On Wed, 2005-06-15 at 15:17 +0100, Ralf Junker wrote:
>> Hello Jarek,
>>
>> there are no naive questions, just naive answers ...
>>
>> >perhaps I'm naive, but are there any chances for versio
Hello All,
a new version of the SQLiteSpy database manager is just released:
http://www.yunqa.de/delphi/sqlitespy/
SQLiteSpy is a fast and memory optimized database manager for SQLite 3 database
files with complete Unicode support for both input and display.
All schema items (tables, views,
Hello F.W.A. van Leeuwen,
I have reason to believe that the the problem you describe might be present in
my "SQLite Spy" (http://www.yunqa.de/delphi/sqlitespy/) as well, since the
program is very similar to SQLite3 explorer.
However, I was not able to reproduce the problem with SQLite3
201 - 272 of 272 matches
Mail list logo