CouchDB: a new way

A few months ago I found out about CouchDB. It is a document database that speaks HTTP: you can manage it from a static HTML page using just HTTP methods: PUT, GET, DELETE and that is an amazing thing. People are reinventing the CRUD wheel last couple of decades and it got so mainstream that no one tries to question that. Why we need to re-implement something that HTTP already has? And that’s true for every web application we see on-line…

What we know as a “record” in relational databases is (almost) a “document” in CouchDB. I’m saying “almost” because a document is a complete thing: a product, an article, a contact, anything, and in relational world a record may be only a piece of something. In relational database terms a document it’s like a completely denormalized entity. Every document is self-contained.

It makes a lot of sense to me because when you gather information on a “record” you have to run across a bunch of tables to get it. Every single time. Relational databases are immensely complex applications and it takes a huge amount of computational power to do that every time. Why don’t we store all the data we need for an entity together and retrieve it quickly when we need it? This is what CouchDB does and I think this is a brilliant approach.

But this is not all: documents are managed as JSON documents which you can easily crunch using JavaScript alone. That’s another reason why I appreciate it so much: is simplifies things. You don’t need a server-side language that would take data from the HTTP request, populate some object, validate, and pass it through an ORM to the database for storage, and this is an enormous gain in computational power and man-effort to write that application code.

One more amazing thing I found in CouchDB is the possibility to attach files to documents. Then you can get it as a part of the document of independently, just as you would download a static file from a web-server. This made me think to store HTML pages in it, as well as CSS files, JavaScript files, images and anything else. So you don’t need anything else to write a web application!

You have a couple of limitation that puts your creativity at work, and this make you review the way you develop a web application on every step. Every request can address a single individual document like “get me the document with ID XYZ”, or a list of document, like “give me the documents that have ID’s from 34 to 42″.

This is only a couple of goodies, that I found for me as a web UI developer. But is has a lot more to offer: fault tolerant (you have to try very very hard to loose data), scalable, fast, and a lot others. If you’re a hardcore RDBMS-oriented developer (and who isn’t??) it may need some time to find your way and to adapt your mind to think the CouchDB way, but even if you don’t like it enough to want to forget everything you know about relational databases and embrace it for it’s simplicity, getting to understand it can dramatically change your viewpoint on web development.

I’ve started an experimental project for CouchDB just to get a feel of how it works and it is amazing.

2010-01-10 02:25:30


Ultimele 25 posturi adăugate

07:45:46Măcelarul din Lunca Prutului – fantoma emblematică a Maiei Sandu sau de ce pe „vremuri bune” lucrurile niciodată nu sunt așa cum par a fi?! —» Sergiu Mocanu
23:46:34Triangle of Sadness —» APort | "Pentru un român care știe citi, cel mai greu lucru e să nu scrie." I.L. Carag
12:59:10La Radio Guerrilla cu Mitoș Micleușanu —» .:EU:.
10:08:23Berliner: gest de solidaritate pentru vinurile moldovenești —» Fine Wine
21:29:07Poliția locală acționează pe alocuri, dar intens —» Curaj.TV | Media alternativă
21:25:29Inspectorul Felix se agită cînd e inspectat —» Curaj.TV | Media alternativă
09:25:46ИНФОРМАЦИОННО ПИСМО —» Biblioteca Hristo Botev
19:45:58True, Biblical Friendship —» Erik and Elena Brewer's Weblog
19:13:58Mai Departe cu Viorica Tătaru – Pe front în Ucraina, Propaganda de război, Transnistria —» Curaj.TV | Media alternativă
19:11:51Pericole la zebra de la parcul Bazilescu, Bucureștii Noi —» Curaj.TV | Media alternativă
15:23:47What’s New on Tools to Make Designing Your Site Easier Than Ever —» Misterioz
14:50:26Program_Campania Naţională ,,Citim cu voce tare împreună” ediţia anului 2023 —» Biblioteca Publică or.Rîşcani
14:44:06Anunţ - Poster_Campania Naţională ,,Citim cu voce tare împreună” ediţia anului 2023 —» Biblioteca Publică or.Rîşcani
14:35:47Lectura — hrană nobilă pentru suflet —» Biblioteca Hristo Botev
14:31:1227 Ianuarie - Ziua Comemorării Victimelor Holocaustului. —» Biblioteca Publică or.Rîşcani
10:15:03Pericol mortal in pasajul de la Guvern pe motiv de neglijență —» Curaj.TV | Media alternativă
04:57:00De ce familia mea nu consumă carnea de pui din comerț, laptele cu termen mare de valabilitate și marmelada —» Sunt MAMĂ!
21:27:45„Amintiri din trecutul Terrei” de Liu Cixin – o părere sinceră despre cărți (fără spoilere) —» Andrei Albu - omul alb cu gînduri negre
18:42:59Citit în ianuarie: „Oameni sărmani” de F.M. Dostoievski —» Sunt MAMĂ!
14:52:14Haiku (trad. în spaniolă) —» Andrei LANGA. Blogul personal
14:43:17CEREȚI vs. CERE-ȚI – când punem cratima? —» Moldova Creștină
14:35:20Caleidoscop cultural. Februarie, 2023 —» Biblioteca de Arte 'Tudor Arghezi'