BestHub
Sign in
Tagged articles
36 articles
Page 1 of 1
Frontend AI Walk
Frontend AI Walk
Mar 31, 2026 · Artificial Intelligence

How to Build an AI‑Agent Friendly npm Package: From Concept to Full Implementation

This guide walks developers through the shift from traditional deterministic npm libraries to AI‑agent compatible components, covering conceptual changes, three‑layer architecture, schema design, context awareness, error handling, observability, and step‑by‑step implementation with real code examples and integration adapters for LangChain and LlamaIndex.

AI agentsNode.jsObservability
0 likes · 19 min read
How to Build an AI‑Agent Friendly npm Package: From Concept to Full Implementation
Tech Musings
Tech Musings
Feb 12, 2026 · Databases

From MySQL to Apache Doris: Key Design Shifts for OLAP Migration

This article explains how backend engineers should rethink table design, indexing, partitioning, and key strategies when migrating attendance data from MySQL's OLTP model to Apache Doris 2.1.7's OLAP architecture, providing concrete DDL examples and practical tips.

Apache DorisOLAPPartitioning
0 likes · 12 min read
From MySQL to Apache Doris: Key Design Shifts for OLAP Migration
Wu Shixiong's Large Model Academy
Wu Shixiong's Large Model Academy
Dec 15, 2025 · Artificial Intelligence

Mastering Text2SQL: From Schema Design to Secure Multi‑Step LLM Pipelines

This article explains how Text2SQL works by teaching LLMs to understand a closed‑world database schema, constructing tightly constrained prompts, validating generated SQL, handling execution errors, and using a second LLM call to translate results into natural language, while highlighting common pitfalls and engineering best practices.

LLMSQL ValidationText2SQL
0 likes · 9 min read
Mastering Text2SQL: From Schema Design to Secure Multi‑Step LLM Pipelines
Wu Shixiong's Large Model Academy
Wu Shixiong's Large Model Academy
Dec 5, 2025 · Artificial Intelligence

Why Do LLM Function Calls Hallucinate Parameters and How to Prevent It?

This article explains the root causes of hallucinated parameters in LLM Function Calls, outlines five common failure patterns, and presents a systematic five‑step engineering framework—including schema design, prompt rules, dynamic routing, result validation, and clarification—to reliably eliminate such errors in real‑world AI agents.

AI AgentLLMfunction call
0 likes · 11 min read
Why Do LLM Function Calls Hallucinate Parameters and How to Prevent It?
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Sep 22, 2025 · Databases

Master Database Table Naming: Clear, Consistent, and Meaningful Designs

This guide explains how to design clear and maintainable database schemas by using meaningful prefixes, full English names, consistent suffixes for booleans, timestamps, and foreign keys, and by applying best‑practice naming conventions, redundancy strategies, and relationship modeling to improve readability and performance.

Database designSQLbest practices
0 likes · 14 min read
Master Database Table Naming: Clear, Consistent, and Meaningful Designs
Architecture Digest
Architecture Digest
Sep 9, 2025 · Databases

How to Safely Add a Column to a Billion‑Row Order Table Without Downtime

When a core order table with tens of millions of rows needs a new column, naïve ALTER TABLE can lock the table and cause outages, so this article explores master‑slave switching, online schema‑change tools, JSON or redundant fields, and practical tips for low‑risk, production‑grade schema evolution.

DDLOnline Schema Changedatabase migration
0 likes · 7 min read
How to Safely Add a Column to a Billion‑Row Order Table Without Downtime
Architect
Architect
Jun 1, 2025 · Databases

Dynamic Extension of Fields in Billion‑Row Core Tables: Architecture and Implementation

To avoid lock, page split, and index degradation when adding fields to billion‑row core tables, this article presents a practical solution that uses dynamic field extension via configurable management, JSON‑based extension fields, and an extension‑table architecture integrated with Elasticsearch for storage and retrieval.

Dynamic FieldsElasticsearchdatabases
0 likes · 10 min read
Dynamic Extension of Fields in Billion‑Row Core Tables: Architecture and Implementation
Java Architecture Stack
Java Architecture Stack
Sep 25, 2024 · Databases

When to Use NOT NULL vs NULL in Database Design: Practical Guidelines

This article explains when to use NOT NULL versus NULL in relational database schemas, covering required fields, optional columns, unknown‑state representation, foreign keys, performance impact, versioning, data analysis, migration, default values and JSON types, with concrete SQL examples and practical guidance.

JSONSQLdata integrity
0 likes · 13 min read
When to Use NOT NULL vs NULL in Database Design: Practical Guidelines
ITPUB
ITPUB
May 5, 2024 · Databases

What GitLab’s 34k‑Line Postgres Schema Reveals About Scalable Database Design

This article examines GitLab’s extensive PostgreSQL schema, explaining why the project uses a pure‑SQL structure file, how primary‑key choices, internal versus external IDs, naming conventions, timestamps, text types, partitioning, GIN indexes, JSONB columns, foreign‑key strategies and other data‑type decisions impact performance, maintainability, and scalability.

JSONBPartitioningPostgreSQL
0 likes · 25 min read
What GitLab’s 34k‑Line Postgres Schema Reveals About Scalable Database Design
Didi Tech
Didi Tech
Jan 18, 2024 · Backend Development

XIAOJUSURVEY: A Lightweight and Secure Open-Source Survey System

XIAOJUSURVEY is an open-source, lightweight yet secure enterprise-grade survey platform derived from Didi’s internal system, offering end-to-end questionnaire creation, distribution, collection, analysis and reporting, with customizable question types, schema-based architecture, pluggable security, and future extensions for collaboration and market-place features.

Software ArchitectureSurvey SystemUser experience
0 likes · 9 min read
XIAOJUSURVEY: A Lightweight and Secure Open-Source Survey System
Alibaba Cloud Developer
Alibaba Cloud Developer
Jun 9, 2023 · Artificial Intelligence

Designing Scalable Knowledge Graph Schemas: From Structure to Semantic Modeling

This guide presents a comprehensive methodology for building knowledge graph schemas that decouple structural representation from semantic meaning, covering schema design, attribute semantic standardization, concept modeling, multi‑relational and hypergraph techniques, and practical steps for implementation across complex business domains.

AIKnowledge GraphSemantic Modeling
0 likes · 54 min read
Designing Scalable Knowledge Graph Schemas: From Structure to Semantic Modeling
IT Architects Alliance
IT Architects Alliance
Apr 11, 2023 · Databases

MySQL Execution Process and Comprehensive Optimization Best Practices

This article explains MySQL's query execution flow and provides extensive best‑practice guidelines—including naming conventions, storage engine choices, primary‑key design, character set settings, query writing tips, indexing strategies, batch operations, and performance‑enhancing techniques—to help developers write efficient and maintainable SQL code.

Database PerformanceQuery TuningSQL Optimization
0 likes · 24 min read
MySQL Execution Process and Comprehensive Optimization Best Practices
Su San Talks Tech
Su San Talks Tech
Aug 26, 2022 · Databases

15 Essential Database Table Design Tips Every Backend Engineer Should Know

This article presents 15 practical guidelines for designing MySQL tables—covering naming conventions, field types, lengths, primary keys, indexes, storage engines, character sets, collations, and large fields—to help backend developers build maintainable, efficient, and reliable database schemas.

MySQL Best Practicesschema designtable naming
0 likes · 19 min read
15 Essential Database Table Design Tips Every Backend Engineer Should Know
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
Architecture & Thinking
Architecture & Thinking
May 31, 2022 · Databases

Master Database Naming: Standards, Design & SQL Best Practices

This comprehensive guide details naming conventions for databases, tables, columns, indexes, views, procedures, functions, triggers, users, and constraints, along with design principles for objects, storage engines, character sets, table structures, field types, index strategies, and SQL usage to ensure consistency, performance, and maintainability in MySQL environments.

Database NamingSQL Standardsbest practices
0 likes · 22 min read
Master Database Naming: Standards, Design & SQL Best Practices
Laravel Tech Community
Laravel Tech Community
Dec 23, 2021 · Databases

Database Object Naming and Design Standards

