News 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

Anna Filina's Blog: Developer Community: Where to Start? Part 1

Reddit.com: Any ideas on what "MVC agnostic" PHP code is?

ProWebDeveloper.info: Reducing Database Load with Secure Client-side Sessions

Travis Swicegood's Blog: Repository Pattern in PHP

Debuggable Blog: How to Fetch the ENUM Options of a Field - The CakePHP Enumerable Behavior


Community Events





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


update zendserver podcast package library introduction laravel community framework language api deployment release list tips symfony series opinion interview install

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