> It would be useful if I can search for all words in the
> data base beginning with a certain string, e.g. search for
> "happ*" and find "happy" and "happiness", etc.
[Damien]
The "like" operator is your friend;)
>
> The program I will write will execute for a very long time
> (several hours, since it will download information from
> websites using HTTP), meaning that there is a risk of
> crashes. If there is a crash, it is important that the data
> base is intact, so that I can begin processing where it
> ended before the crash.
[Damien]
Just do "commits" after updating/inserting values onto the database.
As long a there isn't too many current users querying the database at the
same time, SQLite which is integrated in RB works well.
My 2 cents!
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