This guide details comprehensive naming conventions and design best‑practices for MySQL database objects—including schemas, tables, indexes, views, stored procedures, functions, triggers, constraints, and users—along with recommended storage engine, character set, field types, index strategies, and SQL usage rules to ensure consistency, performance, and maintainability.

Naming ConventionSQLindexing
0 likes · 20 min read
Database Object Naming and Design Standards
Java Architect Essentials
Java Architect Essentials
Nov 15, 2021 · Databases

MySQL Optimization: Concepts, Schema Design, Indexes, and Query Tuning

This article provides a comprehensive overview of MySQL fundamentals—including logical architecture, locks, transactions, and storage engines—and offers practical optimization strategies for schema design, data types, indexing, and query execution, supplemented with code examples and performance‑analysis tips.

Database OptimizationQuery TuningTransactions
0 likes · 14 min read
MySQL Optimization: Concepts, Schema Design, Indexes, and Query Tuning
dbaplus Community
dbaplus Community
Jan 11, 2021 · Databases

Why eBay Switched Its Ad Analytics from Druid to ClickHouse – A Deep Dive

eBay’s ad data platform, originally built on a custom SQL engine and later migrated to Druid, was re‑engineered to use ClickHouse, highlighting challenges such as massive data volume, atomic offline replacements, schema design, compression, and operational simplifications, and demonstrating performance and scalability gains for advertisers.

Ad AnalyticsBig DataClickHouse
0 likes · 18 min read
Why eBay Switched Its Ad Analytics from Druid to ClickHouse – A Deep Dive
Top Architect
Top Architect
Dec 29, 2020 · Backend Development

Migrating OkCupid from REST to GraphQL: Process, Lessons, and Outcomes

The article details OkCupid’s year‑and‑a‑half migration from a REST API to a production GraphQL API, describing the four‑step process—page selection, schema construction, shadow requests, and A/B testing—along with lessons learned about error handling, business‑logic placement, and performance monitoring.

A/B testingAPI MigrationApollo Server
0 likes · 9 min read
Migrating OkCupid from REST to GraphQL: Process, Lessons, and Outcomes
Liangxu Linux
Liangxu Linux
Nov 1, 2020 · Databases

100 MySQL Interview Q&A: Indexes, Transactions, and Schema Design Essentials

This article compiles 100 common MySQL interview questions covering index structures, hash vs B‑tree trade‑offs, clustering, transaction isolation levels, lock types, primary key choices, storage engines, data types, binlog formats, pagination strategies, and best practices for schema design and query optimization.

SQLStorage EngineTransactions
0 likes · 21 min read
100 MySQL Interview Q&A: Indexes, Transactions, and Schema Design Essentials
Code Ape Tech Column
Code Ape Tech Column
Sep 1, 2020 · Databases

Comprehensive Guide to MySQL Database Optimization: SQL Tuning, Index Strategies, and Best Practices

This article presents a thorough overview of MySQL performance tuning, covering step‑by‑step SQL optimization techniques, common pitfalls, index and table‑structure improvements, cache parameter adjustments, and practical guidelines to reduce I/O and CPU bottlenecks while maintaining data integrity.

Database PerformanceQuery TuningSQL Optimization
0 likes · 28 min read
Comprehensive Guide to MySQL Database Optimization: SQL Tuning, Index Strategies, and Best Practices
ITPUB
ITPUB
Jun 17, 2020 · Databases

Why Go All‑in on MongoDB? Architecture, HA, Sharding & Schema Design Explained

This article explains why a fast‑growing e‑commerce platform chose MongoDB, covering its high‑availability replica‑set architecture, Raft‑based election algorithm, replica‑set size limits, write‑concern trade‑offs, sharding components and load‑balancing, as well as the flexible document schema with practical code examples.

Database ArchitectureMongoDBhigh availability
0 likes · 13 min read
Why Go All‑in on MongoDB? Architecture, HA, Sharding & Schema Design Explained
Selected Java Interview Questions
Selected Java Interview Questions
May 7, 2020 · Databases

MySQL Fundamentals and Optimization: Concepts, Schema Design, Indexes, and Query Tuning

