数据库应用开发 CI_CD [HOL2808].pdf

《数据库应用开发 CI_CD [HOL2808].pdf》由会员分享，可在线阅读，更多相关《数据库应用开发 CI_CD [HOL2808].pdf（24页珍藏版）》请在三个皮匠报告上搜索。

1、Database CI/CD Project Automation for a React JS ApplicationGet to know SQLcl ProjectsJeff Smith|Chris HoinaDistinguished Product Manager|Senior Product Manager Database Tools October 2025IntroductionWhat is it?The SQLcl Projects CI/CD workflow brings automation,consistency,and reliability to databa

2、se management.Add database version control to your existing application projects to streamline complete CI/CD workflows.2The HR applicationObjectivesUpdate an existing application and its associated database objectsDeploy the changes to the production databaseAddress the difficulties of synching wit

3、h DEV database instancesUse SQLcl project command to manage your database changesUse version control for database development with SQLcl ProjectsSQLcl Projects is:Git+LiquibaseSQLcl Projects,in a nutshell3LiquibaseGitSQLcl ProjectsGet Started Start as dev_user Initialize Git(no experience required)L

4、ight editing of.env file 4Important lab detailsOpen AI World 2025 Lab 1 Intro to SQLcl Projects Create 1st version Deploy changes to Production(no app updates yet!)Lab 2 Changes to Dev env New version+artifact(Projects)Relaunch app in ProdLab 3 Practical example of lb-changelog-syntax vs lb-update R

5、EST enable Departments REST enable Employees Get Started 5SQL Developer Web/SQL Worksheet You will have two primary URLs SQL Developer Web Jupyter Lab Auto-REST-enabling the DEV_USERs pre-existing table You will also have a PROD_USER(which is the focus later in the workshop)6Jupyter Lab/Application

6、set-up Exploring the React applications source code Workshops are located at assets/assets/workshops/Or workshop is/sqlcl-projects-react-app Configuring the environment with your labs unique settings Remember,the dev_user(and later prod_user)user names should be lower case.These are both required fo