From mboxrd@z Thu Jan 1 00:00:00 1970 Message-ID: <0f1e54b186151c0eecc0003c812124f7@quanstro.net> From: erik quanstrom Date: Fri, 17 Apr 2009 09:22:26 -0400 To: 9fans@9fans.net In-Reply-To: <5d375e920904170531w7d6992ebvee1698d46e668f25@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit Subject: Re: [9fans] web server Topicbox-Message-UUID: e164927c-ead4-11e9-9d60-3106f5b1d025 On Fri Apr 17 08:33:12 EDT 2009, uriel99@gmail.com wrote: > And then you would need some hideous SQL database. > > As ken said: we have persistent objects, they are called files; and > that is what werc uses. i feel compelled to defend one of my favorite quotes of all time from misapplication. i'm sure that werc is well-engineered for its domain, but the mistake i see is generalizing this into sql sucks. just as a point of pedantry, in a standard sql database, there are no objects. sql does not suck. here's why. sql databases are really good at keeping relationships between rows (here's the important part) with no locking visible to the client. even better in the face of non-static requirements, more relationships can be added on the fly. it's hard to do this with flat files, and file-based locking (like upas does for mbox files) is pretty tricky. - erik