CODEWITHSUNDEEP
database-design
zlajko
zlajko

Reputation: 1

property-value database model

How to model a database when you have a different type of value(int, float, boolean, string etc.) of some property, and all possible types are not predefined? I think of a way that all values are strings in database and have some type attribute associated and then convert to that type in the application.. is there a better solution?

Upvotes: 0

Views: 125

Answers (1)

Oded
Oded

Reputation: 499002

Consider an alternative to a relational database.

A document database such a couch DB or Raven DB will give you the flexibility to store any type of data structure.

Upvotes: 1

Related Questions