BestHub
Sign in
Tagged articles
625 articles
Page 3 of 7
Java Architect Essentials
Java Architect Essentials
Jul 3, 2023 · Fundamentals

2023 Stack Overflow Developer Survey: Trends in Programming Languages, Databases, Web Frameworks, and AI Tools

The 2023 Stack Overflow Developer Survey, with over 90,000 respondents, reveals the most popular programming languages, highest‑earning languages, leading databases, preferred web frameworks, and the most trusted AI tools, highlighting how developers worldwide are adopting new technologies and AI assistance.

AI toolsStack Overflow SurveyWeb Frameworks
0 likes · 6 min read
2023 Stack Overflow Developer Survey: Trends in Programming Languages, Databases, Web Frameworks, and AI Tools
macrozheng
macrozheng
Jul 2, 2023 · Fundamentals

2023 Stack Overflow Survey: Top Languages, Databases & AI Tools Unveiled

The 2023 Stack Overflow Developer Survey of over 90,000 participants reveals the most popular programming languages, highest‑paying language, leading databases, favored web frameworks, dominant IDE, and the hottest AI search and development tools, along with developers' trust and future expectations for AI.

2023 trendsAI toolsdatabases
0 likes · 7 min read
2023 Stack Overflow Survey: Top Languages, Databases & AI Tools Unveiled
Java High-Performance Architecture
Java High-Performance Architecture
Jul 1, 2023 · Fundamentals

2023 Stack Overflow Survey: Top Languages, Databases & AI Tools Uncovered

Based on responses from over 90,000 developers, the 2023 Stack Overflow Survey highlights JavaScript’s continued dominance, Zig as the highest‑earning language, PostgreSQL overtaking MySQL, Node.js and React leading web technologies, Visual Studio Code’s growing popularity, and ChatGPT’s prevalence as the top AI search tool.

AI toolsdatabasesdeveloper survey
0 likes · 7 min read
2023 Stack Overflow Survey: Top Languages, Databases & AI Tools Uncovered
Practical DevOps Architecture
Practical DevOps Architecture
Jun 29, 2023 · Backend Development

Comprehensive Course Outline for Backend Development: Databases, Frameworks, Microservices, Messaging, Collections, and JVM

This article presents a detailed curriculum for backend development, covering fundamental concepts and practical topics such as database design and optimization, popular frameworks like Spring and Hibernate, microservice architecture, message middleware (Redis, RabbitMQ, Kafka), common data structures, concurrency, JVM internals, and related interview questions.

JVMMessagingMicroservices
0 likes · 9 min read
Comprehensive Course Outline for Backend Development: Databases, Frameworks, Microservices, Messaging, Collections, and JVM
Architect's Tech Stack
Architect's Tech Stack
Jun 21, 2023 · Fundamentals

2023 Stack Overflow Developer Survey: Popular Languages, Databases, AI Tools and Trends

The 2023 Stack Overflow Developer Survey, with over 90,000 respondents, reveals JavaScript as the top programming language, PostgreSQL overtaking MySQL as the most popular database, Zig as the highest‑earning language, Node.js and React leading web frameworks, VS Code as the preferred IDE, and ChatGPT and GitHub Copilot dominating AI tool usage, while also highlighting developers' trust levels and future expectations for AI in software development.

AI toolsStack Overflow Surveydatabases
0 likes · 7 min read
2023 Stack Overflow Developer Survey: Popular Languages, Databases, AI Tools and Trends
Wukong Talks Architecture
Wukong Talks Architecture
Jun 20, 2023 · Databases

Evolution of JD Baitiao’s Data Architecture: From MySQL to Apache ShardingSphere

This article chronicles JD Baitiao’s journey from early MySQL and NoSQL solutions through DBRep to the adoption of Apache ShardingSphere, highlighting the technical motivations, decoupling strategies, performance comparisons, and the broader Database Plus vision for scalable, stable financial‑grade data architectures.

ArchitectureBig DataJD Baitiao
0 likes · 14 min read
Evolution of JD Baitiao’s Data Architecture: From MySQL to Apache ShardingSphere
Python Programming Learning Circle
Python Programming Learning Circle
Jun 16, 2023 · Fundamentals

Comprehensive Python Knowledge Summary: Language Differences, Advanced Features, Libraries, Concurrency, Testing, and System Design

This extensive guide compiles Python 2 vs 3 differences, essential built‑in modules, common and advanced libraries, multiprocessing, async programming, testing techniques, networking fundamentals, database and cache concepts, Linux I/O models, design patterns, and algorithm implementations, providing a valuable reference for developers.

AlgorithmsDesign Patternsconcurrency
0 likes · 30 min read
Comprehensive Python Knowledge Summary: Language Differences, Advanced Features, Libraries, Concurrency, Testing, and System Design
Sanyou's Java Diary
Sanyou's Java Diary
Jun 15, 2023 · Databases

Mastering Redis Pub/Sub: Channels, Patterns, and Real-World Use Cases

This article explains Redis Pub/Sub fundamentals, demonstrates channel‑based and pattern‑based subscription with command‑line examples, dives into the internal data structures that power them, and shows how to integrate Redis Pub/Sub in Spring Boot using Redisson for lightweight messaging.

Message Queuedatabasespub/sub
0 likes · 14 min read
Mastering Redis Pub/Sub: Channels, Patterns, and Real-World Use Cases
ITPUB
ITPUB
Jun 15, 2023 · Databases

How Domestic Databases Are Shaping China’s Financial Digital Transformation

Amid China’s push for digital and domestic technology, the article examines the evolution of native database products, the opportunities and challenges they face—especially in the financial sector—and how policy, cloud‑native architectures, distributed systems, and multi‑cloud demands are driving the next wave of innovation.

