[sqlite] Happy birthday Dr Hipp

2008-04-08 Thread Cesar D. Rodas
Happy birthday Dr. Hipp!, best wishes for you!

The SQLite community!

-- 
Best Regards

Cesar D. Rodas
http://www.cesarodas.com
http://www.thyphp.com
http://www.phpajax.org
Phone: +595-961-974165
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] I want to this project but I need help..

2008-02-19 Thread Cesar D. Rodas
Hello,

I was looking to the sqlite website after a long time and it looks very
great, it had growth notably  and my congratulations for  SQLite Consortium.
Well before I begin explaining my idea I want to know if some one had the
althttp.c quoted here
http://www.mail-archive.com/sqlite-users@sqlite.org/msg14449.html.

I was thinking If I can implement a new "OS Interface File Virtual Methods
Object" for have a kind of network SQLite. The main idea is not have
"client-server" because only the data it self will be in another(s)
machines, but the processing will be done on the "client". It can be useful,
and it is the easiest way to implement a network-sqlite with full-locking.

Talking fast, instead of a sqlite-db file, it will be saved in another
machine.

What does folk think about this project?, useful or not? I mean for "real
world" needs.

-- 
Best Regards

Cesar D. Rodas
http://www.cesarodas.com
http://www.thyphp.com
http://www.phpajax.org
Phone: +595-961-974165
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] Regarding sqlite website...

2007-12-26 Thread Cesar D. Rodas
Hello,

Merry x-mass to everyone, I'd like to know if all the documentation (
http://www.sqlite.org/c3ref/update_hook.html for example) was generating
with a software that generate documentation from source code or it was
generated by a human.

If the first option is true, does any one can tell me where can I download
that software?

Regards

-- 
Best Regards

Cesar D. Rodas
http://www.cesarodas.com
http://www.thyphp.com
http://www.phpajax.org
Phone: +595-961-974165


[sqlite] PySQLite problem

2007-12-25 Thread Cesar D. Rodas
Hello,

I was testing PySQLite and got an exception:

Traceback (most recent call last):
  File "D:\code.cesarodas.com\etopa\test2.py", line 33, in 
for result in search(raw_input("Search:")):
  File "D:\code.cesarodas.com\etopa\files.py", line 147, in search
r = cu.execute('select dir, file from files where file like :item',
{"item":
item}).fetchall()
sqlite3.OperationalError: Could not decode to UTF-8 column 'file' with text
'DJ
Marky e DJ Patife - S¶ tinHa qUe Ser cOm voce.mp3'


Any one had an idea how to solve this problem?

-- 
Best Regards

Cesar D. Rodas
http://www.cesarodas.com
http://www.thyphp.com
http://www.phpajax.org
Phone: +595-961-974165


[sqlite] Helping with table definition?

2007-12-24 Thread Cesar D. Rodas
Hello,

Merry Christmas for every one!

I am wondering if someone did a function (the language doesn't care very
much) to get the table information and want to share him/her code.

I know that you can have the SQL definition of a table doing a "select *
from sqlite_master where type='table' ", but I need to parse SQL and
understand it.

Thanks in advance.

-- 
Best Regards

Cesar D. Rodas
http://www.cesarodas.com
http://www.thyphp.com
http://www.phpajax.org
Phone: +595-961-974165


Re: [sqlite] Simple question about optimization

2007-12-10 Thread Cesar D. Rodas
On 10/12/2007, Cesar D. Rodas <[EMAIL PROTECTED]> wrote:
>
> What Kess Nuyt is asking is if you want to replace a column with a data,
> which is the data, will SQLite update it or SQLite is smart enough for
> avoid  write the same thing?, very important for keep executing time,
> because write something to HDD is very expensive.
>
> I hope I understand well your question Kees, unfortunately  I couldn't
> answer your question, because I don't know, I think Dr. Hipp will be able to
> answer your question :-)


It was Clodo question, sorry :-)

