HackerTrans
TopNewTrendsCommentsPastAskShowJobs

alexanderskates

no profile record

comments

alexanderskates
·il y a 5 ans·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
·il y a 5 ans·discuss
And what of exclamation or question marks?
alexanderskates
·il y a 5 ans·discuss
Blocking cookies for twitter seems to work for me... sometimes I need to refresh the page a few times however.
alexanderskates
·il y a 5 ans·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
·il y a 5 ans·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
·il y a 5 ans·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.
alexanderskates
·il y a 5 ans·discuss
At least in the UK, sandwiches are the most that pharma reps can use to bribe doctors with... Which is not to say they aren't effective (you'll get butts in chairs at least, no guarantee they will pay any attention to you though).