Tag

SQL review

1 views collected around this technical thread.

DevOps Cloud Academy
DevOps Cloud Academy
Dec 6, 2023 · Databases

Implementing a Complete Azure DevOps Database CI/CD Workflow with Bytebase

This article demonstrates how to set up a full database CI/CD pipeline on Azure DevOps using Bytebase, covering Docker deployment, ngrok configuration, GitOps integration, SQL review automation, approval processes, schema write‑back, and migration detection, with step‑by‑step instructions and code examples.

Azure DevOpsBytebaseDatabase CI/CD
0 likes · 11 min read
Implementing a Complete Azure DevOps Database CI/CD Workflow with Bytebase
DevOps Cloud Academy
DevOps Cloud Academy
Apr 25, 2023 · Databases

Using Bytebase Cloud for GitOps‑Based SQL Review: A Step‑by‑Step Guide

This guide walks through registering Bytebase Cloud, configuring GitOps for database SQL review with GitLab, testing the workflow, and examining the CI/CD script that automatically reviews SQL changes, while also discussing practical considerations and feedback from the experience.

BytebaseDatabaseGitLab
0 likes · 7 min read
Using Bytebase Cloud for GitOps‑Based SQL Review: A Step‑by‑Step Guide
DevOps Cloud Academy
DevOps Cloud Academy
Dec 1, 2022 · Databases

Integrating Bytebase SQL Review into GitHub and GitLab CI/CD Pipelines

This article provides a step‑by‑step guide to seamlessly integrate Bytebase’s SQL review feature into GitHub and GitLab CI/CD pipelines, covering prerequisite setup, configuring the SQL review CI, and verifying automatic SQL script checks on merge requests.

BytebaseDatabase AutomationGitHub
0 likes · 4 min read
Integrating Bytebase SQL Review into GitHub and GitLab CI/CD Pipelines
Aikesheng Open Source Community
Aikesheng Open Source Community
May 16, 2022 · Databases

Creating a PostgreSQL Audit Plugin for SQLE: Step‑by‑Step Guide

This tutorial walks through building a PostgreSQL audit plugin for the SQLE platform using Go, covering project setup, minimal plugin code, adding a SELECT‑star prohibition rule, and implementing a configurable rule that limits table column counts, complete with deployment and testing instructions.

Audit PluginDatabaseGo
0 likes · 11 min read
Creating a PostgreSQL Audit Plugin for SQLE: Step‑by‑Step Guide
Qunar Tech Salon
Qunar Tech Salon
Aug 24, 2018 · Databases

Building an Automated Database Operations Platform: From Monitoring to Multi‑Active Deployment

The article describes how a DBA team at Ele.me transformed manual database management into a fully automated, platform‑driven operation covering monitoring, alarm handling, MHA automation, resource pooling, large‑scale migration, SQL review, and multi‑active DDL release using Go‑based tools and custom workflows.

DBA toolsDatabase AutomationGo
0 likes · 20 min read
Building an Automated Database Operations Platform: From Monitoring to Multi‑Active Deployment
Efficient Ops
Efficient Ops
Aug 13, 2018 · Databases

How NetEase Scaled DBA Automation: From Manual Ops to Self‑Service Platforms

From 2015 to now, NetEase’s DBA team transformed from manual maintenance to a fully automated, platform‑driven system that supports multi‑active database architectures, real‑time monitoring, automated alarm handling, MHA management, resource pooling, rapid migration, and self‑service SQL review, dramatically reducing downtime and operational overhead.

DBA automationMHA managementReal-time Monitoring
0 likes · 21 min read
How NetEase Scaled DBA Automation: From Manual Ops to Self‑Service Platforms
Qunar Tech Salon
Qunar Tech Salon
Sep 8, 2016 · Databases

Design Principles and Implementation of Inception – A MySQL SQL Review and Automation Tool

The article explains the design motivations, architectural choices, and implementation details of Inception, a MySQL‑compatible SQL review and execution platform that follows programmers' habits, prevents common human errors, fully supports MySQL syntax, and integrates audit, backup, and rollback capabilities.

Backup and rollbackDatabase AutomationInception
0 likes · 5 min read
Design Principles and Implementation of Inception – A MySQL SQL Review and Automation Tool