sql-file
pgmigrate
sql-file | pgmigrate | |
---|---|---|
2 | 1 | |
1 | 58 | |
- | - | |
7.0 | 2.6 | |
4 months ago | 4 months ago | |
Clojure | JavaScript | |
Apache License 2.0 | - |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
sql-file
-
Screw DSLs. Write migrations using plain SQL
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.)
-
Ask HN: Do you Self-host your database?
For personal stuff, I tend to keep it about as simple as possible with an HSQLDB instance hosted in-process. (All JVM/Clojure)
I use a small library that encapsulates the use-case (including some schema migration stuff that should probably be replaced with flyway).
https://github.com/mschaef/sql-file
There's a lot that can be said about this approach, both for and against, but I find that it brings a lot of power, is easy to set up, and generally stays out of the way. Given that the fundamental abstraction presented to user code is essentially SQL with connection pooling, there are also good escape strategies to get to architectures that would support however much capacity I'm ever likely to need.
pgmigrate
What are some alternatives?
docker-sqitch-pgtap - Run sqitch and pgTAP for PostgreSQL without installing them from docker
Flyway - Flyway by Redgate • Database Migrations Made Easy.
dbmate - :rocket: A lightweight, framework-agnostic database migration tool.
migrate - Database migrations. CLI and Golang library.