Easy question that should be a sticky!

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
DaveTheAve
Forum Contributor
Posts: 385
Joined: Tue Oct 03, 2006 2:25 pm
Location: 127.0.0.1
Contact:

Easy question that should be a sticky!

Post by DaveTheAve »

So I don't mean to sound like a "noobie" or anything, especially with my experience with PHP & MySQL; however, I've been wanting to advance my complexity of database scheming. Not to make it harder to maintain and understand, but I've never gotten all that deep with MySQL - or so I feel.

What I'm really asking for is exceptional database schemes that where designed with future development in mind, are advanced, and performance-optimized.

I'm working on a CRM project (with many other features so it'll actually be worth using), that'll have users linked to client projects, with company's linked to projects, with client's linked to company's, etc. I already have a base scheme but I would like to see how major companies have implemented their databases and perhaps change my accordingly.

Thanks guys!

Like I said perhaps we should make this a sticky with the title "Exceptional Database Schemes to Learn From".
User avatar
DaveTheAve
Forum Contributor
Posts: 385
Joined: Tue Oct 03, 2006 2:25 pm
Location: 127.0.0.1
Contact:

Re: Easy question that should be a sticky!

Post by DaveTheAve »

Looking at a few Database's from sourceforge's CRM projects, I find that they're databases are not any more complex or thought out as mine are. So I guess I must be doing something right. lol! :drunk:

Though I would like it if someone can post a least a few exceptional database schemes that they've seen.
Post Reply