Would this approach work?

Hi all,

I'm trying to figure out the right approach for one of my projects. The idea is to be able to link any things with any other things, something like a network of everything. For example, if we have a book of Italian cuisine I would like to link it to the author, and also to the class of cuisine, "Italian", and the book itself will belong to the class of things "book".

And everything should be created dynamically because it's like an engine for any possible types of entities.

The approach I'm thinking about is dynamic entities. So basically, there are 4 tables:

– entity (describes an entity and some mandatory attributes like id, name, class, etc.)

– meta (describes attributes for any entities like title and ISBN for books)

– attribute (describes attributes of specific instances of entities), for values, could be used type JSON for example because the value can be of any type

– connection (1 or 2 tables described a connection between classes of attributes and specific entities like book-author or book-publishing house).

This schema looks pretty promising because it allows you constructing an endless amount of entity classes and each class may have a description of any depth. But there is one "but"… search. As for we can't specify the type of values we should look for JSON values and I wonder if it's going to be a bottleneck or not, and if so, what to do.

Thanks!