(name,TOKENIZE icu en_US);
insert into fts (name) values (NULL);
insert into fts (name) values (NULL);
delete from fts;
...
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org
--
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
There is >30 Gb of free space.
2011/3/8 Jay A. Kreibich <j...@kreibi.ch>:
> On Tue, Mar 08, 2011 at 07:51:22PM +0300, Alexey Pechnikov scratched on the
> wall:
>> I try to vacuum database about 11Gb size on debian squeeze host with 1,5 Gb
>> RAM:
>>
>> sql
ATCH expression: [NOT sqlite]
Without ICU this work fine. Please check this on upstream version
becouse I use some patches for FTS3 extension.
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.or
insert into fts(a) values ('test');
sqlite> select last_insert_rowid();
2
sqlite> delete from fts where rowid=2;
sqlite> select last_insert_rowid();
3
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlit
ert_rowid();
end;
--
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
Which functions will be correct? As example, affinity for uncompress
functions can be as "blob" as "text". Now this is not important but
some tests will be nice for future compability.
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
__
...
2011/4/13 Dan Kennedy <danielk1...@gmail.com>:
> On 04/13/2011 06:22 AM, Alexey Pechnikov wrote:
>> Which functions will be correct? As example, affinity for uncompress
>> functions can be as "blob" as "text". Now this is not important but
>> some tes
of uncompressed values isn't trivial but is it
needed?..
2011/4/13 Dan Kennedy <danielk1...@gmail.com>:
> On 04/13/2011 02:49 PM, Alexey Pechnikov wrote:
>> What type of value return _uncompress_? The original content may be
>> blob or text, so uncompress may return blob
Bug report is here
http://www.mail-archive.com/sqlite-users@sqlite.org/msg59442.html
The fix is here
http://sqlite.mobigroup.ru/fdiff?v1=e7d3fea30c80e2f3=f7d463b30fd7d54f
I'm frustrated with no upstream fix of segfault in core extension :(
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel
RAM drive or SSD can help you...
--
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
rom the SQLite mailing list archive at Nabble.com.
>
> ___
> 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/
___
o rows.
>
> Does anyone have any advice on this matter?
>
> Thanks,
> Ian
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-u
what remains can be used to sync the changes.
>
>
> - Gary Gabriel
>
>
>
> _______
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
Best regards, Alexey Pe
e-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
>
--
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
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
>
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, Alexey Pechnikov.
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:
>>
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
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
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
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
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
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:
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
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
://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
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
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
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
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.
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/
___
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
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
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 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:
> 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
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
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
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
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 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/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
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
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
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
-
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
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
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
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
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
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
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
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
?
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/
___
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
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
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
_
>> 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
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/
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
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
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
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.
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
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
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
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
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
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
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
e
> or be part of an argument of an aggregate function. SQLite allows "naked"
> non-grouped columns as an extension (which is occasionally useful).
This is needed as replacement of the "distinct on" clause. I don't
know other way to translate many queries from Postgr
PostgreSQL to SQLite.
--
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
occasionally 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
t regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
PDATE, or DELETE using a properly formed Tcl array as an
> argument?
>
> Seems nice to have, but perhaps I'm not aware of possible dangers in such a
> feature.
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing
Thanks a lot for this link!
2010/5/12 Roger Binns <rog...@rogerbinns.com>
>
>
> http://www.sqlite.org/cvstrac/tktview?tn=2604
>
> To fix it requires code changes to SQLite and the SQLite team haven't
> deemed
> this necessary (yet).
>
> --
Best regards, Alexe
9';
count(*)
476
CPU Time: user 1.888118 sys 0.036002
Why these are too slow and how last queries are interpretated by FTS3? Why
results are different?
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sql
wal_autocheckpoint'
1000
--
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
-- 1 veter veter 896K Июл 7 01:51 test.db-shm
-rw-r--r-- 1 veter veter 880M Июл 7 01:51 test.db-wal
-rwxr-xr-x 1 veter veter 3,0K Июл 7 01:19 test.tcl
My test script
http://mobigroup.ru/files/test.tcl
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel
row.db-wal
--
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
а (РФА)
[blanki_clip_image002]
• Цифры в скобках, например, (1) – это сноски и указывать на РФА их не
нужно.
• Все данные вносятся разборчиво, печатными буквами.
• РФА – это документ, дописывать и исправлять на
--
Best regards, Alexey Pechnikov.
http://pechnik
gt;
> --
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
See http://sqlite.org/draft/wal.html :
<http://sqlite.org/draft/wal.html>"An SQLite database _connection_ defaults
to journal_mode=DELETE. To convert to WAL mode, use the following
pragma: PRAGMA journal_mode=WAL;"
--
Best regards, Alexey Pechnikov.
http
ite> .q
$ ls|grep grow
grow.db
grow.db-shm
grow.db-wal
$ sqlite3 grow.db 'pragma journal_mode'
delete
$ ls|grep grow
grow.db
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlit
I see this too:
$ sqlite3 grow.db 'pragma journal_mode'
delete
$ hexdump -s 17 -n 2 grow.db | head -n1
011 0200
$ sqlite3 grow.db 'pragma journal_mode=delete'
delete
$ hexdump -s 17 -n 2 grow.db | head -n1
011 0100
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel
urnal_mode=delete SQLite may
delete WAL journal before the last connection is closed and so provide
backward compability (of cource, only new SQLite versions can restore the
crashed databases). With wal=on and journal_mode=persist SQLite may use
persistent WAL journal without backward compabilit
t; time
> you open and write to the database.
It's not helpful for backward compability. How about version downgrade of
the Android or some other mobile OS and as result impossibility to open any
SQLite database?..
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
rent than a new(er) application that uses newer APIs
> not working on an older version of the OS.
And how many such changes in POSIX file API?.. I think SQLite API as
applications file format is similar to POSIX file API.
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
__
lect (select count(*) from role_exist)/1000/1000;
Error: database disk image is malformed
sqlite> select (select count(*) from role_exist)/1000/1000;
Error: database disk image is malformed
sqlite> select (select count(*) from role_exist)/1000/1000;
13
--
Best regards, Alexey Pechnik
Maxim, please show example here and the link to your implementation.
--
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
1 - 100 of 553 matches
Mail list logo
