Post SRxZhM91gPe

Severin Zahler Jan 31, 2017 (09:20)

So quick update from my conlang database project!

I've just refactored the database model to be able to include the marks (whether a word is i.e. derived, uncertain or a neologism) more flexibly; At last I think it is the best to include extra intermediary tables so it's able to apply multiple marks to one entry. It will now be possible to add marks to words found in the wordlist, original references as well as relations.

Below is a quick screenshot of the database model. Tables marked green I did extract all the data from eldamo for, red I have not started, orange is WIP.

dbmodel.png
So quick update from my conlang database project! I've just refactored the database model to be able to include the marks (whether a word is i.e. derived, uncertain or a neologism) more flexibly; At last I think it is the best to include extra intermediary tables so it's able to apply multiple marks to one entry. It will now be possible to add marks to words found in the wordlist, original references as well as relations. Below is a quick

Tamas Ferencz Jan 31, 2017 (09:25)

exciting!

Rick Spell Jan 31, 2017 (23:24)

Impressive!

Paul Strack Feb 03, 2017 (03:58)

This looks pretty interesting. Are you using MS access as the DB? If so, that makes the data pretty portable, since you can ship ship the whole database file.

Severin Zahler Feb 03, 2017 (12:53)

Most likely I'm going to use MySQL, mainly as I've already gathered quite a lot of experience with it and am fairly confident it offers all the possibilities I need.