HTML Code

<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="UTF-8">
  <meta name="viewport" content="width=device-width, initial-scale=1.0">
  <title>Web SQL openDatabase()</title>
  <style>
    body { font-family: system-ui, sans-serif; margin: 1.5rem; line-height: 1.5; }
    button { padding: 0.5rem 0.9rem; cursor: pointer; }
    #status { margin-top: 1rem; }
  </style>
</head>
<body>
  <h1>Open a database</h1>
  <p>Create <code>contacts</code> with <code>CREATE TABLE IF NOT EXISTS</code>.</p>

  <button type="button" id="openBtn">Open demoDb</button>
  <p id="status">Click Open to start.</p>

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

    if (!window.openDatabase) {
      statusEl.textContent = 'Web SQL is not available.';
      document.getElementById('openBtn').disabled = true;
    }

    document.getElementById('openBtn').addEventListener('click', function () {
      var db = openDatabase('tryitHubOpen', '1.0', 'Try It', 1024 * 1024);
      db.transaction(function (tx) {
        tx.executeSql(
          'CREATE TABLE IF NOT EXISTS contacts (id INTEGER PRIMARY KEY, name TEXT, email TEXT)'
        );
      }, function (err) {
        statusEl.textContent = 'Error: ' + err.message;
      }, function () {
        statusEl.textContent = 'Ready: tryitHubOpen (contacts table created).';
      });
    });
  </script>
</body>
</html>

Lines: 0 | Characters: 0

Live Preview Auto-refresh on Run

Web SQL — Open Database & Create Table