Re: [sqlite] Do I need to migrate to MySQL?

_ > 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

Re: [sqlite] Do I need to migrate to MySQL?

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

Re: [sqlite] Syncing databases on different servers

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

Re: [sqlite] Syncing databases on different servers

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

Re: [sqlite] Set minimum word/character length in FTS4?

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/ ___

Re: [sqlite] Speeding up index insertion

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

[sqlite] Fix FTS3/FTS4+ICU segfault on NULLs

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

Re: [sqlite] FTS4 compress/uncompress functions

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

Re: [sqlite] FTS4 compress/uncompress functions

... 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

[sqlite] FTS4 compress/uncompress functions

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/ __

Re: [sqlite] FTS4 bug in last_insert_rowid()

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

[sqlite] FTS4 bug in last_insert_rowid()

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

[sqlite] Possible bug in FTS3 "NOT" operator

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

Re: [sqlite] "Error: disk I/O error" on big databases vacuuming

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

[sqlite] "Error: disk I/O error" on big databases vacuuming

-- 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] FTS3/FTS4+ICU segfault on NULLs

(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

Re: [sqlite] FTS4 bug: last_insert_rowid() fail

___ > 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-u

[sqlite] FTS4 bug: last_insert_rowid() fail

= ',last_insert_rowid()); } ### Result: ### regular table - OK last_insert_rowid = 1 last_insert_rowid = 1 FTS3 table - OK last_insert_rowid = 1 last_insert_rowid = 1 FTS4 table - FAIL last_insert_rowid = 1 last_insert_rowid = 0 -- Best regards, Alexey Pechnikov. http://pechnikov.tel

Re: [sqlite] Feature request: hash function for fast indices on text and blob fields

Yes, I have my extension for this http://sqlite.mobigroup.ru/dir?name=ext/murmurhash But I think the feature will be very helpful as core function. 2011/3/6 Enrico Thierbach <e...@open-lab.org>: > > On 06.03.2011, at 14:22, Alexey Pechnikov wrote: > >> Sqlite does not ha

[sqlite] Feature request: hash function for fast indices on text and blob fields

functions may be included into core SQLite. Note: I use the public domain licensed murmur hash algorithm (as extension) but this need custom build of SQLite or external extension. Does anybody has the same problem? -- Best regards, Alexey Pechnikov. http://pechnikov.tel

Re: [sqlite] Best practices fo web interface

__ > 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:

Re: [sqlite] SQLite version 3.7.6 testing

Please mark snapshots by pre-3.7.6 tag in fossil repository. How about compression in FTS extension? Is this production ready now? 12.02.2011 18:30 пользователь "Richard Hipp" написал: > The scheduled release of SQLite version 3.7.6 is mid-April. We are still > two months away.

Re: [sqlite] Feature suggestion for the Tcl interface : ability to use a list variable in combination with IN

See http://sqlite.mobigroup.ru/wiki?name=ext_intarray_tcl 09.02.2011 17:49 пользователь "Fredrik Karlsson" написал: > Dear list, > > I find the IN operator quite useful for selecting a set number of things. > However, I often have a Tcl list with the things I want to match >

Re: [sqlite] WAL for production use

___ > 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] Feature request: chains of stemmers for FTS

table and this is the problem. -- 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

Re: [sqlite] uuid generation in sqlite

te.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] Patch: FTS3 Snawball Stemmer support

Hello! May be this will be useful for somebody too. The code is not well tested yet but demonstrate the solution. http://sqlite.mobigroup.ru/wiki?name=FTS3+Snowball+Stemmer -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ ___ sqlite-users

Re: [sqlite] Reducing time to create indexes

a 1000 characters. > > Thanks > ___ > 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

Re: [sqlite] is it really ok to allow non-aggregates in an aggregate line?

reful. > Is needed the sub-query with "order by" for this. -- 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] Strange WAL mode on 5GB+ database

ok sqlite> pragma journal_mode=delete; delete -- 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] Query planner bug on "distinct" clause

