Is SQLite suitable for use in a production website?

I'm rewriting a PHP+MySQL site that averages 40-50 hits a day using Django.

Is SQLite a suitable database to use here? Are there any advantages/disadvantages between them?

I'm just using the db to store a blog and the users who can edit it. I am using fulltext search for the blog search, but no complex joins anywhere.

Answers


40-50 hits per day is very small and SQLLite can be used without any problem.

MySql might be better once you will get more hit because it handles in a better way multiple connexion (lock isn't the same with MySql and SqlLite).


Need Your Help

Differences between Objective-C vs. Objective-C 2.0

objective-c objective-c++

I reserved 2 library books which came on the same day. I saw them on the shelf and realized that they were the same except one was about ObjC and one was about ObjC 2.0.

Is there a tool to extract all comments from python source, preserving source line/col info?

python parsing

Is there any python library or tool to allow me to extract all comments from a block of python source code, preferably preserving information about the original line and column? For instance

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.