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
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