tag:blogger.com,1999:blog-13286014.post483149234831424370..comments2023-09-02T22:04:21.508+05:30Comments on Bin-Blog: SQLiteBinny V Ahttp://www.blogger.com/profile/17219747953793699351noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-13286014.post-66617679202972960022008-07-03T20:27:00.000+05:302008-07-03T20:27:00.000+05:30Hi Binny. In this post you said, "SQLite is in no ...Hi Binny. <BR/><BR/>In this post you said, <BR/><BR/><I>"SQLite is in no way a competition for MySQL or PostgreSQL as they tend to different needs. In the context of the LAMP platform, it is rare to see SQLite being used in a web server as most servers have MySQL(or PostgreSQL) server running. SQLite is more relevent in the application field where the user may not have a server running."<BR/></I><BR/><BR/>SQLite is, in fact, a great competitor for MySQL and PostgreSQL for many applications using the LAMP platform. That is because most (e.g. 99.9 %) web applications never reach the traffic levels needed to justify a server-based database such as PostgreSQL or MySQL. <BR/><BR/>If you are running your web application as a CGI, or in an application server, your application can make direct calls to SQLite that give the functionality of a relational database, but with the performance and programming semantics of using fopen/fread/fwrite/fclose on local flat files. This generally holds true as long as you don't exceed about 1 request per second (although the SQLite folks run their system at 10 requests per second just fine). <BR/><BR/>Check out my page on SQLite at <A HREF="http://www.squidoo.com/sqlitehammer" REL="nofollow">Squidoo</A> for a different perspective on SQLite.Anonymousnoreply@blogger.com