[baza_dwa]

Is there some place I could learn the meaning of cXX columns in db? Some are obvious, some not at all.

[Montellese]

In the code. For movies you can find it at https://github.com/xbmc/xbmc/blob/master...ase.h#L176. The other video types are covered further down in the same header file. And yes, it's ugly

[baza_dwa]

Cool, thanks. And yes, the cXX idea is... audacious

[nickr]

Shouldn't this be fixed? Code obfuscation is bad.

[Martijn]

Shouldn't this be fixed? Code obfuscation is bad.

Not really. It just requires a complete database and interface layer rewrite

[da-anda]

Shouldn't this be fixed? Code obfuscation is bad.

Not really. It just requires a complete database and interface layer rewrite

which is currently WIP

[ironic_monkey]

it has worked for 10 years, allowing multiple redesigns without completely rewriting the db. sorry, i do not agree that it's ugly.

[nickr]

I tend to think that field names should in same way reflect the data within. c01 means nothing.

[Memphiz]

Its called generalisation - i even tend to say that this is a db pattern

[ironic_monkey]

some details:

we use the same structure for all kinds of contents (movies, episodes, shows, mvideos)

in the code we map from these columns directly to struct members, https://github.com/xbmc/xbmc/blob/master...ase.h#L176 and https://github.com/xbmc/xbmc/blob/master...ase.h#L206

this way we can easily read from db directly into the info structs, https://github.com/xbmc/xbmc/blob/master....cpp#L2199
and we can change the contents of a column as we see fit, removing/adding info without rewriting the entire db.

the price is small on the code side, and it grants flexibility and less code. the displayed names in a db viewer is irrelevant compared to the code advantages.

[baza_dwa]

the displayed names in a db viewer is irrelevant compared to the code advantages.

This would be true if they had never been used by humans.

I see it as old dev fallacy - easier code equals to better code.