I, too, would be interested in this sort of information, as I might have a summer job indexing a local newspaper's back issues for the first time. They really don't care how its done as long as its searchable, so I originally thought "flat file". However, something more complex than a flat file certainly lends itself to better access options, and possibly easier updates (which might be worth a bonus from them).
--- Tim reid [email protected] wrote:
I'm thinking of programing/writing/whatever a database to keep track of some information for work. I think that I would like to keep track of 7-12 fields of information, and be able to set up reminders that are tagged to date information. For instance, "you did such and such 30 days ago...you can now file the claim, here is the information that you recorded earlier."
How would i go about doing this, free as in beer, in an open database format? Let me also mention that I'm a total newb ;)
TIA,
Tim
__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
On Mon, 25 Apr 2005 22:38:06 -0700 (PDT) Leo Mauler [email protected] wrote:
I, too, would be interested in this sort of information, as I might have a summer job indexing a local newspaper's back issues for the first time. They really don't care how its done as long as its searchable, so I originally thought "flat file". However, something more complex than a flat file certainly lends itself to better access options, and possibly easier updates (which might be worth a bonus from them).
You'll want to stay away from flat file for performance reasons. I'd suggest putting the data in PostgreSQL which has a nifty full text searching add-on called tsearch2.
Basically with tsearch2 you can do search engine like searches on your textual data and have it sorted by how good of a match you get.
--------------------------------- Frank Wiles [email protected] http://www.wiles.org ---------------------------------