On 15 Aug 2011, at 9:46am, Raouf Athar wrote: > I have to develop a Library Management System using *PHP* for a medium sized > college library. The library has about 5,000 members and 50,000 books. On an > average, about 500 members will look for books and will be issued books on > daily basis. > > *Kindly let me know if it is okay to use SQLite?**Kindly add a few words in > support of your answer.* > *Can you give me links/ references of a few applications supported by > SQLite?*
I run three PHP/SQLite that size or bigger than that myself, all hosted on the same Mac Pro. I only have about 300 users a day at most, but there is no problem with that amount of data. Use the SQLite3 object-oriented library for PHP. Not PDO or any other method of accessing SQLite. Perhaps start by writing yourself a little SQLite3 library to do the standard things like execute INSERT and UPDATE, read a single-row SELECT, and read a multi-row SELECT. Make sure you make up appropriate indexes for your SQL commands, so they run quickly. Save a great deal of time by designing your user interface for HTML4 or HTML5, not Internet Explorer. If IE has problems running it, tell them it's not IE compatible and have your users use FireFox/Chrome/Safari/whatever. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users