The createIndex()
method of the IDBObjectStore
interface creates and returns a new IDBIndex
object in the connected database. It creates a new field/column defining a new data point for each database record to contain.
Bear in mind that IndexedDB indexes can contain any JavaScript data type; IndexedDB uses the structured clone algorithm to serialize stored objects, which allows for storage of simple and complex objects.
Note that this method must be called only from a VersionChange
transaction mode callback.
createIndex(indexName, keyPath)
createIndex(indexName, keyPath, options)
An IDBIndex
object: the newly created index.
This method may raise a DOMException
of one of the following types:
-
ConstraintError
DOMException
-
Thrown if an index with the same name already exists in the database. Index names are case-sensitive.
-
InvalidAccessError
DOMException
-
Thrown if the provided key path is a sequence, and multiEntry
is set to true
in the objectParameters
object.
-
InvalidStateError
DOMException
-
Thrown if:
- The method was not called from a
versionchange
transaction mode callback, i.e. from inside a onupgradeneeded
handler. - The object store has been deleted.
-
SyntaxError
DOMException
-
Thrown if the provided keyPath
is not a valid key path.
-
TransactionInactiveError
DOMException
-
Thrown if the transaction this IDBObjectStore
belongs to is not active (e.g. has been deleted or removed.) In Firefox previous to version 41, an InvalidStateError
was raised in this case as well, which was misleading; this has now been fixed (see Webkit bug 1176165.)
In the following example you can see the onupgradeneeded
handler being used to update the database structure if a database with a higher version number is loaded. createIndex()
is used to create new indexes on the object store. For a full working example, see our To-do Notifications app (view example live).
let db;
const DBOpenRequest = window.indexedDB.open("toDoList", 4);
DBOpenRequest.onerror = (event) => {
note.innerHTML += "<li>Error loading database.</li>";
};
DBOpenRequest.onsuccess = (event) => {
note.innerHTML += "<li>Database initialized.</li>";
db = request.result;
displayData();
};
DBOpenRequest.onupgradeneeded = (event) => {
const db = event.target.result;
db.onerror = (event) => {
note.innerHTML += "<li>Error loading database.</li>";
};
const objectStore = db.createObjectStore("toDoList", {
keyPath: "taskTitle",
});
objectStore.createIndex("hours", "hours", { unique: false });
objectStore.createIndex("minutes", "minutes", { unique: false });
objectStore.createIndex("day", "day", { unique: false });
objectStore.createIndex("month", "month", { unique: false });
objectStore.createIndex("year", "year", { unique: false });
objectStore.createIndex("notified", "notified", { unique: false });
};