IPB

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Shadowhelix Database, database project of the Shadowhelix wiki
lokii
post Apr 16 2016, 05:22 PM
Post #1


Keeper of the Timeline Maps
**

Group: Members
Posts: 409
Joined: 21-December 10
Member No.: 19,243



This thread is about the Shadowhelix Database (shxdb) project, a database ("Datenbank") for Shadowrun information and meant to support the development of the German wiki Shadowhelix but of course can used for other purposes (and wikis) as well. I give you a short overview and will update the thread when major expansions, new features or views are available. I will crosspost this information to ShadowGrid aka the Catalyst Shadowrun forum.

The principal project site is: http://shadowhelix.pegasus.de/Shadowhelix:Datenbank It has the database tables in TSV format (tab separated values). It also links to this page with a description of how to import the files into an SQLite database: http://shadowhelix.pegasus.de/Shadowhelix:...k/Umsetzung_SQL I can provide an English translation if there is interest. The database itself already uses English for its structural terminology.

What is provided right now is a lot of information about Shadowrun contributors, illustrations, most of the publications and some Sixth World information. Though as it relies on numerical IDs for all kinds of objects you might find it difficult to access the information without a database management system.

(Don't know if this should go into community projects but it looks a bit abandoned over there.)
Go to the top of the page
 
+Quote Post
lokii
post Apr 16 2016, 05:24 PM
Post #2


Keeper of the Timeline Maps
**

Group: Members
Posts: 409
Joined: 21-December 10
Member No.: 19,243



And few interesting and maybe useful by-products:

The Shadowhelix:Signaturidentifikation (signature identification) is a tool to identify an artist based on the signatures on illustrations.

This page is for matching DeviantArt Shadowrun illustrations using their illustration id in the database. Incidentally it is also a list of the official Shadowrun artwork that the artists uploaded to their DeviantArt accounts. Well, you could also use this favourites list: http://dirkloechel.deviantart.com/favourit...un-Official-Art. I based the page on it. But the list was provided for this purpose so I still chalk it up to the database. (IMG:style_emoticons/default/wink.gif)

Finally another temporary page not a final presentation of database content; this page has a hierarchical list of Shadowrun corporations (based on imported compilation work).
Go to the top of the page
 
+Quote Post
Iduno
post Apr 19 2016, 02:11 PM
Post #3


Moving Target
**

Group: Dumpshocked
Posts: 508
Joined: 27-January 07
From: United States
Member No.: 10,812



Nice work, chummer.
Go to the top of the page
 
+Quote Post
lokii
post Jul 21 2016, 10:43 AM
Post #4


Keeper of the Timeline Maps
**

Group: Members
Posts: 409
Joined: 21-December 10
Member No.: 19,243



This week I wrote an ShxDB export script that generates a table of illustrations ("Abbildungsverzeichnis") for a source. It's meant for the Shadowhelix articles. Though as always I'm glad if somebody takes copying the information to the Shadowrun wiki on Wikia off my hands. It will also happen much more quickly that way. (IMG:style_emoticons/default/wink.gif)

So for the result, here is a selection of illustration tables, that have been generated using ShxDB data:
As you will see there are still some gaps. The credit for collecting the bulk of data on illustrations goes to Greadle.


@Iduno: Thanks.
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic

 



RSS Lo-Fi Version Time is now: 28th March 2020 - 09:56 PM

Topps, Inc has sole ownership of the names, logo, artwork, marks, photographs, sounds, audio, video and/or any proprietary material used in connection with the game Shadowrun. Topps, Inc has granted permission to the Dumpshock Forums to use such names, logos, artwork, marks and/or any proprietary materials for promotional and informational purposes on its website but does not endorse, and is not affiliated with the Dumpshock Forums in any official capacity whatsoever.