BestHub
search
Sign in
Tag

SQL Best Practices

1 views collected around this technical thread.

DataFunSummit
DataFunSummit
Feb 18, 2022 · Databases

ClickHouse Usage Guide: Application Scenarios, Table Engine Selection, Development Standards, Cluster Architecture, and Configuration

This comprehensive guide introduces ClickHouse as a high‑performance columnar DBMS, outlines its typical OLAP use cases, explains the four families of table engines with detailed MergeTree variants, provides SQL creation syntax, shares development and write best practices, and describes cluster architecture, Zookeeper role, chproxy, client tools, availability considerations, and key configuration parameters.

ClickHouseCluster ArchitectureDatabases
0 likes · 22 min read
ClickHouse Usage Guide: Application Scenarios, Table Engine Selection, Development Standards, Cluster Architecture, and Configuration
Efficient Ops
Efficient Ops
Jul 1, 2020 · Databases

Essential MySQL Naming, Design, and Indexing Standards for Reliable Databases

This guide outlines comprehensive MySQL best practices covering naming conventions, table engine and charset choices, field type selection, index design principles, common index column recommendations, ordering of composite indexes, avoidance of redundant and foreign‑key constraints, SQL development rules, and operational guidelines for large‑scale data handling.

Index OptimizationMySQLPerformance Tuning
0 likes · 21 min read
Essential MySQL Naming, Design, and Indexing Standards for Reliable Databases
Laravel Tech Community
Laravel Tech Community
May 7, 2020 · Databases

MySQL Database Naming, Design, Field, Index, and Operation Standards

This guide presents comprehensive MySQL best‑practice standards covering object naming, basic schema design, field definitions, index design, common index column recommendations, covering indexes, SET usage, SQL development rules, and safe operational behaviors to improve performance, maintainability, and security.

MySQLSQL Best Practicesdatabase design
0 likes · 19 min read
MySQL Database Naming, Design, Field, Index, and Operation Standards
Laravel Tech Community
Laravel Tech Community
May 2, 2020 · Databases

MySQL Database Naming, Design, Indexing, and Development Standards

This comprehensive guide outlines MySQL database naming conventions, basic design rules, field specifications, index design principles, common index recommendations, and best practices for SQL development and operational behavior to ensure performance, maintainability, and security.

MySQLSQL Best Practicesdatabase design
0 likes · 18 min read
MySQL Database Naming, Design, Indexing, and Development Standards
Architect's Tech Stack
Architect's Tech Stack
Jul 25, 2019 · Databases

Database Command and Design Standards

The article outlines comprehensive MySQL database standards covering naming conventions, table and column design, index strategies, SQL development practices, and operational guidelines to improve performance, maintainability, and security, including recommendations on data types, character sets, reserved fields, binary data storage, and safe query patterns.

DatabaseSQL Best Practicesindex design
0 likes · 21 min read
Database Command and Design Standards
Architecture Digest
Architecture Digest
Apr 18, 2019 · Databases

MySQL High Performance Optimization Guidelines and Best Practices

This article presents a comprehensive set of MySQL high‑performance optimization guidelines, covering naming conventions, table design, data types, index strategies, SQL coding standards, replication, backup, and operational best practices to improve efficiency, reliability, and scalability of database systems.

MySQLOperationsPerformance Optimization
0 likes · 19 min read
MySQL High Performance Optimization Guidelines and Best Practices
Efficient Ops
Efficient Ops
Mar 12, 2019 · Databases

Master MySQL: Essential Naming, Design, and Indexing Standards

This guide outlines comprehensive MySQL best practices, covering naming conventions, basic schema design, field type selection, index strategies, foreign‑key usage, SQL coding standards, batch operations, online schema changes, and permission principles to ensure performant and maintainable databases.

MySQLSQL Best Practicesdatabase design
0 likes · 20 min read
Master MySQL: Essential Naming, Design, and Indexing Standards