RDBMS

St-Cyr · #1 October 27th, 2001, 01:25 AM

I was told by a friend that he spend up to 30 hours extracting out an ordered file to figure out the best ways to use components.

Told him he should have converted those data files to csv files and import these in a RDBMS.

I didn't convince him. So, I tried my own medecine. Took me about 10 minutes to convert one of those file so that I could load it in a database. I did another couple of files and then started to play with relationships. Hmm.. had fun. I'm a DBA. Of course I prefer to design than to administer so it's always fun to figure things out.

I found a lot of flame-threads with people hinting at programmer's knowledge. I've also read that SE up to Version 2 was written in VB and Delphi afterwards.

Just wondering, was there an effort to use relational databases, either inside malfador or by the mods community?

Mephisto · #2 October 26th, 2001, 02:00 PM

This is a very friendly community, no one will be flamed here. I think in the history of this board there were only 2 or 3 people that could not act like grown-ups and were expelled after 2 warnings. So, don't be afraid of flames, you don't need your protective suit here.

quote:
Originally posted by St-Cyr:
Just wondering, was there an effort to use relational databases, either inside malfador or by the mods community?

Now I'm lost. What is such a database and what can you do with it?

Lemmy · #3 October 26th, 2001, 02:45 PM

i don't think anyone here even mentioned relational databases but you St-Cyr.
Maybe malfador used it, mayube not, you would have to ask them to be sure.

St-Cyr · #4 October 26th, 2001, 03:07 PM

Sorry, maybe not a lot. Hmm let's say exchanges about how easy a change in the SEIV app was or not. Seen, hrmm... read some about this.

What's a relational database?

In life: Oracle, MS-SQL, DB2, Sybase, MySQL, Access, etc

In science: mostly symply 3 rules which are called the 3 normal forms as defined by Cobb + add meta-data to it.

Those are real easy to find on the web so I won't enumerate them here. I'll just preach for my own:

Very simplified, it's a way to solve validation and assertion problems in a multi-user setting while the data is coming IN and not when it's going OUT.

I've seen/helped it solve excruciating logical and/or performance problems. A mouse click that used to take 45 seconds now takes the animation time to depress it; a night job that needed full cpu for 8 hours now runs in 5 minutes during rush-hour; etc.

LazarusLong42 · #5 October 26th, 2001, 03:28 PM

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 · #6 October 26th, 2001, 07:38 PM

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.