OpenEuphoria

Is Euphoria OK for a large Database?

• Posted by Stuart Brady <stubrady at NILDRAM.CO.UK> Dec 18, 1997
• 845 views

Hello All,

I am interested in writing a large (chess) database program. I am
considering using Euphoria as it seems relatively straightforward. I do
not have any great programming experience and would like some advice...

The source (chess) files come in a text format :-

[Date "1997.06.03"]
[White "Smith, J"]   <---There are about a dozen fields...
[Black "Jones, T"]        ...but may be in a different order...


1.e4 e5 2. Nf3 Nc6 3. Bg5  <---...followed by the moves over a variable
a6 4. Ba4 Nf6 5. etc                         number of lines.

(repeated)

The number of games in a database can be quite high(up to around 1
million!!)
but usually come in smaller packets of around 500 to 2000 (say). A
useful database could easily be constructed with only 50000 games in it.
Sorting and/or searching will be required.

Question 1. Is Euphoria up to the task?

Question 2. I read in an associated website that Euphoria stored
sequences in             a way that used a lot of diskspace. Can the
data be stored in a             reasonably efficient manner? Would I use
sequences for such a             large database?

Question 3. Euphoria seems slightly confusing with regard
to                              strings/sequences(see above?). Any
suggestions as to a nice simple             method of reading in the
aforementioned textfiles?

I have some ideas as to what will be required but would appreciate some
assistance from any Euphoria Grandmasters. ;)

--
All the Best
Stuart