Solution: Relational Database Design Patterns? #development #dev #programming

Relational Database Design Patterns?

Design patterns are usually related to object oriented design. Are there design patterns for creating and programming relational databases? Many problems surely must have reusable solutions.

Examples would include patterns for table design, stored procedures, triggers, etc…

Is there an online repository of such patterns, similar to martinfowler.com?

Examples…

Fixed: Use email address as primary key? #it #dev #solution

Use email address as primary key?

Is email address a bad candidate for primary when compared to auto incrementing numbers?

Our web application needs the email address to be unique in the system. So, I thought of using email address as primary key. However my colleague suggests that string comparison will be slower than integer comparison.

Is it a valid reason to not use email as primary key?

We…

Answer: Auto Generate Database Diagram MySQL #solution #dev #programming

Auto Generate Database Diagram MySQL

I’m tired of opening Dia and creating a database diagram at the beginning of every project. Is there a tool out there that will let me select specific tables and then create a database diagram for me based on a MySQL database? Preferably it would allow me to edit the diagram afterward since none of the foreign keys are set…

Here is what I am picturing…

Solution: What are good open source GUI SQLite database managers? #dev #answer #it

What are good open source GUI SQLite database managers?

Is there any good open source SQLite database manager around?

I am using sqlitebrowser now but I have to say the interface is not really friendly so I am looking for something better.

Original post

Fix: How do you recommend implementing tags or tagging #answer #programming #it

How do you recommend implementing tags or tagging

I’ve heard of a few ways to implement tagging; using a mapping table between TagID and ItemID (makes sense to me, but does it scale?), adding a fixed number of possible TagID columns to ItemID (seems like a bad idea), Keeping tags in a text column that’s comma separated (sounds crazy but could work). I’ve even heard someone recommend a sparse…

How to: Can I have multiple primary keys in a single table? #it #computers #programming

Can I have multiple primary keys in a single table?

Can I have multiple primary keys in a single table?

Answer [by HLGEM]: Can I have multiple primary keys in a single table?

A primary key is the key that uniquely identifies a record and is used in all indexes. This is why you can’t have more than one. It is also generally the key that is used in joining to child tables but this is not a…

Resolved: First-time database design: am I overengineering? #answer #it #solution

First-time database design: am I overengineering? Background

I’m a first year CS student and I work part time for my dad’s small business. I don’t have any experience in real world application development. I have written scripts in Python, some coursework in C, but nothing like this.

My dad has a small training business and currently all classes are scheduled, recorded and followed up via an…

Fixed What should every developer know about databases? #dev #it #asnwer

What should every developer know about databases?

Whether we like it or not, many if not most of us developers either regularly work with databases or may have to work with one someday. And considering the amount of misuse and abuse in the wild, and the volume of database-related questions that come up every day, it’s fair to say that there are certain concepts that developers should know – even…