Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion AI Tools Integration
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

interview

Home Interviews How to update only a specific field in a record? – MindStick
Ask Question

1 Answers

Jiva Ram
Jiva Ram 30 Jun 2025
Report Abuse

To update a specific field in a record in IndexedDB, follow this common pattern:

  • Get the record by key (get()).
  • Modify the specific field.
  • Put the updated record back using put().

IndexedDB doesn't support partial updates directly — so you need to overwrite the whole object after changing just the part you want.

Example: Update a Specific Field

Suppose we have a Users object store with this record:

{ id: 1, name: "John", email: "john@example.com", age: 30 }

Now we want to update only the email field.

Function to Update One Field

function updateField(db, storeName, key, fieldName, newValue) {
    return new Promise((resolve, reject) => {
        const tx = db.transaction(storeName, 'readwrite');
        const store = tx.objectStore(storeName);

        const getRequest = store.get(key);

        getRequest.onsuccess = () => {
            const record = getRequest.result;

            if (!record) {
                reject('Record not found');
                return;
            }

            // Update the specific field
            record[fieldName] = newValue;

            const updateRequest = store.put(record);

            updateRequest.onsuccess = () => resolve('Field updated');
            updateRequest.onerror = (e) => reject(`Update error: ${e.target.errorCode}`);
        };

        getRequest.onerror = (e) => reject(`Get error: ${e.target.errorCode}`);
    });
}

Usage

(async () => {
    const db = await openDatabase('MyDB', 'Users'); // use the openDatabase function from earlier

    try {
        await updateField(db, 'Users', 1, 'email', 'new.email@example.com');
        console.log('Email updated!');
    } catch (err) {
        console.error(err);
    }
})();

Tip: Batch Field Updates

To update multiple fields:

Object.assign(record, { email: 'new@email.com', age: 31 });

Summary

  • You must fetch the full object, update the field(s), then overwrite it with put().
  • IndexedDB doesn’t support in-place field updates (like SQL’s UPDATE ... SET ...).
  • Use get(), modify, and put() for partial updates.
advertising
Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md