Gang Of Coders
Home
About Us
Contact Us
All Database Design Solutions on Gang of Coders
Total of 197 Database Design Solutions
Database, Table and Column Naming Conventions?
Database
Database Design
Language Agnostic
Naming Conventions
What's the difference between identifying and non-identifying relationships?
Database
Database Design
Data Modeling
Identifying Relationship
Difference between scaling horizontally and vertically for databases
Database
Database Design
Nosql
Scalability
MongoDB vs. Cassandra
Mongodb
Database Design
Cassandra
Database
Database development mistakes made by application developers
Database
Database Design
What is the ideal data type to use when storing latitude / longitude in a MySQL database?
Mysql
Database Design
Maps
Mapping
Latitude Longitude
Can I have multiple primary keys in a single table?
Database
Database Design
Primary Key
Composite Primary-Key
Is storing a delimited list in a database column really that bad?
Database
Database Design
Database Normalization
What are the best practices for using a GUID as a primary key, specifically regarding performance?
Sql Server
Entity Framework
Database Design
Primary Key
Guid
Should each and every table have a primary key?
Database
Database Design
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
Sql
Database Design
Foreign Keys
Relational Database
Relationship
What are the lengths of Location Coordinates, latitude and longitude?
Database Design
Latitude Longitude
Auto Generate Database Diagram MySQL
Mysql
Database
Database Design
Diagram
Calendar Recurring/Repeating Events - Best Storage Method
Database Design
Calendar
What are OLTP and OLAP. What is the difference between them?
Database
Database Design
Database Schema
Olap
Oltp
What does character set and collation mean exactly?
Mysql
Database
Database Design
Character Set
Recommended SQL database design for tags or tagging
Sql
Database Design
Tags
Data Modeling
Tagging
Create unique constraint with null columns
Sql
Postgresql
Database Design
Null
Referential Integrity
How can you represent inheritance in a database?
Sql Server
Inheritance
Database Design
Class Table-Inheritance
Relational Database Design Patterns?
Design Patterns
Database Design
Rdbms
What are database normal forms and can you give examples?
Database
Database Design
Database Normalization
Max length for client ip address
Sql
Database
Database Design
What does ON [PRIMARY] mean?
Sql
Sql Server
Database
Database Design
What does principal end of an association means in 1:1 relationship in Entity framework
C#
Entity Framework
Database Design
Foreign Key-Relationship
What's wrong with foreign keys?
Database
Database Design
Foreign Keys
Referential Integrity
Data Integrity
Schema for a multilanguage database
Database Design
Localization
Multilingual
"Prevent saving changes that require the table to be re-created" negative effects
Sql Server
Sql Server-2008
Database Design
Sql Server-2005
First-time database design: am I overengineering?
Mysql
Database
Database Design
Schema
Database Normalization
Use email address as primary key?
Sql
Database
Database Design
Postgresql
What's the longest possible worldwide phone number I should consider in SQL varchar(length) for phone
Sql Server
Validation
Database Design
Data Modeling
Phone Number
What are best practices for multi-language database design?
Sql
Database
Database Design
How big can a user agent string get?
Http
Database Design
Http Headers
User Agent
Remove Primary Key in MySQL
Mysql
Sql
Database Design
Primary Key
Mysql Error-1075
What should every developer know about databases?
Database
Language Agnostic
Database Design
Strings as Primary Keys in SQL Database
Sql
Database
Database Design
String
Primary Key
Is there a good reason I see VARCHAR(255) used so often (as opposed to another length)?
Database
Database Design
Types
Varchar
How to version control a record in a database
Database Design
Architecture
Versioning
Auditing
Is it better to use multiple databases with one schema each, or one database with multiple schemas?
Database
Database Design
Postgresql
Database Permissions
How big is too big for a PostgreSQL table?
Sql
Ruby on-Rails
Performance
Postgresql
Database Design
Surrogate vs. natural/business keys
Database
Database Design
Primary Key
Key
Storing money in a decimal column - what precision and scale?
Sql
Database
Database Design
Currency
PostgreSQL: Which Datatype should be used for Currency?
Sql
Postgresql
Database Design
Relational table naming convention
Database
Database Design
Coding Style
Naming Conventions
Relational Database
Database Design for Tagging
Sql
Database Design
Tags
Tagging
How to Store Historical Data
Database Design
Versioning
Implementing Comments and Likes in database
Mysql
Database
Design Patterns
Database Design
Is there ever a time where using a database 1:1 relationship makes sense?
Sql
Database Design
One to-One
Database Normalization
What's wrong with nullable columns in composite primary keys?
Database
Database Design
When/Why to use Cascading in SQL Server?
Sql Server
Database Design
Foreign Keys
Rdbms
Cascade
Database design for audit logging
Database Design
Logging
Audit
Database Structure for Tree Data Structure
Sql
Database Design
Tree
Subqueries vs joins
Sql
Mysql
Performance
Database Design
Join
How to design a product table for many kinds of product where each product has many parameters
Database Design
Relational Database
Database Schema
What should I name a table that maps two tables together?
Sql
Database
Database Design
Naming Conventions
Data Modeling
NoSql vs Relational database
Database
Database Design
Nosql
Relational Database
Rdbms
Storing SHA1 hash values in MySQL
Mysql
Database Design
Hash
Sha1
How do you effectively model inheritance in a database?
.Net
Sql Server
Oop
Inheritance
Database Design
Using a Single Row configuration table in SQL Server database. Bad idea?
Sql
Database Design
Configuration
Relational Database
SQL ON DELETE CASCADE, Which Way Does the Deletion Occur?
Sql
Database
Database Design
Cascade
Relation
How to design a database for User Defined Fields?
Sql
Database
Database Design
User Defined-Fields
How to store a list in a column of a database table
Sql
Linq
Linq to-Sql
Database Design
Linq to-Entities
MySQL: multiple tables or one table with many columns?
Mysql
Database Design
What is the most efficient way to store tags in a database?
Database
Database Design
Tags
Data Modeling
Tagging
Good tool to visualise database schema?
Mysql
Database
Database Design
Schema
Visualization
Database design for a survey
Sql
Database Design
Primary key or Unique index?
Sql
Database
Database Design
Storing sex (gender) in database
Sql
Database Design
How to create a multi-tenant database with shared table structures?
Sql
Mysql
Database Design
Multi Tenant
Physical vs. logical (hard vs. soft) delete of database record?
Sql
Database
Database Design
Soft Delete
Hard Delete
Facebook database design?
Sql
Facebook
Database Design
Database Normalization
Database Table
Are soft deletes a good idea?
Sql
Database
Database Design
Data Modeling
Soft Delete
How to implement a many-to-many relationship in PostgreSQL?
Sql
Database
Postgresql
Database Design
Many to-Many
Is there common street addresses database design for all addresses of the world?
Sql
Database Design
Street Address
Postal Code
Database: To delete or not to delete records
Database
Database Design
Difference between clustered and nonclustered index
Sql Server
Database Design
Indexing
Clustered Index
Non Clustered-Index
Unique constraint that allows empty values in MySQL
Mysql
Database Design
Constraints
Database Design for Revisions?
Sql
Database
Database Design
Versioning
A beginner's guide to SQL database design
Sql
Database
Database Design
Scalability
Best design for a changelog / auditing database table?
Database
Database Design
Audit
Best practices for storing postal addresses in a database (RDBMS)?
Database
Database Design
Types
Street Address
Postal Code
How many database indexes is too many?
Database
Oracle
Database Design
Nullable Foreign Key bad practice?
Database Design
Is a one column table good design?
Sql
Database Design
Why use multiple columns as primary keys (composite primary key)
Database Design
Relational Database
Primary Key
Ddl
Database Table
What columns generally make good indexes?
Sql Server
Database
Optimization
Database Design
Indexing
When to use a View instead of a Table?
Sql
Database Design
View
How to create materialized views in SQL Server?
Sql Server
Database Design
Indexed View
Best way to store time (hh:mm) in a database
Sql Server
Database
Database Design
Datetime
Index on multiple columns in Ruby on Rails
Ruby on-Rails
Ruby on-Rails-3
Database Design
Indexing
Grant all on a specific schema in the db to a group role in PostgreSQL
Postgresql
Database Design
Roles
Privileges
Sql Grant
When I should use one to one relationship?
Database
Database Design
Relational Database
What is Normalisation (or Normalization)?
Database Design
Database Normalization
Relational
How to delete from a table where ID is in a list of IDs?
Sql
Database Design
What is the optimal length for an email address in a database?
Database
Performance
Email
Database Design
Table Naming: Underscore vs Camelcase? namespaces? Singular vs Plural?
Database
Database Design
Relationship of Primary Key and Clustered Index
Sql
Sql Server
Database
Database Design
List of Constraints from MySQL Database
Mysql
Database Design
Constraints
How to store phone numbers on MySQL databases?
Mysql
String
Database Design
Formatting
Int
Good practices for designing monthly subscription system in database
Database
Database Design
Database Schema
MongoDB Schema Design - Many small documents or fewer large documents?
Database Design
Schema
Mongodb
Primary key/foreign Key naming convention
Sql
Database Design
Naming Conventions
MySQL - how to front pad zip code with "0"?
Sql
Mysql
Database
Database Design
What is cardinality in Databases?
Database
Database Design
Cardinality
PostgreSQL Index Usage Analysis
Sql
Database Design
Postgresql
Why is a database always represented with a cylinder?
Database
Database Design
Diagram
Diagramming
Database Diagramming
Storing Business Hours in a Database
Database
Database Design
How do you like your primary keys?
Algorithm
Database Design
Relational Database
Primary Key
Ddl
How to create a new schema/new user in Oracle Database 11g?
Sql
Database Design
Oracle11g
Schema
Database
SQL Server: how to constrain a table to contain a single row?
Sql Server
Database Design
Singleton
Database design: Calculating the Account Balance
Sql Server
Database
Sql Server-2008
Database Design
What's the better database design: more tables or more columns?
Database
Database Design
Normalizing
Modeling Product Variants
Mysql
Database
Database Design
Relational Database
Entity Attribute-Value
SQL Server: the maximum number of rows in table
Sql Server
Database Design
Still Confused About Identifying vs. Non-Identifying Relationships
Database
Database Design
Relational Database
Identifying Relationship
Calculating and saving space in PostgreSQL
Postgresql
Database Design
Storage
Bigdata
Firestore - how to structure a feed and follow system
Java
Android
Firebase
Database Design
Google Cloud-Firestore
Are nulls in a relational database okay?
Database Design
Oop
Null
Use float or decimal for accounting application dollar amount?
Sql Server
vb.net
Database Design
Currency
Accounting
When is it better to store flags as a bitmask rather than using an associative table?
C#
Sql Server
Database Design
Bitmask
Standard use of 'Z' instead of NULL to represent missing data?
Sql
Database Design
Null
Standards
Rdbms
Foreign key reference to table in another schema
Sql
Oracle
Database Design
What is the purpose of system table master..spt_values and what are the meanings of its values?
Sql
Sql Server
Database Design
Configuration
How to list all tables in PhpMyAdmin's left menu?
Php
Database Design
Phpmyadmin
What are design patterns to support custom fields in an application?
Database Design
Data Modeling
When should I use Datomic?
Database
Database Design
Clojure
Datomic
Best method to store Enum in Database
C#
Database
Visual Studio
Database Design
Enums
How many columns is too many columns?
Database
Database Design
Database Performance
MySQL stored procedures use them or not to use them
Mysql
Database
Performance
Database Design
Stored Procedures
Composite primary keys versus unique object ID field
Ruby on-Rails
Database
Design Patterns
Database Design
Why & When should I use SPARSE COLUMN? (SQL SERVER 2008)
Sql
Sql Server
Database Design
Sql Server-2008
Best practices to store CreditCard information into DataBase
Mysql
Database
Security
Database Design
Credit Card
Best representation of an ordered list in a database?
Database
Database Design
Rdbms
Composite Primary Keys : Good or Bad?
Sql
Database
Database Design
Relational Database
Dynamic Database Schema
Sql
Database Design
Architecture
Dynamic Data
In what way does denormalization improve database performance?
Database
Performance
Database Design
Normalization
Denormalization
Naming of boolean column in database table
Sql Server
Database
Database Design
Naming Conventions
MySQL ENUM type vs join tables
Mysql
Database Design
Enums
MySQL - Conditional Foreign Key Constraints
Mysql
Sql
Database Design
Foreign Keys
Polymorphic Associations
What databases do the World Wide Web's biggest sites run on?
Database
Database Design
Web Applications
Scalability
Underscores or camelCase in PostgreSQL identifiers, when the programming language uses camelCase?
Oop
Postgresql
Database Design
Naming Conventions
Camelcasing
What are the advantages of using a single database for EACH client?
Database
Database Design
Multi Tenant
Should I use a single or multiple database setup for a multi-client application?
Database Design
Architecture
Database Schema
Multi Tenant
How should international geographical addresses be stored in a relational database?
Database Design
Street Address
How can I tell if a database table is being accessed anymore? Want something like a "SELECT trigger"
Sql Server
Database Design
Sql Server-2008
Clustered Index
MySQL - One To One Relationship?
Mysql
Sql
Database
Database Design
One to-One
Composite Primary key vs additional "ID" column?
Sql
Sql Server
Database
Database Design
How to store directory / hierarchy / tree structure in the database?
Sql Server
Sql Server-2005
Database Design
Tree Structure
What's The Best Practice In Designing A Cassandra Data Model?
Database Design
Nosql
Cassandra
Allow null in unique column
Sql
Postgresql
Database Design
Null
Unique Constraint
Should OLAP databases be denormalized for read performance?
Database
Database Design
Data Modeling
Olap
Data 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?
Sql
Database Design
Derived account balance vs stored account balance for a simple bank account?
Database
Database Design
Derived Table
What is the best way to manage permissions for a web application - bitmask or database table?
Database Design
Web Applications
Permissions
varchar Fields - Is a Power of Two More Efficient?
Database Design
Varchar
MongoDB vs. Cassandra vs. MySQL for real-time advertising platform
Mongodb
Database Design
Cassandra
Database
Nosql
Why should I avoid loops when designing relationships for a database?
Database
Database Design
Loops
Data Modeling
Entity Relationship
Database Design Best Practices
Database Design
PostgreSQL Index on JSON
Sql
Json
Postgresql
Indexing
Database Design
How do you deal with polymorphism in a database?
Database Design
Oop
Database schema design for a double entry accounting system?
Database
Database Design
Accounting
What is the best practice in naming your "user" table?
Database
Database Design
Naming Conventions
Database design: 3 types of users, separate or one table?
Mysql
Database
Database Design
User Interface
Relational Database
Database design for user settings
Mysql
Sql Server
Database
Database Design
Relational Database
How entity framework works for large number of records?
C#
Entity Framework
Database Design
Entity Framework-6
Microservices with shared database? using multiple ORM's?
Database
Database Design
Orm
Architecture
Microservices
Is it possible to query a tree structure table in MySQL in a single query, to any depth?
Mysql
Sql
Database Design
Data Structures
Hierarchical Data
in general, should every table in a database have an identity field to use as a PK?
Sql
Database
Database Design
Why use SQL database?
Sql
Database
Database Design
Data Structures
Why are composite primary keys still around?
Mysql
Sql Server
Database Design
Primary key for multiple column in PostgreSQL?
Postgresql
Database Design
Primary Key
Ddl
Composite Primary-Key
Database - Data Versioning
Database
Database Design
Versioning
Is it a good idea to use an integer column for storing US ZIP codes in a database?
Database
Database Design
Types
Street Address
Postal Code
What is the difference between logical data model and conceptual data model?
Database
Database Design
What is the best way to implement soft deletion?
Sql
Database
Database Design
Backup
When to use MongoDB
Mysql
Mongodb
Database Design
Relational Database
Database
Should I write table and column names ALWAYS lower case?
Database
Database Design
MySQL: bigint Vs int
Mysql
Database Design
Int
Biginteger
Auto Increment
What does ON UPDATE RESTRICT do?
Mysql
Database
Database Design
Ideas on database design for capturing audit trails
Database
Database Design
Audit
Database design for invoices, invoice lines & revisions
Sql Server
Database Design
Invoices
Alternatives to Entity-Attribute-Value (EAV)?
Database
Database Design
Data Structures
Data Modeling
Entity Attribute-Value
Best Practice for Designing User Roles and Permission System?
Mysql
Database
Database Design
Database design for a social networking site
Database
Database Design
Social Networking
Is it good database design to have admin users in the same table as front-end users?
Sql
Sql Server
Database
Database Design
Data Modeling
PostgreSQL's schemas for multi-tenant applications
Performance
Postgresql
Database Design
Schema
Multi Tenant
Sql Data Type for Primary Key - SQL Server?
Sql Server
Database Design
Types
What's the best way to store the days of the week an event takes place on in a relational database?
Sql
Database Design
Data Warehouse Considerations: When and Why?
Database
Database Design
Data Warehouse
Reason why oracle is case sensitive?
Oracle
Database Design
Case Sensitive
MySQL datatype to store month and year only
Mysql
Sql
Database Design
Database partitioning - Horizontal vs Vertical - Difference between Normalization and Row Splitting?
Database
Database Design
Database Performance
Sharding
Database Partitioning
Django models - how to filter number of ForeignKey objects
Python
Django
Database Design
Signed or unsigned in MySQL
Mysql
Database Design
Database Architecture for "Badge" System & Arbitrary Criteria (MySQL/PHP)
Database Design
Badge
First name, middle name, last name. Why not Full Name?
Database
Database Design
User Interface
Django Selective Dumpdata
Python
Django
Database Design
Django Models