News Feed

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

Etienne Kneuss' Blog: Dataflow Type Analysis for PHP

Felix Geisendorfer's Blog: Migrating from WordPress to CakePHP

Brandon Savage's Blog: Hitting the Database Less: Quick and Dirty Strategies for Database Efficiency

SitePoint: Blog Software Smackdown - The Big 3 Reviewed

DevShed: Handling MySQL Data Set Failures in PHP 5

Community Events

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

podcast conference framework development bugfix zendserver symfony threedevsandamaybe deployment laravel series api code release interview list tips introduction community language

All content copyright, 2014 :: - Powered by the Solar PHP Framework