Shihab Sikder

2. Author
3. 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