'.dump' dump.sql
fossil diff dump.sql
With SQLite we can do many things very simple. Why not?
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman
in table/view/index/trigger definitions:
sqlite create table t(x /* :-) */); sqlite .schema CREATE TABLE t(x
/* :-) */);
Regards, Clemens
Bad idea. The schema definition can't be modified!
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel
from some bindings (including official
tclsqlite) when column types are non-standard.
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite
Hello!
And as result it's impossible to search docs in some situations:
SELECT * FROM docs WHERE docs MATCH 'NOT sqlite';
Error: malformed MATCH expression: [NOT sqlite]
As far as I can tell, in MATCH syntax NOT is a binary operator, denoting
set difference. You are trying to use it as a
]
And as result it's impossible to search docs in some situations:
SELECT * FROM docs WHERE docs MATCH 'NOT sqlite';
Error: malformed MATCH expression: [NOT sqlite]
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
Hello!
Sqlite databases 10Gb+ sizes work fine for me in multi-user web environment
and 100Gb+ sizes were tested in my scenarios. The unsupported index
compression is the main problem and so use more scalable FTS4 index when
possible.
Best regards, Alexey.
http://pechnikov.tel
17.12.2012 0:03
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
|e9b4d0bcb5
sqlite INSERT INTO address_fts0(address_fts0) VALUES('rebuild');
sqlite select count(*) from address_fts0 where sys_title:hash match
'e7d4683bb2';
count(*)
0
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing
). May be is more reasonable to make the
content of FTS table synchronized with the content of external table by FTS
extension internally?
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http
regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users
/www/design.wiki
Just thought some people might enjoy reading and thinking about it.
Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--
Best regards, Alexey Pechnikov
The sqlite3_stricmp() function is used only once in FTS3 extension and I
did fix the problem by replacing it to sqlite3_strnicmp()
http://sqlite.mobigroup.ru/fdiff?v1=111626ce72b0df93v2=29b395d2169466ab
2012/4/9 Alexey Pechnikov pechni...@mobigroup.ru
As I find is missed sqlite3_stricmp
regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
'));
1005589861
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
As I find is missed sqlite3_stricmp reference in file loadext.c
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
that?
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Advanced GEOINT Solutions Operating Unit
Northrop Grumman Information Systems
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org]
on behalf of Alexey Pechnikov
Compiled as extension FTS3 module produce error undefined symbol:
sqlite3_stricmp by loading.
The problem exists in last release and current trunk.
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users
for instructions
Enter SQL statements terminated with a ;
sqlite SELECT load_extension('/usr/lib/libsqlitefts3.so');
load_extension('/usr/lib/libsqlitefts3.so')
sqlite
2012/4/7 Richard Hipp d...@sqlite.org
On Sat, Apr 7, 2012 at 7:20 AM, Alexey Pechnikov pechni...@mobigroup.ru
wrote:
Compiled
Why INSERT command can't copy all needed fields from external content table
same as rebuild command? The definition of all values does not has any
reasons and can produce inconsistent FTS table.
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel
and formatting dates.
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
2012/4/2 Simon Slavin slav...@bigfraud.org
Please see http://www.sqlite.org/lang_datefunc.html and you will be
frustrated because SQLite can format date/time to different string formats
but can't read the produced date/time strings.
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite
regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
SELECT icu_load_collation('ru_RU', 'russian');
sqlite select 'ы' like 'Ы' collate russian;
0
The problem is old - I did find it first time at 2011.06.28.
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite
, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
-users
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
.
Please let me know.
Thanks.
--
Marco Bambini
http://www.sqlabs.com
http://twitter.com/sqlabs
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--
Best regards, Alexey Pechnikov
per
transaction) or something else?
Sincerely,
Valentin Davydov.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel
the TCL sqlite3 statement open the database using command switchs
(ie --cvs -headers)
--
-Rod
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--
Best regards, Alexey Pechnikov
bs=4096 count=100
and repair after database by using per pages checksums.
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
? Does powersave overwrite feature conflicts
with idea of per pages
checksums?
P.S. The article Berkeley DB Recoverability provides some info about
WAL+checksum mode:
http://help.bdbxml.net/html/ed539869-eebd-478f-97de-7e5377e87f66.htm
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel
-Laco.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing
@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
link to SQLite documentation instead of any astral reasons.
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Of cource you may report your bug! But I'm not sure about possibility
of the bugfix in upstream and so I speak about patch to SQLite binding
for your language.
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
but for backward compability problem
wil not be resolved by upstream. So I did write patch for myself.
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite
The problem can be fixed by variables bindings patch:
http://sqlite.mobigroup.ru/wiki?name=tclsqlite
I think, you can do same for you lang.
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
version
supports 3.7.3), and it uses a more restrictive license (not hard, since any
license is more restrictive than SQLite's non-license!)
It can be used as extensions set for any new SQLite version.
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel
/sqlite-users
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
:8080/cgi-bin/mailman/listinfo/sqlite-users
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
2011/10/25 Dan Kennedy danielk1...@gmail.com:
Not possible. The Tcl interface has no bindings for either the
virtual table or VFS interfaces.
But why? Is there any technical/ideological problems?
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel
efficiently via TEXT INDEX too. But if the overhead is
comparable, I'd rather use FTS.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--
Best regards, Alexey Pechnikov.
http
it :)
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
some overhead for full-text queries that use the index.
So you can work with a big FTS tables without using the optimize method.
I use some FTS tables with tens of millions records and effect of the
optimize
isn't measurable.
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel
/listinfo/sqlite-users
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http
, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
/mailman/listinfo/sqlite-users
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
temp in-memory
database to main disk-database!
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
2011/9/6 jerome moliere jerome.moli...@gmail.com:
Could you give me more details about corruption cases ?
Is there a list of contexts where we can get corrupted tables ?
http://www.sqlite.org/howtocorrupt.html
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel
different pragmas...
we don't know about your environment enough. You may show some
problematic tests as example.
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin
. Is needed the sources of the test programm.
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
2011/8/11 Sumit Gupta gamersu...@gmail.com:
10-10-2011 18:48:42, 10,20, 30, 40, 50, 60, 80 .. 48 such entries
Use unixtime (time in seconds) and index on this field and your
queries will be fast.
You can use single blob as integers array for more compact database.
--
Best regards, Alexey
, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
for Igor.
We can fast search any id by using match operator on FTS table.
P.S. FTS table has nice scalability. Check insertion a lot of records
and insertion speed is constant. I did try 400 millions of records
(and did get database size 100 Gb).
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel
).
Does somebody interesting in this functionality too?
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
2011/8/7 Simon Slavin slav...@bigfraud.org:
For example,
SELECT * FROM cars WHERE cars.name IN ('Corolla', 'Fiesta')
create table t (names TEXT);
insert into t(name) values ('Corolla Fiesta');
SELECT * FROM cars WHERE cars.name IN (select names from t where rowid=1);
--
Best regards, Alexey
'pltcl' IMMUTABLE;
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
000
rows! It's too slow and is not useful in real world. Of cource all
systems store lists of
identifiers in similar situations.
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http
, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
and send RDF or other data format.
I don't see your problem. May be you want any different?..
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo
of the design ideas were cribbed from:
http://www.sqlite.org/cvstrac/wiki?p=UndoRedo
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
2011/8/2 Eric Scouten e...@scouten.com:
It falls apart badly in a highly distributed environment where ...
...
May be a RDF storage is more reasonable for this. Operations with
atomic facts can be highly distributed. And SPARQL is similar to SQL.
--
Best regards, Alexey Pechnikov.
http
2011/8/1 Black, Michael (IS) michael.bla...@ngc.com:
This is a side-question to this thread...but has anybody every done row-level
locking for edit?
What problem are you solving?
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite
2011/8/1 Simon Slavin slav...@bigfraud.org:
On 1 Aug 2011, at 6:56pm, Alexey Pechnikov wrote:
2011/8/1 Black, Michael (IS) michael.bla...@ngc.com:
This is a side-question to this thread...but has anybody every done
row-level locking for edit?
What problem are you solving?
Please stop
2011/8/1 Simon Slavin slav...@bigfraud.org:
I'm sorry Alexey, I was trying to be funny and failed. Your question is very
important for this situation.
Oh, I'm sorry! My english is bad by night :)
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel
knows the semantics of the data.
You write extra code to find and resolve CouchDB replication conflicts but you
are speak about do not have to write extra code. One of these
approvals is false!
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel
data. There are a lot of causes of _potential_
conflicts and replication is only one
of these. Replication is aggregation process but is not silver
bullet for extracting correct data.
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite
regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
mode.
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Very interesting annonce:
http://www.couchbase.com/press-releases/unql-query-language
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite
-exists test_record
rows from host A to host B and from B to A and then regenerate some
rows in test tables.
And Fossil is well-known example of SQLite database replication :D
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users
and revert any changes.
I think easy replication is not feature of NoSQL solutions. With big
disks we can create and
use append-only datasets in SQL DBMS. And virtual table can
incapsulate all details.
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel
ops)
crc32c : 11.447 micros/op; 341.2 MB/s (4K per op)
snappycomp : 8.106 micros/op; (snappy failure)
snappyuncomp : 26.941 micros/op; (snappy failure)
acquireload : 1.407 micros/op; (each op is 1000 loads)
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel
tests faster.
P.S. There is constant database created by DJB. And exists patch to
drop constant
limitation. IMHO it's functionally equal and better solution than LevelDB...
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users
cheaper.
And single-thread without correct synchronous. Plus full in-memory
copy of LevelDB log.
And tests is adopted for specific scenarious (IMHO test of fixed value
size is incorrect).
I'm sure key-value database may be faster.
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel
LevelDB use append log but SQLite is tested without WAL :)
I check and some tests 2.5x faster with WAL.
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin
: 228.869 micros/op;0.5 MB/s (1 ops)
fillseqbatch : 56.131 micros/op;2.0 MB/s
...
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo
is here:
http://pastebin.com/dM2iqdvj
And patch as above plus integer keys instead of blobs
http://pastebin.com/CnBeChWg
P.S. For blob-to-blob mapping we may use table with index on hashed key.
Virtual table can simplify this.
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel
here: http://sqlite.mobigroup.ru/wiki?name=ext_tcl
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
://sqlite.mobigroup.ru/artifact/56df1be3c402d7d49c3a13be704a2ff22c3003d2
http://sqlite.mobigroup.ru/dir?name=ext/compress
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin
. But that email discussion suggests a nifty trick to
overcome this.
And you can get the content size without decompression. It can be useful.
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http
search
as example. It's very common task for many applications.
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
' before it is run.
I wanted to say - we can't rank results differently. The query 'sqlite educate'
may return result 'dbms education' with low rank and 'sqlite education'
with high rank.
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite
With 0-length token in icuNext there is the error:
Error: SQL logic error or missing database
May xNext returns 0 length when the token is stopword?
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users
will not useful.
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
can try stemmed SQLite FTS4 search and
enjoy by fast work.
Note: you can guess the admin user password :D
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin
I want to add stopwords table support for ICU tokenizer but there is
no database handle access (icuOpen).
Any ideas?
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080
With synonyms dictionary the result token length can be more then
original token length.
Is it problem for current realization of FTS?
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http
See FTS3 extension where the full-text index is stored in multi btree
in regular tables. Note: FTS2 is more simple.
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080
database schema (job_user_id_idx) - no such table:
main.job_record
.dump
...
sqlite pragma integrity_check;
*** in database main ***
Page 5 is never used
Page 35 is never used
Page 67 is never used
Page 97 is never used
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel
or affordable?
Thank you.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel
cannot reference objects in attached
databases but view can reference deleted object?
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite
As example, we have view:
create view vtest as select name1 || ' ' || name2 as name from test;
How to get the definition of name field (will be name1 || ' ' ||
name2)? Of cource, the view can be more complex.
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel
The new PRAGMA or Virtual Table will be more useful. But I don't sure
about possibility of this.
2011/6/14 Nico Williams n...@cryptonector.com:
On Tue, Jun 14, 2011 at 1:58 PM, Alexey Pechnikov
pechni...@mobigroup.ru wrote:
As example, we have view:
create view vtest as select name1
In fts3_tokenizer.c these lines are invalid:
#include sqlite3ext.h
#ifndef SQLITE_CORE
SQLITE_EXTENSION_INIT1
#endif
Use single line instead:
#include sqlite3.h
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing
.
--
Thanks Regards
Irfan Khan
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel
1 - 100 of 553 matches
Mail list logo