News Feed
Jobs Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Brandon Savage's Blog:
Designing Databases Picking The Right Data Types
November 20, 2009 @ 12:29:38

Brandon Savage has a new post that looks at planning databases for your applications, specifically in the context of picking the right data types for what you're going to store.

When I started writing this blog post, I had titled it "Tips for Designing Databases" and I planned to talk about various database design techniques. However, as I did more and more research, it dawned on me that one of the most crucial, and most overlooked, components of database development, is the selection of data types for columns.

He touches on a few different topics like how disk I/O can play a part in the storage type, what kind of numeric type might be best for the data, text storage recommendations and some of the data storage types he thinks you should avoid.

0 comments voice your opinion now!
data type database opinion


blog comments powered by Disqus

Similar Posts

Richard Smaizys' Blog: Improve your code style with simple tips

JSLabs Blog: An ftp server written in PHP

Derick Rethans' Blog: Storing Date/Times in Databases

CodeForest.net: Key/value tables and how to use them in PHP and MySQL

DevShed: Validating Incoming Data by Using Polymorphism with Objects in PHP 5


Community Events











Don't see your event here?
Let us know!


hack package podcast release unittest introduction install overview facebook component code opinion security application language hhvm example composer framework symfony2

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework