HackerTrans
TopNewTrendsCommentsPastAskShowJobs

alexanderskates

no profile record

comments

alexanderskates
·5 yıl önce·discuss
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 yıl önce·discuss
And what of exclamation or question marks?
alexanderskates
·5 yıl önce·discuss
Blocking cookies for twitter seems to work for me... sometimes I need to refresh the page a few times however.
alexanderskates
·5 yıl önce·discuss
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 yıl önce·discuss
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.
alexanderskates
·5 yıl önce·discuss
Given the cost of developing a single drug can be in the billions of dollars, what financial incentive is there for companies to spend so much on R&D and clinical development if there is no commercial exclusivity rights at the end of the pipeline? You could nationalise drug development but that is a lot of risk to burden the taxpayer with.