MongoDB query where array length is greater than ‘n’
While working on any project where we may have a requirement to check the size of an array or to get an element whose size is greater or less than…
0 Comments
13th December 2021
Uncaught exception: Error: Updating user failed: User not found
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…
6th December 2021
The database name is being accessed by other users Postgres | drop the database with command line in Postgres
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…
29th November 2021
Authentication failed Postgress Commandline | pass the password in Postgres command line
In the Postgres command line, it always prompts a password if the password is not set. We can avoid this in the following way. Before running any Postgres command-line command…
22nd November 2021
Multiple aggregation pipeline in a single query in MongoDB | Multiple Counts with a single query in MongoDB
Many time we want run query with in query to get desirable result. MongoDB provide a aggregation operator to achieve result like this. Lets assume we have a collection with…
30th August 2021
How to query MongoDB similar to SQL “Like” operator | SQL “Like” operator in MongoDB
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…
23rd August 2021
How to extract year and month from date in PostgreSQL
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…
2nd August 2021
group by in loopback | Distinct value in loopback
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…
26th July 2021
