Re: [sqlite] Is something special to load fts1.dll in Tcl?

2006-10-09 Thread Gerry Snyder
[EMAIL PROTECTED] wrote: FTS1 is built into the starkit. So if you use the starkit, there is nothing to do to enable full-text search. It's just there. I thought I did the same for the TCL DLL as well - FTS1 is built in. But I admit that I might have not gotten that exactly right. Did you

Re: [sqlite] Is something special to load fts1.dll in Tcl?

2006-10-09 Thread drh
Gerry Snyder <[EMAIL PROTECTED]> wrote: > I am eager to try out full text search using SQLite and Tcl on WinXP. > > I downloaded the Tcl bindings and executable for SQLite 3.3.8 and the > fts1.dll file, and copied them all (after unzipping) to a directory. The > fts1.dll loads fine using the

Re: [sqlite] new sqlite-based webserver

2006-10-09 Thread John Stanton
Martin Jenkins wrote: Fred Williams wrote: What'ch got it running on, a 286? Tried three different times and got tired waiting all three times :-( Seems ok now. Quite fast even. mj - To unsubscribe, send email

[sqlite] Is something special to load fts1.dll in Tcl?

2006-10-09 Thread Gerry Snyder
I am eager to try out full text search using SQLite and Tcl on WinXP. I downloaded the Tcl bindings and executable for SQLite 3.3.8 and the fts1.dll file, and copied them all (after unzipping) to a directory. The fts1.dll loads fine using the stand-alone executable, but I get a "not

Re: [sqlite] new sqlite-based webserver

2006-10-09 Thread Martin Jenkins
Fred Williams wrote: What'ch got it running on, a 286? Tried three different times and got tired waiting all three times :-( Seems ok now. Quite fast even. mj - To unsubscribe, send email to [EMAIL PROTECTED]

[sqlite] creating a view on an attached database

2006-10-09 Thread P Kishor
I am attaching external database 'b' to database 'a', ATTACH DATABASE b AS d_b; and then trying to create a view that uses tables from the attached database, CREATE VIEW v AS SELECT d_b_t.col, d_a_t.col FROM d_b.tbl AS d_b_t JOIN tbl AS d_a_t ON... I get the following error -- view v

Re: [sqlite] Re: SQLite Order BY

2006-10-09 Thread John Stanton
A. Pagaltzis wrote: * John Stanton <[EMAIL PROTECTED]> [2006-10-09 19:35]: Sorting data is time consuming, a physical law is involved. At best it is an nlog(n) process. Only when you sort by comparing elements with each other. Bucket sort runs in O(n), f.ex. And quantum sort is O(1). ;-)

[sqlite] Re: SQLite Order BY

2006-10-09 Thread A. Pagaltzis
* John Stanton <[EMAIL PROTECTED]> [2006-10-09 19:35]: > Sorting data is time consuming, a physical law is involved. At > best it is an nlog(n) process. Only when you sort by comparing elements with each other. Bucket sort runs in O(n), f.ex. And quantum sort is O(1). ;-) Algorithms that run

Re: [sqlite] new sqlite-based webserver

2006-10-09 Thread John Stanton
Gunter, I cannot access your web site. The address is resolved, then the server hangs. It would be interesting to look at your www server. Günter Greschenz wrote: hi, i dont know if anyone is interested in my new open source project... i implemented a little webserver with javascript as

RE: [sqlite] new sqlite-based webserver

2006-10-09 Thread Fred Williams
What'ch got it running on, a 286? Tried three different times and got tired waiting all three times :-( Not going to stir much interest with response times like that! > -Original Message- > From: Günter Greschenz [mailto:[EMAIL PROTECTED] > Sent: Monday, October 09, 2006 12:04 PM > To:

Re: [sqlite] SQLite Order BY

2006-10-09 Thread John Stanton
Sorting data is time consuming, a physical law is involved. At best it is an nlog(n) process. Sorting a result set or sorting the keys to build an index invokes the nlog(n) timing. If you cannot tolerate time spent sorting, you need to redesign your database to avoid sorts, or to maintain

Re: [sqlite] results of SELECT contains carriage returns

