Database articles by our experts

Apr 27, 2018

Triggering SOLR to Remove Records Already Deleted from the Database

When you’re using Solr, sometimes the search can index records that have already been removed from your database - causing some frustration. Here’s how to remove these hanging records from Solr so you have a clean search again.

Read more

Mar 9, 2018

How To: Zero-Downtime Database Upgrade on Heroku

Learn how to upgrade your Heroku database easily and with the quickest downtime. We walk you through the exact steps needs to roll over your PostgreSQL database in this quick read.

Read more

Mar 2, 2018

How to Automatically Schedule Your Dokku Database Backups

The first rule of software is that you need to create and store database backups from time to time. This is also the case when using Dokku with PostgreSQL for hosting your apps. To automate the process and make it easier, it’s best to schedule your backups automatically, encrypt them and send to your AWS S3. We provide the know how in our step-by-step explanation.

Read more

Jan 12, 2018

Intro to Arel: The Database Agnostic SQL Abstract Syntax Tree for Ruby

Those in the know use Arel as a clever SQL AST manager for Ruby. It makes SQL queries easy to read, reliable, and secure - and it’s database agnostic. Learn the basics of Arel right here in our mini-tutorial.

Read more

Mar 3, 2017

Partial unique indexes in PostgreSQL and Rails

Working correctly with database indexes is always the key to application performance and reliability. Especially when the amount of data grows rapidly, well designed database architecture really pays off. However, when we’re working with database indexes, it can be easy to miss something, or fall into the trap of a tricky outlying case. One of these is when performing unique indexing on multiple columns, where at least one of them is null.

Read more