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

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 wrote: > * Stephan Beal [131229 07:48]: > > On Sun, Dec 29,

Re: [sqlite] Web application with SQLite

2013-12-29 Thread Tim Johnson
* Stephan Beal [131229 07:48]: > On Sun, Dec 29, 2013 at 5:35 PM, Tim Johnson 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

Re: [sqlite] Web application with SQLite

2013-12-29 Thread Stephan Beal
On Sun, Dec 29, 2013 at 5:35 PM, Tim Johnson 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

Re: [sqlite] Web application with SQLite

2013-12-29 Thread Richard Hipp
On Fri, Dec 27, 2013 at 4:14 PM, Igor Korot 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,