HTML Code
<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="UTF-8">
  <meta name="viewport" content="width=device-width, initial-scale=1.0">
  <title>IndexedDB — add vs put</title>
  <style>
    body {
      font-family: system-ui, sans-serif;
      margin: 0;
      padding: 1.5rem;
      background: #f8fafc;
      color: #334155;
      line-height: 1.6;
    }
    h1 { margin: 0 0 0.5rem; font-size: 1.25rem; color: #0f172a; }
    p { margin: 0 0 1rem; max-width: 440px; }
    .btns { display: flex; flex-wrap: wrap; gap: 0.5rem; }
    button {
      padding: 0.55rem 1rem;
      font-size: 0.9375rem;
      background: #2563eb;
      color: #fff;
      border: none;
      border-radius: 8px;
      cursor: pointer;
    }
    button.secondary { background: #7c3aed; }
    button.tertiary { background: #64748b; }
    button:hover { filter: brightness(1.06); }
    button:disabled { opacity: 0.6; cursor: not-allowed; }
    #status {
      margin-top: 1rem;
      padding: 0.75rem 1rem;
      max-width: 440px;
      background: #fff;
      border: 1px solid #e2e8f0;
      border-radius: 8px;
      font-size: 0.875rem;
    }
    #status.ok { border-left: 4px solid #22c55e; }
    #status.err { border-left: 4px solid #ef4444; }
    code { background: #e2e8f0; padding: 0.1rem 0.35rem; border-radius: 4px; }
  </style>
</head>
<body>
  <h1>add() vs put()</h1>
  <p>Record <code>id: 1</code> is created first. A second <code>add()</code> fails; <code>put()</code> updates the name.</p>

  <div class="btns">
    <button type="button" id="seedBtn" disabled>1. Seed id 1 as "Draft"</button>
    <button type="button" id="addBtn" class="secondary" disabled>2. add() again (fails)</button>
    <button type="button" id="putBtn" class="tertiary" disabled>3. put() as "Final"</button>
  </div>

  <p id="status">Opening database&hellip;</p>

  <script>
    var statusEl = document.getElementById('status');
    var db;

    var openReq = indexedDB.open('tryitUpsertDemo', 1);

    openReq.onupgradeneeded = function (event) {
      event.target.result.createObjectStore('notes', { keyPath: 'id' });
    };

    openReq.onsuccess = function (event) {
      db = event.target.result;
      statusEl.textContent = 'Ready. Click step 1 to seed the record.';
      statusEl.className = 'ok';
      document.getElementById('seedBtn').disabled = false;
      document.getElementById('addBtn').disabled = false;
      document.getElementById('putBtn').disabled = false;
    };

    function run(op, item) {
      var tx = db.transaction(['notes'], 'readwrite');
      var store = tx.objectStore('notes');
      var req = store[op](item);

      req.onsuccess = function () {
        statusEl.textContent = op + '() succeeded for id 1 → title: "' + item.title + '"';
        statusEl.className = 'ok';
      };

      req.onerror = function (event) {
        statusEl.textContent = op + '() failed: ' + event.target.error.message;
        statusEl.className = 'err';
        event.preventDefault();
      };
    }

    document.getElementById('seedBtn').addEventListener('click', function () {
      run('add', { id: 1, title: 'Draft' });
    });

    document.getElementById('addBtn').addEventListener('click', function () {
      run('add', { id: 1, title: 'Duplicate attempt' });
    });

    document.getElementById('putBtn').addEventListener('click', function () {
      run('put', { id: 1, title: 'Final' });
    });
  </script>
</body>
</html>
Lines: 0 | Characters: 0
Live Preview Auto-refresh on Run
IndexedDB — add() vs put() (Upsert)
