Ideas for database structure / Dictionary

[eluser]Crafter[/eluser]

The amount of languages is dynamic. Let’s say, somebody could add French or Chinese.

Then perhaps consider a single table multilinguage_dictionary (phrase, translated_phrase, source_lang, translated_language).

You would then have:
'to put", "setzen" ,"en", "de"
'to put", “stellen”, "en", "de"
'to put", “legen", "en", "de"

You'd have to perform some magic with indexes,and you'd probably have to use construct like database views. You'd probably have move in both directions to lookup.

Man it could be a performance nightmare, but your code will be as smooth as silk

Perosnally, i don't think using a database for lexicon applications is the right way. I'd program this in a language like C, where I'd probably have to build the database structures in the heap (using pointers).