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 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 How to query MongoDB similar to SQL “Like” operator | SQL “Like” operator in MongoDB
Database / MongoDB / TipsnTricks

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…

0 Comments
23rd August 2021
Read more about the article How to extract year and month from date in PostgreSQL
Database / TipsnTricks

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…

0 Comments
2nd August 2021
Read more about the article group by in loopback | Distinct value in loopback
Database / Tech / TipsnTricks

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…

0 Comments
26th July 2021
  • 1
  • 2
  • Go to the next page

Buy Me a Coffee

Follow Us

Join Telegram Channel

Categories

Archives

Subscribe

Recent Posts

  • 10 MongoDB performance tuning tips for large scale applications
  • Python utility scripts that can automate various tasks
  • Setting up a MongoDB environment: A step-by-step guide for installing MongoDB on your local machine
  • 5 Different ways to compress image using python script.
  • Make rest api call using https node module.

Menu

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

Buy Me a Coffee

Copyright 2021 - Singhak
pixel