,object_id from object_record where rowid>1581369-1) as x; 0|0|TABLE object_record WITH INDEX object_id_idx ORDER BY CPU Time: user 0.00 sys 0.00 sqlite> select distinct object_id from (select ts,object_id from object_record where rowid>1581369-1) as x; 31596 CPU Time: user 0.2

Re: [sqlite] Using sqlite's WAL with a hash table store

As I know, Redis does not garantees the data safety. And I think SQLite in-memory database is faster. I use in-memory SQLite DB and dump (full or incrementally) periodically the DB on disk and restore from disk on startup. -- Best regards, Alexey Pechnikov.

Re: [sqlite] Using sqlite's WAL with a hash table store

of the file that it is WAL'ing against? > > Thanks, > Ben > ___ > 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/

Re: [sqlite] BUG

Yes, I was wrong. Phisical order of records is equal to the useless sort condition in the view... Your examples can help me, thanks! -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ ___ sqlite-users mailing list sqlite-users@sqlite.org http

Re: [sqlite] BUG

Richard, with "PRAGMA reverse_unordered_selects = 1;". it's returns count(*)=0. This is strange for me and not help for development. 2010/10/26 Richard Hipp <d...@sqlite.org> > On Mon, Oct 25, 2010 at 4:06 PM, Alexey Pechnikov <pechni...@mobigroup.ru > >wrote: &g

Re: [sqlite] BUG

the part "ORDER BY and LIMIT/OFFSET Clauses". In the original test script the problem was when two rows are equal for sorting condition. -- 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

Re: [sqlite] BUG

can be resolved by trigger as: CREATE TRIGGER view_user_update instead of update on view_user begin ... SELECT RAISE(ABORT, 'User wait 1 second.') WHERE EXISTS(select 1 from user_record where user_id=OLD.user_id and ts=strftime('%s','now')); ...

Re: [sqlite] BUG

r.id=user_record.user_id >...> ; > sqlite> select * from test; > 11|76|8|11|A > 4|86|11|4|B > 4|87|3|4|B > sqlite> select count(*) from test; > 3 > > Michael D. Black > Senior Scientist > Advanced Analytics Directorate > Northrop Grumman Information

Re: [sqlite] BUG

name like '%'); select * from test; select count(*) from 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

[sqlite] BUG

elect count(*) from main.view_user where record_id in (select record_id from main.view_user where name like '%'); -- equal query returns only single row! select * from main.view_user where record_id in (select record_id from main.view_user where name like '%') order by name; -------

Re: [sqlite] Bundling sqlite database together with exe file.

le and starting > offset of the file, as read-only? > > Thank you for any suggestion. > > > regards, > Radzi. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqli

Re: [sqlite] is it really ok to allow non-aggregates in an aggregate line?

ok with this? > Do any other SQL engines allow this? > (DB2 does not) > > -- 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

Re: [sqlite] Temporary views across attached databases

t; -- > John M. Drescher > ___ > 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

Re: [sqlite] Query to compare two sqlite databases

See hash-based tool for signature/delta calculation and replication here: http://sqlite.mobigroup.ru/wiki?name=sqlite3-rdiff <http://sqlite.mobigroup.ru/wiki?name=sqlite3-rdiff>"delta" database has only differences beetween two databases. -- Best regards, Alexey Pechnikov. http

Re: [sqlite] SQLite Version 3.7.1

Richard, how to set the default value for SQLITE_FCNTL_CHUNK_SIZE? And is it possible to change this from sqlite3 shell and from tcl interface? -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ ___ sqlite-users mailing list sqlite-users

Re: [sqlite] 5000 tables with 3000 records vs 1 table with 15000000 records

, Alexey Pechnikov. http://pechnikov.tel/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3-dbf - converter of XBase / FoxPro tables to SQLite

extension for directly > importing dbf-files into sqlite you make me very happy; BTW: I've to work with > M$ and can't use standard unix libraries. -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ ___ sqlite-users mailing list sqlite-users@

[sqlite] sqlite3-dbf - converter of XBase / FoxPro tables to SQLite

