pvik's recent activity

  1. Comment on What are you reading these days? in ~books

    pvik
    Link
    I generally have a fiction and non-fiction book going on at the same time. (Initially started doing this when I would find it hard to get through a book, I would start up another easier to read...

    I generally have a fiction and non-fiction book going on at the same time. (Initially started doing this when I would find it hard to get through a book, I would start up another easier to read book, and switch between the two. Soon, I made it a habit to have two books going on at the same time :)


    In the non-fiction category I am currently reading:
    David and Goliath by Malcolm Gladwell

    This was suggested to me a while back and have been putting off reading it, finally decided to strike it off my reading list.
    I am about halfway into the book and I don;t really have much of an opinion about it. The tone is a little preachy and sometimes I feel like he is doing a lot of cherry-picking data.

    Next Up: Heavy: The Obesity Crisis in Cultural Context by Helene A Shugart


    In the fiction category am currently reading:
    Of Sea and Shadow by Will Wight

    This is supposed to be a 2 part series with 6 books [1], [2]. Each of the parts telling the same story from opposing perspectives. This "gimmick" piqued my interest.

    I am about 25% into the first book and I like it so far. Pretty good world-building and pacing.

    Next Up: Of Shadow and Sea

    1 vote
  2. Comment on Fortnightly Programming Q&A Thread in ~comp

    pvik
    Link Parent
    This sounds like a regular UNIQUE constraint on 2 columns. CREATE TABLE example ( p_key serial primary key, f_key integer references some_other_table(id), unique_id integer, is_ok bool, UNIQUE...

    This sounds like a regular UNIQUE constraint on 2 columns.

    CREATE TABLE example (
    p_key serial primary key,
    f_key integer references some_other_table(id),
    unique_id integer,
    is_ok bool,
    UNIQUE (f_key, unique_id));
    
    2 votes
  3. Comment on The Monty Hall problem in ~science

    pvik
    Link Parent
    @aphoenix did a good job explaining this above!

    @aphoenix did a good job explaining this above!

    3 votes
  4. Comment on US buys up world stock of remdesivir in ~health.coronavirus

    pvik
    (edited )
    Link
    This article in Stanford Medicine does a good job explaining how Remdesivir works, and This graphic from Science does a good job illustrating how drugs like Remdevisir work. At the same time...

    This article in Stanford Medicine does a good job explaining how Remdesivir works,
    and This graphic from Science does a good job illustrating how drugs like Remdevisir work.

    At the same time articles like this makes me wonder how effective this is even going to be?

    Also, with Remdevisir still being an IV drug, I am not sure of the logistics of administering this to patients with early/mild symptoms and helping patients not progress to a more serious condition.

    Edit: And also this.

    11 votes
  5. Comment on US buys up world stock of remdesivir in ~health.coronavirus

    pvik
    Link Parent
    At approx $530/dose how can they be making any profit? I am sure they are taking heavy losses trying to have this manufactured and available to every American who may need it. (Of course, assuming...

    The cost is around $3,200 per treatment of six doses, according to the US government statement.

    At approx $530/dose how can they be making any profit? I am sure they are taking heavy losses trying to have this manufactured and available to every American who may need it. (Of course, assuming they have proper insurance)

    /s in case it wasn't clear.

    5 votes
  6. Comment on U.S. officials are ramping up criticism of the GDPR, which they say protects cybercriminals in ~tech

    pvik
    Link Parent
    The top two articles from your link were an interesting read! However, they are both from Apr and March 2018. I wonder if someone has an updated article on what the current state is. Also,...

    The top two articles from your link were an interesting read!

    However, they are both from Apr and March 2018. I wonder if someone has an updated article on what the current state is.

    Also, regarding this:

    To understand why data reuse in WHOIS records is so common among crooks, put yourself in the shoes of your average scammer or spammer — someone who has to register dozens or even hundreds or thousands of domains a week to ply their trade.

    I know laziness is generally the norm and not the exception, but I find it hard to grasp that there are no toolkits out there which automates this.

    2 votes
  7. Comment on Favorite political/protest/in-light-of-recent-events songs? in ~music

    pvik
    Link Parent
    Also, Nina Simone performing 'Why?" live three days after the assassination of Martin Luther King Jr.

    Also, Nina Simone performing 'Why?" live three days after the assassination of Martin Luther King Jr.

  8. Comment on Increasing personal security online and Yubikey in ~tech

    pvik
    Link Parent
    Of all the accounts I have the following seem to support Yubikey currently: ProtonMail Google Github Coinbase Dropbox DigitalOcean Wish more services supported it (and actually supported 2FA,...

    Do you have any important online accounts that can use a Yubikey?

    Of all the accounts I have the following seem to support Yubikey currently:

    • ProtonMail
    • Google
    • Github
    • Coinbase
    • Dropbox
    • DigitalOcean

    Wish more services supported it (and actually supported 2FA, mainly online stores)

    Two Yubikeys would work, but one Yubikey and printed backup codes kept somewhere safe might also do.

    That is a good idea!

    1 vote
  9. Increasing personal security online and Yubikey

    I have recently noticed an uptick in phishing emails and SMSs, getting me to click on some malicious link and this has been troubling me. I am fairly good about what I click and so far I haven't...

    I have recently noticed an uptick in phishing emails and SMSs, getting me to click on some malicious link and this has been troubling me.
    I am fairly good about what I click and so far I haven't clicked anything malicious (I think). However, this has motivated me to up my online security.

    All my computers run Linux and I use an Android phone.

    For browsing I use Firefox, with NoScript (and uBlock) and use containers for separating personal/shopping sites, etc.
    I also have host file blocking on my computers and phone (using AdAway).

    I do have a pi-hole setup at home as well.

    I also have 2FA setup on all my banking accounts, email accounts etc.
    However all my banking account 2FA is still just using SMS. Which I think is now easily circumvented.
    Email accounts do use Authenticator apps (like Authy and Google Authenticator).

    I also use a password manager (this one), which works well for me, but is only available on my computer and not from my phone. I am split between having my password manager available on my phone tho, since it is always on me and could be stolen or have something malicious installed on. What do you guys think? I am wary of services like LastPass, is that valid?

    So I wanted to start a thread to discuss what do you guys do to stay safe online?
    I am also considering getting a pair of Yubikey (one backup), are there any caveats/pitfalls I need to be aware of with Yubikey?

    14 votes
  10. Comment on A tale of two 3D printers (and all additive manufacturing processes) in ~tech

    pvik
    Link Parent
    I would also suggest looking at the Creality printers, they are great entry level printers, fairly inexpensive and deliver pretty good results as well. (Learning to calibrate the printers and...

    I would also suggest looking at the Creality printers, they are great entry level printers, fairly inexpensive and deliver pretty good results as well. (Learning to calibrate the printers and fiddling with the slicer options is great for learning the ins and outs of printers too)

    You can also swap out and add parts as needed on these printers (like most 3D printers) and the Marlin firmware (up to v1.1.9) would work on 8bit boards that Creality printers come with (v2 upwards are geared towards 32bit boards, and you may have to remove some features to make them fit in a 8 bit board)

    I have 2 Creality printers and one of them pretty much just uses the same Chassis, steppers and power supply, everything else is swapped out for other parts.

    2 votes
  11. Comment on Daily thread for news/updates/discussion of George Floyd protests - June 10 in ~news

    pvik
    Link
    Youtube's algorithm suggested this guy to me, and my first thought was I was being trolled, going by the thumbnail image. Specifically this video. However, I clicked on the video, thinking, let me...

    Youtube's algorithm suggested this guy to me, and my first thought was I was being trolled, going by the thumbnail image. Specifically this video.
    However, I clicked on the video, thinking, let me see what drivel he is going to spout.

    After, I had to remind myself to stop judging people by their appearance.

    Over the last hour or so, I have seen several of his videos.
    Quite a few of his recent videos talk about what is happening and wanted to share here, but didn't want to make a new post.

    He also has videos more than a year old,which seem to be very relevant to what is happening today:

    6 votes
  12. Comment on Daily thread for news/updates/discussion of George Floyd protests - June 10 in ~news

    pvik
    Link Parent
    How tone-deaf is this head of the International Association of Chiefs of Police? And how incapable of introspection are these cops to have such a petulant response. Really? If there were teachers...

    How tone-deaf is this head of the International Association of Chiefs of Police? And how incapable of introspection are these cops to have such a petulant response.

    “Law enforcement is the only profession where you get rocks, bricks and molotov cocktails thrown at you merely because you’re in the same chosen profession as someone else who did something horribly wrong thousands of miles away,”

    Really? If there were teachers across the country killing students every couple of months, I am sure people will be protesting against all teachers and schools, especially if the government gives them immunity and turns a blind eye.

    People are protesting because of the wide-spread actions of police departments across the country.

    8 votes
  13. Comment on The educational standardization trap in ~life

    pvik
    Link Parent
    Absolutely! Education policies is such a complex topic, with a very very slow control loop (the time it takes to see effects of different policies) and with stakes being pretty high: lives of...

    Absolutely! Education policies is such a complex topic, with a very very slow control loop (the time it takes to see effects of different policies) and with stakes being pretty high: lives of actual humans (kids/adults) on the line!

    Right now there is a bit of debate on weather high school should provide a general education with life skills and basic tradesman techniques so they can enter the workforce directly or if they should provide a basis for higher education.

    That is an interesting point I was not aware of. Having completed most of my education in Asia and Europe and only experienced Graduate school in US, I was not even aware that such a debate even existed!

    1 vote
  14. Comment on The educational standardization trap in ~life

    pvik
    (edited )
    Link Parent
    I don't know if the conclusion the Author of this article is trying to lead us to is the right conclusion tho. I think it would be more worthwhile in trying to see why students struggle with...

    Andrew Hacker goes to great lengths to demonstrate how the hurdle of passing algebra sets many high school students on the road to failure.

    I don't know if the conclusion the Author of this article is trying to lead us to is the right conclusion tho.

    I think it would be more worthwhile in trying to see why students struggle with algebra to begin with? How to remove some of the hurdles students are facing in the first place? Could we train better teachers? Would improving budgets for schools help?
    Instead of just saying, let us lower the standards required for students to pass Algebra.

    I feel like Education up to a certain level does have to be standardized, Undergraduate and Graduate school provides quite a lot of "plasticity" for what education path a student wants to go down. But, if we keep lowering the standards of what students are learning up to that point, in a macro context I think it would be more detrimental.

    Edit: This is a tangential article. But, think would be relevant in this discussion. This is from 2003 1993 and I feel the situation has only gotten worse.

    2 votes
  15. Comment on System of a Down - Toxicity Cover by Halocene, Lauren Babic, and Violet Orlandi in ~music

    pvik
    Link
    This was a well performed cover, the guitarist, drummer and singers all did a great job. But... I felt it was performed at a very high technical level but felt very clean. Not saying the sound...

    This was a well performed cover, the guitarist, drummer and singers all did a great job.

    But...

    I felt it was performed at a very high technical level but felt very clean. Not saying the sound wasn't grungy, but felt like it was emotionally sanitized.
    I am sure it is just my interpretation of it. My reaction to the song was "cool", whereas listening to SOAD and Tankian's vocals always gets me amped up.

    Just found it strange that a cover (performed very well) somehow loses to evoke the feelings that the original does.

    4 votes
  16. Comment on Australian actor Meyne Wyatt supports Black Lives Matter with powerful monologue on racism on Q+A in ~misc

    pvik
    Link
    The video clip in the article wasn't working for me. Here is the clip on youtube if anyone else has the same problem. That was a powerful speech! Thanks for sharing it.

    The video clip in the article wasn't working for me.
    Here is the clip on youtube if anyone else has the same problem.

    That was a powerful speech! Thanks for sharing it.

    4 votes
  17. Comment on Police: Last Week Tonight with John Oliver in ~tv

    pvik
    Link Parent
    Here is the Trevor Noah's clip she references to, which I think is worth watching as well.

    Here is the Trevor Noah's clip she references to, which I think is worth watching as well.

    7 votes
  18. Comment on Trump says the USA will label Antifa as a terror organization amid unrest in ~news

    pvik
    (edited )
    Link Parent
    Unfortunately there is a lot of mislabeling and misinformation in the media surrounding Antifa. This is a really good (albeit long) video on what Antifa is, by PhilosophyTube. The video also talks...

    From what I've seen of ANTIFA on the news (prior to this week)

    Unfortunately there is a lot of mislabeling and misinformation in the media surrounding Antifa.

    This is a really good (albeit long) video on what Antifa is, by PhilosophyTube.
    The video also talks about "punch a nazi" meme.

    Edit: I am sorry, the video in which he does talk about "punch a nazi" meme is this (shorter) video.

    13 votes
  19. Comment on Fortnightly Programming Q&A Thread in ~comp

    pvik
    Link Parent
    You could add an unique constraint on the url column and use the ON CONFLICT[1] modifier when INSERTing (You can also perform an UPSERT operation using the ON CONFLICT modifier, i.e. update the...

    You could add an unique constraint on the url column and use the ON CONFLICT[1] modifier when INSERTing
    (You can also perform an UPSERT operation using the ON CONFLICT modifier, i.e. update the row if a row exists already)

    For example:

    Create a dummy table

    postgres=# create table data (id serial primary key, url text unique, title text);
    CREATE TABLE
    

    Insert some initial dummy data

    postgres=# insert into data (url, title) values ('a', 'A'), ('b', 'B');
    INSERT 0 2
    postgres=# select * from data;
     id | url | title
    ----+-----+-------
      1 | a   | A
      2 | b   | B
    (2 rows)
    

    Trying to reinsert rows with same URL will fail and error out on the first error.

    postgres=# insert into data (url, title) values ('a', 'A'), ('b', 'B');
    ERROR:  duplicate key value violates unique constraint "data_url_key"
    DETAIL:  Key (url)=(a) already exists.
    

    Using ON CONFLICT:

    postgres=# insert into data (url, title) values ('a', 'A'), ('b', 'B') on conflict do nothing;
    INSERT 0 0
    postgres=# insert into data (url, title) values ('a', 'A'), ('c', 'C') on conflict do nothing;
    INSERT 0 1
    postgres=# select * from data;
     id | url | title
    ----+-----+-------
      1 | a   | A
      2 | b   | B
      7 | c   | C
    (3 rows)
    
    2 votes
  20. Comment on Chinese foreign minister warns U.S. against taking the countries ‘to the brink of a new Cold War’ in ~news

    pvik
    Link Parent
    I thought you had mis-typed USSR, but a quick google search showed me URSS is in fact a valid alternate spelling for the Soviet Union[1]. TIL! Thanks!

    I thought you had mis-typed USSR, but a quick google search showed me URSS is in fact a valid alternate spelling for the Soviet Union[1]. TIL! Thanks!

    Within the Soviet Union itself, "URSS" was the preferred Latin-script abbreviation for the country until World War II, when it was replaced with "USSR".

    3 votes