Shihab Sikder avatar Shihab Sikder avatar

About Shihab Sikder

LinkedIn Website

I'm Shihab Sikder, a professional Backend Developer with experience in problem-solving and content writing. Building secure, scalable, and reliable backend architecture is my motive. I'm working with two companies as a part-time backend engineer.

Articles by Shihab Sikder

PostgreSQL Howtos

  1. How to Add Days to Date in PostgreSQL
  2. How to Insert or Update if Exists in PostgreSQL
  3. How to Print Variable in PostgreSQL
  4. How to Use Where Clause in the Date Field Using PostgreSQL
  5. How to Add Primary Key to a PostgreSQL Table Only if It Does Not Exist
  6. How to Change the Owner of the PostgreSQL Database
  7. How to Check if a User-Defined Type Already Exists in PostgreSQL
  8. How to Drop if Exists vs Drop in PostgreSQL
  9. How to Generate a UUID for the Insert Statement in PostgreSQL
  10. How to Connect to PostgreSQL in SSL Mode
  11. How to Find the Disk Size of a PostgreSQL Table and Its Indexes
  12. JSONB in PostgreSQL
  13. How to Get Column Names in PostgreSQL
  14. How to Update Data in the JSON Field in PostgreSQL
  15. How to Drop Primary Key in PostgreSQL
  16. How to PostgreSQL DATE_TRUNC() Function
  17. PostgreSQL Equivalent of SYSDATE
  18. PostgreSQL string_agg Function
  19. How to Left Join Lateral in PostgreSQL
  20. How to Run SQL File in PSQL
  21. How to Show Connections in PostgreSQL
  22. How to Use Loop in PostgreSQL
  23. How to Use Variables in PostgreSQL
  24. Difference Between Timestamp With and Without Time Zone in PostgreSQL
  25. How to Query Between Date Ranges in PostgreSQL
  26. How to Query Between Date Ranges in PostgreSQL
  27. How to Connect to PostgreSQL With Password
  28. How to Use Database in PostgreSQL
  29. How to Use CASE in PostgreSQL
  30. How to Change Column Type in Postgres
  31. How to Change User Password in Postgres
  32. How to Check Version of Postgres
  33. Postgres Connection String

Python How-To's

  1. How to Fix AttributeError: 'Dict' Object Has No Attribute 'Append' in Python
  2. How to Fix AttributeError: 'NoneType' Object Has No Attribute 'Text' in Python
  3. How to Fix the AttributeError: 'numpy.ndarray' Object Has No Attribute 'Append' in Python

MongoDB Howtos

  1. How to Use MongoDB $Pull to Delete Documents Within an Array
  2. How to Search in the Specified Array in MongoDB
  3. Difference Between deleteMany() and Remove() in MongoDB
  4. The $ne Operator in MongoDB
  5. The $unset Operator in MongoDB
  6. Upsert in MongoDB

JavaScript Howtos

  1. How to Get the Day of a Month in JavaScript