Hi I want to write a simple Rails app that gets a list (of TFS Workitems) using a Web Service and presents it on a web page to users. I would like to: * try and avoid using a DB (for simplicity) * have a free text search * filter and sort the list * user login * different users see different subsets of list data * maintain a complete copy of the list in my app. Update regularly by calling WS for latest changes. * keep things simple as I am a noob so my questions are: 1) how should I store my data (DB, XML file? etc). If DB - which? 2) how should I do the regular update. Rake,CRON etc 3) based on storage choice, how do I do free text search. I have read about ferret and sphynx. Do they require DBs? thanks for any suggestions Rhubarb
Hi I am also interested to know if there are any tools/techniques that can help with * list presentation functionality * presentation code minimisation Rhubarb
Rhubarb wrote:> Hi > I want to write a simple Rails app that gets a list (of TFS Workitems) > using a > Web Service and presents it on a web page to users. > > I would like to: > * try and avoid using a DB (for simplicity)In many cases, using a DB makes things simpler.> * have a free text search > * filter and sort the list > * user login > * different users see different subsets of list data > * maintain a complete copy of the list in my app. Update regularly by > calling > WS for latest changes. > * keep things simple as I am a noob > > so my questions are: > 1) how should I store my data (DB, XML file? etc). If DB - which?Probably a DB will be easiest. I recommend PostgreSQL.> 2) how should I do the regular update. Rake,CRON etcThere are many possibilities; I''ll let folx who are more familiar with them address that question.> 3) based on storage choice, how do I do free text search. I have read > about > ferret and sphynx. Do they require DBs?I think so, but honestly, you''ll want a DB anyway for this project.> > thanks for any suggestions > RhubarbBest, -- Marnen Laibow-Koser http://www.marnen.org marnen-sbuyVjPbboAdnm+yROfE0A@public.gmane.org -- Posted via http://www.ruby-forum.com/.
On Oct 2, 2:41 pm, Marnen Laibow-Koser <rails-mailing-l...@andreas- s.net> wrote:> > > 3) based on storage choice, how do I do free text search. I have read > > about > > ferret and sphynx. Do they require DBs? > > I think so, but honestly, you''ll want a DB anyway for this project. >sphinx doesn''t require a db- as long as documents have a unique numeric identifier you can feed sphinx and can also give it your data as suitably formatted xml. But yeah, I don''t see why avoiding a db is a particularly good idea (although depending on the shape of your data a non relational database may be more appropriate than a relational one - from what has been said so far it doesn''t look like this is one of those cases) Fred> > > > thanks for any suggestions > > Rhubarb > > Best, > -- > Marnen Laibow-Koserhttp://www.marnen.org > mar...-sbuyVjPbboAdnm+yROfE0A@public.gmane.org > -- > Posted viahttp://www.ruby-forum.com/.