BestHub
Sign in
Tagged articles
625 articles
Page 2 of 7
DataFunSummit
DataFunSummit
Sep 16, 2024 · Databases

DataFun Summit: Technical Papers on Graph Databases, Vector Databases, Real‑Time Data Warehouses and Industry Data Practices

The DataFun Summit page presents a collection of technical papers covering graph database parallel queries, next‑generation vector databases, real‑time data warehouse architectures, and best practices in finance and e‑commerce, while also providing instructions for obtaining the e‑book via a public account.

Big DataData WarehouseReal-time analytics
0 likes · 5 min read
DataFun Summit: Technical Papers on Graph Databases, Vector Databases, Real‑Time Data Warehouses and Industry Data Practices
ITPUB
ITPUB
Sep 9, 2024 · Databases

What Oracle’s 2024 Global Survey Reveals About Top Databases, Cloud, and AI

Oracle’s 2024 global user survey uncovers preferred databases, key factors for database selection, the advantages of Oracle Cloud Infrastructure, and emerging AI use cases, providing a comprehensive view of current enterprise priorities and future expectations in data management and cloud services.

AIDatabase SurveyOracle
0 likes · 9 min read
What Oracle’s 2024 Global Survey Reveals About Top Databases, Cloud, and AI
AntData
AntData
Sep 6, 2024 · Artificial Intelligence

Insights from the 2024 Inclusion·Bund Conference: From Data for AI to AI for Data

The 2024 Inclusion·Bund Conference forum brought together leading academics and industry experts to examine how data value is shifting in the AI era, covering large‑model storage challenges, the rise of synthetic data, AI‑enhanced databases, and Ant Group’s next‑generation intelligent data architecture.

AIIntelligent Data Systemsdata strategy
0 likes · 6 min read
Insights from the 2024 Inclusion·Bund Conference: From Data for AI to AI for Data
Top Architect
Top Architect
Sep 3, 2024 · Databases

Implementing Online User Counting with Redis Sorted Sets (ZSET)

This article explains how to track online users using Redis sorted sets by describing the core ZSET commands (zadd, zrangeByScore, zremrangeByScore, zrem), showing code examples for adding, querying, and cleaning up user sessions, and discussing fingerprint-based identification methods.

Backend DevelopmentOnline UsersZSet
0 likes · 10 min read
Implementing Online User Counting with Redis Sorted Sets (ZSET)
Python Programming Learning Circle
Python Programming Learning Circle
Aug 30, 2024 · Fundamentals

Key Findings from the 2022 JetBrains Python Developer Survey

The 2022 JetBrains Python Developer Survey, conducted with over 23,000 respondents from more than 200 countries, reveals that 93% now use Python 3 (with Python 3.10 most popular), 7% still use Python 2, and highlights trends in frameworks, databases, big‑data tools, IDEs, operating systems, documentation tools, and primary usage contexts.

IDEbig-datadatabases
0 likes · 5 min read
Key Findings from the 2022 JetBrains Python Developer Survey
Top Architect
Top Architect
Aug 30, 2024 · Databases

MySQL to Elasticsearch Data Synchronization Strategies and Tools

This article examines various methods for synchronizing MySQL data with Elasticsearch, including synchronous and asynchronous dual‑write, Logstash pipelines, binlog real‑time replication, Canal, and Alibaba Cloud DTS, comparing their architectures, advantages, disadvantages, and suitable application scenarios.

Elasticsearchdata synchronizationdatabases
0 likes · 17 min read
MySQL to Elasticsearch Data Synchronization Strategies and Tools
MaGe Linux Operations
MaGe Linux Operations
Aug 29, 2024 · Databases

Database Server Ops: Hardware, Tuning, Backup & Security Best Practices

This guide outlines comprehensive best practices for database server operations, covering hardware selection, OS and kernel tuning, storage choices, MySQL configuration, performance monitoring, backup strategies, security measures, high availability, automation, and systematic maintenance procedures to ensure optimal reliability and efficiency.

BackupOperationsSecurity
0 likes · 7 min read
Database Server Ops: Hardware, Tuning, Backup & Security Best Practices
Xiaolei Talks DB
Xiaolei Talks DB
Aug 28, 2024 · Databases

What 15 Years of China’s DTCC Conferences Reveal About Database Evolution

The author reflects on a decade‑plus journey through China’s DTCC database conferences, describing personal growth from novice to speaker and organizer, sharing insights on Redis Cluster, distributed database selection, openGauss, time‑series databases, and the evolving themes that chart the industry's progress.

Career DevelopmentDistributed SystemsTime Series Database
0 likes · 6 min read
What 15 Years of China’s DTCC Conferences Reveal About Database Evolution
Deepin Linux
Deepin Linux
Aug 10, 2024 · Fundamentals

Comprehensive C/C++ Interview Question Collection Covering Language, Data Structures, OS, Networking, Databases, and More

This article compiles over a thousand common C/C++ interview questions spanning language fundamentals, data structures, algorithms, system programming, networking, databases, design patterns, RPC, and audio‑video development, providing a thorough study guide for backend and systems engineers.

AlgorithmsC++Networking
0 likes · 19 min read
Comprehensive C/C++ Interview Question Collection Covering Language, Data Structures, OS, Networking, Databases, and More
21CTO
21CTO
Jul 30, 2024 · Databases

How Database Architectures Evolved Over 20 Years: From Columnar to Cloud & Beyond

This article surveys two decades of database system architecture innovations—including columnar stores, cloud databases, data lakes, NewSQL, hardware accelerators, and blockchain databases—highlighting their motivations, trade‑offs, and the shifting landscape that shapes modern DBMS design.

Columnar StorageDBMSNewSQL
0 likes · 23 min read
How Database Architectures Evolved Over 20 Years: From Columnar to Cloud & Beyond
58 Tech
58 Tech
Jul 29, 2024 · Databases

HBase Cloud Migration: Architecture, Challenges, and Solutions

This technical report details the background, architecture, construction, core issues, migration plans, and future roadmap of moving 58's HBase clusters to a cloud‑native environment, highlighting cost reduction, operational automation, and performance optimizations.

Big DataCloud NativeHBase
0 likes · 22 min read
HBase Cloud Migration: Architecture, Challenges, and Solutions
21CTO
21CTO
Jul 26, 2024 · Fundamentals

2024 Stack Overflow Survey: Key Tech Trends Uncovered from 65K Developers

Based on responses from over 65,000 developers across 185 countries, the 2024 Stack Overflow Survey highlights the most popular programming languages, databases, frameworks, IDEs, AI tool usage, and salary trends, revealing regional participation, education backgrounds, and emerging preferences such as Rust and Erlang.

AI toolsdatabasesprogramming languages
0 likes · 6 min read
2024 Stack Overflow Survey: Key Tech Trends Uncovered from 65K Developers
JD Cloud Developers
JD Cloud Developers
Jul 17, 2024 · Databases

Choosing the Right Database: MySQL, Redis, HBase, ClickHouse, MongoDB, Elasticsearch, Neo4j, Prometheus & Milvus Explained

Explore nine major database technologies—from traditional relational MySQL to NoSQL Redis, columnar HBase and ClickHouse, document-oriented MongoDB, search engine Elasticsearch, graph Neo4j, time‑series Prometheus, and vector Milvus—plus practical best‑practice guides, real‑world polyglot persistence scenarios, and recommended resources for mastering modern data storage.

ClickHouseElasticsearchHBase
0 likes · 50 min read
Choosing the Right Database: MySQL, Redis, HBase, ClickHouse, MongoDB, Elasticsearch, Neo4j, Prometheus & Milvus Explained
JD Tech Talk
JD Tech Talk
Jul 17, 2024 · Databases

A Comprehensive Guide to 9 Database Types and Polyglot Persistence

This article provides an in‑depth overview of nine major database categories—including relational, key‑value, columnar, document, graph, time‑series, and vector databases—detailing their strengths, weaknesses, best practices, and typical application scenarios, and explains how polyglot persistence combines multiple databases for optimal performance and scalability.

ClickHouseElasticsearchHBase
0 likes · 41 min read
A Comprehensive Guide to 9 Database Types and Polyglot Persistence
Senior Tony
Senior Tony
Jul 15, 2024 · Databases

Mastering Redis maxmemory‑policy: How LRU, LFU and Other Eviction Strategies Work

This article explains how Redis handles memory exhaustion by configuring maxmemory and maxmemory-policy, detailing each eviction strategy (noeviction, volatile‑lru, volatile‑lfu, volatile‑ttl, volatile‑random, allkeys‑lru, allkeys‑lfu, allkeys‑random), their implementation details, and the underlying approximate LRU algorithm.

LFULRUdatabases
0 likes · 8 min read
Mastering Redis maxmemory‑policy: How LRU, LFU and Other Eviction Strategies Work
Practical DevOps Architecture
Practical DevOps Architecture
Jun 21, 2024 · Backend Development

Comprehensive Backend Development and Database Optimization Course Outline

This article presents a detailed syllabus covering advanced programming techniques, database optimization, essential project knowledge, and in‑depth tutorials on backend frameworks such as Flask and Django, outlining over 70 lecture topics ranging from class fundamentals to deployment, security, and full‑stack project implementation.

Backend DevelopmentCourse OutlineDjango
0 likes · 6 min read
Comprehensive Backend Development and Database Optimization Course Outline
Selected Java Interview Questions
Selected Java Interview Questions
Jun 18, 2024 · Databases

Why Redis Is So Fast: Single‑Threaded Core, Multi‑Threaded I/O and Performance Mechanics

The article explains how Redis achieves high QPS by using an in‑memory, single‑threaded event loop for simple commands, leverages I/O multiplexing (epoll/select/kqueue) and optional multi‑threaded I/O for heavy operations, and outlines its evolution from a pure reactor model to a hybrid multi‑threaded architecture.

I/O MultiplexingSingle Threaddatabases
0 likes · 17 min read
Why Redis Is So Fast: Single‑Threaded Core, Multi‑Threaded I/O and Performance Mechanics
dbaplus Community
dbaplus Community
Jun 16, 2024 · Databases

How a Few Volunteers Keep the Internet’s Core Software Alive

Despite powering billions of devices, critical components like the TZ time‑zone database and SQLite are maintained by just a handful of volunteers, and the article reveals how this fragile reliance could cause massive disruptions if those small teams were to disappear.

SQLitedatabasesopen source
0 likes · 8 min read
How a Few Volunteers Keep the Internet’s Core Software Alive
Zhuanzhuan Tech
Zhuanzhuan Tech
Jun 12, 2024 · Databases

Designing a Scalable Persistence Layer: Sharding, Query Optimization, and Read/Write Splitting

This article shares a practical case study on how a coupon‑distribution system evolved from a single‑table design to a sharded, multi‑database architecture with query optimization, ElasticSearch integration, and read/write splitting to handle growing data volume, complex queries, and increasing request traffic.

ElasticsearchScalabilitydatabases
0 likes · 12 min read
Designing a Scalable Persistence Layer: Sharding, Query Optimization, and Read/Write Splitting
Practical DevOps Architecture
Practical DevOps Architecture
Jun 4, 2024 · Databases

Understanding Large Transactions, Risks, and Mitigation Strategies in Databases

The article defines large database transactions, explains their performance and replication risks, offers practical guidelines to avoid them, demonstrates a MySQL example that creates and repeatedly inserts data to illustrate growing execution time, and discusses challenges and solutions for handling massive tables in high‑traffic environments.

Large TransactionsSQLbig tables
0 likes · 5 min read
Understanding Large Transactions, Risks, and Mitigation Strategies in Databases
Ops Development & AI Practice
Ops Development & AI Practice
Jun 1, 2024 · Databases

How Go’s database/sql Injects MySQL Drivers: A Deep Dive

This article explains how Go’s standard database/sql package uses a driver registration mechanism to integrate third‑party MySQL drivers, detailing the global driver map, registration function, init process, and a complete example showing how to define, register, and use a custom MySQL driver.

GoMySQL driverdatabase/sql
0 likes · 7 min read
How Go’s database/sql Injects MySQL Drivers: A Deep Dive
Architecture Digest
Architecture Digest
May 15, 2024 · Databases

Redis Shifts to Dual Licensing: Implications and Community Reactions

Redis announced that starting with version 7.4 it will adopt a dual‑source licensing model (RSALv2 and SSPL), moving away from its permissive BSD‑3 license, sparking widespread community backlash, discussions about cloud provider restrictions, and prompting users to consider alternative databases or forks.

Licensingclouddatabases
0 likes · 6 min read
Redis Shifts to Dual Licensing: Implications and Community Reactions
21CTO
21CTO
May 11, 2024 · Databases

Why a SQL Pioneer Backs NoSQL: Insights from Donald Chamberlin

Donald Chamberlin, co‑author of SQL, explains why he now supports the NoSQL movement, describing how modern web applications demand scalability that traditional relational databases struggle to provide, and discusses emerging query languages like SQL++ (PartiQL) that bridge the gap between relational and document models.

CouchbaseData ScalabilityNoSQL
0 likes · 5 min read
Why a SQL Pioneer Backs NoSQL: Insights from Donald Chamberlin
Python Programming Learning Circle
Python Programming Learning Circle
May 9, 2024 · Fundamentals

Key Findings from the 2022 JetBrains Python Developer Survey

The 2022 JetBrains Python Developer Survey, conducted with over 23,000 respondents from more than 200 countries, reveals that 93% now use Python 3, highlights the dominance of Flask, Django and FastAPI in web development, shows growing adoption of big‑data tools, and details IDE, OS, and documentation preferences among Python developers.

IDEbig-datadatabases
0 likes · 5 min read
Key Findings from the 2022 JetBrains Python Developer Survey
AntTech
AntTech
Apr 26, 2024 · Databases

Data Processing Technologies in the AI Era: Trends and Integration of Vector and Relational Databases

The talk explores how the rapid growth of multimodal data and large language models is reshaping data processing, highlighting three key trends—online‑offline integration, vector‑relational database convergence, and the fusion of data processing with AI computation—while presenting practical solutions and future visions for unified data‑AI ecosystems.

AIBig DataHTAP
0 likes · 12 min read
Data Processing Technologies in the AI Era: Trends and Integration of Vector and Relational Databases
php Courses
php Courses
Apr 17, 2024 · Fundamentals

Navigating Programming Career Challenges and Essential Development Tools: A Comprehensive Guide

The article examines how AI, global competition, remote work, and cross‑cultural demands reshape programmers' careers, highlights the rise of independent developers, and provides a concise reference of essential development tools spanning editors, build systems, testing frameworks, debugging utilities, version control, and database management.

