All Database Design Solutions on Gang of Coders

Total of 197 Database Design Solutions

Database, Table and Column Naming Conventions?

DatabaseDatabase DesignLanguage AgnosticNaming Conventions

What's the difference between identifying and non-identifying relationships?

DatabaseDatabase DesignData ModelingIdentifying Relationship

Difference between scaling horizontally and vertically for databases

DatabaseDatabase DesignNosqlScalability

MongoDB vs. Cassandra

MongodbDatabase DesignCassandraDatabase

Database development mistakes made by application developers

DatabaseDatabase Design

What is the ideal data type to use when storing latitude / longitude in a MySQL database?

MysqlDatabase DesignMapsMappingLatitude Longitude

Can I have multiple primary keys in a single table?

DatabaseDatabase DesignPrimary KeyComposite Primary-Key

Is storing a delimited list in a database column really that bad?

DatabaseDatabase DesignDatabase Normalization

What are the best practices for using a GUID as a primary key, specifically regarding performance?

Sql ServerEntity FrameworkDatabase DesignPrimary KeyGuid

Should each and every table have a primary key?

DatabaseDatabase Design

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

SqlDatabase DesignForeign KeysRelational DatabaseRelationship

What are the lengths of Location Coordinates, latitude and longitude?

Database DesignLatitude Longitude

Auto Generate Database Diagram MySQL

MysqlDatabaseDatabase DesignDiagram

Calendar Recurring/Repeating Events - Best Storage Method

Database DesignCalendar

What are OLTP and OLAP. What is the difference between them?

DatabaseDatabase DesignDatabase SchemaOlapOltp

What does character set and collation mean exactly?

MysqlDatabaseDatabase DesignCharacter Set

Recommended SQL database design for tags or tagging

SqlDatabase DesignTagsData ModelingTagging

Create unique constraint with null columns

SqlPostgresqlDatabase DesignNullReferential Integrity

How can you represent inheritance in a database?

Sql ServerInheritanceDatabase DesignClass Table-Inheritance

Relational Database Design Patterns?

Design PatternsDatabase DesignRdbms

What are database normal forms and can you give examples?

DatabaseDatabase DesignDatabase Normalization

Max length for client ip address

SqlDatabaseDatabase Design

What does ON [PRIMARY] mean?

SqlSql ServerDatabaseDatabase Design

What does principal end of an association means in 1:1 relationship in Entity framework

C#Entity FrameworkDatabase DesignForeign Key-Relationship

What's wrong with foreign keys?

DatabaseDatabase DesignForeign KeysReferential IntegrityData Integrity

Schema for a multilanguage database

Database DesignLocalizationMultilingual

"Prevent saving changes that require the table to be re-created" negative effects

Sql ServerSql Server-2008Database DesignSql Server-2005

First-time database design: am I overengineering?

MysqlDatabaseDatabase DesignSchemaDatabase Normalization

Use email address as primary key?

SqlDatabaseDatabase DesignPostgresql

What's the longest possible worldwide phone number I should consider in SQL varchar(length) for phone

Sql ServerValidationDatabase DesignData ModelingPhone Number

What are best practices for multi-language database design?

SqlDatabaseDatabase Design

How big can a user agent string get?

HttpDatabase DesignHttp HeadersUser Agent

Remove Primary Key in MySQL

MysqlSqlDatabase DesignPrimary KeyMysql Error-1075

What should every developer know about databases?

DatabaseLanguage AgnosticDatabase Design

Strings as Primary Keys in SQL Database

SqlDatabaseDatabase DesignStringPrimary Key

Is there a good reason I see VARCHAR(255) used so often (as opposed to another length)?

DatabaseDatabase DesignTypesVarchar

How to version control a record in a database

Database DesignArchitectureVersioningAuditing

Is it better to use multiple databases with one schema each, or one database with multiple schemas?

DatabaseDatabase DesignPostgresqlDatabase Permissions

How big is too big for a PostgreSQL table?

SqlRuby on-RailsPerformancePostgresqlDatabase Design

Surrogate vs. natural/business keys

DatabaseDatabase DesignPrimary KeyKey

Storing money in a decimal column - what precision and scale?

SqlDatabaseDatabase DesignCurrency

PostgreSQL: Which Datatype should be used for Currency?

SqlPostgresqlDatabase Design

Relational table naming convention

DatabaseDatabase DesignCoding StyleNaming ConventionsRelational Database

Database Design for Tagging

SqlDatabase DesignTagsTagging

How to Store Historical Data

Database DesignVersioning

Implementing Comments and Likes in database

MysqlDatabaseDesign PatternsDatabase Design

Is there ever a time where using a database 1:1 relationship makes sense?

SqlDatabase DesignOne to-OneDatabase Normalization

What's wrong with nullable columns in composite primary keys?

