Post 2418980 by crlf@niu.moe
 (DIR) More posts by crlf@niu.moe
 (DIR) Post #2418979 by siegvriel@niu.moe
       2018-12-30T00:43:23Z
       
       0 likes, 0 repeats
       
       I'm starting to think that SQL databases are kinda lame.If I have a table with 10 columns, but I only index 3 of those columns, what's the point having those other 7 columns? Why go through all of the pain of altering tables whenever I need to add more data to the schema when I could have a single extra column with all the non-indexed data serialized in JSON or something like that?
       
 (DIR) Post #2418980 by crlf@niu.moe
       2018-12-30T01:28:10Z
       
       0 likes, 0 repeats
       
       @siegvriel Aggregate functions? I don't think those necessarily benefit from indexing. I would also expect transaction logging or whatever other backend things to be worse over large strings than for specific columns. Like if you change one value in that json object the transaction log will have to store the entire string. I'm not an expert on database design though.