databasesdevelopment-toolsfrontend
0 likes · 14 min read
Navigating Programming Career Challenges and Essential Development Tools: A Comprehensive Guide
Efficient Ops
Efficient Ops
Apr 7, 2024 · Databases

Unlock 16 Powerful Redis Use Cases to Supercharge Your Backend

This article explores sixteen practical Redis patterns—including caching, distributed sessions, locks, global IDs, counters, rate limiting, bitmaps, shopping carts, timelines, message queues, lotteries, likes, tags, filtering, follow relationships, and ranking—demonstrating how each can boost performance and simplify backend architecture.

Backend DevelopmentData Structurescaching
0 likes · 8 min read
Unlock 16 Powerful Redis Use Cases to Supercharge Your Backend
Architecture Digest
Architecture Digest
Mar 26, 2024 · Fundamentals

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

According to the 2023 Stack Overflow Developer Survey of over 90,000 respondents, JavaScript remains the top language, Python overtakes SQL, PostgreSQL surpasses MySQL as the leading database, Node.js and React dominate web technologies, and AI tools like ChatGPT are widely adopted, with insights on salaries and usage trends.

Stack Overflow Surveydatabasesdeveloper trends
0 likes · 7 min read
2023 Stack Overflow Developer Survey: Popular Languages, Databases, Frameworks, and AI Tools
Programmer DD
Programmer DD
Mar 22, 2024 · Databases

Redis Shifts to Source‑Available Licenses: What It Means for Developers

Redis announced that starting with version 7.4 it will abandon the BSD 3‑Clause license in favor of a dual SSPLv1/RSALv2 model, making the source code source‑available while keeping the community edition free, and clarifying the impact on cloud providers, partners, and end‑users.

LicensingRSALSSPL
0 likes · 4 min read
Redis Shifts to Source‑Available Licenses: What It Means for Developers
IT Services Circle
IT Services Circle
Mar 16, 2024 · Backend Development

Test Development Interview Preparation: Tips, Sample Questions, and Core Technical Knowledge

This article offers a comprehensive guide for students aiming to secure test development internships at major tech companies, covering interview strategies, sample questions on testing concepts, database CRUD commands, MySQL vs Redis differences, HTTP/HTTPS, TCP reliability, Linux commands, data structures, and code examples for linked‑list deletion and binary search.

AlgorithmsInterview PreparationLinux
0 likes · 13 min read
Test Development Interview Preparation: Tips, Sample Questions, and Core Technical Knowledge
Architects' Tech Alliance
Architects' Tech Alliance
Mar 8, 2024 · Databases

What’s Driving the Rise of China’s Home‑grown Databases in 2024?

The article reviews the rapid emergence of high‑performance domestic databases such as OceanBase, TiDB, MaxCompute and TDEngine, outlines their development history, compares strengths and weaknesses, discusses suitable scenarios for TiDB, and forecasts future trends for China’s database ecosystem, while providing a curated list of further readings.

ChinaMaxComputeOceanBase
0 likes · 5 min read
What’s Driving the Rise of China’s Home‑grown Databases in 2024?
dbaplus Community
dbaplus Community
Feb 25, 2024 · Databases

How a Simple UPDATE Wiped My Production Database—and the Lessons I Learned

After a weekend support ticket led to a reckless UPDATE that erased all orders in a production PostgreSQL database, the author details the rapid recovery steps, analyzes the human errors behind the disaster, draws lessons from Chernobyl, and outlines concrete post‑mortem improvements to prevent future data loss.

RecoverySQLdatabases
0 likes · 7 min read
How a Simple UPDATE Wiped My Production Database—and the Lessons I Learned
ITPUB
ITPUB
Feb 13, 2024 · Databases

Achieve Seamless Second‑Level Database Scaling for High‑Throughput Microservices

This guide explains how to design a high‑concurrency, high‑throughput internet architecture that ensures database high availability with double‑master sync and virtual IPs, and how to horizontally shard and smoothly expand the cluster in seconds using configuration changes, reloads, and cleanup steps.

Microservicesdatabaseshigh availability
0 likes · 8 min read
Achieve Seamless Second‑Level Database Scaling for High‑Throughput Microservices
Mike Chen's Internet Architecture
Mike Chen's Internet Architecture
Jan 26, 2024 · Backend Development

Mastering Distributed Architecture: Key Concepts, Patterns, and Tools

This article provides a comprehensive overview of distributed architecture, covering its definition, core benefits such as performance, availability, scalability, and fault tolerance, and detailing major categories like microservices, distributed databases, storage systems, computing, communication, load balancing, security, and transactions.

cloud computingdatabasesdistributed architecture
0 likes · 11 min read
Mastering Distributed Architecture: Key Concepts, Patterns, and Tools
Wukong Talks Architecture
Wukong Talks Architecture
Jan 23, 2024 · Fundamentals

Scaling from Zero to One Million Users: System Design Fundamentals

