#x27;) OR N IS NULL) but
error 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 m
e 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
sq
; 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
egative values slip through this check ('q' would pass the original check,
> too). I can only assume you haven't actually read my message before jumping
> in to respond.
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
s
g about TCL - never used one. But I'm
> sure that it's some additional layer above SQLite. And if you find
> some inconsistencies there then it's inconsistencies in TCL, not in
> SQLite itself.
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
her quote it
> or give a link from mail-archive.com.
--
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 fact that
> SQLite works differently from other database engines.
--
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
n PostgreSQL there is no this problem:
$ psql -h localhost --cluster 8.1/testing -U postgres template1
template1=> select 1='1';
?column?
--
t
(1 row)
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailin
It's bad solution:
sqlite> CREATE TABLE T1 (N INTEGER CHECK(+N >= 0));
sqlite> INSERT INTO T1 VALUES('-5');
sqlite> INSERT INTO T1 VALUES('q');
sqlite> select N, typeof(N) from T1;
-5|integer
q|text
--
Best regards
2010/4/28 Manoj M :
> I am getting error message "near "?": syntax error" randomly while
> executing the query "SELECT [record] FROM [ac_contacts_cache] LIMIT 0,
> 3".
The SQL "LIMIT 0, 3" is incorrect. Use "LIMIT 3 OFFSET 0" instead
2009/11/postgresql-81-vs-sqlite-3620-in-real.html
geomapx.blogspot.com/2009/11/degradation-of-indexing-speed.html
geomapx.blogspot.com/2009/09/sqlite-3617-mobigroup2.html
P.S. And we wait for releasing of the WAL journal mode, of course :-)
Bes
s in the FTS3 extension only.
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
show full-teable scan as "TABLE role_fts VIRTUAL TABLE"?
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 without any
alert.
For FTS3 the workaround is in using _content table insted of virtual
table but now we must search for bad-planned queries manually.
So vurtual tables are similar to regular tables but we have a lot of
hidden planner problems.
Best regards, Alexey Pechnikov.
http://pechniko
=role_fts.rowid;
^CCPU Time: user 34.058128 sys 1.720108
Error: interrupted
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
ze.
You can set
PRAGMA synchronous=0
and writes will be very fast too. But will be possible database corruption.
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin
NTO t
SELECT *
FROM temp_t;
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
ct 1,a from test where id=2;
sqlite> select * from test;
1|11
2|11
So you have some constraints or unique indicies on your table.
P.S. For more than single record:
CREATE TEMP TABLE temp_t AS
SELECT * FROM t
WHERE id = 651;
UPDATE temp_t SET id=649; -- may be id=id-2 for set of records
INS
> access to an in-memory database is supported?
Use database on tmpfs (ram disk) for this task. It's not needed to add
this functionality at SQLite internals.
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing l
rom data_content where rowid in (1);
1
CPU Time: user 0.00 sys 0.00
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
INDEX 1:
sqlite> explain query plan select count(*) from data where rowid in (1);
0|0|TABLE data VIRTUAL TABLE INDEX 0:
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8
type.
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
less than 400M records ;-)
And so select like to below are very slow:
select ... from my_virtual_table where rowid in (...);
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.or
a new interface for "virtual indices" will be best solution. But it
can be realised as virtual table too. Or in SQLite core engine of cource.
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
Hello!
On Monday 05 April 2010 18:11:40 Roger Binns wrote:
> Wouldn't it require changing the file format?
It's not required. The FTS3 extension works with current file format
and rtree extension too.
Best regards, Alexey Pechnikov.
http://
s records) with constant speed.
The b-tree index is required then we selecting range of indexed values
and has good performance for 1000 or less unique values in indexed field.
All other RDMS have hash indices because these required in many
applications.
Best regards, Alexey Pechni
Hello!
The b-tree index is not good choice for high-selective data, but there is no
hash index in SQLite. The hash index will be useful for many new projects
and will optimize a lot of existing applications.
Is anyone interested in this feature?
Best regards, Alexey Pechnikov.
http
qlite> SELECT optimize(data) FROM data LIMIT 1;
Error: out of memory
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
0),
abs(random()%10),
abs(random()%100),
lower(hex(randomblob(16}
}
}
} 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
58037AFD629F13518658B94CD2C
CPU Time: user 2.540159 sys 0.152010
sqlite> select * from data where data match 'zero AND
AF8FD58037AFD629F13518658B94CD2C';
0|0|zero|AF8FD58037AFD629F13518658B94CD2C
CPU Time: user 2.456154 sys 0.156009
Best regards, Alexey Pechnikov.
http://pechnikov.
ul. I have a lot of SQLite installations and I need
to control all of these by compile-time parameters in my SQLite build.
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:
ime: user 0.00 sys 0.00
sqlite> explain query plan select max(rowid)/100. from role;
0|0|TABLE role
CPU Time: user 0.00 sys 0.00
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sql
Hello!
On Thursday 01 April 2010 18:04:10 Adam DeVita wrote:
> How does
> $ time sqlite3 test32k.db "select count(1) from role_exist"
> perform?
Equal to count(*).
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite
758012 0 294966667708
-/+ buffers/cache: 8556767455216
Swap: 3903784 3012403602544
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:80
e trigger terminates, the value returned by this routine
> reverts to the last value inserted before the trigger fired."
>
> Your insert definitely happens in the trigger, so no access to rowid outside.
Hm... yes, so it's not the problem, this is feature :-(
Best regards,
last_insert_rowid();
0
select max(rowid) from test;
1
insert into view_test default values;
Segmentation error
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman
e
is more than cache_size the inserts/updates in SQLite are stopped by fact.
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
better? BerkeleyDB is required
administration and it's strange solution in many embedded devices and
for some desktops and servers too.
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqli
leLock|0|2|0|role|00|
76|Goto|0|6|0||00|
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
p.ru/src/vinfo/d3d9906674
or direct links:
http://sqlite.mobigroup.ru/src/artifact/57b279352c
http://sqlite.mobigroup.ru/src/artifact/daee6be790
(click on "download" link)
Or you can patch you amalgamation...
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
Hello!
On Tuesday 02 March 2010 15:25:35 Max Vlasov wrote:
> can you calculate the ratio between your text data and fts3 data?
In my databases with unicode texts compressed data is about 25% of original.
Best regards, Alexey Pechnikov.
http://pechnikov.
obigroup.ru/src/fdiff?v1=31896&v2=31918
http://sqlite.mobigroup.ru/src/fdiff?v1=31743&v2=31919
3. Or you can download files before and after the check-in and make diff
manually. See links on the page http://sqlite.mobigroup.ru/src/vinfo/d3d9906674
Best
Hello!
Patch is here
http://sqlite.mobigroup.ru/src/vinfo/d3d9906674
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
ck BLOB);
Virtual table interface enumerate rows by selecting full table content instead
of index scan. This solution must be optimized but I don't know how to do it.
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users maili
30
CPU Time: user 0.004000 sys 0.00
Really, unpacking full database content is slow operation. Is it possible to
fix this
on virtual-table level?
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqli
explicitly defined in all select. As example,
PostgreSQL has a few system columns too
and you may explicitly define these in your queries too.
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
htt
e_size*cache_size)
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
Hello!
Will be the very helpful sqlite3_intarray interface included to SQLite core? Or
this is
only example for developers?
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org
10
select intrange2table (100,1000,100,'testrange');
select * from testrange;
1
2
3
4
5
6
7
8
9
10
100
200
300
400
500
600
700
800
900
1000
Best regards, Alexey Pechnikov.
NAME and PASSWORD and we check
PASSWORD in database file md5(USERNAME).db
You may block brutforces in your application. For valid users
performance is usually fine by this schema.
P.S. For javascript auto-complete of user names is possible
to build list of usernames periodically.
Best regards, A
Hello!
On Monday 01 March 2010 14:48:46 Dan Kennedy wrote:
>
> On Mar 1, 2010, at 6:08 PM, Alexey Pechnikov wrote:
>
> >> It would seem to me that asking [1='1'] *should* return false
> >> because the
> >> numeric and character string value doma
Hello!
On Monday 01 March 2010 08:05:06 Darren Duncan wrote:
> Alexey Pechnikov wrote:
> > Hello!
> >
> > On Thursday 25 February 2010 02:53:32 Igor Tandetnik wrote:
> >> http://www.sqlite.org/datatype3.html
> >> For conversions between TEXT and REAL stor
lite
I don't know how to fix it in the SQLite core. My patch for
the tclslite interface can't resolve the internal problem...
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sq
Hello!
See the solution here:
http://www.siftsoft.com/tclsqlitevfs.html
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
Hello!
On Wednesday 17 February 2010 22:51:21 Alexey Pechnikov wrote:
> No, you may search vfs::sqlite3 package for Tcl.
I find it :-)
http://web.ist.utl.pt/~tiago.dionizio/tcl/sqlite3vfs.tcl
Best regards, Alexey Pechnikov.
http://pechnikov.
Hello!
On Wednesday 17 February 2010 05:57:51 Matthew Smith wrote:
> SQLiteVFS a C-language routine for access any file system, on which the
> SQLite database is found. Doesn't appear to give me access to the Tcl VFS.
No, you may search vfs::sqlite3 package for Tcl.
Best rega
rmed
sqlite> select sqlite_version();
3.6.22
sqlite> select sqlite_source_id();
2010-02-04 07:12:10 4ce0faf5b282a64938f11c8541ca47d9c852ecee
Builded from repository http://sqlite.mobigroup.ru/src/home
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
Hello!
See tests and some interpretation:
http://geomapx.blogspot.com/2009/11/degradation-of-indexing-speed.html
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin
but the database must be sent alongside it,
> instead of being packed into the Starpack.
You are wrong. You can't create SQLite-based starpack, but you can put your
SQLite
database into metakit-based starpack.
Best regards, Alexey Pechni
Hello!
On Friday 12 February 2010 04:40:21 Vasanta wrote:
> All expert Users and Developers:
Do not sent your mails to sqlite-...@sqlite.org! This produce spam for core
developers.
And I can't understand you question. What you want to do?
Best regards, Alexey Pechnikov.
http://pechn
no problems to build 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
elect snippet(file_text) from file_text where rowid=9737;
Segmentation fault
===
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
ormat 1000
Wed Nov 16 12:46:40 MSK 5138
> Nevertheless, if your data starts off as a Unix epoch, it can be fast and
> convenient to just store it without having to do any conversion.
As example, Cisco devices and some Unix daemons produce datetime in this format.
Best reg
o use unixepoch format.
And this is very compact 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
es.
*/
if( ctx.pVdbeFunc ){
-sqlite3VdbeDeleteAuxData(ctx.pVdbeFunc, pOp->p1);
pOp->p4.pVdbeFunc = ctx.pVdbeFunc;
pOp->p4type = P4_VDBEFUNC;
}
It's not a problem to manual clean auxdata when these are not needed by now.
The auto clean is really helpful only when t
and this work.
> Remember, the motivating use case for this API is to avoid recompiling a
> regexp for each row.
The API is fine for any flow data processing too. There is no other way to do
it.
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
_
3
4
1
5
2
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
2|2|2
3|3|3
3|4|3
3|5|3
4|6|4
4|7|4
1|8|1
5|9|5
5|10|5
2|11|2
2|12|2
The "value" argument in counter function call is SQL variable, isn't it? If
it's so then the result is wrong.
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
re can I
find additional examples?
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
0) equal to counter(0).
The result of "value=0" is always 0 and so counter(value=0) may be identical
to counter(0).
P.S. I want build function similar to linux "uniq" utility:
select value from state where uniq(value)=1;
This can emulate "distinct on" clause too.
> at http://www.sqlite.org/draft/privatebranch.html that I prepared in
> response to this very issue and which will be in the next official
> release of SQLite.
The patches are added to the new fossil repository
http://sqlite.mobigroup.ru/
Best regards, Alexey Pechnikov.
ht
nt:"мтс-коннект"';
Error: SQL logic error or missing 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
Yes, this is can be changed in config but
it's insecure.
2. I use stunnel for performing https access to fossil.
But it sends all data by insecure http and so https
mode is impossible.
And how to translate interface to national languages?
May be by building fossil from sources?
Best regards
UNIT is similar to
#!/bin/sh
exec /usr/bin/tcpserver -- 0 80 /usr/bin/fossil http
/var/www/sqlite3/private-project.fossil
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:80
as id
_must_ return the column as "id" column. Any other result is wrong.
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
will get scrambled by line-wrapping,
> so best I email it direct to you as an archive -- is that alright with
> you?
Yes, by email is better. And I can to start the private branch of SQLite
Fossil repository if it can help you.
Best regards, Alexey Pechnikov.
http:
o change 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
rom it. If you don't have web server please send me to email
and I will place the pathes on my server.
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
binary values... Thanks.
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
Hello!
On Monday 14 December 2009 01:14:25 Doug Currie wrote:
> The problem is that floating point values (in SQLite shell) do not have
> write-read idempotency
Please read my message again. The index work correct but why?
Best regards, Alexey Pechnikov.
http://pechnik
Hello!
On Monday 14 December 2009 00:24:42 Samuel Adam wrote:
> Smells like a decimal/binary rounding error.
It'is not the answer to my question. Why the unique _index_
can understand when REAL values are equal?
Best regards, Alexey Pechnikov.
http://pechn
4204073;
0
As we can see, the unique index can check equlity of REAL values
but the "=" operator can not. it's fantastic I think :-)
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.o
Hello!
On Sunday 13 December 2009 02:09:48 Roger Binns wrote:
> Alexey Pechnikov wrote:
> > This is standart for all i18n applications.
>
> The SQLite shell is not an i18n application, and this is deliberate. It is
> a developer tool. That is why for example it alway
n to
determine the current locale?
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
here:
http://geomapx.blogspot.com/2009/12/sqlite-versioning-extension.html
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
-replication.html
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
Hello!
On unix the shell must do this initialisation:
setlocale(LC_ALL, "");
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
ine.in
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
#x27;document';
Error: SQL logic error or missing database
In previous versions these work 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
Hello!
On Thursday 10 December 2009 04:04:34 Roger Binns wrote:
>
Thanks! The great idea.
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listi
base logging and real-time audit tasks. I don't see any
reasons to create
the equal functional in applications.
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-b
I can write
this with trace function but it's difficult or impossible to split system and
user queries.
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
ird argument for profile function. But may be
exists another way for logging only user queries?..
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
ster SELECT type, name, tbl_name, rootpage,
sqlFROM main.sqlite_master WHERE type='view' OR type='trigger' OR
(type='table' AND rootpage=0)}
As you can see internal system queries are visualized too. It's may be useful
for developers but very bad for u
om view_test;
id|id:1
1|test
The result is wrong becouse fileld "id" must be equal to '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
Hello!
$ sqlite3
SQLite version 3.6.20
sqlite> create table test (id INTEGER PRIMARY KEY, a text);
sqlite> insert into test (a) values (1);
sqlite> create view view_test as select rowid,* from test;
sqlite> .header on
sqlite> select * from view_test;
id|id:1|a
1|1|1
Best
to decide for me what my data should look like.
I think the custom collation is the user solution for data processing. Or may
be a collation is only data _visualization_ mechanism?
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users
Hello!
On Tuesday 08 December 2009 01:07:54 Igor Tandetnik wrote:
> Alexey Pechnikov
> wrote:
> > Yes, the BOM is on the original string. But with ICU collation we can
> > see that 17 symbols string is equal to 16 symbols string. I think
> > this result is not right.
&
automatically dropping the BOM for ICU
collated fields is more correct way.
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
201 - 300 of 572 matches
Mail list logo