Curtis "Ovid" Poe (he/him)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.
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 🫠
David WheelerShould URI::mysql Switch to DBD::MariaDB?
Fun bit of discussion about my database change management app, Sqitch, in this HN thread about Pgroll.
PuercoPopI'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.
https://gist.github.com/Ovid/fd8ba5b758f86b02f1c5f2a0a75c88f4
きゅーけー#Sqitch
PostgreSQL で使うのに役立ちそうなスライド
https://wiki.postgresql.org/images/b/bd/Sqitch-PgDay-FOSDEM2013.pdf
PostgreSQL で使うのに役立ちそうなスライド
https://wiki.postgresql.org/images/b/bd/Sqitch-PgDay-FOSDEM2013.pdf
Daniel@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+.”