On 10/12/2007, Kees Nuyt <[EMAIL PROTECTED]> wrote:
> >
> > On Mon, 10 Dec 2007 12:22:53 +0100, Clodo <[EMAIL PROTECTED]>
> > wrote:
> >
> > >In this case:
> > >
> > >-
> > >CREATE TABLE test (
> > >  Field01  text PRIMARY KEY NOT NULL,
> > >  Field02  text
> > >);
> > >
> > >insert into test values ('alpha','beta');
> > >
> > >update test set Field01='alpha', Field02='gamma';
> > >-
> > >
> > >In the "update" statement, i re-set the primary field "Field01" to a
> > >value that field already have.
> >
> > >Sqlite detect this situation and don't update the primary index,
> >
> > SQLite will update the primary key, verifying all constraints
> > (NOT NULL, UNIQUE). The performance impact isn't very big,
> > because the relevant pages will be loaded in the cache anyway.
> >
> > EXPLAIN UPDATE test SET Field01='alpha', Field02='gamma';
> > tells the whole story.
> >
> > >or suppose that developers optimize situation like that?
> >
> > The statement does not do what you seem to need.
> > Usually you want to do:
> > UPDATE test SET Field02='gamma' WHERE Field01='alpha';
> >
> > Without the WHERE clause ALL rows will be updated, which will
> > fail because column Field01 will not be unique anymore.
> >
> > Extend your test set with:
> > insert into test values ('delta','kappa');
> > and rerun your test to see what happens.
> >
> > >P.s. in our program, the "update" statement are generated from a
> > >database-layer, and optimize the statement generation is a big work..
> > >for that i'm trying to understand if will be a biggest optimization or
> > >not..
> > >thanks for feedback!
> >
> > HTH
> > --
> >   (  Kees Nuyt
> >   )
> > c[_]
> >
> >
> > -
> > To unsubscribe, send email to [EMAIL PROTECTED]
> >
> > -
> >
> >
>
>
> --
> Best Regards
>
> Cesar D. Rodas
> http://www.cesarodas.com
> http://www.thyphp.com
> http://www.phpajax.org
> Phone: +595-961-974165




-- 
Best Regards

Cesar D. Rodas
http://www.cesarodas.com
http://www.thyphp.com
http://www.phpajax.org
Phone: +595-961-974165


Re: [sqlite] Simple question about optimization

2007-12-10 Thread Cesar D. Rodas
What Kess Nuyt is asking is if you want to replace a column with a data,
which is the data, will SQLite update it or SQLite is smart enough for
avoid  write the same thing?, very important for keep executing time,
because write something to HDD is very expensive.

I hope I understand well your question Kees, unfortunately  I couldn't
answer your question, because I don't know, I think Dr. Hipp will be able to
answer your question :-)


On 10/12/2007, Kees Nuyt <[EMAIL PROTECTED]> wrote:
>
> On Mon, 10 Dec 2007 12:22:53 +0100, Clodo <[EMAIL PROTECTED]>
> wrote:
>
> >In this case:
> >
> >-
> >CREATE TABLE test (
> >  Field01  text PRIMARY KEY NOT NULL,
> >  Field02  text
> >);
> >
> >insert into test values ('alpha','beta');
> >
> >update test set Field01='alpha', Field02='gamma';
> >-
> >
> >In the "update" statement, i re-set the primary field "Field01" to a
> >value that field already have.
>
> >Sqlite detect this situation and don't update the primary index,
>
> SQLite will update the primary key, verifying all constraints
> (NOT NULL, UNIQUE). The performance impact isn't very big,
> because the relevant pages will be loaded in the cache anyway.
>
> EXPLAIN UPDATE test SET Field01='alpha', Field02='gamma';
> tells the whole story.
>
> >or suppose that developers optimize situation like that?
>
> The statement does not do what you seem to need.
> Usually you want to do:
> UPDATE test SET Field02='gamma' WHERE Field01='alpha';
>
> Without the WHERE clause ALL rows will be updated, which will
> fail because column Field01 will not be unique anymore.
>
> Extend your test set with:
> insert into test values ('delta','kappa');
> and rerun your test to see what happens.
>
> >P.s. in our program, the "update" statement are generated from a
> >database-layer, and optimize the statement generation is a big work..
> >for that i'm trying to understand if will be a biggest optimization or
> >not..
> >thanks for feedback!
>
> HTH
> --
>   (  Kees Nuyt
>   )
> c[_]
>
>
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
>
> -
>
>


