News for hackers. Stuff that matters.
Re:Using Schema-less in Django with Postgres by danskil on Thursday June 14, 2012 @09:15PM (#4114455)
You should not use SQLite in production.
Re:Using Schema-less in Django with Postgres by rlander on Friday June 15, 2012 @12:50AM (#4115062)
I downvoted you. Here's why:

I've deployed SQLite to a large number of production software, from embedded systems to web servers handling thousands of daily vistors. In fact, SQLite is my tool of choice when it comes to a small/medium relational-db-based web project.

Sqlite is not a toy db. It is an impressive piece of software engineering.

So, unless you have a very narrow definition of the word production, you should do read up on SQLite (the official website is excellent) and seriously consider it for your next project.

Re:Using Schema-less in Django with Postgres by lost-theory on Friday June 15, 2012 @04:12AM (#4115537)
SQLite should absolutely be used in production, where it makes sense. The one area where sqlite has a big disadvantage is concurrent writes. If you have read-only data, cached data, etc. then sqlite can happily be used in a high traffic production system, with millions of rows and many GB of data. It's also a good store for configuration data, or something like an admin backend. The portability of sqlite database files is a really nice feature.
Re:Using Schema-less in Django with Postgres by StavrosK on Thursday June 14, 2012 @09:31PM (#4114496)
This is true, I should have said "it's not mature".