ChinaDigital TransformationDistributed Systems
0 likes · 10 min read
How Domestic Databases Are Shaping China’s Financial Digital Transformation
JD Retail Technology
JD Retail Technology
May 26, 2023 · Databases

Overview of Database Evolution, Types, and Data Structure Design

This article traces the history of database development from early file systems to relational models, outlines major database categories such as hierarchical, relational, NoSQL, NewSQL, and columnar stores, and explores practical data structure designs like chain tables, bitwise operations, and circular queues for modern software engineering.

Data StructuresHashingNewSQL
0 likes · 28 min read
Overview of Database Evolution, Types, and Data Structure Design
ITPUB
ITPUB
Apr 28, 2023 · Databases

Why Time Series Databases Are Revolutionizing IoT and Industry

This article explains what time series databases are, outlines their key characteristics, traces their evolution from early real‑time databases to modern solutions, and examines current technical innovations and market trends driving their rapid adoption across IoT, finance, and industrial sectors.

AIIoTTime Series
0 likes · 11 min read
Why Time Series Databases Are Revolutionizing IoT and Industry
Efficient Ops
Efficient Ops
Apr 24, 2023 · Databases

Seamless High‑Concurrency Database Migration for Massive Domestic Transformation

This talk outlines the strategic shift toward domestic, high‑performance databases, comparing shared‑everything, shared‑nothing, and shared‑storage architectures, and presents a seven‑step migration framework—including selection, testing, full and incremental sync, application refactoring, dual‑write or middleware switching, and post‑migration observability—to achieve seamless, low‑impact migration of massive, high‑concurrency workloads.

Architecturedatabasesdomestic transformation
0 likes · 17 min read
Seamless High‑Concurrency Database Migration for Massive Domestic Transformation
AntTech
AntTech
Apr 21, 2023 · Databases

Future of Databases in China: Trends, History, and Benchmarking

In a keynote at the first OceanBase Developer Conference, Professor Zhou Aoying outlines the evolution of database technology, its role as a foundational data‑power platform, the importance of benchmarks for distributed databases, and the vision for a unified Data Power Platform in China’s digital economy.

ChinaData PowerOceanBase
0 likes · 11 min read
Future of Databases in China: Trends, History, and Benchmarking
dbaplus Community
dbaplus Community
Apr 19, 2023 · Databases

How to Migrate Large Tables and Sync Data Seamlessly in Production

This article explains common business scenarios such as large‑table splitting, cross‑database migration, and data synchronization, then compares loss‑bearing and loss‑less migration strategies, and provides detailed step‑by‑step implementation guidance for smooth dual‑write migration and real‑world tooling.

Data MigrationDual Writedatabases
0 likes · 17 min read
How to Migrate Large Tables and Sync Data Seamlessly in Production
JD Cloud Developers
JD Cloud Developers
Apr 13, 2023 · Databases

Why Distributed Data Consistency Is Hard and How to Solve It

This article explains why achieving data consistency in modern distributed systems is challenging, reviews ACID properties, CAP and BASE theorems, event ordering, and compares practical solutions such as two‑phase commit, Paxos, local message tables, and cache concurrency strategies.

BASE theoremCAP theoremData Consistency
0 likes · 20 min read
Why Distributed Data Consistency Is Hard and How to Solve It
DataFunSummit
DataFunSummit
Mar 30, 2023 · Artificial Intelligence

An Overview of ChatGPT’s Software Architecture and Technology Stack

The article examines ChatGPT’s underlying software architecture, detailing its cloud deployment on AWS and Azure, database choices like PostgreSQL and Redis, front‑end technologies such as TypeScript and React, core AI frameworks including PyTorch and Triton, as well as its container orchestration, monitoring, and programming language ecosystem.

AI ArchitectureChatGPTFrontend
0 likes · 6 min read
An Overview of ChatGPT’s Software Architecture and Technology Stack
ITPUB
ITPUB
Mar 29, 2023 · Databases

Beyond ACID: A Maslow‑Inspired Hierarchy of Database Needs

Drawing parallels with Maslow’s hierarchy, the article outlines an eight‑level model of database requirements—from core kernel correctness and ACID to advanced observability, automation, and the vision of a truly autonomous database—explaining how each tier maps to functional, security, reliability, ROI, insight, control, and transcendence.

ArchitectureObservabilityPerformance
0 likes · 12 min read
Beyond ACID: A Maslow‑Inspired Hierarchy of Database Needs
IT Services Circle
IT Services Circle
Mar 9, 2023 · Backend Development

Interview Experience and Preparation Guide for Backend Engineer Positions at ByteDance, MiHoYo, Futu, and Yuanfudao

The author shares a detailed recap of interview preparation, processes, technical questions, and personal reflections from recent backend engineering interviews at several top Chinese tech companies, highlighting the importance of solid fundamentals, Go knowledge, and systematic study resources.

BackendCloud NativeGolang
0 likes · 19 min read
Interview Experience and Preparation Guide for Backend Engineer Positions at ByteDance, MiHoYo, Futu, and Yuanfudao
Architects' Tech Alliance
Architects' Tech Alliance
Mar 7, 2023 · Databases

Analysis of Current Trends, Architecture, and Technologies in Chinese Database Products

This article reviews recent Chinese database market reports, outlines the evolution of database management systems, describes architectural layers, HTAP solutions, compression techniques, storage index structures, intelligent governance, and deployment models, highlighting both technical trends and future directions.

