SQLite Forum

Finding the SQLite version for a feature
Login

Finding the SQLite version for a feature

(1) By Jeff M (jeffrey) on 2022-01-25 06:01:49 [link] [source]

Given a certain feature, how can I find the SQLite version number where that feature was introduced?

In particular, I want to know when the ADD COLUMN syntax was added to the ALTER TABLE command. I need to determine if my iOS app users will have that version or newer.

(2) By anonymous on 2022-01-25 08:11:26 in reply to 1 [link] [source]

You can search for "ADD COLUMN" on that page: https://sqlite.org/changes.html

(4.2) By Simon Slavin (slavin) on 2022-01-25 10:48:51 edited from 4.1 in reply to 2 [link] [source]

That actually works, and identifies

2005-03-21 (3.2.0)

Nice. I wish it worked for all features and significant improvements.

Given that the feature was added in 2005, and the iPhone was first released in 2007, I don't think you're going to have to have your users check it.

(3) By ddevienne on 2022-01-25 08:33:00 in reply to 1 [link] [source]

how can I find the SQLite version number where that feature was introduced?

It's unfortunately not something that is tracked.
It's been requested before, but that did not happen.

Searching the release notes is indeed the next best thing.
And there's always finding the code for that feature, and go back to Fossil...

(5) By anonymous on 2022-01-25 19:47:24 in reply to 1 [link] [source]

You can search the FOSSIL.

Command fossil sea add column ends the list with the earliest relevant entry:

=== 2005-03-17 ===
05:06:28 [173e26961f] Update to keyword list for ALTER TABLE ... ADD COLUMN command. (CVS 2394)
05:03:39 [94185dd4f7] Add the ALTER TABLE ... ADD COLUMN command. (CVS 2393)

(6) By ddevienne on 2022-01-26 08:54:05 in reply to 5 [source]

Nice! Thanks for sharing.