Re: [sqlite] ANN: SQLcc another open source Database manager

2007-03-16 Thread Jim Dodgen
Server not found I get "Firefox can't find the server at oase.uci.kun.nl." when I click on: http://oase.uci.kun.nl/~mientki/data_www/pic/jalcc/help/jalcc_sqlite.html Stef Mientki wrote: Although there are already a lot of database manager, I couldn't find a free (preferable

Re: [sqlite] sqlite Performance

2007-03-16 Thread John Stanton
Dennis's insight is apt. Just as you would eliminate "common sub expressions" in your programs (or have an optimizer do it for you) it is a good idea to do the same with systems. Writing numbers in an endian agnostic manner can easily be done on your flat file. Dennis Cote wrote: Ken

Re: [sqlite] Adding columns of records and updating the result to a record

2007-03-16 Thread John Stanton
A good use of wallspace next to "There are no victims, only volunteers". Dennis Cote wrote: jose isaias cabrera wrote: "el que se lleva de consejo, muere de viejo," which loosely translates to, "he who listens to advice, dies of old age." Thanks for that. It's now on my wall. Dennis Cote

Re: [sqlite] Search engines and the Sqlite.Org website

2007-03-16 Thread John Stanton
Why are you surprised? No doubt they are trying to do the job with Microsoft quality control and software. [EMAIL PROTECTED] wrote: I was looking into the server logs and I discovered a curious difference between MSN and Google. Over the past 7 days, the MSN bot has visited www.sqlite.org

[sqlite] ANN: SQLcc another open source Database manager

2007-03-16 Thread Stef Mientki
Although there are already a lot of database manager, I couldn't find a free (preferable open source) one, that fitted my needs. So I wrote another one with a lot of help of this list (Thank you all !!), and I'm returning the result now as an open sources alternative. Compared to others it

Re: [sqlite] Search engines and the Sqlite.Org website

2007-03-16 Thread Cesar Rodas
I think you should disalow MSN bot... nobody use that... if there is top in google when you search "Embedded SQL database", what else could sqlite needs?... MSN is not used (at least here in south America and the rest of the world) Another question... your robots.txt is this User-agent: *

Re: [sqlite] Search engines and the Sqlite.Org website

2007-03-16 Thread Roger Binns
[EMAIL PROTECTED] wrote: Another 59115 hits from the MSN bot contain the name "luggle.com" in the URL. This usually happens if people put broken links in their pages on their site. It can be due to just plain getting the URLs wrong or the more usual making some broken relative link instead

Re: [sqlite] sqlite Performance

2007-03-16 Thread Eduardo Morras
At 15:51 16/03/2007, you wrote: Dennis, Yes the data will be read later by down stream processing. I do have the option of either putting the data into sqlite at the start (when its read) or putting it into a flat file and then Later loading it into a sqlite db via a downstream job.

[sqlite] read/write from diffrent threads

2007-03-16 Thread John Gunnarsson
Hi, I've read mails in this discussion list, and the documentation on the sqlite website, but I'm not smart enough to grasp how to solve the problems of different threads reading and writing from/to the same database, whitin the same application. So basically I will have an application which

Re: [sqlite] Adding columns of records and updating the result to a record

2007-03-16 Thread jose isaias cabrera
Well, it has helped me immensely. :-) - Original Message - From: "Dennis Cote" <[EMAIL PROTECTED]> To: Sent: Friday, March 16, 2007 9:29 AM Subject: Re: [sqlite] Adding columns of records and updating the result to a record jose isaias cabrera wrote: "el

Re: [sqlite] sqlite Performance

2007-03-16 Thread Dennis Cote
Ken wrote: I do have the option of either putting the data into sqlite at the start (when its read) or putting it into a flat file and then Later loading it into a sqlite db via a downstream job. A great deal of the data columns are simple numeric values and thats where sqlite

Re: [sqlite] sqlite Performance

2007-03-16 Thread Ken
Dennis, Yes the data will be read later by down stream processing. I do have the option of either putting the data into sqlite at the start (when its read) or putting it into a flat file and then Later loading it into a sqlite db via a downstream job. A great deal of the data

Re: [sqlite] Adding columns of records and updating the result to a record

2007-03-16 Thread Dennis Cote
jose isaias cabrera wrote: "el que se lleva de consejo, muere de viejo," which loosely translates to, "he who listens to advice, dies of old age." Thanks for that. It's now on my wall. Dennis Cote - To unsubscribe,

Re: [sqlite] sqlite Performance

2007-03-16 Thread Dennis Cote
Ken wrote: This is a write only app. 100% insert. Ken, Why bother putting the data into a database if you are never going to read it back out? Other formats, such as a flat text file are much better for logs or archives. If, in fact, you will be reading the data at some point then

RE: [sqlite] Re: Re: Meta Information: How to retrieve the column names of a table ?

2007-03-16 Thread Samuel R. Neff
Thanks Dennis, I appreciate the detailed response. Sam --- We're Hiring! Seeking a passionate developer to join our team building products. Position is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] -Original

Re: [sqlite] Re: Adding columns of records and updating the result to a record

2007-03-16 Thread jose isaias cabrera
Thank you, John. This helps a lot. josé - Original Message - From: "John Stanton" <[EMAIL PROTECTED]> To: Sent: Friday, March 16, 2007 12:19 AM Subject: Re: [sqlite] Re: Adding columns of records and updating the result to a record When you design a

RE: [sqlite] Search engines and the Sqlite.Org website

2007-03-16 Thread Griggs, Donald
Regarding: Does anybody know what "luggle.com" is? FWIW, I see that Luggle.com appears to be a small site run off a linux pentium by a few developers. It does contain mention of sqlite: http://luggle.com/~sean/Articles/sqlitePV.php Excerpt from page:

Re: [sqlite] Search engines and the Sqlite.Org website

2007-03-16 Thread A.J.Millan
>> I consider the behavior of the MSN bot to be abusive. I'm >> sorely tempted to ban the MSN bot from the entire sqlite.org >> website. Absolutely agree. >> If SQLite ceased to be indexed by MSN, would that >> seriously inconvenience any users? IMHO none at all A.J.Millan ZATOR Systems

Re: [sqlite] Search engines and the Sqlite.Org website

2007-03-16 Thread Markus Hoenicka
Just out of curiosity, enter "attach_get" into google. The #1 hit is from SQLite: www.sqlite.org/cvstrac/attach_get/293/fx2lite.prg Go figure. regards, Markus Quoting [EMAIL PROTECTED]: I was looking into the server logs and I discovered a curious difference between MSN and Google. Over

[sqlite] Search engines and the Sqlite.Org website

2007-03-16 Thread drh
I was looking into the server logs and I discovered a curious difference between MSN and Google. Over the past 7 days, the MSN bot has visited www.sqlite.org 114550 times. The Google bot, on the other hand, has only visited 4070 times. In spite of this, when I type "Embedded SQL database" into