Tootfinder

Opt-in global Mastodon full text search. Join the index!

@cwensel@fosstodon.org
2026-09-17 00:04:22

Hey all
We have a new retrofit demo to share:
retrofit.sh/demos/manually-tes
Imagine your team has been using retrofit for the past couple weeks and now every branch to be reviewed has a schema change that will require a migration in pr…

Review schema-change branches against a production snapshot without reloading it · retrofit
Three branches, one snapshot of a production PostgreSQL database. See make db-up put each branch's schema change on the snapshot from its own dump, make db-down take it back off, a branch that drops a column refused before anything runs, and the clean branches merged with the snapshot following main.

@cwensel@fosstodon.org
2026-09-02 23:54:33

It’s Wednesday, and we’ve got a new demo.
retrofit.sh/demos/pull-and-syn
In the demo we simulate a standard developer flow.

Keep a local PostgreSQL database in sync with the operation log · retrofit
See Retrofit identify which cut a local PostgreSQL database is at from a pg_dump, gate make run on the head of the operation log, migrate the database forward after a git pull, and capture a change made by hand into the log.

@cwensel@fosstodon.org
2026-09-30 17:18:49

Hey all
Finally, I think we landed on a great design with handling both reference (and seed) data in retrofit.
This week we demo managing reference data as part of the schema. Reference data is the data that apps only read, and never write, like zip codes and states. This includes data that might change slowly over time, like an order status label, or even currencies.
…

Manage PostgreSQL reference data with the schema · retrofit
Capture a PostgreSQL lookup table's rows from pg_dump into a data file pinned to the operation log, retire the .sql side file that held them, rename the table and its column, and see a hand edit to the witnessed data file fail validation.

@cwensel@fosstodon.org
2026-09-09 22:32:37

Check out our latest retrofit demo:
retrofit.sh/demos/liquibase-ad
This week we inject retrofit into a Liquibase user flow. Retrofit captures the current schema rendered by Liquibase and then authors forward and rollback migration scripts to be run b…

Use Retrofit with an existing Liquibase project · retrofit
See Retrofit import Metabase's Liquibase-built PostgreSQL schema, identify which version it is at, render a staged foreign key's forward and rollback SQL from one operation log, and have Liquibase deploy and roll back both.

@piger@mastodon.social
2026-10-09 18:04:35

so postgresql is supposed to be the better database, and I'm trying to upgrade an installation and this is all very delirious?

@cwensel@fosstodon.org
2026-10-07 17:47:20

Continuing from last week's demo on reference data, this week we show off how we handle seed data.
#llm

Initialize a PostgreSQL development or test database from labelled datasets · retrofit
Capture baseline seed data from pg_dump into data files under a label, start a postgres container from one rendered SQL file, and layer a fixture for one regression over the baseline by naming both labels.

@piger@mastodon.social
2026-10-09 18:04:35

so postgresql is supposed to be the better database, and I'm trying to upgrade an installation and this is all very delirious?

@cwensel@fosstodon.org
2026-08-26 18:10:49

Progress on my new open source project retrofit continues.
As we work to getting a stable release I’d be happy for others to kick around, we’ve decided to make Wednesdays demo day.
So do please check out our new demo:
retrofit.sh/demos/flyway-adopt<…

Use Retrofit with new or existing Flyway projects · retrofit
See Retrofit import Marquez's mature PostgreSQL schema, add and validate a foreign key between existing tables, and register the generated SQL with Flyway.