All Relational Database Solutions on Gang of Coders

Total of 41 Relational Database Solutions

When to use MongoDB

MysqlMongodbDatabase DesignRelational DatabaseDatabase

What are the known ways to store a tree structure in a relational DB?

MysqlDesign PatternsTreeRelational Database

What is the difference between a candidate key and a primary key?

SqlRelational Database

How to persist a graph data structure in a relational database?

DatabaseGraphRelational Database

What is the difference between MySQL & MySQL2 considering NodeJS

Mysqlnode.jsRelational DatabaseMysql2

Does the join order matter in SQL?

SqlJoinRelational Database

Storing time-series data, relational or non?

DatabaseNosqlRelational DatabaseTime SeriesNon Relational-Database

Relational table naming convention

DatabaseDatabase DesignCoding StyleNaming ConventionsRelational Database

Foreign Key to multiple tables

Sql ServerRelational Database

Difference between 3NF and BCNF in simple terms (must be able to explain to an 8-year old)

DatabaseRelational DatabaseDatabase Normalization3nf

postgresql foreign key syntax

SqlPostgresqlForeign KeysRelational DatabaseForeign Key-Relationship

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

Database DesignRelational DatabaseDatabase Schema

NoSql vs Relational database

DatabaseDatabase DesignNosqlRelational DatabaseRdbms

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

SqlDatabase DesignConfigurationRelational Database

Use cases for NoSQL

SqlMongodbCouchdbRelational DatabaseNosql

Difference between one-to-many and many-to-one relationship

SqlRelational DatabaseOne to-ManyMany to-One

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

Database DesignRelational DatabasePrimary KeyDdlDatabase Table

What are the uses for Cross Join?

SqlDatabaseJoinRelational Database

Comparison of Relational Databases and Graph Databases

SqlRelational DatabaseGraph Databases

Difference between a theta join, equijoin and natural join

DatabaseRelational DatabaseRelational Algebra

When I should use one to one relationship?

DatabaseDatabase DesignRelational Database

How to create relationships in MySQL

MysqlSqlForeign KeysRelational Database

How do you like your primary keys?

AlgorithmDatabase DesignRelational DatabasePrimary KeyDdl

What is the difference between a Relational and Non-Relational Database?

Relational DatabaseNon Relational-Database

Modeling Product Variants

MysqlDatabaseDatabase DesignRelational DatabaseEntity Attribute-Value

Still Confused About Identifying vs. Non-Identifying Relationships

DatabaseDatabase DesignRelational DatabaseIdentifying Relationship

Pros/cons of document-based databases vs. relational databases

DatabaseNosqlCouchdbRelational DatabaseDocument Database

What is the difference between Views and Materialized Views in Oracle?

SqlOracleViewRelational DatabaseMaterialized Views

When shouldn't you use a relational database?

SqlDatabaseNosqlRelational Database

When and why are database joins expensive?

DatabasePerformanceJoinRelational DatabaseDenormalization

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

SqlDatabase DesignForeign KeysRelational DatabaseRelationship

Composite Primary Keys : Good or Bad?

SqlDatabaseDatabase DesignRelational Database

What are the options for storing hierarchical data in a relational database?

SqlDatabaseTreeRelational DatabaseHierarchical Data

Practical example for each type of database (real cases)

DatabaseNosqlRelational Database

Are relational databases a poor fit for Node.js?

node.jsRelational Database

How to organise a many to many relationship in MongoDB

MongodbMany to-ManyRelational DatabaseDocument Database

Setting up table relations what do "Cascade", "Set Null" and "Restrict" do?

MysqlPhpmyadminInnodbRelational Database

How can I find MAX with relational algebra?

DatabaseRelational DatabaseRelational Algebra

Laravel - Eloquent "Has", "With", "WhereHas" - What do they mean?

LaravelOrmEloquentRelational DatabaseRelationship

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

MysqlDatabaseDatabase DesignUser InterfaceRelational Database

Database design for user settings

MysqlSql ServerDatabaseDatabase DesignRelational Database