Hello, I would be interested to know if RoR supports basic CRUD operations through WebDAV? In a nutshell, I would like to be able to manipulate ActiveRecords by directly "mounting" a database on my file system and then simply create, read, update and delete records "in place"... Thoughts? Cheers -- PA, Onnay Equitursay http://alt.textdrive.com/
PA wrote:> I would be interested to know if RoR supports basic CRUD operations > through WebDAV?Rails supports you building such an app. Sounds interesting. jeremy
On 31/03/2005, at 1:00 AM, PA wrote:> I would be interested to know if RoR supports basic CRUD operations > through WebDAV?Yes. It also fetches the paper and gives back massages. Any other requests? ;)> In a nutshell, I would like to be able to manipulate ActiveRecords by > directly "mounting" a database on my file system and then simply > create, read, update and delete records "in place"... > > Thoughts?Sounds interesting, though how would you represent an AR in the filesystem? How would you encode, and what program could manipulate it? I guess I''d be inclined to have it represent the record as YAML or XML, and then write a Cocoa program that could edit and save. Hrmm... this could be very interesting. - tim lucas
On Mar 31, 2005, at 00:52, Tim Lucas wrote:> On 31/03/2005, at 1:00 AM, PA wrote: >> I would be interested to know if RoR supports basic CRUD operations >> through WebDAV? > > Yes. It also fetches the paper and gives back massages. Any other > requests? ;)Yes. Coffee?>> In a nutshell, I would like to be able to manipulate ActiveRecords by >> directly "mounting" a database on my file system and then simply >> create, read, update and delete records "in place"... >> >> Thoughts? > > Sounds interesting, though how would you represent an AR in the > filesystem? How would you encode, and what program could manipulate > it?Most mainstream operating systems support WebDAV at the file system level... so whatever one uses to access the file system become the editor... in Mac OS X, this would be the Finder... on Windows, Explorer or some such... etc... From a user perspective, the database, once mounted as a WebDAV drive/folder/whatnot on a filesystem, is a set of folder structures and files. The folder represent the database tables and the files the rows themselves. For example, to use the Cookbook Database as an illustration, one could view it directly in the file system as the following folder structure: ~/cookbook/recipes/ The record themselves could be represented as plain text files, their names defaulting to the row primary key: ~/cookbook/data/recipes/1.txt The file content would reflect the record content: title: Hot Chips description: Only for the brave! instructions: Sprinkle hot-pepper sauce on corn chips. Changing record values boils down to edit such a file in your favorite text editor and press save. Creating a record means creating such a file. Deleting means, well, deleting such a file. Etc. In other words, you get direct record manipulation at the file system level. Out-of-the-box. No need for any extra anything. Optionally, one could represent table''s relationships as folders as well. The same principle could be applied when defining a database structure in the first place: ~/cookbook/meta/recipes/title.txt To create a database, create a top level folder. To create a table, create a folder under the database "meta" directory. To create a row attribute, create a plain text file under the table folder containing the attribute definitions: type: VarChar length: 255> I guess I''d be inclined to have it represent the record as YAML or XML,YAML is fine. The textual representation should strive to be "wetware" friendly. Optionally/additionally, the WebDAV response itself could contain the record attributes as well.> and then write a Cocoa program that could edit and save.No need for any esoteric client side stuff. Your file system and a plain text editor should suffice.> Hrmm... this could be very interesting.Yes! And... this should be really part of the framework itself as it''s totally generic and provides "out-of-the-box" CRUD operations. No need even for scaffolding anything. Painless and straightforward :) Cheers -- PA, Onnay Equitursay http://alt.textdrive.com/
On Mar 30, 2005, at 19:27, Jeremy Kemper wrote:> PA wrote: >> I would be interested to know if RoR supports basic CRUD operations >> through WebDAV? > > Rails supports you building such an app. Sounds interesting.Some literature... not to take literally though 8^) "An Application for WebDAV-based Authoring of Databases - WebDAD" http://www.cs.bris.ac.uk/Publications/pub_info.jsp?id=2000012 Cheers -- PA, Onnay Equitursay http://alt.textdrive.com/
* PA <petite.abeille-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> [0331 12:31]:> Most mainstream operating systems support WebDAV at the file system > level...As someone who''s spent the last month working around crappy bugs in all DAV clients, can I stick a ''hah!'' here for the record. Finder #1 shit bug: no SSL support (fixed in Tiger finally). There are others. M$ "Microsoft Data Access Internet Publishing Provider DAV" (a.k.a. ''web folders'') #1 shit bug: Oooh, it''s so hard to choose! Hmm, lets'' try: when you talk to a ssl server and are not allowed to see the toplevel folder (because it''s a shared server, duh), IE tries password auth, fails, and asks the user for a client certificate. despite the fact that the server doesn''t want one. then when you cancel, it asks again. and again. about 200 times for a collection of about two dozen files. I finally fixed this with some very nasty mod_rewrite voodoo, which on a hassle/benefit scale is about on a par with raising the dead to open a jar for you.> so whatever one uses to access the file system become the > editor... in Mac OS X, this would be the Finder... on Windows, Explorer > or some such... etc...Yeah you''d think so wouldn''t you? Unless you''re on winders, in which case web folders just passes the url to word and friends, who force you to log in again....... No, no, I''m fine, really. -- ''A little rudeness and disrespect can elevate a meaningless interaction into a battle of wills and add drama to an otherwise dull day.'' -- Calvin discovers Usenet Rasputin :: Jack of All Trades - Master of Nuns
On Mar 31, 2005 6:33 AM, Dick Davies <rasputnik-ogHSZ3ARDZIOXkKaSkYkkl6hYfS7NtTn@public.gmane.org> wrote:> * PA <petite.abeille-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> [0331 12:31]: > > > Most mainstream operating systems support WebDAV at the file system > > level... > > As someone who''s spent the last month working around crappy bugs in all > DAV clients, can I stick a ''hah!'' here for the record. > > Finder #1 shit bug: no SSL support (fixed in Tiger finally). There are others. > > M$ "Microsoft Data Access Internet Publishing Provider DAV" (a.k.a. > ''web folders'') #1 shit bug: > > Oooh, it''s so hard to choose! Hmm, lets'' try: > > when you talk to a ssl server and are not allowed to see the toplevel folder > (because it''s a shared server, duh), IE tries password auth, fails, > and asks the user for a client certificate. > despite the fact that the server doesn''t want one. > then when you cancel, it asks again. and again. > about 200 times for a collection of about two dozen files. > > I finally fixed this with some very nasty mod_rewrite voodoo, which on a > hassle/benefit scale is about on a par with raising the dead to open a jar > for you. > > > so whatever one uses to access the file system become the > > editor... in Mac OS X, this would be the Finder... on Windows, Explorer > > or some such... etc... > > Yeah you''d think so wouldn''t you? Unless you''re on winders, in which case > web folders just passes the url to word and friends, who force you to log in > again....... > > No, no, I''m fine, really.You can map a Webdav folder to a drive in Windows. net use z: http://server/path/to/webdav http://www.microsoft.com/windowsxp/home/using/productdoc/en/default.asp?url=/windowsxp/home/using/productdoc/en/net_use.asp -- rick http://techno-weenie.net
On Mar 31, 2005, at 14:33, Dick Davies wrote:> As someone who''s spent the last month working around crappy bugs in all > DAV clients, can I stick a ''hah!'' here for the record.As someone who wrote a broken WebDAV server in one Mojito imbibed afternoon [1], let me retort: (1) Darwin''s WebDAVFS do not support TLS at this time. This is a well known shortcoming. You might want to consider Goliath or Transmit if you absolutely require secure connections at this time. (2) Windows Data Access works fine as it is but you might be better off mapping your WebDAV folders directly to a drive, as mentioned by Rick Olson. Beside "net use", I had good experiences with South River''s WebDrive: http://www.southrivertech.com/ All in all, your complains seem to boil down to a lack of stelar support for TLS. Perhaps. But this is not what this thread is about. Cheers -- PA, Onnay Equitursay http://alt.textdrive.com/ [1] http://dev.alt.textdrive.com/file/LW/LWDAVService.lua
* Rick Olson <technoweenie-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> [0349 20:49]:> On Mar 31, 2005 6:33 AM, Dick Davies <rasputnik-ogHSZ3ARDZIOXkKaSkYkkl6hYfS7NtTn@public.gmane.org> wrote: > > > > No, no, I''m fine, really. > > You can map a Webdav folder to a drive in Windows. > > net use z: http://server/path/to/webdavI get ''system error 67 has occurred''. Maybe it doesn''t support https://, or you need to be on the LAN or something (although it doesn''t seem to like talking to a local DAV box either) ? In any case, this doesn''t work on a mac (which was the point originally, until we realised OSX doesn''t do security). Cheers anyway though. -- ''Interesting. No, wait, the other thing - Tedious.'' -- Bender Rasputin :: Jack of All Trades - Master of Nuns
I guess you mean something like this. http://jakarta.apache.org/slide/wck.html or the way Zope does it (I believe). I never seen a DAV server implementation in Ruby or PHP, let alone a Rails adaptor for it. It is also interesting in which format do you intend to marshall ActiveRecord in there and for what client. Maybe it can be possible to forward PROPFIND, PROPPATCH etc. to mod_ruby though. On 30-mrt-05, at 17:00, PA wrote:> Hello, > > I would be interested to know if RoR supports basic CRUD operations > through WebDAV? > > In a nutshell, I would like to be able to manipulate ActiveRecords by > directly "mounting" a database on my file system and then simply > create, read, update and delete records "in place"... > > Thoughts? >-- Julian "Julik" Tarkhanov
On Mar 31, 2005, at 23:30, Julian ''Julik'' Tarkhanov wrote:> I guess you mean something like this. > > http://jakarta.apache.org/slide/wck.htmlYes. Kind of. Slide''s WebDAV Construction Kit is, well, a construction kit. I''m looking for something for database authoring. In other words, not a toolkit, but rather an out-of-the-box solution.> or the way Zope does it (I believe). > > I never seen a DAV server implementation in Ruby or PHP, let alone a > Rails adaptor for it.Well... this is a glaring deficiency which I hope will be correct soon.. after all, if RoR sports a so called "Action Mailer", it should handle WebDAV as well...> It is also interesting in which format do you intend to marshall > ActiveRecord in there and for what client.http://article.gmane.org/gmane.comp.lang.ruby.rails/5798/> Maybe it can be possible to forward PROPFIND, PROPPATCH etc. to > mod_ruby though.http://article.gmane.org/gmane.comp.lang.ruby.rails/5800/ Cheers -- PA, Onnay Equitursay http://alt.textdrive.com/