Re: Database schema for "custom fields"
Greg Sabino Mullane <htamfids@gmail.com>
From: Greg Sabino Mullane <htamfids@gmail.com>
To: Matthias Leisi <matthias@leisi.net>
Cc: pgsql-general@postgresql.org
Date: 2024-09-11T13:24:16Z
Lists: pgsql-general
I'd go with option 2 (jsonb), as it's likely already well supported by your applications, while the other approaches will require a good bit of customization. JSONB can be indexed, so performance should be on par with "traditional" tables. Cheers, Greg