alexanderskates

5 年前議論

Their video player is also garbage, especially on mobile. I'll have to open and close a video multiple times to get it to play, the quality will take a nosedive midway through and just stay that way for the rest of the video, and they take forever to load.

alexanderskates

5 年前議論

And what of exclamation or question marks?

alexanderskates

5 年前議論

Blocking cookies for twitter seems to work for me... sometimes I need to refresh the page a few times however.

alexanderskates

5 年前議論

I had this same issue in Redshift and ended up populating a table with values 1 to the maximum number of commas found (e.g. using max(regexp_count(...)) or something), then cross joining on the table with the csv column and calling split_part on the corresponding column and index (with the index coming from the numbers table). The cross join ensures that you index every value of the csv column.

alexanderskates

5 年前議論

What does "X for white people" look like though? The only reason that "X for black people" exists is that black people are a minority group and aren't sufficiently catered to by X, which is already more or less "X for white people" by default, at least in the US and much of Europe. As such, any product that that markets itself explicitly to white people (again, only referencing the US and Europe here) is much more likely to have less socially acceptable intent behind it

"X for white people" makes more sense in a population where caucasians are the minority, for instance in China.

コメント