On 15 Feb 2016, at 9:41pm, James K. Lowden <jklowden at schemamania.org> wrote:
> SQL Server has none of those restrictions, and probably keeps pace with > SQLite even on its home turf. But the administration of SQL Server is > nontrivial. For that reason alone, I would never use it in situations > where SQLite would do. That's the fella. Major advantage of SQLite: zero admin. Not even a background task. Second advantage: you know exactly where you data is. Better still, it's simple: one database == one file, and the file has the same name as the database. I remember trying to reconstruct a MySQL database from a dead server. One folder with a confusing mass of files in. Your database is part of some of those files, but the files may be huge even if the one database you care about is tiny. That was not a fun time. Simon.