This article explains MySQL's core architecture, lock and transaction mechanisms, storage engines, and provides practical creation‑time and query‑time optimization techniques such as proper data types, index selection, query rewriting, and performance analysis using EXPLAIN, supplemented with concrete SQL examples.

Database OptimizationTransactionsindexes
0 likes · 10 min read
MySQL Fundamentals and Optimization: Concepts, Schema Design, Indexes, and Query Tuning
Aotu Lab
Aotu Lab
Dec 5, 2019 · Databases

Mastering One-to-N Relationships in MongoDB: Practical Design Patterns and Tips

This multi‑part guide explains how to model One‑to‑N relationships in MongoDB, covering basic patterns for one‑to‑few, one‑to‑many, and one‑to‑squillions, then advancing to two‑way referencing and denormalization, and finally offering a concise set of rules of thumb for choosing the right schema design.

DenormalizationEmbeddingMongoDB
0 likes · 21 min read
Mastering One-to-N Relationships in MongoDB: Practical Design Patterns and Tips
Java Captain
Java Captain
Oct 11, 2019 · Databases

MySQL Optimization: Concepts, Schema Design, Indexing, and Query Tuning

This article introduces MySQL fundamentals, covering logical architecture, locking, transactions, storage engines, schema and data type design, as well as index types and their constraints, plus practical creation‑time and query‑time optimization techniques with code examples and best‑practice recommendations.

Database OptimizationQuery TuningTransactions
0 likes · 11 min read
MySQL Optimization: Concepts, Schema Design, Indexing, and Query Tuning
Tencent Cloud Developer
Tencent Cloud Developer
Sep 17, 2018 · Databases

MySQL Schema Design and SQL Development Standards Practice

Tencent Cloud Academy will livestream a MySQL schema design and development standards session on September 17 at 20:00, featuring experts Ye Jinrong and Wu Bingxi, covering best practices such as default InnoDB engine, utf8mb4 charset, row size limits, partitioning, appropriate data types, index guidelines, and operational recommendations.

Database AdministrationDevelopment StandardsInnoDB
0 likes · 9 min read
MySQL Schema Design and SQL Development Standards Practice
Efficient Ops
Efficient Ops
Aug 27, 2017 · Databases

Master MySQL: Core Scenarios, Engines, and Performance Optimization

This article provides a comprehensive overview of MySQL, covering its primary application scenarios, architecture diagram, detailed storage engine characteristics, factors influencing server performance, lock mechanisms, query and schema optimization techniques, scalability strategies such as data sharding, and the role of caching and search technologies.

Storage Enginesmysqlschema design
0 likes · 22 min read
Master MySQL: Core Scenarios, Engines, and Performance Optimization
ITPUB
ITPUB
Jul 7, 2017 · Databases

Why Most MySQL Optimization Tips Miss the Mark—and a Better Checklist

The article critiques a popular MySQL tuning list, explains why many of its suggestions are misguided, and presents a more practical, performance‑focused checklist that covers benchmarking, schema design, indexing, query rewriting, and engine‑specific tricks.

Database Enginesmysqlschema design
0 likes · 11 min read
Why Most MySQL Optimization Tips Miss the Mark—and a Better Checklist
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Nov 18, 2016 · Databases

Mastering Database Schema: From Normalization to Sharding Strategies

This article explores core database design concepts, covering normalization principles, denormalization tactics, schema simplification, MySQL architecture, various data partitioning methods—including vertical, horizontal, logical, and time‑based sharding—and practical routing and storage optimizations for high‑performance systems.

Denormalizationdatabasesnormalization
0 likes · 27 min read
Mastering Database Schema: From Normalization to Sharding Strategies
21CTO
21CTO
Sep 12, 2015 · Databases

Master MySQL Optimization: Practical Tips for Performance, Hardware, and Schema

This comprehensive guide explores MySQL's unique characteristics, hardware and OS tuning, configuration tweaks, schema and SQL optimization techniques, and provides actionable recommendations and tools to identify and resolve common performance bottlenecks.

Database TuningHardware ConfigurationPerformance Optimization
0 likes · 13 min read
Master MySQL Optimization: Practical Tips for Performance, Hardware, and Schema