Database ArchitectureHTAPcloud deployment
0 likes · 11 min read
Analysis of Current Trends, Architecture, and Technologies in Chinese Database Products
DevOps Operations Practice
DevOps Operations Practice
Feb 28, 2023 · Databases

Understanding Redis: NoSQL Basics, Data Types, Persistence, Replication, Sentinel and Cache Issues

This article provides a comprehensive overview of Redis as a NoSQL in‑memory database, covering its core data structures, special types, transaction model, RDB and AOF persistence, publish/subscribe, master‑slave replication, Sentinel failover, and common cache pitfalls such as penetration, breakdown and avalanche, with practical mitigation strategies.

NoSQLPersistenceReplication
0 likes · 45 min read
Understanding Redis: NoSQL Basics, Data Types, Persistence, Replication, Sentinel and Cache Issues
Big Data Technology Architecture
Big Data Technology Architecture
Feb 15, 2023 · Databases

ClickHouse Usage Guide: Table Engines, Best Practices, and Cluster Architecture

This comprehensive guide introduces ClickHouse as a high‑performance columnar DBMS, outlines its main application scenarios, details the various table engines and their creation syntax, and provides practical development, deployment, and operational recommendations for building reliable ClickHouse clusters.

ClickHouseClusterArchitectureSQLGuidelines
0 likes · 22 min read
ClickHouse Usage Guide: Table Engines, Best Practices, and Cluster Architecture
Code Ape Tech Column
Code Ape Tech Column
Feb 7, 2023 · Backend Development

YouTube Backend Architecture: Databases, Vitess, and Cloud‑Native Infrastructure

This article examines YouTube's massive backend infrastructure, detailing its use of MySQL with Vitess for horizontal scaling, caching with Memcache, coordination via Zookeeper, cloud‑native deployment on Kubernetes, CDN delivery, and the storage systems (GFS, BigTable) that enable billions of users to upload and stream petabytes of video data.

BackendCloud NativeScalability
0 likes · 15 min read
YouTube Backend Architecture: Databases, Vitess, and Cloud‑Native Infrastructure
Architecture Digest
Architecture Digest
Feb 5, 2023 · Databases

Redis Memory Management and Optimization Practices

This article explains Redis's internal memory architecture, details the various memory components such as used_memory, object memory, client buffers, and fragmentation, and provides practical optimization techniques and real‑world case studies to reduce memory usage and improve performance.

Memory ManagementPerformancedatabases
0 likes · 22 min read
Redis Memory Management and Optimization Practices
dbaplus Community
dbaplus Community
Jan 30, 2023 · Databases

Why Velox, ReadySet, and Neon Are Redefining the 2022 Database Landscape

The article reviews the cooling of 2022 database funding, highlights Velox as a shared execution engine, examines ReadySet's transparent caching, profiles Neon’s serverless PostgreSQL, surveys other notable databases, and outlines emerging trends and predictions for 2023, offering a comprehensive technical and market analysis for developers and DB professionals.

AIExecution EngineNEON
0 likes · 19 min read
Why Velox, ReadySet, and Neon Are Redefining the 2022 Database Landscape
Cognitive Technology Team
Cognitive Technology Team
Jan 19, 2023 · Databases

Implementation Principles of Redis Pub/Sub (Ordinary Subscription)

This article explains how Redis implements the Pub/Sub messaging pattern by storing subscription relationships in hash‑based dictionaries, detailing the processing flow of SUBSCRIBE and PUBLISH commands, cluster propagation, and key limitations such as lack of persistence and client buffer constraints.

Message Queuedatabasespub/sub
0 likes · 5 min read
Implementation Principles of Redis Pub/Sub (Ordinary Subscription)
ITPUB
ITPUB
Jan 9, 2023 · Databases

How MatrixOne’s Hyper‑Converged Architecture Redefines Cloud‑Native Databases

The article examines MatrixOne, a cloud‑native hyper‑converged database, detailing its storage‑compute separation, unified file service, resource isolation, HTAP streaming capabilities, and emerging serverless features, while outlining future directions such as CXL memory integration and broader cloud storage support.

DistributedHTAPHyper-Converged
0 likes · 9 min read
How MatrixOne’s Hyper‑Converged Architecture Redefines Cloud‑Native Databases
Architecture Digest
Architecture Digest
Jan 4, 2023 · Databases

YouTube Backend Architecture: Databases, Scaling, and Vitess

This article examines YouTube’s massive backend infrastructure, detailing how the platform stores billions of videos using MySQL, Vitess for horizontal scaling, sharding, replication, disaster management, cloud‑native deployment on Kubernetes, and the supporting storage systems such as GFS and BigTable.

BackendCloud NativeScalability
0 likes · 13 min read
YouTube Backend Architecture: Databases, Scaling, and Vitess
Java Captain
Java Captain
Jan 4, 2023 · Databases

Managing Database Intermediate Tables with File Storage Using SPL

The article explains how excessive intermediate tables generated by reporting workloads degrade database storage and performance, and proposes using the SPL data‑processing tool to store these intermediate results as external files, thereby reducing capacity pressure, improving I/O speed, and simplifying management.

SPLdata-processingdatabases
0 likes · 9 min read
Managing Database Intermediate Tables with File Storage Using SPL
政采云技术
政采云技术
Dec 27, 2022 · Databases

Comprehensive Guide to MySQL Backup Types, Tools, and Procedures

This article provides an in‑depth overview of MySQL backup classifications—including hot, warm, and cold backups—explains physical versus logical backup methods, compares built‑in and third‑party tools such as mysqldump, mysqlhotcopy, LVM snapshots, XtraBackup, and presents step‑by‑step command examples for each approach.

