LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Programming (http://www.linuxquestions.org/questions/programming-9/)
-   -   SQLite vs MySQL on a web-site (http://www.linuxquestions.org/questions/programming-9/sqlite-vs-mysql-on-a-web-site-924772/)

Mr. Alex 01-20-2012 06:11 AM

SQLite vs MySQL on a web-site
 
Hello guys!

As far as I know SQLite doesn't need a server running to work and provides SQL type of database. Can it be used on a web-site instead of MySQL to make things easier and more portable?

Cedrik 01-20-2012 06:59 AM

Yes, if web server php or perl module supports it

Mr. Alex 01-20-2012 07:58 AM

And the SQLite database can be stored in a structured plaintext file in the web-site directory?

sundialsvcs 01-20-2012 09:36 AM

An SQLite database is a disk file. If you are reading from it, it might be just fine ... but if you might be simultaneously writing to it, you might not want to go that route.

audriusk 01-20-2012 09:53 AM

From SQLite website:
Quote:

SQLite usually will work great as the database engine for low to medium traffic websites (which is to say, 99.9% of all websites). The amount of web traffic that SQLite can handle depends, of course, on how heavily the website uses its database. Generally speaking, any site that gets fewer than 100K hits/day should work fine with SQLite. The 100K hits/day figure is a conservative estimate, not a hard upper bound. SQLite has been demonstrated to work with 10 times that amount of traffic.


All times are GMT -5. The time now is 10:45 AM.