HN user

sfaxon

54 karma
Posts2
Comments7
View on HN

I own a VW ID.4. For reasons I wanted to reverse engineer some of the API. After authenticating to the account tied to my car, the landing page (https://www.vw.com/en/owners.html) makes calls to a lot of analytics trackers. I'll just list what pi-hole defaults block:

analytics.tiktok.com

sp.analytics.yahoo.com

googletagmanger.com

universal.iperceptions.com

cdn4.userzoom.com

snap.licdn.com

secure-ds.serving-sys.com

bat.bing.com

ct.pinterest.com

adherent.com

And a few others. I would guess the phone app (which has access to the car location) has a similar list of trackers. I hope to get some time to MITM the app to be able to know for sure.

I felt a loss when the On the Metal podcast series wrapped up.

Big same. I was so happy to find the Oxide and Friends podcast that I went through the entire backlog in the last couple months. It really helped solidify my thoughts on debug-ability as a first class property of a programming language/environment/system.

It's a great mix of tech history, personal accounts from industry, practical conversations about development and debugging and current industry happenings.

A few standout episodes:

  Engineering Culture
  Engineering Incentives... and Misincentives
  The Rise and Fall of DEC

I actually got curious about this a year ago when I got a dog and she was watching me paint a wall. I made an iOS app* that allows you to see the color spectrum a dog sees, as well as take video and photos.

Some weekend I hope to make enough time to add something to represent the short sightedness using image depth data as well as a few other features I would like to add.

I actually had not heard about the flicker fusion threshold being different, thanks for the links!

* https://itunes.apple.com/us/app/dog-optics/id1447069492?ls=1...

There have been a few articles claiming bots are being used on Twitter to impact trending topics. One solution I talked to a friend about was having a yearly subscription fee to make it less cost effective to create hundreds of fake accounts. Of course hitting a critical mass of users would be very difficult. And even if the service did become wildly popular, and trusted, it would only increase the value for companies to game the system.

I think the general population is becoming more aware of how intrusive ad networks are, possibly moving the needle on making a pay service more viable. But I don't think I know any non-tech people that would be willing to pay for a Twitter/Facebook/Reddit type service today.

So, I have no good solution. But I sure hope someone figures out a good solution. The whole concept of "pick your own truth" has some terrifying consequences.

My favorite (kind of related) little gem from the postgresql documentation is from the century section of EXTRACT, date_part: https://www.postgresql.org/docs/9.5/static/functions-datetim...

Under the century section it notes:

"The first century starts at 0001-01-01 00:00:00 AD, although they did not know it at the time. This definition applies to all Gregorian calendar countries. There is no century number 0, you go from -1 century to 1 century. If you disagree with this, please write your complaint to: Pope, Cathedral Saint-Peter of Roma, Vatican."

I chuckle imagining someone in the Vatican mail room tossing aside one letter a year related to this.

I've been using Navicat Essentials for years and I still get frustrated with it on a regular basis. Only after bdcravens' comment did I find the section of the UI that allows syntax highlighting. Years ago, when I first tried, Navicat failed to import a standard pg_dump file so I've given up on it for import/export. Which is fine, I prefer the command line most of the time for things like that anyway.

I gave PGAdmin a shot, but it does not support left-right scrolling from a Magic Mouse. Getting to table views is cumbersome, 5-6 whole clicks. On the up side it does visualize explain queries really well. But 99% of the time I just want to browse some data to see what data is there.

I've spent 3-4 hours using Postico today and really like it. I can see it being really useful in my normal workflow. I can move data from the command line, browse tables and make quick updates in Postico and if I really need to dig into a query use PGAdmin. Syntax highlight would be nice, but I've been without it for so long (due to my own inability to find a button in Navicat) that it's a nice to have at this point.

Keep up the great work! I do hope there is a way to transfer my license over to the AppStore version when it comes along.