RDBMS

[LazarusLong42]

St-Cyr,

I work with databases quite a bit even though I'm not an actual DBA. (I use Access and mySQL). I don't see any really _useful_ way in which an RDB could be used by players or modders, though... which I think is why you don't see many people talking about them here.

What sort of things would you be talking about doing with SE4 and an RDB?

(Within the game, of course, I can see a lot of call for all sorts of relations, but that's somethign else

LL/Eric Snyder II

[Puke]

i dont see a whole lot of use here for a RDB either. people have dumped things like the components file into spreadsheets to analyze different damage / weight / RoF ratios, and other such things.. but unless you wanted to extract the most optimal ship design with a given technology level or something, im not sure what you would accomplish.

[Atrocities]

DBA is one job that I would not envy having. It takes a special kind of person with a keen analitical eye to do that kind of work. The most I have done with Data Basing is with Acess and MySQL. Now statistics, thats for me. God showed man how much he cared when SPC was realized.

------------------
New Age Ship Yards

"We've made too many compromises already, too many retreats! They invade our space and we fall back -- they assimilate entire worlds and we fall back! Not again! The line must be drawn here -- this far, no further! And I will make them pay for what they've done!" -- Captain Picard STNG

Borg Breen Species 8472 Cardassian Dominion STNG Ferengi Klingon Romulan
Trek Movie era TOS Illuminati Starwolf

[Atrocities]

Here is the old thread about CODE. Read at own risk.

[Alpha Kodiak]

Malfador could have used an RDBMS for storing all of the data in the various AI files, component files, etc. and it would have probably worked more efficiently than parsing the text files, as is now done. The advantage to the text files is that anyone with a text editor can make their own modifications to the game. It would have been difficult (possible, but difficult) to provide the customization flexibility we have now using a database scheme to store all of the information.

If this were a production package where stability and data integrity were critical, I would definitely want it running on an RDBMS, but I believe that for a game of this nature, the text files are the way to go.

Having said that, I believe that the game would probably be more stable and perform faster if the data was in an RDBMS. What might have been cool, and might be good for SE5 would be to use the text files to populate an RDBMS. Then, people could make their changes to the text files and run a utility to load the changes into the database. Data validation would occur at that time, so you would never see an error crop up in the game because you hit an error in the text file. Multiple mods could easily be supported by adding a mod name to the key information for storing and extracting the data. I would imagine that this would entail a significant internal architecture change though, so we would not see anything like that in SEIV.

Ok, time to take off my designer's hat. It's too much fun to think about what could be done in a game when I am supposed to be debugging a GIS query interface that keeps wanting to lose the operator's selections.

[Puke]

are we talking about the design of the game, or utilities to mod the game or play more effectively?

[St-Cyr]

Alpha Kodiak said most of what I was thinking about.
Loading files text files as they are in a RDB gives me the possibility of asking Queries in any direction I want. Kind of what people are getting with spreadsheets.

One way to use RDB would be to code a WinAPI file extension (virtual directory) so that multiples mods could be stored in a db and be shown as virtual files for PBW. Am working on something like this for a app about documentation for quality control. Files are basically built on the fly from the DB as soon as someone try to access them. That's how windows manages control panels, Favorites and printers by the way.

Of course if data is stored in DB it begs to simply use it to resolve the turn but this is malfador internals, I guess.

There are nifty tricks hidden in SQL. Ever read Joc Celko's SQL Puzzles?