Defensive programming should be done like a process. Start with all the checks in your code and finally move the checks to a centralized place so that you have reliable exit.

For example, I would had a stored procedure for validating the data.

Or I would have made the smartest decision of using Postgres and live happily there after.