Sql Provider

sql.ts

import { Injectable } from '@angular/core';
import { SQLite } from '@ionic-native/sqlite';
import { Platform } from 'ionic-angular';
import { isEmpty, isNull, keys, sortBy, get, parseInt } from 'lodash';
import { browserDBInstance } from './browser';

declare var window: any;
const SQL_DB_NAME = process.env.IONIC_ENV === 'dev' ? '__broswer.db' : '__native.db';

@Injectable()
export class SqlProvider {

  dbInstance: any;

  constructor(public sqlite: SQLite, private platform: Platform) {
    this.init();
  }

  async init() {
    if (!this.platform.is('cordova')) {
      let db = window.openDatabase(SQL_DB_NAME, '1.0', 'DEV', 5 * 1024 * 1024);
      this.dbInstance = browserDBInstance(db);
    } else {
      this.dbInstance = await this.sqlite.create({
        name: SQL_DB_NAME,
        location: 'default'
      });
    }
  }
}

openDatabase is not available

@mitesh-shah please refer to this blog post for details.
https://medium.com/@surajair/ionic-native-sqlite-with-browser-development-6847b7f9611

@surajair
Yes, I am referring that only.
In that there is a line -> let db = window.openDatabase(SQL_DB_NAME, '1.0', 'DEV', 5 * 1024 * 1024);

In that line openDatabase not found for type window

Please try this in chrome browser. I will update it in post too

I am trying in chrome only.

But, this error is coming before ionic serve.

It's a compilation error.

This setup was done on ionic 3. There are package changes in ionic 4. You might have to make some changes. Can you post exact error here?