SQL Articles
A minor shift in mindset that improved my SQL
I am currently working on a project that involves writing stored functions in PostgreSQL. Typically the goal is one SQL query that returns all the data needed by a particular web page. At first I approached this from an Object Oriented perspective with a focus on minimizing redundant data. This led me down the path […]
Oracle Wallets and You … No, Not You, Behind You. Yeah, You.
Oracle databases are a complex system of interconnected parts. The toolset is comprehensive and robust. And so is the documentation. Possibly too robust, even. I have spent the last couple of days researching how to do One Specific Thing, while the documentation has delighted in telling me All the Things That Can Be Done. And […]