DatabaseDatabase Design

When/Why to use Cascading in SQL Server?

Sql ServerDatabase DesignForeign KeysRdbmsCascade

Database design for audit logging

Database DesignLoggingAudit

Database Structure for Tree Data Structure

SqlDatabase DesignTree

Subqueries vs joins

SqlMysqlPerformanceDatabase DesignJoin

How to design a product table for many kinds of product where each product has many parameters

Database DesignRelational DatabaseDatabase Schema

What should I name a table that maps two tables together?

SqlDatabaseDatabase DesignNaming ConventionsData Modeling

NoSql vs Relational database

DatabaseDatabase DesignNosqlRelational DatabaseRdbms

Storing SHA1 hash values in MySQL

MysqlDatabase DesignHashSha1

How do you effectively model inheritance in a database?

.NetSql ServerOopInheritanceDatabase Design

Using a Single Row configuration table in SQL Server database. Bad idea?

SqlDatabase DesignConfigurationRelational Database

SQL ON DELETE CASCADE, Which Way Does the Deletion Occur?

SqlDatabaseDatabase DesignCascadeRelation

How to design a database for User Defined Fields?

SqlDatabaseDatabase DesignUser Defined-Fields

How to store a list in a column of a database table

SqlLinqLinq to-SqlDatabase DesignLinq to-Entities

MySQL: multiple tables or one table with many columns?

MysqlDatabase Design

What is the most efficient way to store tags in a database?

DatabaseDatabase DesignTagsData ModelingTagging

Good tool to visualise database schema?

MysqlDatabaseDatabase DesignSchemaVisualization

Database design for a survey

SqlDatabase Design

Primary key or Unique index?

SqlDatabaseDatabase Design

Storing sex (gender) in database

SqlDatabase Design

How to create a multi-tenant database with shared table structures?

SqlMysqlDatabase DesignMulti Tenant

Physical vs. logical (hard vs. soft) delete of database record?

SqlDatabaseDatabase DesignSoft DeleteHard Delete

Facebook database design?

SqlFacebookDatabase DesignDatabase NormalizationDatabase Table

Are soft deletes a good idea?

SqlDatabaseDatabase DesignData ModelingSoft Delete

How to implement a many-to-many relationship in PostgreSQL?

SqlDatabasePostgresqlDatabase DesignMany to-Many

Is there common street addresses database design for all addresses of the world?

SqlDatabase DesignStreet AddressPostal Code

Database: To delete or not to delete records

DatabaseDatabase Design

Difference between clustered and nonclustered index

Sql ServerDatabase DesignIndexingClustered IndexNon Clustered-Index

Unique constraint that allows empty values in MySQL

MysqlDatabase DesignConstraints

Database Design for Revisions?

SqlDatabaseDatabase DesignVersioning

A beginner's guide to SQL database design

SqlDatabaseDatabase DesignScalability

Best design for a changelog / auditing database table?

DatabaseDatabase DesignAudit

Best practices for storing postal addresses in a database (RDBMS)?

DatabaseDatabase DesignTypesStreet AddressPostal Code

How many database indexes is too many?

DatabaseOracleDatabase Design

Nullable Foreign Key bad practice?

Database Design

Is a one column table good design?

SqlDatabase Design

Why use multiple columns as primary keys (composite primary key)

Database DesignRelational DatabasePrimary KeyDdlDatabase Table

What columns generally make good indexes?

Sql ServerDatabaseOptimizationDatabase DesignIndexing

When to use a View instead of a Table?

SqlDatabase DesignView

How to create materialized views in SQL Server?

Sql ServerDatabase DesignIndexed View

Best way to store time (hh:mm) in a database

Sql ServerDatabaseDatabase DesignDatetime

Index on multiple columns in Ruby on Rails

Ruby on-RailsRuby on-Rails-3Database DesignIndexing

Grant all on a specific schema in the db to a group role in PostgreSQL

PostgresqlDatabase DesignRolesPrivilegesSql Grant

When I should use one to one relationship?

DatabaseDatabase DesignRelational Database

What is Normalisation (or Normalization)?

Database DesignDatabase NormalizationRelational

How to delete from a table where ID is in a list of IDs?

SqlDatabase Design

What is the optimal length for an email address in a database?

DatabasePerformanceEmailDatabase Design

Table Naming: Underscore vs Camelcase? namespaces? Singular vs Plural?

DatabaseDatabase Design

Relationship of Primary Key and Clustered Index

SqlSql ServerDatabaseDatabase Design

List of Constraints from MySQL Database

MysqlDatabase DesignConstraints

How to store phone numbers on MySQL databases?

MysqlStringDatabase DesignFormattingInt

Good practices for designing monthly subscription system in database

DatabaseDatabase DesignDatabase Schema

