Seems like a good reason to introduce a way to query the existence of a particular pragma command, something like: PRAGMA exists('user_version'); or PRAGMA exists='user_version'; -- Marco Bambini http://www.sqlabs.com http://twitter.com/sqlabs http://instagram.com/sqlabs
> On 6 Apr 2017, at 13:42, Richard Hipp <d...@sqlite.org> wrote: > > On Thu, 06 Apr 2017 12:11 +0100, Tim Streater <t...@clothears.org.uk> wrote: >> >> I keep reading that the continued >> existence of any particular PRAGMA is completely un-guaranteed. >> > > We say that. But in practice, if we were to remove a pragma it would > break thousands, perhaps millions, of applications, so they are all > there for the long haul. Especially "PRAGMA user_version" you can > count on being there. > -- > D. Richard Hipp > d...@sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users