-- 
Best Regards

Cesar D. Rodas
http://www.cesarodas.com
http://www.thyphp.com
http://www.phpajax.org
Phone: +595-961-974165


[sqlite] SQLite with PHP

2007-11-24 Thread Cesar D. Rodas
Hello,

This message is only for let know users that I've wrote a class for manage
SQL database using the same interface.

It supports:
- Connect to a database given a connection string
- Prepared queries
- Caching query results in files
- Binding variables to query result columns
- Fetch whole result sets into an array

SQLite is supported but not well tested :-$, for a matter of time. It will
be great if the SQLite people could test this class and let me know if there
is a bug or for request new features.

http://cesars.users.phpclasses.org/browse/package/4222.html, here is the
class site.

-- 
Best Regards

Cesar D. Rodas
www.cesarodas.com
www.thyphp.com
Phone: +595-961-974165


Re: [sqlite] Problem inserting blob

2007-08-31 Thread Cesar D. Rodas
insert into t values ("x'ccaa-ffee'");
or
insert into t values ('x''ccaa-ffee''');
What you wanna insert must be between " or ' (''[double ' ] is the scape of
')

The cleanest way to do is compiling the query


On 31/08/2007, Prakash Reddy Bande <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I am trying to insert blob in a sqlite database using sqlite.exe .
>
> create table t (x blob);
>
> insert into t values (x'ccaaffee');
>
> insert into t values (x'ccaa-ffee'); // This line give the error SQL
> error: unrecognized token: "x'ccaa"
>
>
>
> Where am I going wrong?
>
>
>
> Regards,
>
>
>
> Prakash Reddy Bande
>
> Altair Engg. Inc,
>
> Troy, MI
>
>
>
>


-- 
Cesar D. Rodas
http://www.cesarodas.com/
Mobile Phone: 595 961 974165
Phone: 595 21 645590
[EMAIL PROTECTED]
[EMAIL PROTECTED]


Re: [sqlite] FTS2 suggestion

2007-08-29 Thread Cesar D. Rodas
N-gram is a sequense of N Letters of a word or set of words...

http://en.wikipedia.org/wiki/N-gram



