Hey, any Python experts want to help a Python newbie out? I've been hacking for decades, but I can't say I know Python best practices.

I'm working on https://github.com/Ovid/sqlitch-v2 (porting some Perl code to Python) and while it seems good to me (but very much alpha and a WIP), I don't know what I don't know. If there's anything obvious I've missed or is unpythonic, I would love to know.

#Python #Perl

@ovid But… why? Is this to improve adoption by Perl-adverse shops? I use the dockerized version for several projects and no one bats an eye.

@cromedome Not happy about this, but:

* The company bans Perl in its tech stack.
* If they switch away from their currently broken tooling, they want something they can maintain and extend.
* I'm working with 200+ devs, many of them newer, and they don't want to use CLI tools. It's trivial for me to extend this new tool with a GUI.

I'm not saying these are great reasons, but that's the pushback.

@ovid “Don’t want to use CLI tools”? Eww. But the GUI would still be a nice addition.
@ovid Currently feeling some of this pain here. Our private equity overlords have declared we need to remove Perl from the stack, so we are currently rewriting 575k lines of Perl to Python… 😭
@cromedome @ovid wow. Any idea about there reasoning? Is it easier to sell you with a different stack?
This sure sounds like a huge "investment".
@confuseacat @ovid On the surface, because “of Perl’s lack of long term viability, and high cost of hiring Perl developers.” Honestly, I think our PE ownership thinks they can sell us for more if we rewrite, and I think the CTO must get a better bonus if we’re done when that happens. #pessimist
@cromedome @confuseacat @ovid At this point I’d say define long term viability? Like we’re (nearly) as far down the totem as you can get and still dropping annual releases.

@ovid @cromedome Out of interest, what sort of GUI do the command-line-adverse want / will they get? A menu item in VSCode or similar? A button in GitHub and/or their CI website? Something else?

I mean, I think far more people should have said “no, I want to use a proper GUI rather than basically CP/M or MS DOS” 20 years ago, rather than people deciding to carry on using dinosaurs like vi or emacs, but I’m concerned about how you automate this stuff.

@skington @cromedome There weren't specific, beyond hyperventilating at the thought of the command line.

I could try to duplicate UX of Flyway (https://www.red-gate.com/products/flyway/), but at the core level, their database management is so poorly designed that I want to step back and rethink. Will have a play with interfaces later.

Redgate Flyway - Automate database deployments across teams and technologies - Redgate Software

From version control to continuous delivery, Redgate Flyway helps individuals, teams, and enterprises build on application delivery processes to automate database development.