Creating Raw SQL Migrations in Django
I am using Django, which has great support for PostgreSQL-specific functions in it’s ORM. I wanted to use a SearchVectorField inside my application and PostgreSQL recommends creating a trigger for to populate that column. Well that was easy enough but I ...
Configure Jenkins to dynamically create a database for your Grails tests
Test pollution can be a frustrating issue to look into, especially when the failures are sporadic. These may be caused by reliance on hard-coded fields (such as ids), timezone/DST issues, or previous test case leakage ...
Conquering With CLOBs
Introduction Today’s web-based applications can freely pass around large amounts of data formatted in XML and JSON. Businesses often want to hang on to and analyze even the most obscure pieces of information, either for ...
Simpler Stored Procedures with Groovy
Using Groovy almost makes calling Stored Procedures an enjoyable process. More like a less painful adventure. But since many large enterprises have thousands of stored procedures lying around, at least we can make calling them ...
Using MyBatis Annotations with Spring 3.0 and Maven
I had a difficult time trying to figure out how to use MyBatis annotations for my project. The examples I found would answer a portion of what I was looking for, but never actually answered what I was looking for. Eventually I found ways to make it work for what I was trying to do. Here are some examples on how to use MyBatis Annotations with Select, SelectProvider, SQLBuilder, and SelectBuilder. ...