On 29/08/2007, Uma Krishnan <[EMAIL PROTECTED]> wrote:
>
> Hello Scott,
>
> I have several clarifications with respect to full text search. I'm a
> newbie in open source development, so please bear with me if some of the
> questions are irrelevant/obvious/nonsense.
>
> I was given to understand that the potter stemming algorithm implemented
> in fts2 is not robust enough (or rather snowball is more accurate). If
> fts2(or 3) has to be made more robust, then what should be the next step.
> The following url (I thought) gave the steps to follow rather succinctly:
>
>
> http://web.njit.edu/~wu/teaching/CIS634/GoodProjects/AccessLisa/documentation.php
>
> At what stage would n-gram kick in (I assume n-gram would be in
> conjunction to snowball/potter). Which would be a good n-gram algorithm to
> implement.
>
> Finally, what's the rationale in having sqlite's own search. Why not use
> something like luceneC?
>
> Thanks in advance
>
> Uma
>
> Scott Hess <[EMAIL PROTECTED]> wrote: Porter stemmer is already in
> there.  The main issue with Porter is
> that it's English only.
>
> There is no general game-plan for fuzzy search at this time, though if
> someone wants to step into the breech, go for it!  Even a prototype
> which demonstrates the concepts and problems but isn't
> production-ready would be worth something.
>
> My current focus for the next generation is international support
> (this is more of a Google Gears project, but with focus on SQLite so
> there is likely to be stuff checked in on the SQLite side), and more
> scalable/manageable indexing.  Not a lot of focus on things like
> quality and recall, mostly because I'm not aware of any major users
> with enough of an installed baseline to even generate decent metrics.
> [Basically, solving concrete identified problems rather than looking
> for ill-defined potential problems.]
>
> -scott
>
>
> On 8/24/07, Uma Krishnan  wrote:
> > Would it not be more useful to first implement potter stemmer algorithm,
> and then to implement n-gram (as I understand n-gram is for cross column
> fuzzy search?). What is the general game plan for FTS3 with regard to fuzzy
> search?
> >
> >   Thanks in advance
> >
> > "Cesar D. Rodas"  wrote:
> >   On 23/08/07, Scott Hess wrote:
> > > On 8/20/07, Cesar D. Rodas wrote:
> > > > As I know ( I can be wrong ) SQLite Full Text Search is only match
> with hole
> > > > words right? It could not be
> > > > And also no FT extension to db ( as far I know) is miss spell
> tolerant,
> > >
> > > Yes, fts is matching exactly. There is some primitive support for
> > > English stemming using the Porter stemmer, but, honestly, it's not
> > > well-exercised.
> > >
> > > > And
> > > > I've found this Paper that talks about *Using Superimposed Coding Of
> N-Gram
> > > > Lists For Efficient Inexact Matching*
> > >
> > >
> http://citeseer.ist.psu.edu/cache/papers/cs/22812/http:zSzzSzwww.novodynamics.comzSztrenklezSzpaperszSzatc92v.pdf/william92using.pdf
> > > >
> > > > I was reading and it is not so hard to implement, but it cost a
> extra
> > > > storage space, but I think the benefits are more.
> > > >
> > > > Also following this paper could be done a way to match with
> fragments of
> > > > words... what do you think of it?
> > >
> > > It's an interesting paper, and I must say that anything which involves
> > > Bloom Filters automatically draws my attention :-).
> >
> > Yeah. I am doing some investigations about that, I love that too. And
> > I was watching that with n-grams you get a filter to stop common
> > words, and could be used as a stemming-like algorithm but independent
> > from the language.
> >
> > I was thinking to implement this
> > http://www.mail-archive.com/sqlite-users%40sqlite.org/msg26923.html
> > when I finish up some things. What do you think of it?
> >
> > > While I think spelling-suggestion might be valuable for fts in the
> > > longer term, I'm not very enthusiastic about this particular model.
> > > It seems much more useful in the standard indexing model of building
> > > the index, manually tweaking it, and then doing a ton of queries
> > > against it. fts is really fairly constrained, because many use-cases
> > > are more along the lines of update the index quite a bit, and query it
> > > only a few times.
> > >
> &

Re: [sqlite] FTS2 suggestion

2007-08-23 Thread Cesar D. Rodas
I

On 23/08/07, Russell Leighton <[EMAIL PROTECTED]> wrote:
>
>
> Could fts3 (the next fts) have the option to override the default
> 'match' function with one passed in (similar to the tokenizer)?
>
> The reason I ask is then the fts table could be used as smart index
> when the tokenizer is
> something like bigram, trigram, etc. and the 'match' function computes
> a similarity metric
> and returns the row if above a threshold.
>
> Postgres does this when you declare an index of type trigram, see:
>
> http://www.sai.msu.su/~megera/postgres/gist/pg_trgm/README.pg_trgm
>
> Since SQLite does not allow 'plug-in' indexes, the idea would be to
> create an fts3 table with a key back to the main table and the string
> column you want index.
> Indexing becomes a join through the fts3 table.
>
> You would probably want to allow the user to pass args to the 'match'
> function so a threshold could be set to non-default values and maybe
> tweak matching options
> specific to the match and tokenization.
>
> Thoughts?


I think this idea is great... If the ft3 has this optionality i could
rewrite the match function, I like the idea to give the possibility that
users can training  with data, and in database is where most data  are
store, and usually by categories, tags, or other system.

My goal is to give a set of data for learn, then in new inserts assign the
correct or closest category. And another feature that I want is that it
could learn about its mistakes (human assisted)

