Skip to content
Singhak
  • Home
  • Tech
    • Javascript
    • Python
    • QnA
    • TipsnTricks
    • Automation
  • Blog
  • Submit Guest Post
  • About me
    • Contact Us
    • Privacy Policy
Menu Close
  • Home
  • Tech
    • Javascript
    • Python
    • QnA
    • TipsnTricks
    • Automation
  • Blog
  • Submit Guest Post
  • About me
    • Contact Us
    • Privacy Policy

Database

Home » Database
Read more about the article Add createdAt and updatedAt in mongoose schema using timstamps | Mongoose Timestamp
Database / MongoDB / TipsnTricks

Add createdAt and updatedAt in mongoose schema using timstamps | Mongoose Timestamp

Mongoose schemas support a timestamps option. If you set timestamps: true, Mongoose will add two properties of type Date to your schema: createdAt: a date representing when this document was createdupdatedAt: a date representing when…

0 Comments
13th June 2022
Read more about the article ORA-01536: space quota exceeded for tablespace ‘USERS’ | space quota exceeded for tablespace
Database / QnA

ORA-01536: space quota exceeded for tablespace ‘USERS’ | space quota exceeded for tablespace

First check table space quota for all user or for specific user using sql query. DBA_TS_QUOTAS describes tablespace quotas for all users.USER_TS_QUOTAS describes tablespace quotas for the current user. select * from…

0 Comments
25th April 2022
Read more about the article 5 ways to reduce fetch time of sql queries | Sql Query optimization
Database / TipsnTricks

5 ways to reduce fetch time of sql queries | Sql Query optimization

Here are five ways to reduce fetch time of our sql queries. 1 - If you have access to check the execution plan of you query then check which part…

0 Comments
11th April 2022
Read more about the article MongoParseError: options usecreateindex, usefindandmodify are not supported
Database / MongoDB

MongoParseError: options usecreateindex, usefindandmodify are not supported

The error is because of the new version of the mongoose i.e version 6.0.6. useNewUrlParser, useUnifiedTopology, useFindAndModify, and useCreateIndex are no longer supported options. Mongoose 6 always behaves as if useNewUrlParser, useUnifiedTopology, and useCreateIndex are true, and useFindAndModify is false. Please remove…

0 Comments
31st January 2022
Read more about the article MongoDB query where array length is greater than ‘n’
Database / MongoDB / TipsnTricks

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
Read more about the article Uncaught exception: Error: Updating user failed: User not found
Database / MongoDB / TipsnTricks

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…

0 Comments
6th December 2021
Read more about the article The database name is being accessed by other users Postgres | drop the database with command line in Postgres
Database / TipsnTricks

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…

0 Comments
29th November 2021
Read more about the article Authentication failed Postgress Commandline | pass the password in Postgres command line
Database / TipsnTricks

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…

0 Comments
22nd November 2021
  • 1
  • 2
  • 3
  • Go to the next page

Buy Me a Coffee

Join fb group

Follow on Instagram

Join Telegram Channel

Categories

Archives

Subscribe

Recent Posts

  • Remove a property from a JavaScript object?
  • Deep cloning of Object in JavaScript | Object Deep Copy
  • Remove specific item from array in JavaScript
  • Output based JavaScript interview questions
  • JavaScript coding interview question

Menu

  • Home
  • Submit Post
  • Privacy Policy
  • About me
  • Guest Post Submission
  • Contact Us
Support Me

Buy Me a Coffee

Copyright 2021 - Singhak
pixel