<pedrocorreia.net ⁄>
 

<Less database, more code ⁄ >




clicks: 2436 2436 2006-12-28 2006-12-28 goto tecnologia myNews tecnologia  Bookmark This Bookmark This


Less database, more code... Is it a really healthy solution to long run and lot-of-users services? I recently started to think about it more and more. Especially, after been influenced by that. It really sometimes feels better just to keep as least data in the database as possible, and then proceed with all the processing in the application layer. We can do virtually everything, and we can do everything as flexible as possible. It's code, anyway! You are right - and sometimes it's kind of a headache, but I am talking about long run, remember? You don't want to be stuck with one database, because this is the only one which supports these or that functions. You don't want to pay huge money for support, just to be able to ask to fix something, on what you already made yourself dependent. You don't want later (while failing to find some database function in exactly this database or version) to move some logic into application layer. Come on, that happens. It really does, especially with time lasting upgrades of the database versions, changes of everything you can think of... And of course, by stucking on some point you do get all the "beauty" of adding extra fields, normalization, re-building relationships in the database... That can drop down speed of you application big time!.. just because over the time you stunned with few hundred different tables, and relationships between them suck as much as possible. And you can't imagine how to fix that now. And you have to keep everything up and running. Well, you can be nice to yourself saying that your initial database design was good. Well it was. It was. Was. But it is not now. And that is ugly weird situation with legacy applications. Blaiming your DBA not to update your database structure every week, or blaiming yourself that you didn't want to do code and database updates that often will not help either. You wish then to have everything in code, which you can change, update, delete or extend. When you need it. And you want your database to be built not following all the perfect-kind-of-database-DBA-rules, but following your logic, and your understanding of what we should keep in the database just for storage, not processing. No huge joins, no huge internal sub-selects.



este é só um excerto do artigo, para aceder ao artigo completo, clique no link em baixo:
this is just a small excerpt from the article, to access the full article please click in the link below:

http://objecty.blogspot.com/2006/12/less-database-more-code.html




Subscribe News RSS  Subscribe News Updates by E-mail





myNews <myNews show="rand" cat="tecnologia" ⁄>

MongoDb Architecture new ...

NOSQL has become a very heated topic for large web-scale deployment where scalability and semi-struc (...)

clicks: 16761 16761 2012-05-14 2012-05-14 goto url (new window) horicky.blogspo... goto myNews tecnologia


A Hopefully Fair and Useful Comparison of Haskell Web Frameworks new ...

Recently there has been a lot of discussion and questions about the differences between the big thre (...)

clicks: 13363 13363 2012-05-13 2012-05-13 goto url (new window) softwaresimply.... goto myNews tecnologia


Retina graphics for your website new ...

retina.js is an open source script that makes it easy to serve high-resolution images to devices wit (...)

clicks: 13203 13203 2012-05-11 2012-05-11 goto url (new window) retinajs.com/ goto myNews tecnologia


What every programmer should know about memory, Part 1 new ...

In the early days computers were much simpler. The various components of a system, such as the CPU, (...)

clicks: 14475 14475 2012-05-10 2012-05-10 goto url (new window) lwn.net/Article... goto myNews tecnologia


The State Of HTML5 Video

HTML5 has entered the online video market, which is both exciting and challenging for developers in (...)

clicks: 5507 5507 2012-02-14 2012-02-14 goto url (new window) longtailvideo.c... goto myNews tecnologia


A Tour of Amazon's DynamoDB

Amazon's recent release of DynamoDB, a database whose name is inspired by Dynamo, the key-value data (...)

clicks: 5273 5273 2012-02-13 2012-02-13 goto url (new window) paperplanes.de/... goto myNews tecnologia


Google BigQuery Service: Big data analytics at Google speed

Rapidly crunching terabytes of big data can lead to better business decisions, but this has traditio (...)

clicks: 4930 4930 2011-11-30 2011-11-30 goto url (new window) googlecode.blog... goto myNews tecnologia


Video: CSS3 Secrets: 10 things you might not know about CSS3

A number of prominent front-end developers delivered helpful talks at this year's Fronteers 2011 con (...)

clicks: 5797 5797 2011-11-30 2011-11-30 goto url (new window) css.dzone.com/a... goto myNews tecnologia