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

PHPMaster.com: Data Structures for PHP Devs: Heaps

Anthony Ferrara: Framework Fixation - An Anti Pattern

Reddit.com: A Response to "The MicroPHP Manifesto"

Medium.com: PHP7: More strict! (but only if you want it to be)

Paul Jones: Action-Domain-Responder and the “Domain Payload” Pattern


Community Events

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


community symfony2 voicesoftheelephpant application series version performance introduction release extension php7 conference laravel api framework podcast interview library example opinion

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