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