HackerTrans
TopNewTrendsCommentsPastAskShowJobs

alexanderskates

no profile record

comments

alexanderskates
·5 anni fa·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 anni fa·discuss
And what of exclamation or question marks?
alexanderskates
·5 anni fa·discuss
Blocking cookies for twitter seems to work for me... sometimes I need to refresh the page a few times however.
alexanderskates
·5 anni fa·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 anni fa·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 anni fa·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.