Anton Perez

Writing

  • Cross-platform SQL Client

    In case you’re looking for a SQL client that is cross-platform, lightweight, and free SQL client, check out: I use it on a Mac.  It’s easy to use and feels “new.”

  • Git: SSL certificate problem: unable to get local issuer certificate

    In case you come across, this, run the following in a terminal window: git config –global http.sslVerify false Now go back to coding!

  • Facebook: Shortcut to unliking Pages

    I wanted to clean up my News Feed from no longer relatable Pages. I tried the “go-to-page-unlike” cycle, but it took waaay too long. So I found this trick: Go to https://www.facebook.com/<your-user-name>/allactivity Go to “Likes” Go to “Pages and Interests” Click the “Edit” icon and “Unlike” Or, you can go to: https://www.facebook.com/<your-user-name>/allactivity?privacy_source=activity_log&log_filter=likedinterests Hope this helps. \m/

  • Git: Syncing fork repo against upstream repo

    ,

    In case you need to make sure your forked repo is up-to-date with the original repo (i.e. /git/original/HelloWorld vs /git/anton/HelloWorld), here’s what you need to do in your terminal: $ git remote -v $ git remote add upstream git@git.url.io:original/HelloWorld.git $ git remote -v $ git fetch upstream $ git checkout master $ git merge upstream/master $…

  • DynamoDb Notes

    ,

    DynamoDb is a NoSQL database, which to me means it’s schema-less, scales horizontally, and has incredible performance when accessing data via K/V pairs.  I’m adding this here as writing about it helps me remember. Two types of primary key Partition key same as a primary key must be unique scalar attribute internally also known as…

  • My Understanding of the CAP Theorem

    With the technical landscape being distributed, you will have heard of the CAP Theorem, as it related to the systems that you work on to be 99.99999% up. These are my $0.02 on my understanding of the CAP Theorem. * Consistency – read/write guarantee between nodes * Availability – nodes respond and do no error…