Reputation: 5790
Recently I have started learning rails and was a little surprised that the default database is sqlite3.
I have used sqlite3 before for lightweight applications like programs that have their own personal database, embedded databases on iPhone apps and keeping a light database on a embedded system with a microcontroller, but I never thought of using it on a system as a drop in replacement for a more advanced DBMS like mysql.
Can sqlite3 handle being the DBMS for high traffic sites?
Upvotes: 2
Views: 698
Reputation: 40277
This is probably the best answer on the subject: How Scalable is SQLite?
My opinion is no-way would I use sqlite for something as multi-user and persistent-intensive as a social networking site.
Upvotes: 2