.db
or
sqlite3 1.db '.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
saves comments 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 regar
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
]
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
* from test_fts where test_fts match 'test';
test
--
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
lete deletion from FTS table and before the new
record insertion into FTS table). 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/
_
s_id=64402;
sqlite> select rowid,"sys_title:hash" from address_fts0 where
"sys_title:hash" match 'e7d4683bb2';
rowid|sys_title:hash
64402|e9b4d0bcb5
sqlite> INSERT INTO address_fts0(address_fts0) VALUES('rebuild');
sqlite> select
> 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://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
> >>
> >
> >
> >
> > --
> > D. Richard Hipp
> > d...@sqlite.org
> > ___
> > 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://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
Y %H:%M:%S', '12.11.2001 18:31:01'));
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
ers 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://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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=111626ce72b0df93=29b395d2169466ab
2012/4/9 Alexey Pechnikov <pechni...@mobigroup.ru>
> As I find is missed sqlite
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
__
> From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org]
> on behalf of Alexey Pechnikov [pechni...@mobigroup.ru]
> Sent: Saturday, April 07, 2012 7:14 AM
> To: General Discussion of SQLite Database
> Subject: EXT :Re: [sqlite] undefined symbol: sqlite3_stricmp
>
>
ter ".help" 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, Alex
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
sq
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://pec
t;
> http://src.opensolaris.org/source/xref/onnv/onnv-gate/usr/src/uts/common/sys/
> (scroll down to u8_textprep.h and u8_textprep_data.h)
>
> Nico
> --
> ___
> 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://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
it. But *requiring* SQLite to link against ICU is a
> deal-breaker for many users.
>
> --
> D. Richard Hipp
> d...@sqlite.org
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> h
> 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://pech
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
sqliteicu.so');
sqlite> 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-
st 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://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
bout to re-invent the wheel, I'ld appreciate a warning.
>
>
> Best regards,
> Niall O'Reilly
> _______
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
--
Best re
n/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
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.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
lite-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://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
=backup.db of=corrupted.db 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://pec
Udi
>> > ___
>> > 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
>>
> ___
> 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://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
; (can I post somewhere bug report, feature request)
> TIA
> -Laco.
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-use
Why not? Please send 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
ersion of SQLite (3.6.16, but a beta 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 P
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://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
if(m.op->stmt)
> m.status = sqlite3_step(m.op->stmt );
> m.status = ghandler(m.top);
> if(m.status == G_RESTART) return;
> } while( m.status == SQLITE_ROW || (m.status == SQLITE_OK) );
> if(m.op->stmt)
> m.status = sqlite3_reset(m.op->stmt);
> }
> else gerror("bind
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://p
nce when writing to an
FTS table, but causes 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.
will be
support 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
h, and both can be
> implemented 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-us
happy to provide more
> details if needed.
> ___
> 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://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
lob.html
>
> --
> D. Richard Hipp
> d...@sqlite.org
> ___
> 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://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>
>
>
> --
> D. Richard Hipp
> d...@sqlite.org
> ___
> sqlite-users mai
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://p
t ..so I prefer to keep it as
> a joker...
Database corruption can't be the result of the coping from 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
t; Jerome
> ___
> 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://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
?
Really, these are nice questions! Jerome, different environments may
have 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/
___
ot right behaviour. 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
ages.
--
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
my test script 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 reg
ery slow.
--
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
an the table of relations (t1.rowid, t2.rowid) will
have 1 000 000 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/
___
sqli
eturn [llength $1]
$BODY$
LANGUAGE '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
-
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
r function).
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
b
P.S. Many 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/lis
export your data 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
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
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://p
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
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://p
est regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
eady
to work with real 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
> since only your code 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
).
And user can view 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:
-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/
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
quot;PRAGMA
synchronous = FULL" in WAL 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
id this. Works for what they need and is lots 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, Alex
ize we can make
some 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/
___
B/s (1000 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.
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
: 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
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
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
while compressing. 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
sq
://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
l be transformed
> to 'dbms educate' 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 P
ms dictionary in PostgreSQL full-text 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
e is russian. You 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:
cation
--
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
Source SQLite DBMS" 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
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
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
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
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
from sqlite_master;
Error: malformed 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 Pe
What is the best tool for this, free or affordable?
>
> Thank you.
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
Best re
VIEW b as select * from a;
This strange, really. View 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.or
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:
>>
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.
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/
___
do
> with other rdbms.
>
> --
>
>
>
> Thanks & Regards
>
> Irfan Khan
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
1 - 100 of 553 matches
Mail list logo