2006-10-09 Thread P Kishor
On 10/9/06, T <[EMAIL PROTECTED]> wrote: Hi He, >> sqlite3 Disney.db "SELECT * FROM Characters" >> >> When I get the result of a SELECT statement, the output has >> columns separated by pipe characters and rows by new lines. So, if >> a value contains a return, it prematurely starts a new line,

[sqlite] [ANN] New DBManager Professional 3.4.0 Enterprise Edition

2006-10-09 Thread COS
DBTools Software is pleased to announce the new DBManager Professional 3.4.0 Enterprise Edition. This is a major update with plenty of bugs fixed and new improvements to the application. See the details: NEW FEATURES AND IMPROVEMENTS - Added Context Menu for Default Servers - Diagram Designer

Re: [sqlite] results of SELECT contains carriage returns

2006-10-09 Thread T
Hi He, sqlite3 Disney.db "SELECT * FROM Characters" When I get the result of a SELECT statement, the output has columns separated by pipe characters and rows by new lines. So, if a value contains a return, it prematurely starts a new line, and messes up my output result. Well, you

[sqlite] Re: any questions

2006-10-09 Thread Igor Tandetnik
mimuel1 <[EMAIL PROTECTED]> wrote: - with access it is possible to integrate "pseudo-stored-procedure". can I do this with SQLite too? SQLite has triggers, which can be used as poor man's stored procedures. That's the only kind of "code" that can be stored in a database. Your program can

[sqlite] Re: SQLite Order BY

2006-10-09 Thread Igor Tandetnik
He Shiming <[EMAIL PROTECTED]> wrote: select * from hvh5m,itm where hvh5m.Column4=itm.Icol1 order by Column8 You can try creating two additional indexes, one on hvh5m.Column4 and the other on hvh5m.Column8. They should speed things up. Actually, what would help here is a compound index on

Re: [sqlite] transaction and tables

2006-10-09 Thread drh
chetana bhargav <[EMAIL PROTECTED]> wrote: > Hi, > > I have a query regarding transactions and tables. > > Say in a DB if you have 4 tables, now in my code I will say , "begin > transaction" and start modifying a table, say tbl1, now a journal would be > backed up for the tbl1 that

[sqlite] transaction and tables

2006-10-09 Thread chetana bhargav
Hi, I have a query regarding transactions and tables. Say in a DB if you have 4 tables, now in my code I will say , "begin transaction" and start modifying a table, say tbl1, now a journal would be backed up for the tbl1 that I am going to modify, now if in the same transaction if

[sqlite] any questions

2006-10-09 Thread mimuel1
Hi, now I wrote a db-application with ms-access. Its only a single-user application. But the size of access-dbs are limited.(2GB). Now I found SQLite, limited at 4 TB. My questions: - with access it is possible to integrate "pseudo-stored-procedure". can I do this with SQLite too? - where can I

Re: [sqlite] Can anyone recommend some ISAM db to me?

2006-10-09 Thread Paul Smith
At 11:38 08/10/2006, you wrote: Hi, all After trying SQLite on my embedded platform, I feel that it's a little too complicated and time-consuming to my platform, especially the parsing. So, could someone recommend several ISAM ones to me?(I'm a newbie of database*^_^*) You could have a look

Re: [sqlite] SQLite Order BY

2006-10-09 Thread He Shiming
Thanks shiming we have tried this method as u suggested , but creating an index on a 5 million records take a long time, nearly 4 seconds. And in our case the Database contain 5 Million to 30 or 50 million records. so if I try to create additional indices on these tables it takes too much

[sqlite] error on sqlite3_close

2006-10-09 Thread Kibae Shin
Hi. in sqlite3.3.8(latest) ./configure --prefix=/sw CFLAGS=-g CPPFLAGS=-g 1 thread : 1 db model Error on many thread's request(about 1k/sec) to same db file. This problem repeated sometimes. I use sqlite3_commit_hook, sqlite3_rollback_hook, sqlite3_update_hook and sqlite3_set_authorizer

Re: [sqlite] SQLite Order BY

2006-10-09 Thread Manzoor Ilahi
Thanks shiming we have tried this method as u suggested , but creating an index on a 5 million records take a long time, nearly 4 seconds. And in our case the Database contain 5 Million to 30 or 50 million records. so if I try to create additional indices on these tables it takes too much