On Aug 23, 2007, at 4:56 PM, Scott Hess wrote:
>
> > On 8/20/07, Cesar D. Rodas <[EMAIL PROTECTED]> wrote:
> >> As I know ( I can be wrong ) SQLite Full Text Search is only match
> >> with hole
> >> words right? It could not be
> >> And also no FT extension to db ( as far I know) is miss spell
> >> tolerant,
> >
> > Yes, fts is matching exactly.  There is some primitive support for
> > English stemming using the Porter stemmer, but, honestly, it's not
> > well-exercised.
> >
> >> And
> >> I've found this Paper that talks about *Using Superimposed Coding Of
> >> N-Gram
> >> Lists For Efficient Inexact Matching*
> >
> > http://citeseer.ist.psu.edu/cache/papers/cs/22812/http:
> > zSzzSzwww.novodynamics.comzSztrenklezSzpaperszSzatc92v.pdf/
> > william92using.pdf
> >>
> >> I was reading and it is not so hard to implement, but it cost a extra
> >> storage space, but I think the benefits are more.
> >>
> >> Also following this paper could be done a way to match with fragments
> >> of
> >> words... what do you think of it?
> >
> > It's an interesting paper, and I must say that anything which involves
> > Bloom Filters automatically draws my attention :-).
> >
> > While I think spelling-suggestion might be valuable for fts in the
> > longer term, I'm not very enthusiastic about this particular model.
> > It seems much more useful in the standard indexing model of building
> > the index, manually tweaking it, and then doing a ton of queries
> > against it.  fts is really fairly constrained, because many use-cases
> > are more along the lines of update the index quite a bit, and query it
> > only a few times.
> >
> > Also, I think the concepts in the paper might have very significant
> > problems handling Unicode, because the bit vectors will get so very
> > large.  I may be wrong, sometimes the overlapping-vector approach can
> > have surprising relevance depending on the frequency distribution of
> > the things in the vector.  It would need some experimentation to
> > figure that out.
> >
> > Certainly something to bookmark, though.
> >
> > Thanks,
> > scott
> >
> > -----------
> > --
> > To unsubscribe, send email to [EMAIL PROTECTED]
> > ---
> > --
> >
>
>
>
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
>
> -
>
>


-- 
Cesar D. Rodas
http://www.cesarodas.com/
Mobile Phone: 595 961 974165
Phone: 595 21 645590
[EMAIL PROTECTED]
[EMAIL PROTECTED]


Re: [sqlite] FTS2 suggestion

2007-08-23 Thread Cesar D. Rodas
On 23/08/07, Scott Hess <[EMAIL PROTECTED]> wrote:
> On 8/20/07, Cesar D. Rodas <[EMAIL PROTECTED]> wrote:
> > As I know ( I can be wrong ) SQLite Full Text Search is only match with hole
> > words right? It could not be
> > And also no FT extension to db ( as far I know) is miss spell tolerant,
>
> Yes, fts is matching exactly.  There is some primitive support for
> English stemming using the Porter stemmer, but, honestly, it's not
> well-exercised.
>
> > And
> > I've found this Paper that talks about *Using Superimposed Coding Of N-Gram
> > Lists For Efficient Inexact Matching*
>
> http://citeseer.ist.psu.edu/cache/papers/cs/22812/http:zSzzSzwww.novodynamics.comzSztrenklezSzpaperszSzatc92v.pdf/william92using.pdf
> >
> > I was reading and it is not so hard to implement, but it cost a extra
> > storage space, but I think the benefits are more.
> >
> > Also following this paper could be done a way to match with fragments of
> > words... what do you think of it?
>
> It's an interesting paper, and I must say that anything which involves
> Bloom Filters automatically draws my attention :-).

Yeah. I am doing some investigations about that, I love that too. And
I was watching that with n-grams you get a filter to stop common
words, and could be used as a stemming-like algorithm but independent
from the language.

I was thinking to implement this
http://www.mail-archive.com/sqlite-users%40sqlite.org/msg26923.html
when I finish up some things. What do you think of it?

> While I think spelling-suggestion might be valuable for fts in the
> longer term, I'm not very enthusiastic about this particular model.
> It seems much more useful in the standard indexing model of building
> the index, manually tweaking it, and then doing a ton of queries
> against it.  fts is really fairly constrained, because many use-cases
> are more along the lines of update the index quite a bit, and query it
> only a few times.
>
> Also, I think the concepts in the paper might have very significant
> problems handling Unicode, because the bit vectors will get so very
> large.  I may be wrong, sometimes the overlapping-vector approach can
> have surprising relevance depending on the frequency distribution of
> the things in the vector.  It would need some experimentation to
> figure that out.
>
> Certainly something to bookmark, though.
>
> Thanks,
> scott
>
> ---------
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
>
>



