Current status: creating a web interface for the excellent database change management system, sqitch. https://sqitch.org/

Sadly, I don't have as much time to write software in my current role, so this is a nice distraction for my limited free time.

#Perl #Sqitch #Database

Guiding 200+ devs across various teams to fix their dev processes. None have database change management which let's them automatically revert a change. So I suggested the excellent, free, open-source #sqitch https://sqitch.org/.

But it's a CLI tool and younger devs hyperventilate. So I looked at building a #VSCode extension for it. Not too hard.

Some devs use #IntelliJ. After some discussion, #Gemini suggested it would be easier to just have them use the command line 🫠

Should URI::mysql Switch to DBD::MariaDB?

https://justatheory.com/2025/01/uri-mysql-mariadb/

#perl #sqitch #mysql #mariadb

Fun bit of discussion about my database change management app, Sqitch, in this HN thread about Pgroll.

https://news.ycombinator.com/item?id=42388973

#Sqitch #Pgroll

How do the people that provision new releases with nixos-rebuild integrate their deploy with #sqitch ? A one-shot systemd unit? Do y'all use a different database migration tool?
#nix

I've also written functions like `get_pk_from_slug` which allows you to write `get_pk_from_slug('character', 'ovid')` for https://taustation.space/ and you get the `character_id` value.

We only use that in our database migration code (via #sqitch https://sqitch.org/) and not in our production code, but it makes database migrations much easier to write, even if they're a touch slower to run.

If any of you use the excellent #sqitch (https://sqitch.org/) tool for database change management, I wrote this tool a couple of years ago. It adds a `sqitch grep` command that shows you the matching sqitch changes in the order they were added.

This makes it *much* easier to follow the order in which changes happened in your database.

#perl

https://gist.github.com/Ovid/fd8ba5b758f86b02f1c5f2a0a75c88f4

#Sqitch
PostgreSQL で使うのに役立ちそうなスライド
https://wiki.postgresql.org/images/b/bd/Sqitch-PgDay-FOSDEM2013.pdf

@cimi You can look at #Sqitch, it's not restricted to #PostreSQL

“Sqitch is a database change management application. It currently supports #PostgreSQL 8.4+, #SQLite 3.7.11+, #MySQL 5.0+, #Oracle 10g+, #Firebird 2.0+, #Vertica 6.0+ and #Exasol 6.0+.”

https://github.com/theory/sqitch