This article walks through the step‑by‑step process of turning a single‑server prototype into a highly available, horizontally‑scaled system that can serve over a million users, covering server configuration, database selection, load balancing, caching, CDN, stateless networking, multi‑data‑center deployment, message queues, monitoring, and sharding strategies.

CDNScalabilitySystem Design
0 likes · 26 min read
Scaling from Zero to One Million Users: System Design Fundamentals
ITPUB
ITPUB
Jan 18, 2024 · Databases

Why the Database Market Is Booming: Cloud, AI, and Vector DB Trends

The global database market is accelerating beyond $1 trillion, driven by cloud adoption, AI workloads, and the rise of vector and NoSQL databases, while traditional relational vendors slow, creating a unique growth dynamic for enterprises seeking the right data solutions.

Market TrendsNoSQLRelational Databases
0 likes · 7 min read
Why the Database Market Is Booming: Cloud, AI, and Vector DB Trends
ITPUB
ITPUB
Jan 12, 2024 · Databases

What the 2023 Chinese Government Database Procurement Standard Means for Vendors

The 2023 Chinese government database procurement standard defines unified requirements for government agencies, covering scope, procurement principles, mandatory indicators, response and acceptance forms, and detailed technical criteria for centralized and distributed databases, offering clear guidance for vendors on functional, reliability, security, compatibility, service, and safety expectations.

Distributed SystemsReliabilitydatabases
0 likes · 15 min read
What the 2023 Chinese Government Database Procurement Standard Means for Vendors
JD Retail Technology
JD Retail Technology
Jan 8, 2024 · Databases

Practical Case Study of System Storage Expansion, Upgrade, and Optimization

This article presents a detailed technical case study on expanding and optimizing a system's storage capacity, covering business background, current architecture, implementation plans, technology selection, data synchronization strategies, phased rollout steps, results, and remaining challenges, with concrete metrics and diagrams.

Data MigrationScalabilitydatabases
0 likes · 11 min read
Practical Case Study of System Storage Expansion, Upgrade, and Optimization
21CTO
21CTO
Dec 29, 2023 · Databases

What Michael Stonebraker’s 80-Year Journey Teaches About Modern Databases

Celebrating Michael Stonebraker’s 80th birthday, this article chronicles his pioneering work from Ingres to PostgreSQL, his influence on open‑source databases, the rise of cloud‑compatible DBMS, and his bold vision of a database‑centric operating system reshaping the future of data management.

DBMSDatabase OSPostgreSQL
0 likes · 11 min read
What Michael Stonebraker’s 80-Year Journey Teaches About Modern Databases
Zuoyebang Tech Team
Zuoyebang Tech Team
Dec 22, 2023 · Databases

Unlocking Intelligent Database Operations: Inside Zyb’s Multi‑Cloud Platform

This article details how Zyb’s multi‑cloud database platform integrates diverse database types, a unified proxy layer, intelligent lifecycle management, automated task orchestration, monitoring, resource allocation, backup, and fault‑handling to achieve efficient, reliable, and secure database operations across cloud environments.

BackupIntelligent Operationsdatabases
0 likes · 19 min read
Unlocking Intelligent Database Operations: Inside Zyb’s Multi‑Cloud Platform
Open Source Tech Hub
Open Source Tech Hub
Dec 22, 2023 · Databases

Mastering RedisSearch: Build Fast Full-Text Search on Redis with PHP

This guide introduces RedisSearch, walks through installation, explains its rich feature set, details core concepts like data models and indexing, shows command‑line operations for creating indexes and querying, and provides a complete PHP example for integrating RedisSearch into applications.

Full‑Text SearchPHPRedisSearch
0 likes · 9 min read
Mastering RedisSearch: Build Fast Full-Text Search on Redis with PHP
dbaplus Community
dbaplus Community
Dec 13, 2023 · Databases

Tackling the Top 8 Challenges of Domestic Databases in Banking and Proven Strategies

The article examines the rapid growth of domestic databases in China’s banking sector, identifies eight critical pain points—from product stability and resource consumption to tooling gaps and migration difficulties—and offers detailed countermeasures covering version upgrade planning, resource optimization, functional testing, skill development, monitoring, ecosystem building, data migration, and backup‑recovery improvements.

Operationsdatabasesdomestic
0 likes · 16 min read
Tackling the Top 8 Challenges of Domestic Databases in Banking and Proven Strategies
dbaplus Community
dbaplus Community
Dec 12, 2023 · Databases

Why Does MySQL Replication Lag? Causes and Practical Fixes

This article explains the fundamentals of MySQL master‑slave replication, identifies why replication lag occurs—including single‑threaded processing, lock contention, network issues, and outdated versions—and offers concrete strategies such as hardware upgrades, configuration tweaks, and architectural changes to minimize the delay.

Lagdatabasesmysql
0 likes · 7 min read
Why Does MySQL Replication Lag? Causes and Practical Fixes
DataFunTalk
DataFunTalk
Dec 11, 2023 · Databases