-- 
Cesar D. Rodas
http://www.cesarodas.com/
Mobile Phone: 595 961 974165
Phone: 595 21 645590
[EMAIL PROTECTED]
[EMAIL PROTECTED]

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



[sqlite] FTS2 suggestion

2007-08-20 Thread Cesar D. Rodas
Hello SQLite community


This is suggestion for the core team suggestion.

As I know ( I can be wrong ) SQLite Full Text Search is only match with hole
words right? It could not be

And also no FT extension to db ( as far I know) is miss spell tolerant, And
I've found this Paper that talks about *Using Superimposed Coding Of N-Gram
Lists For Efficient Inexact Matching*
http://citeseer.ist.psu.edu/cache/papers/cs/22812/http:zSzzSzwww.novodynamics.comzSztrenklezSzpaperszSzatc92v.pdf/william92using.pdf

I was reading and it is not so hard to implement, but it cost a extra
storage space, but I think the benefits are more.

Also following this paper could be done a way to match with fragments of
words... what do you think of it?



-- 
Cesar D. Rodas
http://www.cesarodas.com/
Mobile Phone: 595 961 974165
Phone: 595 21 645590
[EMAIL PROTECTED]
[EMAIL PROTECTED]


[sqlite] SQLite extension

2007-08-11 Thread Cesar D. Rodas
Hello SQLite community

I am doing an investigation about Text Categorization based on
N-Grams at my University. The main goal of the project is to offer a
inexpensive way to categorize texts based on previous "learn". The
categorization could not only be done as the language of the text, my
hypothesis is that I could work well for categorize by subject of a
text. The project is a "alpha" based and is writing in PHP for many
reasons, I think the most important is that easier to write and debug
than C.

The previous paragraph was only an introduction of what I want
to propose to the SQLite community, that was *not* advertisement or
spam.

I think that SQLite is a good database, and very useful for
many task. I think the simple and effective architecture of SQLite
made it popular and useful for developers. For that reasons I was
thinking to write an extension for SQLite adding a Text Categorization
module to it. You may be wondering *why* or how that can be useful for
you?.

I think I have the answer. Because n-gram based text
categorization works well for *long texts* and it is human-language
independent, that offer us (developers) a way to give to SQLite the
"knowledge" and "power" to categorize text automatically, of course
with a previous trine for every possible category with a set of
examples. This is useful for build a system for categorize articles of
a news-paper or organize a library.

My experiments are not finish, but first of nothing I want to
know if is this a good idea and of course, if it useful for SQLite
community.

-- 
Cesar D. Rodas
http://www.cesarodas.com/
Mobile Phone: 595 961 974165
Phone: 595 21 645590
[EMAIL PROTECTED]
[EMAIL PROTECTED]

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] SQLite Project. A contribution to manking

2007-06-27 Thread Cesar D. Rodas

D. Richard Hipp

The blog is updated!, and I think you should put in your website GoogleAds
to get other benefis with your wonderful project, and the comunity think
about this?

Thank you for take time for send me the update information.

Also this information will be publish in some free magazines from here.


Here it could be found:
http://cesarodas.com/2007/06/how-to-manage-thousands-visitors-part-ii-wwwsqliteorg.html


On 27/06/07, Cesar D. Rodas <[EMAIL PROTECTED]> wrote:


Thank you very much for your information Mr. Hipp!

I will update my blog.