BackupData RecoveryLVM
0 likes · 14 min read
Comprehensive Guide to MySQL Backup Types, Tools, and Procedures
ITPUB
ITPUB
Dec 23, 2022 · Databases

Understanding Database Transaction Isolation: From ACID Basics to TDSQL Implementation

This article explains the ACID properties of database transactions, clarifies the often‑confused concepts of consistency and isolation, details the four SQL standard isolation levels, compares lock‑based and MVCC concurrency controls, and examines concrete implementations in MySQL, PostgreSQL, and the distributed TDSQL system.

ACIDMVCCMySQL
0 likes · 28 min read
Understanding Database Transaction Isolation: From ACID Basics to TDSQL Implementation
php Courses
php Courses
Dec 20, 2022 · Databases

Redis Memory Not Releasing Issue and Analysis of 20 Million Expiring Keys

This article describes a Redis 5.0 memory leak scenario where 20 million keys with expiration caused memory not to be released, details the investigation steps, findings about the activeExpireCycle, and concludes that memory will eventually be freed, followed by a promotional announcement for a PHP online live class.

Memory ManagementPHPPerformance
0 likes · 3 min read
Redis Memory Not Releasing Issue and Analysis of 20 Million Expiring Keys
Architect
Architect
Dec 19, 2022 · Databases

Understanding Elasticsearch DSL Query Syntax (7.x)

This article provides a comprehensive guide to Elasticsearch 7.x DSL query syntax, explaining core keywords, field mappings, various query types such as match, term, range, fuzzy, and bool, and includes practical code examples for building effective search queries.

DSLElasticsearchElasticsearch7
0 likes · 8 min read
Understanding Elasticsearch DSL Query Syntax (7.x)
DataFunTalk
DataFunTalk
Dec 19, 2022 · Big Data

Evolution of OLAP: Key Technologies, Engine Comparison, and Future Trends

This article provides a comprehensive overview of OLAP technology evolution, covering its origins, modern requirements for massive and real‑time data, detailed comparisons of major open‑source OLAP engines such as Druid, Elasticsearch, Kylin, Doris/StarRocks, and ClickHouse, core architectural and storage techniques, and emerging trends like federated queries, hybrid storage, and lakehouse integration.

ClickHouseDruidOLAP
0 likes · 22 min read
Evolution of OLAP: Key Technologies, Engine Comparison, and Future Trends
Selected Java Interview Questions
Selected Java Interview Questions
Dec 10, 2022 · Backend Development

InfoWorld 2022 Best Open Source Software Awards – Highlights of Notable Projects

InfoWorld's 2022 Best Open Source Software Awards showcase a curated list of influential open‑source projects—including AlmaLinux, Podman, Play with Docker, Vaadin, JHipster, SolidJS, Redwood, Next.js, Wasmtime, PyScript, Hardhat, OpenFGA, Sentry, Appsmith, Spinnaker, Hypertrace, Gravitee, OpenTelemetry, Grafana, Dapr, Redpanda, Iceberg, Druid, JAX, nbdev, Accelerate, Stable Diffusion, and EleutherAI—covering backend, cloud‑native, AI, and data‑centric technologies.

BackendOpen-sourcedatabases
0 likes · 11 min read
InfoWorld 2022 Best Open Source Software Awards – Highlights of Notable Projects
ITPUB
ITPUB
Dec 7, 2022 · Databases

Can Modern OSes Replace Database Kernels? Insights on OS‑Database Synergy

The article examines whether today’s powerful operating systems can assume tasks traditionally handled by database kernels, tracing the evolution from early OS‑dependent databases to modern systems that leverage OS file cache, VMM, and storage optimizations, while also discussing scenarios where direct DB control remains necessary.

LinuxOperating Systemdatabases
0 likes · 8 min read
Can Modern OSes Replace Database Kernels? Insights on OS‑Database Synergy
Thoughts on Knowledge and Action
Thoughts on Knowledge and Action
Nov 23, 2022 · Databases

Inside Redis 6.0: Understanding SDS, Ziplist, Quicklist, and ZSet Data Structures

Redis 6.0 implements several compact data structures—SDS, ziplist, quicklist, hash, set, and ZSet—each optimized for memory efficiency and performance, and this guide explains their definitions, internal layouts, usage scenarios, and key implementation details such as packing attributes, incremental rehashing, and skiplist operations.

Data Structuresbackend-developmentdatabases
0 likes · 16 min read
Inside Redis 6.0: Understanding SDS, Ziplist, Quicklist, and ZSet Data Structures
Architects' Tech Alliance
Architects' Tech Alliance
Nov 5, 2022 · Databases

Data Replication: Fundamentals, Technologies, and Future Trends

This article explains the concept of data replication, its three-stage process, key principles of compliance, timeliness, and diversity, various replication methods, layered technologies across storage, operating system, and database levels, emerging cloud and big‑data solutions, and heterogeneous use‑case scenarios.

Big Datadata replicationdatabases
0 likes · 15 min read
Data Replication: Fundamentals, Technologies, and Future Trends
IT Architects Alliance
IT Architects Alliance
Nov 2, 2022 · Databases

The Importance, Evolution, and Future Trends of Distributed Databases

This article examines why databases are foundational to modern IT, traces the historical development of distributed database technologies, compares various architectural approaches such as sharding middleware, shared‑storage and shared‑nothing designs, and discusses emerging trends like multi‑model, HTAP, cloud‑native, and open‑source ecosystems.

Cloud NativeDistributed SystemsHTAP
0 likes · 11 min read
The Importance, Evolution, and Future Trends of Distributed Databases
Architects' Tech Alliance
Architects' Tech Alliance
Nov 1, 2022 · Databases

