Database design: storing delimited rows in a database is bad

Question

I worked on projects before they store fields in a comma or string separated by commas, as a field that can be parameters or something similar. I was wondering if this would be considered a poor database design and always need to use relational tables or is it sometimes acceptable to store data this way?

Answer 1

This is usually a bad idea .

However, there is a balance between normalization and performance.

-, , , , .

Answer 2

. , , . , fullname, - ..

, ..

, , , firstname lastName.

, , , . , .

Answer 3

:

• , -/ . , , , , .

• , . , Python pickle , , , .

Answer 4

, , , . Drupal, Wordpress .. .

Answer 5

- - , , ? , ?

Answer 6

, ( ). . , , ... ?

Answer 7

. . :

, , ( )

() . , , .

Answer 8

.

, :

abc | 123,456,789
def | 123
ghi | 123

:

1 | abc | 123
2 | abc | 456
3 | def | 123
4 | ghi | 123
5 | abc | 789

Answer 9

, " ". db , . , , , , - .

, , , . - , u + x, , .

Answer 10

. , SOAP- . . , .

Answer 11

, , , . , .

, . . JSON , "", , JSON. "", , , . , .

"version_id" , .

. , .

Answer 12

, , , , .

, , - " ", , , . , (, , ) . , , , , , "denormalised for performance".

Answer 13

, , , . , XML , -, .

, , .

Answer 14

, , - , . , , , , - , , . , - , - , , , , , , , , , , .