On 26/06/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> "Cesar D. Rodas" <[EMAIL PROTECTED]> wrote:
> >
> > I was surfing  and I saw that sqlite website is very busy with a hight
> band
> > width traffic (http://alexa.com/data/details/traffic_details?url=sqlite.org
> )
> > and I was reading about the SQLite has an Server which is not the
> normal
> > apache or other known webserver, is that right?
> >
> > I am interesting to know more about this server, and configurations
> about
> > know more about the SQLite server configuration, what do you do Mr.
> Hipp for
> > handle a great quantity of traffic (server configuration, your wserver
> code
> > (if you can give it away) and a network connection)? If you can give
> that
> > information will be great, coz I think is better the Practice (and
> your site
> > is very very busy) than theory.
> >
>
> I was surfing and I found your article:
>
> 
http://cesarodas.com/2007/06/how-to-manage-thousands-visitors-part-ii-wwwsqliteorg.html
>
> Let me give you slightly more up-to-date statistics on the
> www.sqlite.org website.  Traffic has been on a steady rise
> for some time now, and for the past week we've seen in excess
> of 1 unique IPs per day.  The total number of hits is
> still running around 7/day.  Bandwidth is over 3GB per
> day. CPU utilization is running about 4%.  (It is unclear to
> me if that is 4% of the total CPU available on the physical
> host or 4% of my 1/20th slice of that host.  Probably the
> former)
>
> I made a change to the althttpd.c server a couple of months
> ago where it automatically drops any connection from the msnbot
> or IE5 running on windows95 (as determined by the USER-AGENT
> parameter in the HTTP header.)  Kicking off the msnbot resulted
> in a huge reduction in hits but with no reduction in the number
> of unique IPs.  This means, of course, that SQLite is no longer
> listed on the MSN search, but nobody seems to use MSN so that
> is no big loss.  And the MSN bot is downright abusive in the
> way it hammers a site.  The load presented by the msnbot far
> exceeds the combined load of all other search engines on the
> internet combined.  Go figure
>
> I used to get lots of hung win95/IE5 clients that would do
> things like download 5 copies of the tarball over the
> course of 8 hours.  I would be getting 2 or 3 download
> requests per second.  This was chewing through a lot of
> bandwidth so I just made the decision to ban win95/IE5 from
> the site.  So far, no complaints have reached me.
>
> Perhaps someday my humble little website will be overwhelmed
> and I will have to switch to something like Apache which is
> designed to handle a heavy load.  But for now, everything
> seems to be going along peachy.  If it ain't broke, don't
> fix it
>
> --
> D. Richard Hipp <[EMAIL PROTECTED]>
>
>
>
> -----
> To unsubscribe, send email to [EMAIL PROTECTED]
>
> -
>
>


--
Cesar D. Rodas
http://www.cesarodas.com/
Mobile Phone: 595 961 974165
Phone: 595 21 645590
[EMAIL PROTECTED]
[EMAIL PROTECTED]





--
Cesar D. Rodas
http://www.cesarodas.com/
Mobile Phone: 595 961 974165
Phone: 595 21 645590
[EMAIL PROTECTED]
[EMAIL PROTECTED]


Re: [sqlite] SQLite Project. A contribution to manking

2007-06-27 Thread Cesar D. Rodas

Thank you very much for your information Mr. Hipp!

I will update my blog.




On 26/06/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:


