home.social

#sqitch — Public Fediverse posts

Live and recent posts from across the Fediverse tagged #sqitch, aggregated by home.social.

fetched live
  1. PuercoPop @[email protected] ·

    After installing #sqitch from cpan, I found that #emacs's M-x man wasn't finding some pages that man was finding. The pages in question where placed in $HOME/perl5/man. It seems that if MANPATH is not set, man tries to guess the directories to look in from your $PATH.

    gitlab.com/man-db/man-db/-/blo

    #sqitch #emacs
  2. Curtis "Ovid" Poe (he/him) @ovid ·

    Current status: creating a web interface for the excellent database change management system, sqitch. 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
  3. Curtis "Ovid" Poe (he/him) @ovid ·

    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.org/.

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

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

    #sqitch #vscode #intellij #gemini
  4. David Wheeler @[email protected] ·

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

    justatheory.com/2025/01/uri-my

    #perl #sqitch #mysql #mariadb

    #perl #sqitch #mysql #mariadb
  5. David Wheeler @[email protected] ·

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

    news.ycombinator.com/item?id=4

    #Sqitch #Pgroll

    #sqitch #pgroll
  6. PuercoPop @[email protected] ·

    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

    #sqitch #nix
  7. Curtis "Ovid" Poe (he/him) @ovid ·

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

    We only use that in our database migration code (via 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.

    #sqitch
  8. Curtis "Ovid" Poe (he/him) @ovid ·

    If any of you use the excellent (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.

    gist.github.com/Ovid/fd8ba5b75

    #sqitch #perl