On 27 Dec 2013, at 9:14pm, Igor Korot <ikoro...@gmail.com> wrote: > Does people use SQLite for Web development? Or web apps are written > only with mySQL/MS SQL?
I use SQLite databases to run about 10 web-facing applications for my department. The applications are written in JavaScript, but to read or write to the databases they use HTTP calls to access PHP web pages on the same server. The PHP pages use PHP's sqlite3 library to access databases on the same server. I got the first of these working about 12 years ago and it still works fine. Everyone seems happy with them all, certainly more happy than they were with the FileMaker system we were using before. > What are pros/cons of usinf SQLite for Web app? The backend to my system originally accessed MySQL databases. I changed this when Apple no longer included MySQL as part of its Server software. So all I can compare is MySQL and SQLite. The biggest advantage of MySQL was that MySQL was faster -- up to three times as fast -- especially when many users were using my system at once. However, this didn't make much difference to my users: as far as they could see even under SQLite they were still getting their results in less than 2 seconds 99% of the time, which is acceptable for a web interface. MySQL also has a security model which allowed me to password-protect my database in case someone tried to hack the MySQL socket (which never happened). The biggest advantage of SQLite was that when using SQLite it's obvious exactly what data is kept in which database files. When testing a new database or taking a backup of a dataset, you quit one of your apps, the data for that app is in exactly one file on disk, and you can take copies or restore backups as as you wish. You can look up old backups of your hard disk and restore the data for one app without messing with any others. If you want to create or look at a SQLite database you can do it on any computer that can run the sqlite shell tool. In contrast, the data for MySQL is kept in multiple files within one big folder. If you want to create or look at a MySQL database you have to set up a MySQL server, complete with sockets, on a computer with a working internet stack. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
