[Spaceships] Getting started on a Java-based ship builder

[panton41]

I'm planning on looking into more database options and talking to one of my professors for idea. Great thing about going to university, I have access to an expert in Java and databases. (The same professor offered to share his homebrew with me after I graduate.)

[ericbsmith]

Originally Posted by ciaran_skye

If Eric doesn't mind, I'd like some pointers, based off his spreadsheet experience, about how to structure various parts of it.

I'd be more than willing to chat when you actually start getting into it. As I've said, I really don't know Java nor do I know much about databases... though Excel can be very much like a database when used in certain ways (such as I've used in my sheet), and there are certainly some pointers I can give you in regards to setting up the database for the back end of the program. In fact one of the major reworks of my spreadsheet for v2.0 was a complete revamp of the back end "database" portion of the sheet to address what I found out was a major weakness in the sheet. Had I written it as an actual program using databases it would have been much easier to address that weakness, but at any rate it'll be easier for you if you avoid it altogether by making things more scalable in certain ways right from the start.

[panton41]

On Kuroshima suggestion (over Yahoo) I'm going to go with SQL Lite and build the database backend first. My plan is to have a Spaceship entity built roughly like this:

Spaceship ID			INT
SM				INT
cost				CURRENCY
WS				INT
CS				INT
Front1				INT
...

Center1				INT
...

Rear1				INT
...

From there I'd have an attribute for every item in the vehicle block. There's also be BINARY attributes for the various design switches. I'd also do separate entities for weapon and habitat modules and probably even shoehorn in a way to do something similar to what Eric's done with mix-and-match weapon mounts. I might even put in a few other of Eric's house rules as an add-on data file from the main one.

Probably I'd make the data files be SQL commands and simply have it recreate the underlying database on every load, after asking while files to include. It might take a performance hit at load time, but make up for it by being a fresh database every time and a well-documented language to code new files in. Ditto and saving and loading spaceships.

Eric, I'm going to tear apart your 1.x spread sheet and possibly use it for the raw data files if it's possible to extract that information. If you can suggest ideas about what to put into it I'd be more than happy to take them.

[Puppetminion]

Possible problem, if you hardcode in the locations adding smaller systems becomes very hard.
I've got a reasonably complete FileMaker implementation done, and what I did was split the spaceship over several tables.
Weapons, habitats, open spaces are all fairly obvious but more importantly I used a spaceship table (for SM and ship wide stuff) and a systems table, where basically an entry is <ship ID>, <location>, <system>; eg Viper, F1, Laminate Armour. So if C1 gets split I rename it C1.1 and then add C1.2 & C1.3 records, all with a -1 SM modifier.

Also means I only needed to do a lot of stuff once rather than 21 times.

Don't know if that helps, but I can hope :)