Shihab Sikder

PostgreSQL Howtos

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

Python How-To's

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

MongoDB Howtos

  1. Use MongoDB $Pull to Delete Documents Within an Array
  2. 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. Get the Day of a Month in JavaScript
Shihab Sikder avatar Shihab Sikder avatar

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.

LinkedIn Website