Interview with Wu Li on Columnar Storage, JIT Compilation, and Push Mode in Modern Database Systems

The interview with Wu Li, a research engineer at Shanghai Yanhuang Data, explores how columnar storage, JIT compilation, and push-mode processing are reshaping modern database performance, highlighting hardware constraints, software optimizations, and product‑centric goals in the era of big data analytics.

Columnar StorageJIT CompilationOLAP
0 likes · 11 min read
Interview with Wu Li on Columnar Storage, JIT Compilation, and Push Mode in Modern Database Systems
Architect's Guide
Architect's Guide
Dec 8, 2023 · Databases

Why Transaction Isolation Is Needed and Understanding MySQL Isolation Levels

Transaction isolation prevents concurrency issues such as dirty writes, dirty reads, non‑repeatable reads, and phantom reads in MySQL, and the article explains these problems, the ACID properties of transactions, and the four isolation levels—read uncommitted, read committed, repeatable read, and serializable.

ACIDdatabasesmysql
0 likes · 9 min read
Why Transaction Isolation Is Needed and Understanding MySQL Isolation Levels
JavaEdge
JavaEdge
Dec 5, 2023 · Backend Development

Designing a Scalable Instagram Backend: Architecture, Storage, and Timeline Strategies

This article presents a comprehensive backend design for an Instagram‑like service, covering functional and non‑functional requirements, data models, storage choices, top‑level and detailed component designs, timeline generation methods, and an evaluation of scalability, latency, availability, persistence, consistency, and reliability.

Scalabilityarchitecturedatabases
0 likes · 11 min read
Designing a Scalable Instagram Backend: Architecture, Storage, and Timeline Strategies
Huawei Cloud Developer Alliance
Huawei Cloud Developer Alliance
Nov 17, 2023 · Databases

How openGemini’s New Columnar Engine Solves High‑Cardinality Time‑Series Challenges

This article explains why time‑series databases are ideal for massive telemetry data, describes the high‑cardinality problem that degrades performance, and shows how openGemini’s newly introduced columnar engine—combined with sorting and clustering indexes—effectively mitigates those issues while delivering impressive write and query speeds.

Columnar Storagedatabaseshigh-cardinality
0 likes · 7 min read
How openGemini’s New Columnar Engine Solves High‑Cardinality Time‑Series Challenges
Test Development Learning Exchange
Test Development Learning Exchange
Nov 13, 2023 · Fundamentals

Master Core Python, Database, Linux, and Networking Concepts in One Guide

This comprehensive guide covers essential programming fundamentals—including Python memory management, metaclasses, decorators, multithreading, data structures, algorithmic techniques, database concepts such as ACID, indexing, and transaction isolation, Redis operations, Linux memory handling, networking protocols, Docker/Kubernetes commands, and core testing methodologies—providing clear explanations and practical code examples.

AlgorithmsLinuxNetworking
0 likes · 38 min read
Master Core Python, Database, Linux, and Networking Concepts in One Guide
Architecture Digest
Architecture Digest
Nov 11, 2023 · Databases

Redis: From Cache to Distributed Data Store – Benefits, Persistence, and Use Cases

This article explains how Redis evolved from a simple cache to a high‑performance distributed data store, covering its architecture, persistence models, scalability, high‑availability features, complex data structures, and the trade‑offs of using it as a primary database versus a traditional relational system.

Distributed SystemsPersistencecaching
0 likes · 9 min read
Redis: From Cache to Distributed Data Store – Benefits, Persistence, and Use Cases
ITPUB
ITPUB
Nov 10, 2023 · Databases

Why Does MySQL Replication Lag? Causes and Practical Fixes

This article explains what MySQL master‑slave replication lag is, walks through the replication workflow, identifies the main technical reasons for delay such as single‑threaded replay and lock contention, and provides concrete configuration and architectural solutions to reduce or eliminate the lag.

Lagdatabasesmysql
0 likes · 8 min read
Why Does MySQL Replication Lag? Causes and Practical Fixes
JD Retail Technology
JD Retail Technology
Nov 3, 2023 · Backend Development

Order System Architecture Overview and Design

This document outlines the business scope, value, overall and real‑time data layer architecture, design advantages, data model, extensibility, and future challenges of the order system, emphasizing decoupling, high availability, scalability, and cost control.

Backend ArchitectureScalabilitydatabases
0 likes · 12 min read
Order System Architecture Overview and Design
ITPUB
ITPUB
Oct 28, 2023 · Databases

Why Is Single‑Threaded Redis So Fast? Uncover the Secrets

This article explains why Redis, despite being described as single‑threaded, achieves extremely high performance by using a single thread for network I/O and command execution, avoiding multithreading overhead, and leveraging efficient in‑memory data structures together with an event‑driven multiplexing I/O model.

Event-drivenI/O MultiplexingSingle Thread
0 likes · 12 min read
Why Is Single‑Threaded Redis So Fast? Uncover the Secrets
ITPUB
ITPUB
Oct 26, 2023 · Databases