This is not tested enough but it's work for me. May be it's interesting for somebody. http://sqlite.mobigroup.ru/wiki?name=sqlite3-dbf -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ ___ sqlite-users mailing list sqlite-users@sqlite.org http

[sqlite] Extension for TCL evaluation by user-defined function inside SQLite

://sqlite.mobigroup.ru/dir?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

Re: [sqlite] Inserting a large amount of data into a large indexed table

Paul, the WAL mode or SSD will be helpful. -- 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

Re: [sqlite] indexing speed

perftest_log_*. -- 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

Re: [sqlite] "database disk image is malformed" while using WAL

g/3_7_1.html "SQLite Release 3.7.1 On 2010 August 19 (3.7.1)" -- 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

Re: [sqlite] crypt() as SQL core function

2010/8/2 Simon Slavin <slav...@bigfraud.org>: > But frankly I'm not even sure that abs(), round() and soundex() should be in >SQLite.  I wonder how they ever made it in. Soundex function is build-in :-) Compile with -DSQLITE_SOUNDEX. -- Best regards, Alexey Pechnikov. http://p

[sqlite] How to manipulate Tcl lists/dicts by SQLite user-defined functions?

I'm store Tcl lists/dicts in SQLite but there is no functions to manipulate by these. I want to find or write the extension. May be this exists? Or how to do it optimally? Of cource example will be very helpful. -- Best regards, Alexey Pechnikov. http://pechnikov.tel

Re: [sqlite] crypt() as SQL core function

oup.ru/dir?name=ext/murmurhash -- 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

Re: [sqlite] crypt() as SQL core function

Nikolaus Rath, see encfs/gnupg/truecrypt/compressed filesystems and similar solutions. -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite

Re: [sqlite] Optimizing Songbird

steps" to "step" and "sorts" to "sort" at http://sqlite.org/tclsqlite.html#status And your comment > If the answer to either question is non-zero, you found a > potential place to optimize using an index. will be v

Re: [sqlite] Optimizing Songbird

do.  If the answer to either question is non-zero, you found a > potential place to optimize using an index. It's new for me and really interesting possibility. Can we use this feature from tclsqlite interface? -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ _

Re: [sqlite] PRAGMA database_list: insert into table?

extension for Tcl, as example. I use it as helpful extension but in upstream sources this is test only code. And md5 extension can be easy builded from upstream test code). -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ ___ sqlite-users mailing

Re: [sqlite] PRAGMA database_list: insert into table?

{ str = sqlite3_mprintf("%s, %s", str, sqlite3_column_name(stmt,i)); } sqlite3_finalize(stmt); if (strlen(str)) { sqlite3_result_text( context, str, strlen(str), sqlite3_free); } else { sqlite3_result_null( context ); sqlite3_free(str); } -

Re: [sqlite] PRAGMA database_list: insert into table?

I'm sorry, see right link for added file pragmacols.c: http://sqlite.mobigroup.ru/artifact?name=1ef363e38a2fef3ed64a6659079264524d6bc0e0 -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ ___ sqlite-users mailing list sqlite-users@sqlite.org http

Re: [sqlite] PRAGMA database_list: insert into table?

hard coding column names and "polluting" both the > temporary database and function list :-) > It's more simple than to discuss about :-) > I'd be a little nervous about using SQLITE_STATIC instead of > SQLITE_TRANSIENT. You are right, thanks. -- Best r

Re: [sqlite] PRAGMA database_list: insert into table?

./libsqlitepragmawrapper.so select database_list(); select * from temp.database_list; Of cource you can add other pragmas similar to pragma database list. -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ ___ sqlite-users mailing list sqlite-users@sqlite.org http

Re: [sqlite] Suggestion for sqlite shell

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

[sqlite] WAL: Wrong error "database disk image is malformed"

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

Re: [sqlite] WAL questions

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/ __

Re: [sqlite] WAL questions

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/ ___

Re: [sqlite] WAL questions

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

Re: [sqlite] WAL questions

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

[sqlite] Problem to switch between WAL and delete journal modes

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

Re: [sqlite] WAL questions

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

Re: [sqlite] WAL journal size grow unlimited

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

