Some time while performing any operation on user like updating user, dropping user or granting or revoking access, we face error like user not found for particular db. Few thing…
dropdb destroys an existing PostgreSQL database. The user who executes this command must be a database superuser or the owner of the database. dropdb is a wrapper around the SQL command DROP DATABASE. There is no effective…
If we want SQL like "Like" operator in Mongo DB for string matching. But in mongo DB there is no such "like" operator instead it has regular expression to achieve…
There are various way to get year and month from date in PostgreSQL. 1. Extract The extract function retrieves subfields such as year or hour from date/time values. source must be a value expression…
Loopback does not support group by or distinct query. But we can achieve in loopback another way. Let see a solution for this issue. 1. Distinct // Let User is…
What is IndexedDB? IndexedDB is a large-scale, NoSQL storage system. It lets you store just about anything in the user's browser. In addition to the usual search, get, and put…
