<pedrocorreia.net ⁄>

<Less database, more code ⁄ >

clicks: 3595 3595 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:


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: 21591 21591 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: 26996 26996 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: 17191 17191 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: 20594 20594 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: 8086 8086 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: 7466 7466 2012-02-13 2012-02-13 goto url (new window) paperplanes.de/... 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: 8153 8153 2011-11-30 2011-11-30 goto url (new window) css.dzone.com/a... 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: 7449 7449 2011-11-30 2011-11-30 goto url (new window) googlecode.blog... goto myNews tecnologia