I called it "Microsoft S.Q.L" but Bobby argued it's Sequel not S.Q.L then I asked Bobby "PostgreSQL" and also he said "Postgre Sequel". Hehe sequel my ass then cus I'm sticking with my abbreviation.

How to screw with other developers?

Expose postgres at Port 5435.

I spent 15 mins trying to figure out why my dev machine doesn't connect to the RDS instance.

I prefer it doing 2 tasks parallely during the initial phase of requirement gathering and design phase.(makes more sense if you are working extremely new system and framework)
1. Keep collecting requirements from clients and understand them.
2. Collect different designing aspects for the project and parallely, build a POC for 2 purpose: to get hands into the new Framework and also as a demo to clients. Working on POC helps in 3 ways: Improving understanding of requirement, improving framework knowledge, and playing around with code whenever bored of designing and reading tons of existing designs..
3. Once primary requirements are clear and fixed, analyse all different designs, if possible I setup meetings with senior devs, principal engineers (they help a lot when it comes to reviews on scalability and reliability of a design)
4. The above design is mostly architectural level. Once design is fixed, then I start taking each component and prepare a detailed implementation design. (Notice that whenever I am bored of designing, I spend sometime in building POC)
5. In detail design, I focus on modularity and flexibility. Anything defined should have getters and setters for example. This will help you reuse your code. Keep the interface between components in your design as generic as possible, so that in case your MySQL is change to Postgre or NoSQL, your design should be able to adapt new features..
6. Instead of building entire project, define feature targets and deliver small features.. this will help you to be in line with the requirements with minimum deviation.

From morning to afternoon, finally installed Nginx, Postgre, and phpPgAdmin.

my head is like, I have smoked some third class weed.

I am done for today.

I hate Postgre. Given a chance I'll never use it again. I'll use MySQL instead!

It’s PostgreSQL!!!! not PostGreSQL, not postgressql, not postgre not postgre_sql!!!

Tell me if that has happened to you!!

Elixir, Phoenix, PostgreSQL, GraphQL, ReactJS and Redux.

Anything missing on this stack to be perfect? 🤔

PS: sorry the the question is too generic and with very broad boundaries.
PPS: Pls don't mention integration problems?

Ques: I wish to know what kind of software related problems do you devs face/faced in your work,

Say like you were working in version 9.2 postgre and in the end you realised it had to be 9.6 and get doomed or like the bot deployed created it's own error?

PPPS: It would be lovely if you could classify in what category or stage of pipeline does it belong to.

Thanks!!☺️