News for hackers. Stuff that matters.
Re:SQLite 3.8.0 Release with next-generation query planner by simias on Tuesday August 27, 2013 @04:35AM (#6282205)
I love SQLite but I don't think it's fair to compare it directly to other rdbms. As the official website itself puts it:

"Another way to look at SQLite is this: SQLite is not designed to replace Oracle. It is designed to replace fopen()."

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

There are very few instances where I end up in a position where I have to decide whether I need to use postgres or sqlite, they have very different use cases.

Re:SQLite 3.8.0 Release with next-generation query planner by Shorel on Tuesday August 27, 2013 @10:32AM (#6283630)
I don't think it is designed to replace fopen().

They can't say it, but it is designed to replace FoxPro and Access, or more generally: a local ODBC connection.