"Cesar D. Rodas" <[EMAIL PROTECTED]> wrote:
>
> I was surfing  and I saw that sqlite website is very busy with a hight
band
> width traffic (
http://alexa.com/data/details/traffic_details?url=sqlite.org)
> and I was reading about the SQLite has an Server which is not the normal
> apache or other known webserver, is that right?
>
> I am interesting to know more about this server, and configurations
about
> know more about the SQLite server configuration, what do you do Mr. Hipp
for
> handle a great quantity of traffic (server configuration, your wserver
code
> (if you can give it away) and a network connection)? If you can give
that
> information will be great, coz I think is better the Practice (and your
site
> is very very busy) than theory.
>

I was surfing and I found your article:

http://cesarodas.com/2007/06/how-to-manage-thousands-visitors-part-ii-wwwsqliteorg.html

Let me give you slightly more up-to-date statistics on the
www.sqlite.org website.  Traffic has been on a steady rise
for some time now, and for the past week we've seen in excess
of 1 unique IPs per day.  The total number of hits is
still running around 7/day.  Bandwidth is over 3GB per
day. CPU utilization is running about 4%.  (It is unclear to
me if that is 4% of the total CPU available on the physical
host or 4% of my 1/20th slice of that host.  Probably the
former)

I made a change to the althttpd.c server a couple of months
ago where it automatically drops any connection from the msnbot
or IE5 running on windows95 (as determined by the USER-AGENT
parameter in the HTTP header.)  Kicking off the msnbot resulted
in a huge reduction in hits but with no reduction in the number
of unique IPs.  This means, of course, that SQLite is no longer
listed on the MSN search, but nobody seems to use MSN so that
is no big loss.  And the MSN bot is downright abusive in the
way it hammers a site.  The load presented by the msnbot far
exceeds the combined load of all other search engines on the
internet combined.  Go figure

I used to get lots of hung win95/IE5 clients that would do
things like download 5 copies of the tarball over the
course of 8 hours.  I would be getting 2 or 3 download
requests per second.  This was chewing through a lot of
bandwidth so I just made the decision to ban win95/IE5 from
the site.  So far, no complaints have reached me.

Perhaps someday my humble little website will be overwhelmed
and I will have to switch to something like Apache which is
designed to handle a heavy load.  But for now, everything
seems to be going along peachy.  If it ain't broke, don't
fix it

--
D. Richard Hipp <[EMAIL PROTECTED]>



-
To unsubscribe, send email to [EMAIL PROTECTED]

---------





--
Cesar D. Rodas
http://www.cesarodas.com/
Mobile Phone: 595 961 974165
Phone: 595 21 645590
[EMAIL PROTECTED]
[EMAIL PROTECTED]


[sqlite] SQLite Project. A contribution to manking

2007-06-25 Thread Cesar D. Rodas

I know that this post is not a query about SQLite DB, and I am sorry for
that.

First to all, congratulation to D. Richard Hipp and this wonderful
community.

And I know Mr. Hipp that SQLite is open source, public domain, but I think
you deserve to make money with that quantity of money. I won't be and I
think the community angry if you put Google  Ads Sense in your page, for you
to get some money for such great contribution to the world, I think SQLite
is great.

And Also, congratulation because SQLite will be spread around the world with
Google Gears.

I was surfing  and I saw that sqlite website is very busy with a hight band
width traffic (http://alexa.com/data/details/traffic_details?url=sqlite.org)
and I was reading about the SQLite has an Server which is not the normal
apache or other known webserver, is that right?

I am interesting to know more about this server, and configurations about
know more about the SQLite server configuration, what do you do Mr. Hipp for
handle a great quantity of traffic (server configuration, your wserver code
(if you can give it away) and a network connection)? If you can give that
information will be great, coz I think is better the Practice (and your site
is very very busy) than theory.


--
Cesar D. Rodas
http://www.cesarodas.com/
Mobile Phone: 595 961 974165
Phone: 595 21 645590
[EMAIL PROTECTED]
[EMAIL PROTECTED]


Re: [sqlite] Why do you use SQLite? Comments for an article needed

2007-06-07 Thread Cesar D. Rodas

I am using SQLite because it is easy to use (zero config). To add to your
project.  And it was  well designed by Mr. Hipp, with a really to use API. A
wild SQL support.
Because there is not Client-Server, and thousands times better than access
and foxpro
Many people uses, so there is a lot of help.
A lot wrappers for C++, PHP, Python, Ruby on rails, and others.
Because it is done in C, it will have a great performance


A proof of the power of SQLite is that is used in Google Gear Project.

On 07/06/07, Tim Anderson <[EMAIL PROTECTED]> wrote:


I'm writing an article about SQLite and I'd love to get some comments
from users about why you use it. Performance? Features? Reliability?
Cost? Is the open source aspect important? Anything else? For that
matter, anything you really don't like about SQLite?

You can email me at tim(at)itwriting.com or comment here if you prefer -
but to use your quote I'd need at least a full name, what you do and the
company you work for

Thanks in advance for your help.

Tim
http://www.itwriting.com/blog



-
To unsubscribe, send email to [EMAIL PROTECTED]

-





--
Cesar Rodas
http://www.cesarodas.com/
Mobile Phone: 595 961 974165
Phone: 595 21 645590
[EMAIL PROTECTED]
[EMAIL PROTECTED]