3 ms·

I don't think there is an answer to your question beyond "it's been battle tested extremely well", but there are strong reasons to move to sqlite4 (in particula

I don't think there is an answer to your question beyond "it's been battle tested extremely well", but there are strong reasons to move to sqlite4 (in particular, multiple linked instances in eg mobile apps and mobile OSes). It's not like Python where the weight of the existing community has drawn you towards python 2 (something that has changed a lot recently).

jasode 12y ago
That's fair but I guess I was looking for a stronger statement from them because even for new minor point releases, the sqlite.org home page says clearly: "Version 3.8.4.3 of SQLite is recommended for all new development." Every time they change the "z" in v.x.y.z, they'll still state "is recommended for all new development." So, it seems like they could just clearly say, "SQLite4 is recommended for all new development." ...unless there's some architecture tradeoff (unrelated to backward compatibility) that still makes SQLite3 desirable over SQLite4.