News for hackers. Stuff that matters.
Re:SAML Is Insecure by Design by paulmd on Thursday August 05, 2021 @09:16PM (#28082166)
these days if you are modeling the "sparse, high-dimensional data" of the kind that EAV schema does well, you probably should be reaching for JSON columns instead of EAV schema.
Re:SAML Is Insecure by Design by jiggawatts on Thursday August 05, 2021 @11:06PM (#28082855)
Some databases support "sparse columns", which use EAV under the hood but are better optimised: https://docs.microsoft.com/en-us/sql/relational-databases/ta...
Re:SAML Is Insecure by Design by Serow225 on Friday August 06, 2021 @01:54AM (#28083768)
Thanks, I forgot about that! :)
Re:SAML Is Insecure by Design by smitty1e on Friday August 06, 2021 @04:30AM (#28084584)
Isn't that the problem that these "columnar store" DBs address?

A bunch of dictionaries containing UUID/data, where each dimension is its own dict, and the dicts might or might not be running on the same system?