Mastering Case Sensitivity Across Snowflake, Databend, MySQL, and PostgreSQL

This guide explains why case‑sensitivity issues arise in databases, how naming conventions can prevent them, and compares the behavior of Snowflake, Databend, MySQL, and PostgreSQL for database, table, column names and string literals, complete with practical examples and a concise checklist.

DatabendPostgreSQLSQL
0 likes · 6 min read
Mastering Case Sensitivity Across Snowflake, Databend, MySQL, and PostgreSQL
php Courses
php Courses
Oct 20, 2023 · Backend Development

Advantages of PHP in Modern Web Development

PHP remains a resilient, versatile server‑side language whose active community, regular updates, strong security, seamless database integration, and efficient server‑side scripting deliver fast, dynamic, and interactive web applications, making it a pivotal technology in modern web development.

Web Developmentdatabasesserver-side
0 likes · 4 min read
Advantages of PHP in Modern Web Development
Liangxu Linux
Liangxu Linux
Oct 11, 2023 · Databases

Beyond MySQL: A Practical Guide to 10+ Database Types and Their Ideal Use‑Cases

This article provides a concise yet comprehensive overview of relational, key‑value, document, search‑engine, time‑series, vector, spatial, graph, columnar, and multimodel databases, explaining their data models, typical queries, core advantages, and popular implementations to help developers choose the right storage solution for any project.

ColumnarNoSQLRelational
0 likes · 16 min read
Beyond MySQL: A Practical Guide to 10+ Database Types and Their Ideal Use‑Cases
Top Architect
Top Architect
Oct 11, 2023 · Databases

Understanding Redis Memory Eviction Policies and Configuration

This article explains how Redis uses the maxmemory setting to trigger memory eviction, details the various eviction policies (including LRU and LFU), shows how to query and modify these settings with config commands, and briefly mentions promotional offers for a ChatGPT community.

LFULRUdatabases
0 likes · 10 min read
Understanding Redis Memory Eviction Policies and Configuration
Architect
Architect
Sep 28, 2023 · Databases

How to Pick the Best Storage Engine for High‑Throughput Browsing Records: Redis, MySQL or Tair?

This article walks through a real‑world e‑commerce scenario where billions of daily browsing events generate over 100K TPS writes, evaluates storage options on reliability, cost, read/write performance and implementation difficulty, and ultimately recommends Tair after detailed analysis of List, Sorted‑Set and Hash structures, code examples, and concurrency controls.

Tairconcurrencydata modeling
0 likes · 15 min read
How to Pick the Best Storage Engine for High‑Throughput Browsing Records: Redis, MySQL or Tair?
Tencent Tech
Tencent Tech
Sep 27, 2023 · Databases

PolySI & Tesseract: New Black‑Box Tools for Snapshot Isolation & Schema Evolution

Tencent Cloud, in collaboration with Nanjing University, ETH Zurich, and Simon Fraser University, presented two VLDB‑2023 papers introducing PolySI, a black‑box checker for snapshot isolation, and Tesseract, an online, transactional schema‑evolution technique, both demonstrating superior performance and practical impact on modern cloud databases.

VLDBblack-box testingdatabases
0 likes · 7 min read
PolySI & Tesseract: New Black‑Box Tools for Snapshot Isolation & Schema Evolution
ITPUB
ITPUB
Sep 22, 2023 · Databases

Where Does Database Innovation Come From? Exploring the Future of Distributed Databases

The article examines the driving forces behind database innovation, emphasizing the role of inherent shortcomings, AI integration, and the emergence of third‑generation distributed databases that aim for minimal usability, controllable latency high availability, and 100% data correctness.

Distributed SystemsInnovationdata correctness
0 likes · 11 min read
Where Does Database Innovation Come From? Exploring the Future of Distributed Databases
dbaplus Community
dbaplus Community
Sep 21, 2023 · Databases

Why Smaller DB Connection Pools Boost Performance: Real-World Test Insights

Through a detailed analysis of Oracle and PostgreSQL benchmarks, this article reveals why reducing database connection pool size—often to far fewer than the number of concurrent users—significantly cuts wait times and response latency, and provides a practical formula for sizing pools based on CPU cores and disk resources.

BenchmarkConnection Poolingdatabases
0 likes · 10 min read
Why Smaller DB Connection Pools Boost Performance: Real-World Test Insights
dbaplus Community
dbaplus Community
Sep 6, 2023 · Backend Development

How to Scale a Schema‑Free Classification Platform to 100 Billion Records

This article explains how to design a classification‑information system that handles 100 billion rows, ten‑thousand dynamic attributes, and hundreds of thousands of QPS by using vertical partitioning, unified metadata services, and an external search layer for scalable storage and retrieval.

Backenddatabasesmetadata
0 likes · 12 min read
How to Scale a Schema‑Free Classification Platform to 100 Billion Records
JD Tech
JD Tech
Aug 30, 2023 · Databases

