How to Use GitHub to Update a Database Automatically

preview_player
Показать описание

Deploying application code automatically is one thing, but did you know it's possible to automatically deploy changes to a database?

In this video, I'll introduce you to the concept of making database changes, and show you how to use GitHub Actions to read an SQL script that we create on our local database and run that same SQL script on a remote database.

Let me know in the comments below what questions, comments, or issues you have with this process and this video!

⏱ TIMESTAMPS:
00:00 - What we are doing
01:13 - Create a database
02:36 - Check in our script
04:51 - Create a YML file
08:39 - View GitHub Actions
10:13 - Update YML to connect to the database
14:37 - See the updated action
15:43 - Update YML to run SQL script
17:56 - Update SQL file

🔗 VIDEO LINKS:
  1. Database Star
  2. github actions
  3. github actions tutorial
  4. sql github
  5. database deployment
  6. github database
Рекомендации по теме
GitHub Tutorial - 0:08:11

GitHub Tutorial - Beginner's Training Guide

How to Use 0:13:04

How to Use GitHub

How to Use 0:05:50

How to Use GitHub for Beginners

GitHub Basics Made 0:23:30

GitHub Basics Made Easy: A Fast Beginner's Tutorial!

Git and GitHub 0:46:19

Git and GitHub Tutorial for Beginners

Git It? How 0:12:19

Git It? How to use Git and Github

GitHub Basics Tutorial 0:31:20

GitHub Basics Tutorial - How to Use GitHub

How to use 0:31:17

How to use GitHub | What is GitHub | Git and GitHub Tutorial | DevOps Training | Edureka

Learn Live: Automate 0:56:42

Learn Live: Automate your repository using GitHub Actions

What is GitHub? 0:02:43

What is GitHub?

Git, GitHub, & 0:22:16

Git, GitHub, & GitHub Desktop for beginners

Learn how to 0:23:09

Learn how to use GitHub for Beginners | GitHub Tutorial

What Is GitHub? 0:07:46

What Is GitHub? | What Is Git And How To Use It? | GitHub Tutorial For Beginners | Simplilearn

How to upload 0:04:31

How to upload project on github | Github Tutorial - How to use Github

Git and GitHub 1:08:30

Git and GitHub for Beginners - Crash Course

Use Other People's 0:12:57

Use Other People's Code on GitHub in 15 Min (THE EASY WAY)

How to use 0:07:27

How to use GitHub with Unity

Learn Github in 0:20:00

Learn Github in 20 Minutes

What Is GitHub 0:12:02

What Is GitHub | How To Use Github| Git & Github |Intellipaat

What is GitHub 0:07:21

What is GitHub | how to use it | benefits of GitHub

How to Use 0:11:04

How to Use GitHub

Git Tutorial for 0:43:06

Git Tutorial for Beginners - Git & GitHub Fundamentals In Depth

How To Use 0:06:05

How To Use GitHub + VSCode: Create a Repository & Merge Changes With a Pull Request

Host website on 0:02:23

Host website on github for free in just 2 mins

Комментарии
Автор

Not specifically doing anything wrong, but it can definitely be risky migrating production schema like that if you don’t exactly know what you’re doing ensuring that it’s backwards compatible.

Just got in love with planetscale’s branching and schema deploy request 🥰

Alternatively there are tools you can use instead of planetscale like gh-ost (which Planetscale uses under the hood)

CanRau
Автор

Hello, what if I have multiple .sql file in that case if we just pass the folder will it run all the sql file in database

saketshetty
Автор

Hey I hope you are doing great.

I have been following the same codes and all but I keep on getting this error and been exploring the options on google but haven't got a solution.

Error: -
ERROR 2003 (HY000): Can't connect to MySQL server on '***:3306' (110)
Error: Process completed with exit code 1

What exactly wrong am I doing here? Also, I am using google cloud sql instance for mysql workbench and trying to set up a connection in the same way as you mentioned in your video.

Please help me with this. Your efforts will be highly appreciated. Thanks

satyndragautam
Автор

iam using Entity Framework Migration and i get an error in line 15 😥 could i get help please

bebehzad