DOE: Locations Extension

Quote:

---

Originally Posted by dr_venture

You do know I was joking, right?

---

Of course I know - obviously I need to work on my sarcasm generator :p

Quote:

---

Originally Posted by dr_venture

I actually programmed a web page a couple years back to use that Medieval demographic info on countries to generate all the cities, towns, hamlets, etc., with all the businesses (and the like: temples, etc.) and the proprietors. I just the generated the owners, their families, and some apprentices -- I didn't even create all the citizens, farms, etc. I quickly started creating XML files that were so bloated that they were problematic to deal with.... and I was generating pretty concise XML compared with FG.

It was a really fun experiment, but just way too unwieldy to actually use with XML. You have to use a proper database, which gets into a whole other ball of wax that I didn't want to get mired in.

---

Yeah, way too complex for a flat DB structure like XML - I use Firebird RDMS (open source, small footprint and waaaaayyy better than MS-SQL or MY-SQL) and good old dBase (the modern version) for the Front-end for a lot of my DB stuff - I was actually working on a RDMS character generator of 3.5DnD when I stumbled across FG - I would have never used XML for the DB structure of something like this but I'm glad SW got it to work.

Do you still have the demographic data? I wouldn't mind getting a copy of it if you do.

Cheers

Quote:

---

Originally Posted by dulux-oz

Do you still have the demographic data? I wouldn't mind getting a copy of it if you do.

---

I just used the info from this site, which seems to provides a good ground work to start from: https://www222.pair.com/sjohn/blueroom/demog.htm

There is a PDF at DriveThruRPG that is much, much more comprehensive, called the "A Magical Medieval Society: Western Europe". It provides tons of great info, and you can even download a free subset of the book here: https://rpg.drivethrustuff.com/produ...ety-City-Guide

I have a much more detailed list of occupations than are listed in either of the above sources, which I'm happy to share with you if you like.

Hope those provide some useful info for you!

Wow, this extension is really getting fancier! Great work! I will definitely use this in my SW Army of Darkness game to record all demonic places :)
EDIT: comments about exporting were unnecesary

Quote:

---

Originally Posted by dulux-oz

Yeah, way too complex for a flat DB structure like XML - I use Firebird RDMS (open source, small footprint and waaaaayyy better than MS-SQL or MY-SQL) and good old dBase (the modern version) for the Front-end for a lot of my DB stuff - I was actually working on a RDMS character generator of 3.5DnD when I stumbled across FG - I would have never used XML for the DB structure of something like this but I'm glad SW got it to work.

---

FireBird vs any other DB will depend very much on its purpose and the size of the DB and the performance required and other things.
As to using XML for FG - it is probably a way better solution in terms of its ease of install - image having to support users issues with installing SQLExpress or SQLEmbedded.
And add Mac support via WINE into that equation.
For all its limitations - the XML storage is very portable and simple to install.

Quote:

---

Originally Posted by damned

FireBird vs any other DB will depend very much on its purpose and the size of the DB and the performance required and other things.
As to using XML for FG - it is probably a way better solution in terms of its ease of install - image having to support users issues with installing SQLExpress or SQLEmbedded.
And add Mac support via WINE into that equation.
For all its limitations - the XML storage is very portable and simple to install.

---

Oh, I agree. For the size of DBs FG has to handle and for all of the support and other points you raised, a flat file structure (like XML) is the best way to go. My point was, as a (former) DBA my first inclination wasn't for a flat file structure but for a RDMS, and of the available RDMS's out there my first choice is almost always FireBird - but I'm glad that SW has gotten FG working with XML (I don't think I could have) - I'm just miss having the relational functions a RDMS has: I had to write all the relational code for the Locations DB Extension by hand, and I haven't had to do that in a long, looonnngg time (and now my brain hurts :( ). :)

This is as far as I got -- the town name links went to town detail pages with info on the shops there, owners names & deets, etc. All the data there (other than the county's size in sq. miles and over-all population density) is 100% calculated or random (as evidenced by some of the less than graceful place names from my faux English city/town name generator). I suppose I could get it running fully again, add the new data fields from your extension, and just export the data into your extension's FG format, insert it into the campaign db file...

Quote:

---

Originally Posted by dr_venture

This is as far as I got -- the town name links went to town detail pages with info on the shops there, owners names & deets, etc. All the data there (other than the county's size in sq. miles and over-all population density) is 100% calculated or random (as evidenced by some of the less than graceful place names from my faux English city/town name generator). I suppose I could get it running fully again, add the new data fields from your extension, and just export the data into your extension's FG format, insert it into the campaign db file...

---

Sorry, being a bit dense this afternoon - what are we looking at?

this is a screenshot from dr_ventures previous world builder...

see post above

Quote:

---

Originally Posted by damned

this is a screenshot from dr_ventures previous world builder...

see post above

---

Oh, is that what it is?

OK, now I can see it - nice job.

Quote:

---

Originally Posted by damned

this is a screenshot from dr_ventures previous world builder...

---

Correct - a cookie for damned. That sounds like it should be a song title.