A Comprehensive Overview of Database Evolution, Types, and Data Structure Design Techniques

This article explains key database terminology, traces the history of database technologies, compares relational, NoSQL, NewSQL, OLTP/OLAP, columnar, time‑series and graph databases, and demonstrates practical data‑structure designs such as zipper tables, bit operations, bitmaps, bloom filters, and ring queues for software development.

Big DataData StructuresNoSQL
0 likes · 27 min read
A Comprehensive Overview of Database Evolution, Types, and Data Structure Design Techniques
IT Services Circle
IT Services Circle
Aug 26, 2023 · Databases

An Overview of Different Types of Databases

This article introduces and compares major database categories—including relational, key‑value, document, columnar, graph, and time‑series databases—explaining their structures, typical use cases, and advantages, helping readers understand when to choose each type for various applications.

DocumentKey-ValueNoSQL
0 likes · 7 min read
An Overview of Different Types of Databases
dbaplus Community
dbaplus Community
Aug 26, 2023 · Databases

What Is a Vector Database? A Simple Guide from Kids to Engineers

This article demystifies vector databases by first explaining the concept with a five‑year‑old analogy, then expanding to technical details for developers, covering how embeddings work, the differences from relational databases, ANN search, indexing, similarity metrics, and why vector stores outperform raw NumPy arrays for large‑scale similarity retrieval.

ANNdatabasesmachine learning
0 likes · 9 min read
What Is a Vector Database? A Simple Guide from Kids to Engineers
360 Quality & Efficiency
360 Quality & Efficiency
Aug 4, 2023 · Databases

Understanding MySQL Query Execution, Indexes, Slow Queries and Optimization Practices

This article explains MySQL’s server and storage‑engine architecture, walks through the step‑by‑step execution of a SELECT statement, describes how indexes are organized, defines slow queries, shows how to detect and analyze them, and provides practical optimization examples and additional MySQL pitfalls.

Database OptimizationSQLdatabases
0 likes · 13 min read
Understanding MySQL Query Execution, Indexes, Slow Queries and Optimization Practices
Architect
Architect
Jul 19, 2023 · Databases

Understanding Redis LRU and LFU Cache Eviction Algorithms

This article explains the principles, implementation details, and trade‑offs of Redis’s LRU and LFU cache eviction algorithms, including their data structures, code snippets, configuration parameters, and practical guidance on choosing the appropriate strategy based on workload characteristics.

Cache EvictionLFULRU
0 likes · 13 min read
Understanding Redis LRU and LFU Cache Eviction Algorithms
ITPUB
ITPUB
Jul 13, 2023 · Databases

Exploring 10+ Database Types: From Relational to Vector and Beyond

This article provides a concise yet comprehensive overview of over ten database categories—including relational, key‑value, document, time‑series, vector, spatial, graph, columnar, and multi‑model systems—explaining their core concepts, typical use cases, popular implementations, and underlying storage mechanisms.

ColumnarRelationalVector
0 likes · 16 min read
Exploring 10+ Database Types: From Relational to Vector and Beyond
Big Data Technology Architecture
Big Data Technology Architecture
Jul 8, 2023 · Databases

Industry Leaders Discuss the Integration of Databases, Big Data, and AI in Modern Enterprise Data Platforms

In a round‑table interview, former Alibaba executive Jia Yangqing, Yunqi CTO Guan Tao, and OtterTune co‑founder Zhang Bohan explore how databases, big data, and AI converge, the distinctions between “AI for Data” and “Data for AI,” and what enterprises need in an integrated AI‑enabled data platform.

Data Platformsdatabasesenterprise architecture
0 likes · 23 min read
Industry Leaders Discuss the Integration of Databases, Big Data, and AI in Modern Enterprise Data Platforms
Python Programming Learning Circle
Python Programming Learning Circle
Jul 4, 2023 · Fundamentals

2023 Stack Overflow Developer Survey: Top Languages, Databases, Frameworks, and AI Tool Usage

According to the 2023 Stack Overflow Developer Survey of over 90,000 respondents, JavaScript remains the most popular language, PostgreSQL tops databases, Node.js and React dominate web technologies, Zig tops highest‑earning languages, and AI tools like ChatGPT and GitHub Copilot see widespread adoption, reshaping development workflows.

AI toolsStack Overflow Surveydatabases
0 likes · 6 min read
2023 Stack Overflow Developer Survey: Top Languages, Databases, Frameworks, and AI Tool Usage
php Courses
php Courses
Jul 4, 2023 · Databases

Using Redis with Python for Data Storage and Retrieval

This article explains how to install and configure Redis, connect to it using Python's redis library, and demonstrates storing and retrieving various data structures—including strings, hashes, lists, sets, and sorted sets—followed by proper disconnection, providing a practical guide for Python developers.

Data StructuresPythoncaching
0 likes · 3 min read
Using Redis with Python for Data Storage and Retrieval