On 9 Jan 2018, at 6:46pm, Richard Hipp <d...@sqlite.org> wrote: > The latest change summary can be seen at > https://www.sqlite.org/draft/releaselog/3_22_0.html and the draft
In <https://www.sqlite.org/draft/cli.html#expert> … For "clobbering" use "overwriting", if only for the sake of international readers. "If this option is pass a non-zero argument" should probably be "passed". I think you can come up with a more appropriate name than "expert". How about "cleverindex" or "indexwizard" or something. If this is easy to do, then for the .expert command and, by extension, the external function … Please allow an option "—ignoreexisting" for the .expert command. This option makes SQLite ignore any existing indexes except for the ones which implement primary keys. For extra points, with this option selected, in the output section, it includes DROP INDEX commands for the indexes it ignored before the CREATE INDEX command it prefers. For an additional bonus point, with this option selected, the command should recognise when the new index it recommended is the same as one of the existing indexes it ignored, and do the "no new indexes" thing. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users