2022 China Database Industry Report: Emerging Hardware and Architectural Innovations

The September 2022 China Database Industry Analysis report highlights a wave of hardware‑driven innovations—including multi‑core CPUs, heterogeneous GPUs/TPUs/DPU, programmable FPGAs, CXL‑DDR5, persistent memory, NVMe‑oF, and RDMA‑based storage—that enable massive data storage and high‑concurrency real‑time computing across a range of novel database architectures and products.

GPUHardware accelerationOLTP
0 likes · 10 min read
2022 China Database Industry Report: Emerging Hardware and Architectural Innovations
Architects' Tech Alliance
Architects' Tech Alliance
Oct 29, 2022 · Databases

Analysis of China's Distributed Database Market and Future Development Trends

This article examines the importance, definitions, classifications, and technological evolution of distributed databases in China, outlines major architecture routes such as sharding middleware, shared‑storage and decentralized models, discusses HTAP and cloud‑native trends, and summarizes future directions including open‑source ecosystems and industry support.

Cloud NativeDistributed SystemsHTAP
0 likes · 10 min read
Analysis of China's Distributed Database Market and Future Development Trends
ITPUB
ITPUB
Oct 23, 2022 · Databases

Databases vs Data Warehouses vs Data Lakes vs Lake Houses: Key Differences

The article explains the fundamental concepts and distinctions among databases, data warehouses, and data lakes, describes how each serves transactional or analytical workloads, introduces the emerging lake‑house architecture that integrates lake and warehouse capabilities, and outlines AWS services such as S3, Lake Formation, Glue, Athena, Redshift Spectrum that enable these solutions.

AWSdatabaseslake house
0 likes · 14 min read
Databases vs Data Warehouses vs Data Lakes vs Lake Houses: Key Differences
JD Cloud Developers
JD Cloud Developers
Sep 29, 2022 · Databases

Mastering Data Consistency: Transactions, Isolation Levels, and MVCC Explained

This article explores how to achieve data consistency by examining transaction properties, isolation levels, common concurrency issues like dirty, non-repeatable, and phantom reads, and compares lock‑based concurrency control with multi‑version concurrency control (MVCC), detailing undo logs, read‑view mechanisms, and practical examples.

ConsistencyMVCCTransactions
0 likes · 15 min read
Mastering Data Consistency: Transactions, Isolation Levels, and MVCC Explained
Architects' Tech Alliance
Architects' Tech Alliance
Sep 23, 2022 · Databases

Analysis of Chinese Database Product Strategies and Emerging Trends

This article summarizes recent Chinese database product strategy reports, outlining database definitions, management systems, design processes, product classifications, architectural layers, HTAP technology, compression methods, storage index structures, intelligent autonomous optimization, and deployment models, highlighting trends and future directions in the database industry.

AI OptimizationDatabase ArchitectureHTAP
0 likes · 8 min read
Analysis of Chinese Database Product Strategies and Emerging Trends
Practical DevOps Architecture
Practical DevOps Architecture
Sep 21, 2022 · Databases

Understanding MySQL Transaction Isolation Levels: Dirty Read, Non-Repeatable Read, and Phantom Read

This article explains MySQL's four transaction isolation levels, illustrating how concurrent transactions can cause dirty reads, non‑repeatable reads, and phantom reads through detailed examples of two transactions interacting via SELECT, UPDATE, and INSERT operations, and summarizes the consistency issues each scenario creates.

MySQLdatabasesdirty read
0 likes · 4 min read
Understanding MySQL Transaction Isolation Levels: Dirty Read, Non-Repeatable Read, and Phantom Read
Sohu Tech Products
Sohu Tech Products
Sep 14, 2022 · Databases

Understanding Redis Memory Fragmentation and How to Manage It

This article explains why Redis may show high OS‑allocated memory despite low data usage, describes the causes of memory fragmentation, and provides practical steps—including configuration changes and automatic defragmentation settings—to diagnose and mitigate fragmentation for stable performance.

Memory Fragmentationcachingdatabases
0 likes · 9 min read
Understanding Redis Memory Fragmentation and How to Manage It
Programmer DD
Programmer DD
Sep 5, 2022 · Databases

What’s Driving the Latest DB‑Engines Rankings? Oracle’s Drop, MySQL & MongoDB Surge

The September DB‑Engines ranking shows Oracle’s steep decline while MySQL and MongoDB climb, presents top‑10 lists for relational, key‑value, document, time‑series and graph databases, explains the five metrics behind the scores, and advises professionals to choose databases based on business needs rather than pure popularity.

DB-EnginesMongoDBMySQL
0 likes · 4 min read
What’s Driving the Latest DB‑Engines Rankings? Oracle’s Drop, MySQL & MongoDB Surge
21CTO
21CTO
Sep 4, 2022 · Databases

Why SQL Remains a Must‑Learn Skill in 2022: Top 5 Reasons

Despite the rise of newer data tools, SQL continues to dominate the developer landscape in 2022, offering universal applicability, high demand, strong career prospects, and a rich history that makes it an essential skill for data analysts, developers, and high‑paying tech roles.

careerdata analysisdatabases
0 likes · 7 min read
Why SQL Remains a Must‑Learn Skill in 2022: Top 5 Reasons
Architects' Tech Alliance
Architects' Tech Alliance
Sep 4, 2022 · Cloud Native

Understanding Cloud Native: Concepts, Architecture, and Key Technologies

This article explains cloud native as a design philosophy that maximizes cloud efficiency through elastic, loosely coupled, observable systems, outlines its industry benefits, technical characteristics, architectural principles, and reviews core technologies such as containers, serverless, microservices, networking, chips, and databases.

