BestHub
Sign in
Tagged articles
15 articles
Page 1 of 1
21CTO
21CTO
Sep 27, 2025 · Databases

PostgreSQL 18 Unveiled: Async I/O, OAuth Security, and SQL Boosts Explained

PostgreSQL 18 introduces async I/O for faster queries, built‑in OAuth authentication, expanded SQL standard support, optimizer and extension enhancements, and tighter Kubernetes integration, delivering higher performance, stronger security, and greater flexibility for developers and DBAs tackling modern analytics, AI workloads, and distributed environments.

ExtensionsKubernetesOAuth
0 likes · 8 min read
PostgreSQL 18 Unveiled: Async I/O, OAuth Security, and SQL Boosts Explained
dbaplus Community
dbaplus Community
Aug 18, 2022 · Databases

Mastering MySQL Naming Conventions: From Schemas to Indexes

This guide presents comprehensive MySQL naming standards covering database objects, schemas, tables, columns, indexes, views, stored procedures, functions, triggers, constraints, and users, along with design principles for storage engines, character sets, table structures, and SQL query best practices.

SQL Standardsmysqlnaming conventions
0 likes · 21 min read
Mastering MySQL Naming Conventions: From Schemas to Indexes
Senior Brother's Insights
Senior Brother's Insights
Jun 6, 2022 · Databases

Comprehensive Guide to Database Object Naming and Design Standards

This guide outlines detailed naming conventions for databases, tables, columns, indexes, views, stored procedures, functions, triggers, constraints, and users, plus best practices for storage engine, charset, table design, field types, index design, and SQL usage to ensure consistency, performance, and maintainability.

Constraint GuidelinesDatabase NamingMySQL Best Practices
0 likes · 21 min read
Comprehensive Guide to Database Object Naming and Design Standards
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
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Dec 3, 2020 · Databases

Essential MySQL Design & Development Standards for Reliable Databases

This guide outlines comprehensive MySQL best‑practice standards covering naming conventions, storage engine selection, charset usage, table and column comments, size limits, partitioning, hot‑cold data separation, index design, SQL coding rules, and operational safeguards to ensure performant, maintainable, and secure database systems.

Database designSQL Standardsbest practices
0 likes · 22 min read
Essential MySQL Design & Development Standards for Reliable Databases
dbaplus Community
dbaplus Community
Oct 25, 2020 · Databases

Essential MySQL Database Standards: Table, SQL, and Index Guidelines

This article presents a comprehensive MySQL database standard covering table creation rules, SQL writing conventions, and index design recommendations, explaining the rationale behind each mandatory or suggested practice to improve performance, maintainability, and consistency across projects.

Database designSQL Standardsmysql
0 likes · 13 min read
Essential MySQL Database Standards: Table, SQL, and Index Guidelines
DataFunTalk
DataFunTalk
Oct 7, 2020 · Big Data

Yanxuan Data Warehouse: Architecture, Standards, and Evaluation Framework

This article outlines the Yanxuan data warehouse’s layered architecture, the offline and real‑time development platforms, the comprehensive standards for metric definition, model design, and SQL development, and proposes a six‑dimensional evaluation system covering data norms, security, quality, stability, continuous improvement, and development efficiency.

Big DataData GovernanceSQL Standards
0 likes · 12 min read
Yanxuan Data Warehouse: Architecture, Standards, and Evaluation Framework
Laravel Tech Community
Laravel Tech Community
Aug 2, 2020 · Databases

MySQL Database Design and SQL Writing Standards

This document outlines comprehensive MySQL database design standards and SQL writing guidelines, covering naming conventions, character sets, table and column specifications, index design, partitioning, data types, transaction handling, and prohibited statements to ensure stable, performant, and maintainable production databases.

PartitioningSQL Standardsindexing
0 likes · 18 min read
MySQL Database Design and SQL Writing Standards
Senior Brother's Insights
Senior Brother's Insights
Apr 20, 2019 · Databases

Essential MySQL Database Design and Coding Standards for Reliable Systems

This guide outlines comprehensive MySQL naming conventions, table and column design rules, indexing best practices, SQL coding standards, and operational recommendations to improve performance, maintainability, and security while avoiding common pitfalls such as redundant indexes, unsafe data types, and excessive batch operations.

Database designSQL Standardsbest practices
0 likes · 19 min read
Essential MySQL Database Design and Coding Standards for Reliable Systems
Java Captain
Java Captain
Mar 20, 2019 · Databases

Comprehensive MySQL Database Design and Development Standards

This article presents a detailed set of MySQL database naming conventions, design principles, field type recommendations, index strategies, and SQL development best practices to improve performance, maintainability, and security while avoiding common pitfalls such as reserved keywords, oversized tables, and inefficient queries.

SQL Standardsindexingmysql
0 likes · 17 min read
Comprehensive MySQL Database Design and Development Standards
21CTO
21CTO
Jan 19, 2019 · Databases

Essential MySQL Standards: Naming, Design, Indexing, and SQL Best Practices

This guide outlines comprehensive MySQL standards covering object naming conventions, basic design rules, field type choices, index creation strategies, and SQL development practices to improve performance, maintainability, and security across database projects.

Index OptimizationSQL Standardsmysql
0 likes · 18 min read
Essential MySQL Standards: Naming, Design, Indexing, and SQL Best Practices
dbaplus Community
dbaplus Community
Jul 20, 2017 · Databases

Master MySQL Backup, Security, and SQL Best Practices: A Complete Guide

This article provides a comprehensive, step‑by‑step guide on MySQL backup strategies, security hardening, SQL coding standards, and system planning, offering practical recommendations, verification methods, and actionable checklists to help DBAs build resilient and well‑managed database environments.

BackupDBADatabase Planning
0 likes · 26 min read
Master MySQL Backup, Security, and SQL Best Practices: A Complete Guide