Your system of indexing metadata is an antipattern

[vporton]

You system of creating indices for INDICES environment variable is both not enough flexible and over-complicated.

The reasonable way to store metadata is to use a composite PostgreSQL index of both name and value. For queries use JOINs.

Then no need to create a separate DB table field for each index and every index could be used for filtering/sorting.

[TheLoneRonin]

@vporton

Hey VIctor,

First, thank you for taking the time to review everything. Appreciate you taking the time.
Second, agree it was an antipattern.

The intent was to achieve something like this: #6

This will eventually be phased out don't worry.

Thank you for mentioning it (and the other issues).

[TheLoneRonin]

Noting that indices should be refactored as part of: #61