Cloud NativeContainersMicroservices
0 likes · 9 min read
Understanding Cloud Native: Concepts, Architecture, and Key Technologies
Su San Talks Tech
Su San Talks Tech
Aug 29, 2022 · Databases

Why Redis Added Multithreading in 6.0: Design Rationale and Trade‑offs

This article explains why Redis, originally designed as a single‑threaded in‑memory database, introduced a multithreaded network layer in version 6.0, covering the historical design, the limits of CPU vs I/O utilization, the role of I/O multiplexing, and the benefits and drawbacks of the new model.

I/O Multiplexingconcurrencydatabases
0 likes · 11 min read
Why Redis Added Multithreading in 6.0: Design Rationale and Trade‑offs
JavaEdge
JavaEdge
Aug 28, 2022 · Databases

Why Serializability Matters: Single‑Threaded Transactions and Stored Procedures

The article explains how RC and snapshot isolation fail to prevent write skew and phantom reads, advocates serializable isolation, and examines three implementation techniques—strict serial execution, two‑phase locking, and optimistic concurrency—detailing their trade‑offs, stored‑procedure usage, partitioning, and practical constraints for achieving true serializable isolation.

PartitioningSingle‑threadedStored Procedures
0 likes · 11 min read
Why Serializability Matters: Single‑Threaded Transactions and Stored Procedures
JavaEdge
JavaEdge
Aug 25, 2022 · Databases

How to Prevent Lost Updates: Atomic Writes, Explicit Locks, and CAS

The article explains why concurrent write transactions cause lost updates, then details practical solutions such as atomic update statements, explicit row‑level locking, automatic lost‑update detection, compare‑and‑swap (CAS) techniques, and special considerations for multi‑replica databases.

CASConcurrency Controlatomic write
0 likes · 8 min read
How to Prevent Lost Updates: Atomic Writes, Explicit Locks, and CAS
Top Architect
Top Architect
Aug 21, 2022 · Databases

42 Lessons Learned from Building a Production Database – Translation

This translated article shares 42 practical lessons drawn from Mahesh Balakrishnan’s experience building a production database, covering customer focus, project management, design principles, observability, research, and strategic thinking to help engineers and managers create reliable, scalable infrastructure.

Architecturedatabasesproduction
0 likes · 12 min read
42 Lessons Learned from Building a Production Database – Translation
Architect's Guide
Architect's Guide
Aug 18, 2022 · Databases

42 Lessons Learned from Building a Production Database

This article translates and summarizes Mahesh Balakrishnan’s 42 practical insights on building a production database, covering customer focus, project management, design principles, code review, observability, research, and cultural practices for engineering teams.

DesignInfrastructureObservability
0 likes · 11 min read
42 Lessons Learned from Building a Production Database
DaTaobao Tech
DaTaobao Tech
Aug 17, 2022 · Cloud Computing

Alibaba Open Source Week 2022: Complete Schedule and Technical Forums

Alibaba Open Source Week 2022, held online from August 22‑24, offers a main forum and five specialized forums—Operating Systems, Databases, Cloud Native, Big Data & AI, and Terminal—featuring over 30 technical presentations by more than 40 global experts on open‑source ecosystem development, emerging technologies, and real‑world applications.

AIAlibabaCloud Computing
0 likes · 5 min read
Alibaba Open Source Week 2022: Complete Schedule and Technical Forums
dbaplus Community
dbaplus Community
Aug 11, 2022 · Databases

5 Essential Rules for Writing High‑Performance SQL Queries

This article presents five practical rules—return only needed columns, use proper indexes, avoid subqueries, replace OFFSET pagination with key‑based limits, and understand SQL's logical execution order—to help developers craft efficient SQL statements across major relational databases.

Subqueriesdatabasesexecution plan
0 likes · 13 min read
5 Essential Rules for Writing High‑Performance SQL Queries
21CTO
21CTO
Aug 6, 2022 · Databases

August 2023 DB-Engines Ranking: Oracle Drops, MySQL & MongoDB Surge

The August 2023 DB‑Engines ranking shows Oracle’s steep 19.5‑point drop, while MySQL and MongoDB surge, PostgreSQL continues rising, and the top‑10 list highlights shifts across relational, key‑value, and document databases, with methodology based on search, job, and community metrics.

DB-EnginesMySQLOracle
0 likes · 4 min read
August 2023 DB-Engines Ranking: Oracle Drops, MySQL & MongoDB Surge
AntTech
AntTech
Jul 30, 2022 · Fundamentals

Open Source Core Infrastructure: Ant Group’s Strategy and Key Projects

In his keynote at the 2022 Open Atom Global Open Source Summit, He Zhengyu outlined Ant Group’s open‑source strategy, highlighting over 900 repositories and key projects such as OceanBase, SOFA Mesh, MOSN, BabaSSL, Occlum, and the upcoming TuGraph, emphasizing how open core infrastructure drives industry innovation and ecosystem growth.

Ant GroupCloud NativeInfrastructure
0 likes · 9 min read
Open Source Core Infrastructure: Ant Group’s Strategy and Key Projects
Volcano Engine Developer Services
Volcano Engine Developer Services
Jul 28, 2022 · Databases

ByteDance’s NoSQL Strategy: Powering Billions of Requests with KV, Graph & More

ByteDance’s NoSQL ecosystem, spanning KV stores like ABase, document databases, columnar systems, and a custom distributed graph database, underpins over 90% of its online services, handling tens of thousands of instances and billions of daily requests, while embracing BASE principles and cloud‑native scalability.

