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
- How to Add Days to Date in PostgreSQL
- How to Insert or Update if Exists in PostgreSQL
- How to Print Variable in PostgreSQL
- How to Use Where Clause in the Date Field Using PostgreSQL
- How to Add Primary Key to a PostgreSQL Table Only if It Does Not Exist
- How to Change the Owner of the PostgreSQL Database
- How to Check if a User-Defined Type Already Exists in PostgreSQL
- How to Drop if Exists vs Drop in PostgreSQL
- How to Generate a UUID for the Insert Statement in PostgreSQL
- How to Connect to PostgreSQL in SSL Mode
- How to Find the Disk Size of a PostgreSQL Table and Its Indexes
- JSONB in PostgreSQL
- How to Get Column Names in PostgreSQL
- How to Update Data in the JSON Field in PostgreSQL
- How to Drop Primary Key in PostgreSQL
- How to PostgreSQL DATE_TRUNC() Function
- PostgreSQL Equivalent of SYSDATE
- PostgreSQL string_agg Function
- How to Left Join Lateral in PostgreSQL
- How to Run SQL File in PSQL
- How to Show Connections in PostgreSQL
- How to Use Loop in PostgreSQL
- How to Use Variables in PostgreSQL
- Difference Between Timestamp With and Without Time Zone in PostgreSQL
- How to Query Between Date Ranges in PostgreSQL
- How to Query Between Date Ranges in PostgreSQL
- How to Connect to PostgreSQL With Password
- How to Use Database in PostgreSQL
- How to Use CASE in PostgreSQL
- How to Change Column Type in Postgres
- How to Change User Password in Postgres
- How to Check Version of Postgres
- Postgres Connection String
Python How-To's
- How to Fix AttributeError: 'Dict' Object Has No Attribute 'Append' in Python
- How to Fix AttributeError: 'NoneType' Object Has No Attribute 'Text' in Python
- How to Fix the AttributeError: 'numpy.ndarray' Object Has No Attribute 'Append' in Python
MongoDB Howtos
- How to Use MongoDB $Pull to Delete Documents Within an Array
- How to Search in the Specified Array in MongoDB
- Difference Between deleteMany() and Remove() in MongoDB
- The $ne Operator in MongoDB
- The $unset Operator in MongoDB
- Upsert in MongoDB