Skip to main content

Getting Started With IndexedDB

What is IndexedDB? How does it work?

  1. Stores data in the browser. It is called the browser database
  2. More structured than localStorage.
  3. Used to store objects indexed with a key.
  4. Can be accessed from the same domain.
  5. API is asynchronous.
  6. stores data in key-value pairs.
  7. Open DB > Create Object Store > On Success, Conduct Transaction > Close Transaction

Let us see a little demo of IndexedDB

  1. Open console of a Chrome Browser
  2. Paste the following
    • const request = indexedDB.open("notes");
      request.onupgradeneeded = e => {
        alert("upgrade");
      }
      request.onsuccess = e => {
        alert("success");
      }
      request.onerror = e => {
        alert("error");
      }
  3. This example is something that we created. You will see notes database in Application > IndexedDB > notes
  4. Another example would be of real IndexedDB used in production
    1. Open Youtube and see IndexDB in Application tab of developer's console of browser
    2. You will encounter database named swpushnotificationsdb with a store named swpushnotificationsstore
  5. Run this example of IndexedDB transaction in the console of your browser
    • let db;
      function createDB() {    
          let dbName = "Jokes";
          let dbVersion = 5;
          let request = indexedDB.open(dbName, dbVersion);
          request.onupgradeneeded = e => {
            db = e.target.result
            console.log(db);
            let jstore = db.createObjectStore("JokeStore", {keyPath: "title"});
            let mstore = db.createObjectStore("MockStore", {keyPath: "title"});
            alert("upgrade");
          }
          request.onsuccess = e => {
            db = e.target.result
            console.log(db);
            alert("success");
          }
          request.onerror = e => {
            alert("error"+e.target.error);
          }
      }
      function addRecord(title, text) {
          let tx = db.transaction("JokeStore","readwrite");
          tx.onerror = e => alert(e.target.error);
          let jstoretx = tx.objectStore("JokeStore");
          jstoretx.add({title: title, text: text});
      }
      function viewNotes() {
          let tx = db.transaction("JokeStore", "readonly");
          let jstore = tx.objectStore("JokeStore");
          let request = jstore.openCursor();
          request.onsuccess = e => {
              let cursor = e.target.result;
              if (cursor) {
                  console.log(cursor.key, cursor.value.text);
                  cursor.continue();
              }
          }
      }
      createDB(); // Creates db if not there or opens an existing one
      addRecord("Joke 1", "Knock Knock"); // Adds record
      addRecord("Joke 2", "Elephant and the ant"); // Adds record
      viewNotes(); // Displays all records in console
  6. It connects, creates an entry in the database store, and displays all records on the console.

Comments

Popular posts from this blog

Python - List - Append, Count, Extend, Index, Insert, Pop, Remove, Reverse, Sort

🐍 Advance List List is widely used and it's functionalities are heavily useful. Append Adds one element at the end of the list. Syntax list1.append(value) Input l1 = [1, 2, 3] l1.append(4) l1 Output [1, 2, 3, 4] append can be used to add any datatype in a list. It can even add list inside list. Caution: Append does not return anything. It just appends the list. Count .count(value) counts the number of occurrences of an element in the list. Syntax list1.count(value) Input l1 = [1, 2, 3, 4, 3] l1.count(3) Output 2 It returns 0 if the value is not found in the list. Extend .count(value) counts the number of occurrences of an element in the list. Syntax list1.extend(list) Input l1 = [1, 2, 3] l1.extend([4, 5]) Output [1, 2, 3, 4, 5] If we use append, entire list will be added to the first list like one element. Extend, i nstead of considering a list as one element, it joins the two lists one after other. Append works in the following way. Input l1 = [1, 2, 3] l1.append([4, 5]) Output...

Difference between .exec() and .execPopulate() in Mongoose?

Here I answer what is the difference between .exec() and .execPopulate() in Mongoose? .exec() is used with a query while .execPopulate() is used with a document Syntax for .exec() is as follows: Model.query() . populate ( 'field' ) . exec () // returns promise . then ( function ( document ) { console . log ( document ); }); Syntax for .execPopulate() is as follows: fetchedDocument . populate ( 'field' ) . execPopulate () // returns promise . then ( function ( document ) { console . log ( document ); }); When working with individual document use .execPopulate(), for model query use .exec(). Both returns a promise. One can do without .exec() or .execPopulate() but then has to pass a callback in populate.

683 K Empty Slots

  Approach #1: Insert Into Sorted Structure [Accepted] Intuition Let's add flowers in the order they bloom. When each flower blooms, we check it's neighbors to see if they can satisfy the condition with the current flower. Algorithm We'll maintain  active , a sorted data structure containing every flower that has currently bloomed. When we add a flower to  active , we should check it's lower and higher neighbors. If some neighbor satisfies the condition, we know the condition occurred first on this day. Complexity Analysis Time Complexity (Java):  O(N \log N) O ( N lo g N ) , where  N N  is the length of  flowers . Every insertion and search is  O(\log N) O ( lo g N ) . Time Complexity (Python):  O(N^2) O ( N 2 ) . As above, except  list.insert  is  O(N) O ( N ) . Space Complexity:  O(N) O ( N ) , the size of  active . Approach #2: Min Queue [Accepted] Intuition For each contiguous block ("window") of  k  po...