200th Episode Extravaganza!

Development Tips

Michael Outlaw shares insights on database development, emphasizing the challenges faced when transitioning from an object-oriented background. He highlights the difficulty in adapting to database routines, which often result in large stored procedures. Outlaw recounts his experience with DataGrip, where error messages were initially unhelpful due to their vague nature.

I had no idea what position that it was referring to. You know what I didn't notice at first though was that the data grip was automatically putting the cursor where the error was.

--- Michael Outlaw

He eventually discovered that DataGrip automatically positions the cursor at the error location, a feature he had overlooked 1 2 3.

   

SQL Syntax

The hosts discuss the nuances of SQL, particularly the importance of understanding syntax differences between SQL Server and PostgreSQL. Michael Outlaw shares his habit of starting CTEs with a semicolon, a practice from his SQL Server days that caused issues in PostgreSQL.

SQL Server isn't as specific about semicolons that postgres is.

--- Michael Outlaw

Joe Zack and Allen Underwood join the conversation, highlighting the need for developers to adapt to different SQL environments and the importance of recognizing subtle syntax requirements 4 5 1.