ABaseByteGraphGraph Database
0 likes · 14 min read
ByteDance’s NoSQL Strategy: Powering Billions of Requests with KV, Graph & More
Laravel Tech Community
Laravel Tech Community
Jul 26, 2022 · Big Data

Red Hat 2019 Enterprise Open Source Survey: Overview of Popular Open Source Projects Across Web Servers, Big Data, Cloud, Storage, Operating Systems, Databases, and Development Tools

The Red Hat 2019 Enterprise Open Source Survey summarizes the most widely adopted open‑source projects in enterprises, covering web servers, big‑data frameworks, cloud platforms, distributed storage, operating systems, databases, development tools, and middleware, and highlights their strategic importance for modern IT infrastructure.

Big DataCloud ComputingEnterprise
0 likes · 18 min read
Red Hat 2019 Enterprise Open Source Survey: Overview of Popular Open Source Projects Across Web Servers, Big Data, Cloud, Storage, Operating Systems, Databases, and Development Tools
macrozheng
macrozheng
Jul 23, 2022 · Databases

July 2023 DB-Engines Ranking: Oracle Drops, MySQL & SQL Server Rise

The July 2023 DB-Engines ranking shows Oracle, PostgreSQL and MongoDB slipping, while MySQL and Microsoft SQL Server climb, and provides detailed scores, trend charts, and the methodology behind the monthly popularity scores for the top ten database systems.

DB-EnginesMySQLOracle
0 likes · 4 min read
July 2023 DB-Engines Ranking: Oracle Drops, MySQL & SQL Server Rise
Efficient Ops
Efficient Ops
Jul 19, 2022 · Databases

How CDC Powers Real-Time Analytics Without Overloading Your Database

This article introduces the practice of Change Data Capture (CDC), explaining how capturing only data changes can feed downstream systems and data warehouses in near real‑time, reducing load on the source database, improving reporting latency, and supporting scalable, reliable analytics pipelines.

CDCChange Data CaptureReal-time analytics
0 likes · 9 min read
How CDC Powers Real-Time Analytics Without Overloading Your Database
Programmer DD
Programmer DD
Jul 18, 2022 · Fundamentals

Top Open‑Source Projects Every Developer Should Know in 2024

An extensive overview of the most influential open‑source projects—from web servers and big‑data frameworks to cloud platforms, operating systems, databases, development tools, and middleware—highlighting their key features, supported platforms, and real‑world adoption, based on Red Hat’s 2019 enterprise open‑source survey.

Open-sourcedatabasessoftware projects
0 likes · 21 min read
Top Open‑Source Projects Every Developer Should Know in 2024
IT Services Circle
IT Services Circle
Jun 21, 2022 · Databases

MySQL High‑Availability Incident Review and Resolution in a Dual‑Master Setup with Keepalived

This article recounts a MySQL high‑availability incident in a dual‑master environment, explains how missing binary‑log index files caused replication failures, and details step‑by‑step troubleshooting, directory recreation, binlog position correction, and configuration improvements to restore reliable database operation.

MySQLReplicationdatabases
0 likes · 8 min read
MySQL High‑Availability Incident Review and Resolution in a Dual‑Master Setup with Keepalived
Wukong Talks Architecture
Wukong Talks Architecture
Jun 14, 2022 · Databases

MySQL High‑Availability Incident Review and Recovery Steps

The article recounts a production‑like MySQL dual‑master HA setup using Keepalived, describes how a missing binary‑log index caused replication failure, and details step‑by‑step troubleshooting commands, configuration fixes, and preventive measures to restore reliable database synchronization.

MySQLdatabaseshigh-availability
0 likes · 9 min read
MySQL High‑Availability Incident Review and Recovery Steps
IT Architects Alliance
IT Architects Alliance
Jun 13, 2022 · Backend Development

Why Choose Microservice Architecture? A Comprehensive Roadmap and Tool Guide

This article explains why microservice architecture is preferred over monolithic applications, outlines a detailed learning roadmap covering core concerns such as Docker, container orchestration, API gateways, load balancing, service discovery, event buses, logging, monitoring, tracing, persistence, caching, and cloud providers, and recommends suitable tools for each component.

ArchitectureBackendMicroservices
0 likes · 12 min read
Why Choose Microservice Architecture? A Comprehensive Roadmap and Tool Guide
JavaEdge
JavaEdge
Jun 10, 2022 · Databases

Why Choosing the Right Data Model Matters: Relational vs Document vs Graph

This article explains how different data models—from relational tables to JSON documents and graph structures—affect software design, storage, querying, and scalability, illustrating concepts with a resume example and discussing trade‑offs such as impedance mismatch, normalization, and multi‑entity relationships.

JSONNoSQLORM
0 likes · 14 min read
Why Choosing the Right Data Model Matters: Relational vs Document vs Graph
Laravel Tech Community
Laravel Tech Community
Jun 8, 2022 · Fundamentals

Comprehensive Programming and IT Knowledge Quiz with Multiple‑Choice and Coding Questions

This timed programmer quiz combines single‑choice, short‑answer, and coding problems that test a broad spectrum of IT topics—from programming history and algorithms to Linux commands, networking layers, Helm chart concepts, and practical Python and C coding tasks—providing a holistic assessment of technical fundamentals.

PythonQuizalgorithm
0 likes · 9 min read
Comprehensive Programming and IT Knowledge Quiz with Multiple‑Choice and Coding Questions
Top Architect
Top Architect
Jun 7, 2022 · Databases

An Introduction to Change Data Capture (CDC) Practices and Modern Approaches

This article introduces the concept of Change Data Capture (CDC), explains why traditional batch reporting strains resources, describes how CDC captures only data changes to keep source databases performant, and outlines modern CDC architectures, production‑ready considerations, and best‑practice guidelines for building reliable data pipelines.

