Databaseless app choices

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.

  1. how should I do the regular update. Rake,CRON etc

There are many possibilities; I’ll let folx who are more familiar with
them address that question.

  1. 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
Rhubarb

Best,

Marnen Laibow-Koser
http://www.marnen.org
[email protected]

On Oct 2, 2:41 pm, Marnen Laibow-Koser <rails-mailing-l…@andreas-
s.net> wrote:

  1. 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

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs