It would be useful for mozIStorageConnection to have a method for creating indices. It's possible to do so using executeSimpleSQL (which is what I use in my patch on bug 403375), but it would be easier if there were a method in the interface, just as the interface has a method for creating tables. The method could take an index name, table name, array of columns, and a boolean that indicated whether or not to die if the index already exists (i.e. the equivalent of the IF NOT EXISTS clause to the CREATE INDEX statement).
it's easy enough to run a simple query to create an index, abstracting any Sqlite functionality is not in the plans, especially in the new async API.
Status: NEW → RESOLVED
Last Resolved: 4 years ago
Resolution: --- → WONTFIX
You need to log in before you can comment on or make changes to this bug.