OPI Blog
Learn from experts in their fields

Browsing Tags: database

Jan 16, 2020
Add a custom object to your Liquibase diff
Adding a custom object to your liquibase diff is a pretty simple two step process. Create an implementation of DatabaseObject Create an implementation of SnapshotGenerator In my case I wanted to add tracking of Stored ...
Liquibase and Spring Boot
I think it’s great that Spring Boot has built-in support for Liquibase but I think there is missing documentation on it. Some of it is on Spring’s part and others are in Liquibase. I hope ...
Sep 22, 2017
Getting XML Directly from PostgreSQL
There was a discussion on our company Slack recently about databases and XML, and someone pointed out that PostgreSQL has some nice XML functions. I’m a Postgres fan and knew that it had some XML ...
Jun 21, 2017
Database Migrations in Flyway
The concept of data migrations has been around for a long time and in the past, they have been projects that are separated from the main project, mostly with SQL script to change the tables, ...
Using secondary datasources in Grails 3
Something changed in Grails 3 and how datasources are configured. If you have datasources defined like this: dataSources: dataSource: pooled: true jmxExport: true driverClassName: org.h2.Driver username: sa password: dbCreate: create-drop url: jdbc:h2:mem:devDb;MVCC=TRUE;LOCK_TIMEOUT=10000;DB_CLOSE_ON_EXIT=FALSE secondary: pooled: true ...
Relational data management with Lovefield
When writing a new JavaScript application I often find that the hardest part isn’t the UI or functionality but rather accessing and managing data. Storing dozens of arrays of dynamically-typed objects in memory and iterating across them hundreds of times ...
Getting Grails Database Connections to Reconnect
Where I work, a bunch of the Grails have many, many datasources. One app in particular I was brought in on because it was dropping a bunch of connections on Saturday night or Sunday morning. ...