Re: [sqlite] Web application with SQLite

2013-12-29 Thread Richard Hipp
On Fri, Dec 27, 2013 at 4:14 PM, Igor Korot ikoro...@gmail.com wrote: Hi ALL, Does people use SQLite for Web development? Or web apps are written only with mySQL/MS SQL? The www.sqlite.org site uses SQLite, of course. That site gets between 200K and 300K HTTP requests per day, depending on

Re: [sqlite] Web application with SQLite

2013-12-29 Thread Stephan Beal
On Sun, Dec 29, 2013 at 5:35 PM, Tim Johnson t...@akwebsoft.com wrote: :) And if I request http://www.sqlite.org/src/timeline/index.php I get the same page, so Igor, Mr. Hipp uses PHP as the 'querying' code, or so I presume. LOL! If you try /timeline/foo/bar/baz you'll get the same

Re: [sqlite] Web application with SQLite

2013-12-29 Thread Tim Johnson
* Stephan Beal sgb...@googlemail.com [131229 07:48]: On Sun, Dec 29, 2013 at 5:35 PM, Tim Johnson t...@akwebsoft.com wrote: :) And if I request http://www.sqlite.org/src/timeline/index.php I get the same page, so Igor, Mr. Hipp uses PHP as the 'querying' code, or so I presume.

Re: [sqlite] Web application with SQLite

2013-12-29 Thread Mohd Radzi Ibrahim
fossil is a webserver by itself with sqlite as the database engine. AFAIK, there's no scripting language used on the server. All written in C. On Mon, Dec 30, 2013 at 1:02 AM, Tim Johnson t...@akwebsoft.com wrote: * Stephan Beal sgb...@googlemail.com [131229 07:48]: On Sun, Dec 29, 2013 at

Re: [sqlite] Common Table Expression

2013-12-29 Thread Sylvain Pointeau
I agree with David, CTE is just wonderful, a big help to avoid re-typing many times the same sub-query and a performance improvement as well. Yes we can workaround it but it is ugly and leads to un-maintainable code. I am using it every days in my job and I can just tell that it has been proven to