Build Scalable Multi‑Tenant SQL Server Pools in Go with GORM Optimizations

This guide details a complete solution for building multi‑tenant SQL Server connection pools in Go microservices, covering YAML tenant configuration, a thread‑safe pool factory, Gin middleware integration, advanced GORM query techniques, high‑concurrency optimizations, monitoring, slow‑query logging, and circuit‑breaker safeguards.

Connection PoolGORMGolang

0 likes · 8 min read

Build Scalable Multi‑Tenant SQL Server Pools in Go with GORM Optimizations

dbaplus Community

Mar 22, 2023 · Databases

Scaling an Airline Ticket Order Database: From Monolith to 64‑Shard Sharding

The article details how a rapidly growing airline ticket order system was re‑architected by identifying performance bottlenecks, applying vertical and horizontal sharding, optimizing cache layers, implementing dual‑write mechanisms, and planning a phased migration to achieve ten‑fold QPS growth while reducing resource usage and operational risk.

Distributed SystemsDual Writecache optimization

0 likes · 38 min read

Scaling an Airline Ticket Order Database: From Monolith to 64‑Shard Sharding

Python Programming Learning Circle

Oct 24, 2022 · Backend Development

Python Tutorial: Connecting to SQL Server with pymssql and Building a Tkinter UI

This guide walks through setting up a Python 3.8 environment, configuring SQL Server authentication, installing pymssql and ttkbootstrap, and running a Tkinter‑based application via command line or Visual Studio, complete with screenshots and a QR code for additional Python learning resources.

Backendpymssqlsqlserver

0 likes · 4 min read

Python Tutorial: Connecting to SQL Server with pymssql and Building a Tkinter UI

Aikesheng Open Source Community

Jan 28, 2022 · Databases

SQLE 1.2201.0 Release Notes

The SQLE 1.2201.0 release introduces workflow optimizations, new MySQL and SQL Server audit rules, enhanced pre‑check capabilities, several UI improvements, and numerous bug fixes, while providing links to the source repository, documentation, and plugin development guide.

ReleaseNotesSQLEaudit

0 likes · 5 min read

The Dominant Programmer

May 28, 2021 · Backend Development

Integrating Spring Boot with a Capture System to Query Violation Data and Preview Photos

This guide explains how to configure a Spring Boot application with MySQL and SQL Server data sources, use Nginx to expose capture‑server images as URLs, and implement Vue components for on‑demand photo preview of traffic‑violation records.

IntegrationNginxSpring Boot

0 likes · 3 min read

Integrating Spring Boot with a Capture System to Query Violation Data and Preview Photos

Qunar Tech Salon

Sep 28, 2016 · Databases

Ctrip DAL: An Open‑Source Database Access Framework for Scalable Enterprise Development

The article introduces Ctrip DAL, an open‑source Java/C# database access framework that supports sharding across MySQL and SQL Server, provides a code generator and client library, and helps large enterprises manage multi‑team, multi‑database environments while ensuring scalability, consistency, and security.

CtripDALc++

0 likes · 5 min read

Ctrip DAL: An Open‑Source Database Access Framework for Scalable Enterprise Development