CDCChange Data CaptureData Integration
0 likes · 16 min read
An Introduction to Change Data Capture (CDC) Practices and Modern Approaches
DaTaobao Tech
DaTaobao Tech
Jun 7, 2022 · Databases

Inside Redis AOF Rewrite: How Forked Processes Manage Data Persistence

This article provides a detailed walkthrough of Redis's AOF rewrite mechanism, covering trigger conditions, parent‑child process forking, three communication pipes, key data structures, the child’s rewrite steps, the parent’s handling of concurrent writes, and the final hand‑over that swaps the new AOF file into production.

AOF RewriteData PersistenceFork Process
0 likes · 12 min read
Inside Redis AOF Rewrite: How Forked Processes Manage Data Persistence
DataFunTalk
DataFunTalk
Jun 4, 2022 · Databases

Future of Databases: Cloud‑Native Innovations, Amazon Aurora, and Migration Strategies

This presentation explores the rapid growth of data demands, the challenges of traditional on‑premise databases, and how cloud‑native innovations such as Amazon Aurora, Aurora Serverless, Global Database, and Babelfish enable high‑performance, cost‑effective, and globally distributed database solutions with seamless migration pathways.

Amazon AuroraBabelfishcloud-native
0 likes · 13 min read
Future of Databases: Cloud‑Native Innovations, Amazon Aurora, and Migration Strategies
IT Services Circle
IT Services Circle
Jun 1, 2022 · Backend Development

Key Knowledge Points for C++ Backend Development (Image Overview)

This article presents a series of images that quickly review essential C++ backend development topics, highlighting low‑level concepts such as memory management, inter‑process communication, network programming, and the importance of databases and Linux, while comparing C++ to Java backend routes.

C++LinuxMemory Management
0 likes · 3 min read
Key Knowledge Points for C++ Backend Development (Image Overview)
AntTech
AntTech
May 30, 2022 · Information Security

Ant Group’s Technical Innovations: Green Computing, Trusted Mobile Anti‑Fraud Sandbox, Open‑Source Privacy Platform, OceanBase DB Competition, and Security Parallel Slice

This article highlights Ant Group’s recent technical achievements—including green carbon‑reduction scheduling, the AntDTX trusted privacy sandbox for mobile anti‑fraud, the open‑source YinYu privacy‑computing platform, the OceanBase database competition, and the Space5D security parallel‑slice architecture—showcasing their impact on sustainability, security, and open‑source collaboration.

Cloud NativeInformation SecurityOpen-source
0 likes · 9 min read
Ant Group’s Technical Innovations: Green Computing, Trusted Mobile Anti‑Fraud Sandbox, Open‑Source Privacy Platform, OceanBase DB Competition, and Security Parallel Slice
dbaplus Community
dbaplus Community
May 24, 2022 · Cloud Computing

Why Serverless is Shaping the Future of Cloud Computing and Databases

Serverless, once a niche concept, is rapidly becoming a core paradigm in cloud computing, offering resource decoupling, automatic scaling, and usage‑based billing, while its adoption in databases introduces unique challenges such as persistence, connection handling, and performance, prompting ongoing research and evolving commercial implementations.

BaaSCloud ComputingFaaS
0 likes · 13 min read
Why Serverless is Shaping the Future of Cloud Computing and Databases
ITPUB
ITPUB
May 23, 2022 · Databases

How to Choose the Right Cloud‑Native Database: A Maturity Model Guide

This article explains the evolution of cloud service models, defines cloud‑native databases, and presents a detailed maturity model—from basic cloud‑ready deployments to fully serverless data services—helping enterprises evaluate and adopt the most suitable architecture and technology stack for their workloads.

CaaSDBaaSFaaS
0 likes · 11 min read
How to Choose the Right Cloud‑Native Database: A Maturity Model Guide
Architecture Digest
Architecture Digest
May 16, 2022 · Databases

Evolution of JD Baitiao’s Data Architecture: From MySQL to Apache ShardingSphere

This article chronicles JD Baitiao’s journey from a monolithic MySQL setup through NoSQL and DBRep to a mature ShardingSphere‑based sharding solution, highlighting the technical motivations, architectural decoupling strategies, evaluation criteria, performance comparison, and the operational benefits achieved for a high‑traffic financial service.

Apache ShardingSphereData Architecturedatabases
0 likes · 14 min read
Evolution of JD Baitiao’s Data Architecture: From MySQL to Apache ShardingSphere
DataFunSummit
DataFunSummit
May 15, 2022 · Databases

Design and Evolution of a Custom Storage Engine for IoT Device Metadata

This article presents a detailed case study of an IoT device metadata management platform, describing the business scenario, the evolution from a single‑node MySQL solution through sharded MySQL, HBase and Elasticsearch, to a self‑developed distributed storage engine that separates compute and storage, supports LSM, multi‑dimensional indexing, routing keys, and parallel scans to meet massive write‑read throughput and complex query requirements.

Big DataDistributed SystemsIoT
0 likes · 14 min read
Design and Evolution of a Custom Storage Engine for IoT Device Metadata
Top Architect
Top Architect
May 11, 2022 · Databases

An Introduction to Change Data Capture (CDC) Practices

This article introduces the concept and practice of Change Data Capture (CDC), explaining why CDC is needed for real‑time analytics, how it works by capturing DML changes, modern approaches using transaction logs, and key considerations for building a production‑ready CDC system.

CDCChange Data CaptureData Integration
0 likes · 8 min read
An Introduction to Change Data Capture (CDC) Practices