other rdbms.
>
> --
>
>
>
> Thanks & Regards
>
> Irfan Khan
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
-
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/
___
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
The new PRAGMA or Virtual Table will be more useful. But I don't sure
about possibility of this.
2011/6/14 Nico Williams :
> On Tue, Jun 14, 2011 at 1:58 PM, Alexey Pechnikov
> wrote:
>> As example, we have view:
>>
>> create view vtest as select name1 || &
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
, free 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/
__
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
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
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
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
"Open 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
from fts where fts match 'sqlite educate'
SQLite may be useful for education
--
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
mmed 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/mailman/listinfo/sqlite-users
stgreSQL 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
rmed
> 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 Pechnikov.
h
http://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/cg
scussion 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://sql
'a c b');
a b c
SELECT TCLCMD('lsort', '-decreasing', 'a c b');
c b a
SELECT TCLCMD('lreverse', 'a c b');
b c a
SELECT TCLCMD('lsearch', 'a c b', 'b');
2
SELECT TCLCMD('lsearch', 'a c b', 'd');
-1
See details 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
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
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
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.
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/
__
ey 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,
nous = 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
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/
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/
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 Pechnikov.
http://pechnikov.tel/
___
ata. 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/
___
want 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
2011/8/1 Black, Michael (IS) :
> 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-users mailin
2011/8/1 Simon Slavin :
>
> On 1 Aug 2011, at 6:56pm, Alexey Pechnikov wrote:
>
>> 2011/8/1 Black, Michael (IS) :
>>> This is a side-question to this thread...but has anybody every done
>>> row-level locking for edit?
>>
>> What problem are you solv
2011/8/1 Simon Slavin :
> 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/
__
2011/8/2 Eric Scouten :
> 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://pech
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/sqlite-users
esign 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
orizer 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
2011/8/7 Simon Slavin :
> 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);
-
BODY$
return [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
about 1000
items and there are
1 000 000 lists than 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://pechni
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
ee 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).
--
2011/8/10 Wiktor Adamski :
> You
> may try increasing page size - bigger block means less near-random
> reads from the disc.
It's good way. With page size 8k instead of default 1k selects performance
may increasing ~3x. Note: PostgreSQL use 8k disk pages.
--
Best regards, Alexey P
2011/8/11 Sumit Gupta :
> 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 Pechni
iour. 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
erome, 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/
___
sqlite-users mailing list
sqlite-us
_
> 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
> 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
2011/9/6 jerome moliere :
> 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://pechnik
te-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
>
--
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
ob.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/
_
t; 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
d 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
>
2011/10/19 Fabian :
> Thanks, that's good to hear! It makes me wonder why SQLite doesn't use that
> same multi-tree mechanism for regular indexes, but that's a whole different
> question.
It's impossible with SQLite3 database format. May be SQLite4 will be
support it
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 mea
2011/10/25 Dan Kennedy :
> 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/
___
(m.op->stmt);
> }
> else gerror("bind \n");
> }
> void init_gbase() {
> m.status = sqlite3_open(GBASE,&m.db);
> debug("Gbase");
> m.status = sqlite3_create_function_v2(m.db,GFUN,2,SQLITE_UTF8
> ,0,gfunction,0,0,
> NULL);
> m.status = sqlite3_prepare_v2(m.db,POP_SQL, strlen(POP_SQL),
> &operands[G_POP].stmt,0);
> m.status = sqlite3_prepare_v2(m.db,TEST_SQL, strlen(TEST_SQL),
> &operands[G_TEST].stmt,0);
>
> }
>
> int _tmain(int argc, _TCHAR* argv[])
> {
> init_dll();
> init_gbase();
> m.top=POP_TRIPLE;
> for(;;) {
> m.status = SQLITE_OK;
> m.called = POP_TRIPLE;
> if(m.status == G_RESTART)
> m.self_rowid=0;
> read_triples();}
> }
> ___
> 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
-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
.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, Alex
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
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
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
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
bug report, feature request)
> TIA
> -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
gt;> See
>> PRAGMA cache_size
>> PRAGMA synchronous
>>
>> In particular the page cache should be increased dramatically
>> for huge DB files.
>>
>> Marcus
>>
>> >
>> > Thanks,
>> >
>> > Udi
>> > ___
s/database? 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.
o
dd if=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
and happy write
> bursts on each COMMIT). What is sqlite reading there? Does it try to
> perfectly balance each index on each insert (million times per
> transaction) or something else?
>
> Sincerely,
> Valentin Davydov.
> _______
> sq
t; puts $b_list
> }
>
>
>
>
>
>
> Each of these needs something added; either the rowid to the output or
> a counter test.
> is there a better way??
>
>
> Thanks
>
> P.S. can the TCL sqlite3 statement open the database using command switchs
> (ie
> 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/sqlit
501 - 572 of 572 matches
Mail list logo