Screw DSLs. Write migrations using plain SQL

• pgmigrate

  1 58 2.6 JavaScript
  

• Flyway

  81 7,786 7.2 Java

  Flyway by Redgate • Database Migrations Made Easy.

  

• InfluxDB

  www.influxdata.com featured

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• sql-file

  2 1 7.0 Clojure

  Utility package for managing embedded hsqldb databases

Several years ago, I wrote something similar for Clojure, as part of a way to make it super simple to put a SQL database behind a Clojure all. Essential goal was for close to single jar file deployment.

https://github.com/mschaef/sql-file

Doesn’t get a lot of use aside from a few small things I use it for, but has been nice to have around.

(This was before I knew of Flyway…. These days I might just link to that for the migration part.)

• dbmate

  25 4,378 8.1 Go

  :rocket: A lightweight, framework-agnostic database migration tool.

• migrate

  72 14,062 8.0 Go

  Database migrations. CLI and Golang library.

  

• docker-sqitch-pgtap

  1 4 7.4 Shell

  Run sqitch and pgTAP for PostgreSQL without installing them from docker

  

I use sqitch quite heavily on one of our projects, and miss it on the one where we use Ecto migrations with Elixir (although, for in-built migration functionality, Ecto migrations are very good).

Installing sqitch and pgTAP (a unit testing framework for PostgreSQL) has always been a pain, so I ended up making a docker image that we now use at work: https://github.com/kineticcafe/docker-sqitch-pgtap

Suggest a related project