RFC: Dom3 DB

[B0rsuk]

At the moment, I packed both age and nation into same column, and think it's probably a good idea. Even Machaka, which only exists in middle era, is Machaka2. Should probably be 2Machaka...

For spells, I suggest categorizing them by their purpose. Later, when I grep things, I'll want to filter spells which let me devastate enemy provinces, buff my provinces, etc. I don't like idea of having both Forest Dome and Seeking Arrow in same category.
rituals:
- assasination (targets an enemy commander)
- artillery (targets enemy province - fires from afar or ghost riders)
- travel/movement
- paratroopers (separate cattegory, because this may allow you to take control of a province)
- summon
- global enchantment
- local,(beneficial) enchantment (Domes, Watcher, Three Red Seconds)
- other
----
battle:
- selfbuffs
- army buffs
- weakening spells (False Fetters, Numbness, Slime...)
- offensive (various damage dealers)
- sniper spells (single target offensive spells)
- symmetric (Darkness, Storm, Rain of Blood, Heat from Hell, Acid Rain)
- reinforcements (Raise Skeleton, Mists of Deception, Howl)

[Agrajag]

B0rsuk said:
battle:
- selfbuffs
- army buffs
- reinforcements (Raise Skeleton, Mists of Deception, Howl)

Why seperate selfbuffs from army buffs? You could just search for "buffs" and then check for a Range of "self".
Making a secondary search by Range seems to make more sense to me, since there are always those confusing spells like Body Etheral.
Also, why call them "reinforcements" when battle summons would do it? Merely cosmetic, I know, but just wondering.

[Gandalf Parker]

Its definetly a DB type of project. But please dont limit it by MSing it.

[Agrajag]

Gandalf Parker said:
Its definetly a DB type of project. But please dont limit it by MSing it.

I wouldn't know about what exactly he has in mind, but I suspect that a "port" from ms-bound to "free" would be fairly easy.
Since accessing an access database is still done via simple SQL querys AFAIK, it shouldn't mean much work to just switch to another database type.

Feel free to correct me if I'm wrong, I don't have much experience :X

[Edi]

Gandalf Parker said:
Its definetly a DB type of project. But please dont limit it by MSing it.

I've never intended it to be MS only. In fact, I'm doing my stuff natively in Open Office and trying to make it so that the data will be readable straight into a SQL database. So most of this will be usable to you in any case.

Edi

[Gandalf Parker]

I understand that an MS file can be read non-MS programs but Im not sure if that holds true on non-MS machines.