From mboxrd@z Thu Jan 1 00:00:00 1970 Message-ID: <4926A19F.9030409@proweb.co.uk> Date: Fri, 21 Nov 2008 11:55:11 +0000 From: matt User-Agent: Icedove 1.5.0.14eol (X11/20080724) MIME-Version: 1.0 To: Fans of the OS Plan 9 from Bell Labs <9fans@9fans.net> References: <3d61afbea6c3d54d8371a08214902949@9netics.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Subject: Re: [9fans] web-based plan 9? Topicbox-Message-UUID: 4e6440d0-ead4-11e9-9d60-3106f5b1d025 > > Moreover such a dbfs should allow rapid development of views over data > (with different permissions) by simply write the query in a file and > then open the file for reading the XML. > I've tried a couple of times to map files / directories on to SQL and it is not a great match imho. I wrote a Limbo module that handles the postgresql protocol and frankly that's as far as I thought it should be taken, writes are one time use and any returned qureries are (potentially) outdated by the time the client gets them. Any FS would end up as a read only cache with somewhere to send sql writes and a load of logic that repeats what's on the SQL server already. I split my system into two - one to deal with the SQL and one that makes a FS tree from columnated data. Though I abandoned dev on the tree because I just ended up accessing the data through the Limbo pg module directly.