Is SQLite Enough?

Question

I finally finished my first rail application, and I would like to release it. But I'm not sure if SQLite is enough. Do they use it for a deployed production environment?

I made the craiglist app as an app for my school where people can read and write text records.

Answer 1

This is a great way to get started, and it can work even in easily bootable environments, but it will not scale very well in a read / write environment.

The good news is that upgrading to a full RDBMS, such as MySQL or Postgres, is usually very simple.

Answer 2

. , . concurrency . .

. : http://www.sqlite.org/whentouse.html

Answer 3

SQLite performance crashes under simultaneous loads, which leads to a high delay when updating database rows, because the entire db file is locked during recording. Mysql etc. They lock at the row level, thereby allowing a higher level of concurrent requests.