IndexedDB: how to reseed/reset auto-increment key to 0 (or 1)

Question

Simple question, but I haven't been able to find an answer.

How can I reset an object store in IndexedDB so the auto-increment key starts at 0 (or 1) again?

I am using IDBWrapper currently, but could use an alternative library if it is easier. I am using in-line keys.

From here: http://jensarps.de/2011/11/25/working-with-idbwrapper-part-1

If you need to clear the store from all stored entries, you can use the clear method. Note that this won’t reset Chrome’s autoIncrement counter.

If I manually clear the object store in Chrome Developer tools, this does not reset the key to 0 (or 1).

I did find this rejected bug: https://bugzilla.mozilla.org/show_bug.cgi?id=635551 and from there, this outline of key generation: http://www.w3.org/TR/2012/WD-IndexedDB-20120524/#key-generator-concept

Presumably I could write my own logic to remember when the store was last cleared and then alter the code where records are inserted to manually override the key to be 0 (or 1), but is this really necessary?

Glooming

Answer 1

You can't reset the generator, without deleting and recreating the object store.

As noted in https://w3c.github.io/IndexedDB/#key-generator-construct the maximum generated key is 9007199254740992 and:

If you generate a new key 1000 times per second day and night, you won’t run into this limit for over 285000 years.

Crossway

Sounds solid enough for me – Kaoliang

Answer 2

According to spec, generated key value can be anything depending on browser implementation. Your code should not rely on it.

Lab

I wasn't planning on hard-coding against any specific keys, just wondering as it seems messy that the keys will just keep incrementing forever, seemingly until the object store itself is deleted. Over the lifetime of an app the keys could become pretty long. – Glooming

Answer 3

You can't reset the generator, without deleting and recreating the object store. https://github.com/Tesfaye-Eshetie/reusable-comment-component/blob/store-comments-IndexedDB/js/idb/indexedDB.js

Torrential

you can also use the follow function to delete the database to restart the key: import { openDB, deleteDB } from 'idb'; (function createStore() { openDB('myDB', 1, { upgrade(db) { db.createObjectStore('store', { autoIncrement: true }); }, }); })(); (function deleteMyDB() { await deleteDB('myDB', { blocked() { console.log('deletions is successful'); }, }); })(); – Torrential

Your answer should rather be a comment. – Frail