Hello!
On Thursday 12 November 2009 07:30:28 Rich Shepard wrote:
>Perhaps. I learned today that only the Winduhs version of OO.o can import
> .mdb files; the linux version cannot.
Try to read by Linux ODBC and save to SQLite.
Best regards, Alexey Pechnikov.
http://pechnik
+ virtualtext.c
+
main.c
notify.c
.
2.3 Patch Makefile.in
SRC += \
$(TOP)/ext/rtree/rtree.h \
$(TOP)/ext/rtree/rtree.c
+SRC += \
+ $(TOP)/ext/iconv/iconv.h \
+ $(TOP)/ext/iconv/iconv.c \
+ $(TOP)/ext/virtualtext/virtualtext.c
2.4 Build SQLite with option -DSQLITE_ENABLE_VI
compile as
gcc -fPIC -lm -shared iconv.c virtualtext.c -o libsqlitevirtualtext.so
The iconv may be useful without virtualtext extension and so I did place it
in the different directory.
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users m
iles/sqlite-ext/iconv/
extension too.
Compile as
gcc -fPIC -lm -shared ../iconv/iconv.c virtualtext.c -o libsqlitevirtualtext.so
I did fix the comment in code. Thanks for your report!
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-use
e like to
tokenizer (document_text, document_position)
This function can be called from xNext() interface function.
I don't sure about the realization and may be the interface will be different.
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlit
the disk activity. The processors now have more better
performance than disks.
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
is added to
http://geomapx.blogspot.com/2009/11/fts3-compression.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!
The code is only prototype but it's simple and work for me.
http://geomapx.blogspot.com/2009/11/fts3-compression.html
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org
ng it is
> not optimized to get value from table and compare it? In this case
> your results are explainable.
I'm sure there are the bugs. I'm not sure why. The SQLite shell is part of
SQLite project and so the bugs must be reported here.
Best regards, Alexey P
download the dataset and test it on your site.
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
1
And so text '1' in view_test is not equal to text '1' in view_test2. Are you
sure
that current datatypes realisation is right?
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 Saturday 31 October 2009 02:31:44 Simon Slavin wrote:
>
> On 30 Oct 2009, at 9:47pm, Alexey Pechnikov wrote:
>
> > Now SQLite think that 1 is equal to '1' in some causes and think
> > different in other.
>
> Just like every other language, once you ge
fore check
of equality.
SQLite datatyping is similar to Tcl by ideology. As example in Tcl:
$ tclsh8.5
tclsh8.5 [/tmp]expr {1==1.0?1:0}
1
tclsh8.5 [/tmp]expr {1=="1.0"?1:0}
1
tclsh8.5 [/tmp]expr {1=="1"?1:0}
1
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
_
l or other lang.
Is it possible?
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
the whole SQLite that it doesn't work
> correctly.
I did find some datatypes bugs in tclsqlite interface and fix it as
http://geomapx.blogspot.com/2009/10/tclsqlite.html
Note: the original code produce different results from tclsh shell and from
tcl script file.
As you can see the datatyping
l other types of triggers
> (I've tested "after insert" and "before insert").
Yes, there are some differents. But documentation of SQLite datatypes is not
right correspond to the realization. So documentation is wrong or realization
is wrong.
Best regards, Alexey Pechnikov.
http:
Hello!
The feature was planning some times ago. Is this released now?
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
lect * from test where a=1;
1
So 1 can be equal to '1' and can be not. It's terrible behaviour.
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
me as text) and 'telephony_number'=(select hw_name
from view_user_service where id=NEW.user_service_id);
end;
There are no same problems in PostgreSQL and so SQLite has incompatible SQL.
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users
)==0) ){
- Tcl_WideInt v;
- Tcl_GetWideIntFromObj(interp, pVar, );
+}else if( TCL_OK == Tcl_GetWideIntFromObj(interp, pVar, )) {
sqlite3_bind_int64(pStmt, i, v);
+}else if( TCL_OK == Tcl_GetDoubleFromObj(interp, pVar, )) {
+ sql
set rowid [expr round(rand()*$limit)]
db onecolumn {select NULL from test where id=$rowid}
}
}
}]
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
ols
[sqlite] Low-Cost data migration and ETL tools
etc.
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
time: 0.25 secs
>
> But I'm still looking to speed up selects.
Hm... I think you may not open more than 8 000 tcp/ip sockets per second
in common case and so SQLite speed is good enough. Why you write about
"to handle tens of thousands requests p
db onecolumn {select value from test where rowid=$rowid}
}
}
}]
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!
How about solution like to
select rowid from my_fts_table
where my_fts_table match @query2 and rowid in
(select rowid from my_fts_table where my_fts_table match @query1)
limit 21
I don't know about performance of this but rowid index may be used success.
Best regards, Alexey
ed extension is available here
http://mobigroup.ru/files/sqlite-ext/functions/
And compile with -DSQLITE_ENABLE_FUNCTIONS
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) ){
- Tcl_WideInt v;
- Tcl_GetWideIntFromObj(interp, pVar, );
+}else if( TCL_OK == Tcl_GetWideIntFromObj(interp, pVar, )) {
sqlite3_bind_int64(pStmt, i, v);
+}else if( TCL_OK == Tcl_GetDoubleFromObj(interp, pVar, )) {
+ sql
test3" 1
test 3.4 "create view view_test4 as select * from test where 1 IN ($j);select *
from view_test4" 1 ;# it doesn't work in orig sqlite
test 4.1 "select typeof(sql($j))" integer
===
$ ./tclsqlite_bind.tcl
Hello!
But why do you not compress big text strings? And index
size can be reduced by using md5 hash of text key field.
See the extensions
http://mobigroup.ru/files/sqlite-ext/
http://mobigroup.ru/files/sqlite-ext/md5/
Best regards, Alexey Pechnikov.
http://pechnikov.tel
Hello!
These work fine:
set i 1
string is wideint -strict $i ;# for correct typing
test 1.1 {select * from test where a=$i}
test 1.2 {select * from test where 1=$i}
But it's badly to manually call [string is wideint -strict]
before all queries.
Best regards, Alexey Pechnikov.
http
nd
produced results doesn't correspond to sqlite3 shell results.
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
delete from t where is_new=0;
vacuum;
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!
Try this:
pragma cache_size=20;
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
}
#detach the source DB
$dbhandle eval {DETACH loadfrom}
}
}
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
(last_insert_rowid(user),...);
...
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
from test where 1=quote(1);
1
sqlite> select a from test where a IN (1, 160);
1
sqlite> select a from test where 1 IN (1, 160);
1
sqlite> select a from test where 1 IN (quote(1), 160);
1
sqlite> select a from test where a IN (quote(1), 160);
1
======
il list every week.
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
the comparison would work for values that represent, for
> example, 3, 6, 9 and 12 o'clock (both AM and PM).
Can you add this note to documentation? This is very speculate question.
Especially because internal SQLite representation of julianday was chanded
some times ago
ong.
Have you any IO operations? As result you have dependence of page
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
same block 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
t me if I should work in this
> direction.
Last version is 3.6.18 and is more better to use this. But your version is
thread-safe too.
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.
onth or otherwise.
Are correct selects like as
SELECT * from tbl_name where date = julianday('now','start of month');
Equal condition for dates is work now but is it safety?
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users maili
obigroup.ru/files/sqlite-ext/virtualtext/
I did pack this as single extension. NB: in multitheaded env is more better
to make copy of date in SQLite with the extension and after operate with
the copy.
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
_
> It will be great for debugging, for example.
>
You can create a custom wrapper for savepoints which may have
the stack of calls.
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.o
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 reprezentation of microseconds
for the julianday and store it as long integer or float?
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
nctions
in any programming lang and create wrappers.
Is it not enought for 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
t extensions which are not exists in
SQLite. And Oracle ideology is very different. You may not replace Oracle to
SQLite with the same application architecture.
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-user
ould be customizable so it can be thusly strict.
It's interesting. The new pragma "unique_column_names" may be helpful for
a lot of situations same as the "indexed by" condition for selects.
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
_
TCL type inside of empty string.
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
) can be stored into database and
executed by application. C code can be compiled once and executed with
Tiny C compiler. I'm sorry but I don't see any helpful features of your
wrapper.
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlit
e old RDBMS problem. And SQLite Tcl interface has no equal
availability
for NULL values because we can't operate with non-defined variables. So we can
translate NULL values into empty Tcl strings but not vice versa.
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> pragma collation_list;
0|russian
1|NOCASE
2|RTRIM
3|BINARY
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-us
extensions from database table but it's not
realised now, really?
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
way to distribute external libs.
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
ples? Thx.
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
mp;&
0!=sqlite3_column_bytes(argv[i]) ){
sqlite3_result_value(context, argv[i]);
break;
}
}
}
But construction "... IS Empty" produce some difficults to me.
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mail
Hello!
On Saturday 19 September 2009 00:43:18 Noah Hart wrote:
> Stored Procedures
There are Tiny C compiler extension and realization of
stored procedures for SQLite 2 and Lua extension and other.
So you can use one or all of these.
Best regards, Alexey Pechnikov.
http://pechnikov.
stcode text not null
...> );
sqlite> INSERT INTO "const_telephony_direction"
VALUES('Совинтел_МГМН_старые_кмст','7485');
sqlite> CREATE INDEX const_telephony_direction_complex_idx on
const_telephony_direction(destcode);
sqlite> COMMIT;
sqlite>
sqlite> pragma integrity_check;
ok
==
Hello!
Can somebody to show example of the group_split() function?
PRAGMA can return rowset but how to do this in user functions?
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http
fields
select versioning('md5','sessions');
Note: function arg1() is coded in versioning extension.
select arg1('a');
a
select arg1('a','b','c');
a
When you will define sha256 function (as example) you can do
select versioning('sha256','sessions');
Thanks for you comment.
Best regards,
d to the master?
By the tcl scripts. Databases only store data and versions information.
I'm planning to publish some of the tcl scripts on the next week.
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@
s tables are renamed
Updated files is here
http://mobigroup.ru/files/sqlite-ext/versioning/
Now there are two problems in the realization:
the "replace" conflict resolution algorithm for SOURCE table may produce
errors - tickets 3964, 3982
versioning_drop() function doesn't work - tic
CREATE TABLE test(a);
sqlite> INSERT INTO "test" VALUES(1);
sqlite> INSERT INTO "test" VALUES(3);
sqlite> COMMIT;
sqlite> select rowid,* from test;
1|1
2|3
As you can see now ROWID=2 is correspond to field value 3 and it's wrong.
Best regards, Alexey Pechnikov.
h
Hello!
On Thursday 30 July 2009 18:17:45 Jim Showalter wrote:
> MD5 hashes can still collide. How does this implementation deal with
> hash collisions?
You may use any other hash (sha256 as example). But I think md5 collisions is
not
the problem for common applications.
Best regards,
an help for this situation 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
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!
There are a lot of tasks where GiST index is needed.
Does exists any plans to implement this?
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman
ould be great if this could
> be changed.
I did change license to Public Domain same as SQLite core and my other
extensions.
P.S. Added indexes in new "Versioning" version.
README =
"Versioning" SQLite extension
Copyright 2009 Alexey Pechnikov
azon and so on with 6 to 8 weeks. Amazon is a little
slow."
Now the book is available here:
http://www.lulu.com/preview/paperback-book/the-sql-guide-to-sqlite/7251432
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing l
7.00753368|I|3
||2455027.00753382|D|1
||2455027.00753382|D|2
||2455027.00753382|D|3
==
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 repository keyring as
sudo aptitude install debian-mobigroup-keyring
Also you can get sources directly from
http://mobigroup.ru/debian/pool/main/s/sqlite3/
The patch file for current SQLite release is
http://mobigroup.ru/debian/pool/main/s/sqlite3/sqlite3_
p from 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
ists and site release messages?
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.1/24');
==>256
May be exists more correct way for complex datatype implementation? I think
it's more useful when typeof(inet('192.168.1.1/24'))=inet (where 'inet' is new
type) but now typeof('192.168.1.1/24')=text. Collation can be used but
collation is not datatype.
Best regards, Alexey
Hello!
On Friday 10 April 2009 16:23:43 D. Richard Hipp wrote:
> On Apr 10, 2009, at 5:58 AM, Alexey Pechnikov wrote:
> > Note: TCL interface binds all as text values
>
> False. The following TCL script is proof by counter-example:
>
> package require sqlite3
>
Hello!
Note: TCL interface binds all as text values and we can't use typeof()
function (typeof returns 'text' for all fields). So we may use manual cast() to
field datatype instead.
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite
code */
db = (sqlite3*) sqlite3_context_db_handle(context);
rc = sqlite3_exec(db, SCHEMA_USERKEY, NULL, NULL, NULL);
if( rc != SQLITE_OK ){
sqlite3_result_error(context, sqlite3_errmsg(db), -1);
return;
}
Hello!
On Saturday 21 March 2009 17:31:45 P Kishor wrote:
> My intent is to simply retrieve a BLOB and
> deserialize it... it would possibly be quicker than 33 ms per
> retrieval. Well, I haven't yet completed this test because each BLOB
> is taking about 430 KB. At 1 million rows, that is going
Hello!
On Tuesday 24 March 2009 20:19:00 aditya siram wrote:
> Hi all,
> Is there a way to do an accent/diacritic insensitive search in sqlite? For
> example I want to a query to find " `a blanc " with the search term "a
> blanc".
Yes.
Hello!
On Wednesday 18 March 2009 21:51:10 Roger Binns wrote:
> > Tcl, Python and other langs have different unicode implementations. The
> > realizations are more simple than ICU library but millions of
> > applications are using these. I'm will glad to see Tcl/Python/etc.
> > unicode
Hello!
> From the German example, you can't even do that (name order is different
> than dictionary order). I think we are agreed that the default SQLite
> implementation gets ASCII right and makes no attempt to deal
> specifically with non-ASCII locales. The ICU extension gets all the
>
Hello!
On Monday 16 March 2009 09:48:50 Pierre Chatelier wrote:
> But we are not answering my initial question !
>
> Can I expect some gain in
> -recompiling SQLite (which options/DEFINEs would help ?)
> -using custom memory allocators (I am on Win32, in a multi-threaded
> environment, and yes,
Hello!
On Thursday 12 March 2009 10:09:28 Roger Binns wrote:
> > I was asking the group their opinion about the usefulness of such
> > feature.
>
> As described I think it is mostly useless. Sorting even just for West
> European languages is not trivial. For example some countries have a
>
Hello!
On Sunday 15 March 2009 23:10:02 Roger Andersson wrote:
> The SQL below might be out there but I didn't find it and since there might
> be other that need to get 32-bit integer IP in a sqlite3 database to the
> a.b.c.d format using SQL
There is extension for ipv4
Hello!
On Tuesday 10 March 2009 06:16:16 Alexandre Courbot wrote:
> Never did this myself, but I think you can do what you need by writing
> your own tokenizer:
>
> http://www.sqlite.org/cvstrac/fileview?f=sqlite/ext/fts3/README.tokenizers
It's not good advice for a few documented module.
I
Hello!
On Saturday 07 March 2009 01:59:13 Roger Binns wrote:
> A transaction requires two syncs (ie requesting the drive write the data
> to the metal and not return until it does). On average each sync will
> take a disk rotation so a 7200rpm drive maxes out at 60 transactions a
> second. If
Hello!
> I too am puzzled. Perhaps the app involves a web server accepting any
> bunch of text from anybody who knows the URL and just running the text
> as an SQL query -- i.e. read-only is perceived to be a last-ditch
> (only?) defence against an SQL injection attack.
There is "authorizer"
Hello!
On Wednesday 04 March 2009 17:19:09 Jim Wilcoxson wrote:
> Have you tried changing the page size to 4096 or 8192? Doing this
> with my SQLite application and increasing the transaction size
> decreased runtime from over 4 hours to 75 minutes. The runtime for
> my app writing the same
Hello!
On Wednesday 04 March 2009 15:38:39 rahed wrote:
> I doubt. To my acknowledge tksqlite is a tcl/tk script run from shell. The
> source doesn't distinguish the platform.
tksqlite.tcl is tcl script but you did write about tksqlite. tksqlite is
binary file with tcl interp and virtual file
Hello!
On Wednesday 04 March 2009 04:44:05 D. Richard Hipp wrote:
> One could envision future versions
> of SQLite that allowed you to preallocate a large database files such
> that the database always stayed less than 80% full. Then we could use
> filesystem techniques to keep
Hello!
On Tuesday 03 March 2009 17:04:32 rahed wrote:
> I installed 3.6.11 on Solaris with 3_6_11-tea.
> When I try to open sqlite db with tksqlite there is core dump:
>
> warning: core file may not match specified executable file.
> Core was generated by `wish /export/home/user1/tksqlite'.
>
Hello!
On Friday 27 February 2009 23:57:39 Allan Edwards wrote:
> You setup 2 seperate machines, sqlite on one, and Oracle on another...
> they both have the exact make and model hard drives and OS. Which one
> can write data faster to the hard drive?
There are two strategies:
1. Rows are
Hello!
On Saturday 28 February 2009 00:31:37 pyt...@bdurham.com wrote:
> Your approach of splitting large data sets sounds similar to what other
> SQLite users with large data sets seem to be doing. At a high level,
> this sounds like how one would partition data using Oracle? I'm going to
>
Hello!
On Friday 27 February 2009 21:50:30 Kees Nuyt wrote:
> A view or trigger in one database is not allowed to
> reference tables (or other views) in other databases. The
> reason is, the schema of the main database (in this case
> your :memory: database) would be invalid once the main
>
Hello!
On Friday 27 February 2009 18:08:19 you wrote:
> [string map {\; "" \[ "" \] "" $user_id]
>
> you can get rid of most threats, right?
We can do
set param {test' sql with some injection}
puts $param
set param [db onecolumn {select quote($param)}]
puts $param
and get result
test' sql with
Hello!
Is there way to careate view such as
db eval {
CREATE TABLE view_report_01 AS
?SELECT s.name ?AS service_name,
? t_l_r.cost AS cost
?FROM work.users ? AS u,
? work.user_contracts ?AS u_c,
? work.user_services ?AS u_s,
? work.services ? AS s,
? telephony.telephony_log_rating AS t_l_r,
?
Hello!
On Friday 27 February 2009 16:25:28 Alexey Pechnikov wrote:
> But it's work some time ago! How can I create view for attached databases
> now? Create table is bad becouse attached database may be huge.
I did patch attach.c as
/* sqlite3ErrorMsg(pFix->pParse,
&quo
Hello!
On Thursday 26 February 2009 18:53:18 Jay A. Kreibich wrote:
> I agree. The only major addition I'd like to see is full support for
> referential integrity. I know you can fake it, to a degree, with
> triggers, but I'd still like to see it baked into the database engine
> itself.
Hello!
On Friday 27 February 2009 01:17:51 D. Richard Hipp wrote:
> > Then, I ran the .read command in sqlite3 to read in the sql
> > statements.
> > sqlite doesn't support the TO_Date function.
>
> Please send me an example of the TOAD-generated INSERT statement that
> includes a TO_Date
301 - 400 of 553 matches
Mail list logo