Good software habits apply to databases too. Trust in these little design tips to build a useful, rot-resistant database schema. It is a universal truth that everything in software eventually rots.
PostgreSQL with the pgvector extension allows tables to be used as storage for vectors, each of which is saved as a row. It also allows any number of metadata columns to be added. In an enterprise ...