[Wikidata-bugs] [Maniphest] [Commented On] T148988: Cognate DB review

[jcrespo]

jcrespo added a comment.

Is there a reason why T148988#2744793, with some fixes based on your latest feedback could not work?

I do not know what you are trying to do achieve here, honestly, only you know- and I do not have time to work on this unless you schedule it appropriately some months in advance, only to review it afterwards.
Create a design where your most common queries are:

SELECT X FROM table1;

or

SELECT Y FROM table1 JOIN table2 ON table1.indexed_colum = table2.PK_column

Then make sure you do not create redundant data (writing the same data on 2 places) and  follow https://en.wikipedia.org/wiki/Database_normalization best practices.

Some links:


https://en.wikipedia.org/wiki/First_normal_form
https://en.wikipedia.org/wiki/Second_normal_form
https://en.wikipedia.org/wiki/Third_normal_form
https://en.wikipedia.org/wiki/Boyce%E2%80%93Codd_normal_form

TASK DETAIL

https://phabricator.wikimedia.org/T148988

EMAIL PREFERENCES

https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: jcrespo
Cc: hoo, Aklapper, jcrespo, Addshore, Marostegui, Minhnv-2809, D3r1ck01, Izno, Luke081515, Wikidata-bugs, aude, Darkdadaah, Mbch331, Jay8g, Krenair

_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs