News for hackers. Stuff that matters.
Re:Show HN: A Schemaless Data Store Within Your SQL Database by gkop on Thursday February 10, 2022 @07:36PM (#30295135)
How do you protect against user input that produces a psychopathic volume of indexes?
Re:Show HN: A Schemaless Data Store Within Your SQL Database by etirk on Thursday February 10, 2022 @10:21PM (#30296482)
That's a problem that standard SQL tables encounter - chasing new columns with new/modified indexes. (more info at our FAQ). SFSQL never runs into that problem since the indexes are static in structure. No new indexes are made, even if every attribute name was unique. The result is a very consistent query performance.
Re:Show HN: A Schemaless Data Store Within Your SQL Database by rmbyrro on Thursday February 10, 2022 @08:20PM (#30295531)
I guess that would be on the developer side to sanitize/limit/clean in some way, like limiting the number of key-value pairs, object depth, etc?