MongoDB Schema Design - Many small documents or fewer large documents?

Database DesignSchemaMongodb

Primary key/foreign Key naming convention

SqlDatabase DesignNaming Conventions

MySQL - how to front pad zip code with "0"?

SqlMysqlDatabaseDatabase Design

What is cardinality in Databases?

DatabaseDatabase DesignCardinality

PostgreSQL Index Usage Analysis

SqlDatabase DesignPostgresql

Why is a database always represented with a cylinder?

DatabaseDatabase DesignDiagramDiagrammingDatabase Diagramming

Storing Business Hours in a Database

DatabaseDatabase Design

How do you like your primary keys?

AlgorithmDatabase DesignRelational DatabasePrimary KeyDdl

How to create a new schema/new user in Oracle Database 11g?

SqlDatabase DesignOracle11gSchemaDatabase

SQL Server: how to constrain a table to contain a single row?

Sql ServerDatabase DesignSingleton

Database design: Calculating the Account Balance

Sql ServerDatabaseSql Server-2008Database Design

What's the better database design: more tables or more columns?

DatabaseDatabase DesignNormalizing

Modeling Product Variants

MysqlDatabaseDatabase DesignRelational DatabaseEntity Attribute-Value

SQL Server: the maximum number of rows in table

Sql ServerDatabase Design

Still Confused About Identifying vs. Non-Identifying Relationships

DatabaseDatabase DesignRelational DatabaseIdentifying Relationship

Calculating and saving space in PostgreSQL

PostgresqlDatabase DesignStorageBigdata

Firestore - how to structure a feed and follow system

JavaAndroidFirebaseDatabase DesignGoogle Cloud-Firestore

Are nulls in a relational database okay?

Database DesignOopNull

Use float or decimal for accounting application dollar amount?

Sql Servervb.netDatabase DesignCurrencyAccounting

When is it better to store flags as a bitmask rather than using an associative table?

C#Sql ServerDatabase DesignBitmask

Standard use of 'Z' instead of NULL to represent missing data?

SqlDatabase DesignNullStandardsRdbms

Foreign key reference to table in another schema

SqlOracleDatabase Design

What is the purpose of system table master..spt_values and what are the meanings of its values?

SqlSql ServerDatabase DesignConfiguration

How to list all tables in PhpMyAdmin's left menu?

PhpDatabase DesignPhpmyadmin

What are design patterns to support custom fields in an application?

Database DesignData Modeling

When should I use Datomic?

DatabaseDatabase DesignClojureDatomic

Best method to store Enum in Database

C#DatabaseVisual StudioDatabase DesignEnums

How many columns is too many columns?

DatabaseDatabase DesignDatabase Performance

MySQL stored procedures use them or not to use them

MysqlDatabasePerformanceDatabase DesignStored Procedures

Composite primary keys versus unique object ID field

Ruby on-RailsDatabaseDesign PatternsDatabase Design

Why & When should I use SPARSE COLUMN? (SQL SERVER 2008)

SqlSql ServerDatabase DesignSql Server-2008

Best practices to store CreditCard information into DataBase

MysqlDatabaseSecurityDatabase DesignCredit Card

Best representation of an ordered list in a database?

DatabaseDatabase DesignRdbms

Composite Primary Keys : Good or Bad?

SqlDatabaseDatabase DesignRelational Database

Dynamic Database Schema

SqlDatabase DesignArchitectureDynamic Data

In what way does denormalization improve database performance?

DatabasePerformanceDatabase DesignNormalizationDenormalization

Naming of boolean column in database table

Sql ServerDatabaseDatabase DesignNaming Conventions

MySQL ENUM type vs join tables

MysqlDatabase DesignEnums

MySQL - Conditional Foreign Key Constraints

MysqlSqlDatabase DesignForeign KeysPolymorphic Associations

What databases do the World Wide Web's biggest sites run on?

DatabaseDatabase DesignWeb ApplicationsScalability

Underscores or camelCase in PostgreSQL identifiers, when the programming language uses camelCase?

OopPostgresqlDatabase DesignNaming ConventionsCamelcasing

What are the advantages of using a single database for EACH client?

DatabaseDatabase DesignMulti Tenant

Should I use a single or multiple database setup for a multi-client application?

Database DesignArchitectureDatabase SchemaMulti Tenant

How should international geographical addresses be stored in a relational database?

Database DesignStreet Address

How can I tell if a database table is being accessed anymore? Want something like a "SELECT trigger"

Sql ServerDatabase DesignSql Server-2008Clustered Index

MySQL - One To One Relationship?

MysqlSqlDatabaseDatabase DesignOne to-One

Composite Primary key vs additional "ID" column?

SqlSql ServerDatabaseDatabase Design

How to store directory / hierarchy / tree structure in the database?

Sql ServerSql Server-2005Database DesignTree Structure

