Getting Your DBA Teams Scripts into Git

[robertkoss]

Call me ignorant but I am surprised that there are people in the engineering realm that still don't use a VCS for everything.

[way0utwest]

In the world I work in, which is lots of DBAs/sysadmins/db developers, lots don't do anything with VCS when working in databases.

To be fair, lots of developers who make/need database changes still email those to DBAs/sysadmins.

[tichiian]

I've gotten surprised gasps for the use of etckeeper.

"you can actually do that?" "why didn't anyone tell me?" etc.

[Cthulhu_]

To some, VCS is still a novel invention.

[guruparan18]

A bit surprised to see there is no mention of Liquibase, Flyway or others. Not to mention there is also "https://www.dolthub.com/". This was just for git.

[way0utwest]

I work for the company that owns/developers Flyway, so I didn't include it in here.

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.

[sea-gold]

There is also Bytebase[1].

[1] https://github.com/bytebase/bytebase

[amne]

going off of "devops are sysadmin that push their scripts to git" I think we can now call DBAs DbOps. I pronounce it like "deebops".

[d-trieu]

I thought they were called Data Engineers nowadays

[pjmlp]

Well done for knowledge sharing.

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.

[way0utwest]

Thank you (it's my piece)

[albertopv]

I'll send it to a DBA colleague that is truly struggling with this XD

[len881]

Neat! Very intersting

[fnord123]

I've never seen so many screenshots for a git tutorial. Are windows users ok?

[hobs]

Generally the word DBA has a pretty broad meaning - and one of them is that you were a click admin that got hoisted into being responsible for your database servers, and things like software engineering tools (git, shell scripting in general) are a few years off.

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

[okasaki]

Have you ever seen a book about a Windows app? 1200 pages, 1000 of them screenshots.

An insane way to do computing.

[shortrounddev2]

It's a very old way to use git, too. There's a CLI client for windows which doesn't require the old git bash program or mingw. You can install it via widget, scoop, or chocolatey and run it in windows terminal

[way0utwest]

It's that lots of db people don't understand anything about VCS period. They don't use them. (it's my piece)

[hnrodey]

letting Git, get you down?

Mental Models I Rely On To Beat Git: https://www.youtube.com/watch?v=sm2x7xWQID4&t=7s

note: this is my video