[sqlite] FTS3 snippet problem: function returns full document content

а (РФА) [blanki_clip_image002] • Цифры в скобках, например, (1) – это сноски и указывать на РФА их не нужно. • Все данные вносятся разборчиво, печатными буквами. • РФА – это документ, дописывать и исправлять на -- Best regards, Alexey Pechnikov. http://pechnik

Re: [sqlite] WAL journal size grow unlimited

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

Re: [sqlite] WAL journal size grow unlimited

-- 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

[sqlite] WAL journal size grow unlimited

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

[sqlite] Slow FTS3 query for time strings (like to "19:10:59")

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

Re: [sqlite] create virtual table if not exists table_id???

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

Re: [sqlite] Insert Using Tcl Array?

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

Re: [sqlite] where to find an examples of writing a extension?

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

Re: [sqlite] SQLite lets selecting a column that is not inthe Group by clause

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

Re: [sqlite] SQLite lets selecting a column that is not inthe Group by clause

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

Re: [sqlite] SQLite lets selecting a column that is not inthe Group by clause

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

Re: [sqlite] SQLite Database in Shared Memory

- speak 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

Re: [sqlite] SQLite Database in Shared Memory

TCP-socket listening daemon + SQLite in-memory database may be helpful. -- 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

Re: [sqlite] Returning column to default

ndard tables, but not for virtual tables, etc.  If anyone is interested > in the patch, I would be very interested to hear how well it works. -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] A few simple parsers and search utilities for FTS3

?name=sqlite3-poisk Shell utilities for emulate some SQL abilities http://sqlite.mobigroup.ru/src/wiki?name=poisk-client Search utilities http://sqlite.mobigroup.ru/src/wiki?name=sqlite3-poisk-client Usage in our company http://sqlite.mobigroup.ru/src/wiki?name=poisk-mbg -- Best regards, Alexey

Re: [sqlite] where may I find a simple sqlitecopy

For incremental copy may be useful the sqlite3-rdiff utility: http://sqlite.mobigroup.ru/src/wiki?name=sqlite3-rdiff -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080

Re: [sqlite] Read-only tables in in-memory database?

changing that row, as well as making the rowid readonly. -- 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

Re: [sqlite] [server] HTTP + SQLite bundled as single EXE?

;: > I must respectfully disagree with the statement that Apache is huge and > complicated, but I guess it is all relative... -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.

Re: [sqlite] [server] HTTP + SQLite bundled as single EXE?

See http://wiki.tcl.tk/15722 Add SQLite into it - about few minuts of time. 2010/5/3 Gilles Ganault <gilles.gana...@free.fr>: > I don't know if it'd be easier to combine existing HTTP server + > SQLite -- Best regards, Alexey Pechnikov. http://p

Re: [sqlite] [server] HTTP + SQLite bundled as single EXE?

regards, Alexey Pechnikov. http://pechnikov.tel/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] scripting language interpreter

JavaScript. -- 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

Re: [sqlite] scripting language interpreter

will be fine. -- 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

Re: [sqlite] "restore" doesn't work

=%d    nDestPgSz=\n",nSrcPgsz,nDestPgSz); >    rc = SQLITE_READONLY; >  } -- 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

Re: [sqlite] "restore" doesn't work

restoring on?   > Page size difference will create this error 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

[sqlite] "restore" doesn't work

.6.23 sqlite> .restore './work.db' sqlite> .q -- 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

Re: [sqlite] CHECK constraints and type affinity

description is much helpful than "SQL error: constraint failed". Did you try to debugging on database with a lot of constraints?.. -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ ___ sqlite-users mailing list sqlite-users@sqlit

Re: [sqlite] CHECK constraints and type affinity

qlite> create trigger tr before insert on t begin select raise(fail, > 'Value must be positive') where typeof(new.n) != 'integer' or new.n < > 0; end; -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ ___ sqlite-users mailing list sqlit

Re: [sqlite] CHECK constraints and type affinity

ed > sqlite> insert into t2 values(5); > sqlite> select n from t2; > 5 -- 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   2   3   4   5   6   >