I always impresses me, how many don't understand how to manage their SQL scripts, packages and stored procedures in SCM systems, when this was already a common product from SQL vendors in the 1990's.
The number of databases I have seen out of source control is too many to count, the number of times I had people who understood SQL very well but couldn't use git worth a damn. Some of them have been modifying the top of the file of a stored procedure for decades
2024-01-01 hobs - changed even more shit
2023-07-24 hobs - minor tweaks
2001-02-04 hobs - created
-- MODIFIED (MM/DD/YYYY)
-- mhichwa 08/04/1999 - Created
-- mhichwa 09/30/1999 - Removed g_show_reset global
-- mhichwa 10/09/1999 - Added g_last_query_text global for error reporting
-- mhichwa 10/09/1999 - Removed g_success_procedure, g_success_url
-- mhichwa 10/09/1999 - Removed g_step_sub_title_font_color --
-- mhichwa 10/14/1999 - Added 10 extra inputs v26 ... v35
An insane way to do computing.
true, you need some screenshots to teach someone a new trick
but then when they've done it once they'll remember it because GUIs really help for that kind of stuff
whereas for command line you'll have to google it every single time for the rest of your life unless its something you do regularly
Which the GUI paradigm has no built in equivalent to
It is a little better on MacOS with AppleScript, which can be used to bind different applications together. But not all of them, and it is far from ideal.
In the end, nothing of this is command-line equivalent.
Btw, if you want to see a GUI application that can do really really good macros, learn Blender! E.g. you can bind any button and knob to keyframes to change them in animations. That would be the level of macro-integration required to be CLI-like...
Some people cultivate aspects of both skillsets of course and data engineers often end up doing DBA functions in point B (where analytical data is stored) while DBAs manage point A (OLTP source systems)
Mental Models I Rely On To Beat Git: https://www.youtube.com/watch?v=sm2x7xWQID4&t=7s
note: this is my video
"you can actually do that?" "why didn't anyone tell me?" etc.
To be fair, lots of developers who make/need database changes still email those to DBAs/sysadmins.
However, for DBAs, they often are doing ad hoc stuff and there is a bit of overhead for FW/LB that they may not want. This is part of a series, just getting people comfortable with tracking their work.