What's The Best Practice In Designing A Cassandra Data Model?

Database DesignNosqlCassandra

Allow null in unique column

SqlPostgresqlDatabase DesignNullUnique Constraint

Should OLAP databases be denormalized for read performance?

DatabaseDatabase DesignData ModelingOlapData Warehouse

Should you enforce constraints at the database level as well as the application level?

Database Design

When to use an auto-incremented primary key and when not to?

SqlDatabase Design

Derived account balance vs stored account balance for a simple bank account?

DatabaseDatabase DesignDerived Table

What is the best way to manage permissions for a web application - bitmask or database table?

Database DesignWeb ApplicationsPermissions

varchar Fields - Is a Power of Two More Efficient?

Database DesignVarchar

MongoDB vs. Cassandra vs. MySQL for real-time advertising platform

MongodbDatabase DesignCassandraDatabaseNosql

Why should I avoid loops when designing relationships for a database?

DatabaseDatabase DesignLoopsData ModelingEntity Relationship

Database Design Best Practices

Database Design

PostgreSQL Index on JSON

SqlJsonPostgresqlIndexingDatabase Design

How do you deal with polymorphism in a database?

Database DesignOop

Database schema design for a double entry accounting system?

DatabaseDatabase DesignAccounting

What is the best practice in naming your "user" table?

DatabaseDatabase DesignNaming Conventions

Database design: 3 types of users, separate or one table?

MysqlDatabaseDatabase DesignUser InterfaceRelational Database

Database design for user settings

MysqlSql ServerDatabaseDatabase DesignRelational Database

How entity framework works for large number of records?

C#Entity FrameworkDatabase DesignEntity Framework-6

Microservices with shared database? using multiple ORM's?

DatabaseDatabase DesignOrmArchitectureMicroservices

Is it possible to query a tree structure table in MySQL in a single query, to any depth?

MysqlSqlDatabase DesignData StructuresHierarchical Data

in general, should every table in a database have an identity field to use as a PK?

SqlDatabaseDatabase Design

Why use SQL database?

SqlDatabaseDatabase DesignData Structures

Why are composite primary keys still around?

MysqlSql ServerDatabase Design

Primary key for multiple column in PostgreSQL?

PostgresqlDatabase DesignPrimary KeyDdlComposite Primary-Key

Database - Data Versioning

DatabaseDatabase DesignVersioning

Is it a good idea to use an integer column for storing US ZIP codes in a database?

DatabaseDatabase DesignTypesStreet AddressPostal Code

What is the difference between logical data model and conceptual data model?

DatabaseDatabase Design

What is the best way to implement soft deletion?

SqlDatabaseDatabase DesignBackup

When to use MongoDB

MysqlMongodbDatabase DesignRelational DatabaseDatabase

Should I write table and column names ALWAYS lower case?

DatabaseDatabase Design

MySQL: bigint Vs int

MysqlDatabase DesignIntBigintegerAuto Increment

What does ON UPDATE RESTRICT do?

MysqlDatabaseDatabase Design

Ideas on database design for capturing audit trails

DatabaseDatabase DesignAudit

Database design for invoices, invoice lines & revisions

Sql ServerDatabase DesignInvoices

Alternatives to Entity-Attribute-Value (EAV)?

DatabaseDatabase DesignData StructuresData ModelingEntity Attribute-Value

Best Practice for Designing User Roles and Permission System?

MysqlDatabaseDatabase Design

Database design for a social networking site

DatabaseDatabase DesignSocial Networking

Is it good database design to have admin users in the same table as front-end users?

SqlSql ServerDatabaseDatabase DesignData Modeling

PostgreSQL's schemas for multi-tenant applications

PerformancePostgresqlDatabase DesignSchemaMulti Tenant

Sql Data Type for Primary Key - SQL Server?

Sql ServerDatabase DesignTypes

What's the best way to store the days of the week an event takes place on in a relational database?

SqlDatabase Design

Data Warehouse Considerations: When and Why?

DatabaseDatabase DesignData Warehouse

Reason why oracle is case sensitive?

OracleDatabase DesignCase Sensitive

MySQL datatype to store month and year only

MysqlSqlDatabase Design

Database partitioning - Horizontal vs Vertical - Difference between Normalization and Row Splitting?

DatabaseDatabase DesignDatabase PerformanceShardingDatabase Partitioning

Django models - how to filter number of ForeignKey objects

PythonDjangoDatabase Design

Signed or unsigned in MySQL

MysqlDatabase Design

Database Architecture for "Badge" System & Arbitrary Criteria (MySQL/PHP)

Database DesignBadge

First name, middle name, last name. Why not Full Name?

DatabaseDatabase DesignUser Interface

Django Selective Dumpdata

PythonDjangoDatabase DesignDjango Models