OPI Blog
Learn from experts in their fields

Browsing Tags: sql

Jan 24, 2019
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 ...
Dec 22, 2015
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 ...
Jun 16, 2015
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 ...
Jan 24, 2014
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. ...