HN user

fhoffa

1,539 karma

https://twitter.com/felipehoffa

Posts55
Comments130
View on HN
hoffa.medium.com 3y ago

From BigQuery Director to Snowflake User – With Dan Delorey, VP of Data at SoFi

fhoffa
1pts0
hoffa.medium.com 4y ago

Loading all Hacker News comments into Snowflake (in less than 1 minute)

fhoffa
3pts0
hoffa.medium.com 4y ago

The Most Popular Languages on Reddit after analyzing 1M comments

fhoffa
3pts1
hoffa.medium.com 5y ago

Open source boards and tenure terms: The FSF has stalled

fhoffa
7pts0
hoffa.medium.com 5y ago

Funnel Analytics with SQL: Match_recognize()

fhoffa
1pts0
hoffa.medium.com 5y ago

Explore the World with Foursquare Places on Snowflake

fhoffa
2pts0
hoffa.medium.com 5y ago

SQL to track startups, IPOs and more: Crunchbase Enterprise with Snowflake

fhoffa
2pts0
medium.com 5y ago

Real people don’t use UTM codes

fhoffa
3pts0
medium.com 6y ago

Stack Overflow in 2023: Predicting with Arima and BigQuery

fhoffa
1pts0
www.youtube.com 6y ago

An hour long conversation with the creators behind BigQuery

fhoffa
8pts0
medium.com 6y ago

Interactive: Wikipedia Pages

fhoffa
1pts0
medium.com 6y ago

“OK Boomer” Escalated Quickly – A Reddit+BigQuery Report

fhoffa
2pts1
news.ycombinator.com 7y ago

Uber datasets in BigQuery: Driving times around SF (and your city too)

fhoffa
1pts0
towardsdatascience.com 7y ago

The real top Stack Overflow Questions

fhoffa
2pts0
medium.com 7y ago

When Will Stack Overflow Reply: How to Predict with BigQuery

fhoffa
3pts0
medium.com 7y ago

Connecting Africa: Nomanini, GCP, and BigQuery

fhoffa
2pts0
www.blog.google 8y ago

Google Cloud: Our first private trans-Atlantic subsea cable

fhoffa
4pts0
medium.com 8y ago

These are the real Stack Overflow trends: Use the pageviews

fhoffa
1pts1
cloud.google.com 8y ago

Google Patents Public Datasets: connecting public, paid, and private patent data

fhoffa
2pts1
medium.com 8y ago

The top contributors to GitHub – 2017

fhoffa
14pts0
hackernoon.com 9y ago

Some coders like it hot – but most prefer colder climates

fhoffa
2pts1
medium.com 9y ago

Counting uniques faster in BigQuery with HyperLogLog++

fhoffa
20pts0
www.blog.google 9y ago

How to use BeyondCorp to ditch VPN, improve security and go to the cloud

fhoffa
441pts155
sbaltes.github.io 9y ago

Finding Stack Overflow code snippets in GitHub projects

fhoffa
4pts0
cloudplatform.googleblog.com 9y ago

Quantifying the performance of the TPU, our first machine learning chip

fhoffa
110pts27
medium.com 9y ago

DNA Sequencing of 1000 Cannabis Strains Publicly Available in Google BigQuery

fhoffa
14pts1
medium.com 9y ago

Hacker News on BigQuery: Now with daily updates. Top domains and time to post?

fhoffa
52pts9
medium.com 9y ago

The news sources that Reddit prefers

fhoffa
3pts2
opensource.googleblog.com 9y ago

Operation Rosehub – patching thousands of open-source projects

fhoffa
727pts117
www.kaggle.com 9y ago

Kaggle Challenge: YouTube-8M Video Understanding (7M Videos+vectors)

fhoffa
2pts1

This is awesome, thanks for all the background info. Now let me give you an example of App Engine deprecating stuff:

- In 2012 App Engine deprecated the "Conversion API".

- They notified this deprecation in August 2012, and they told users it would stop working only 3 months afterwards.

- You were affected by this deprecation.

- You created an alternative to it, that worked on Heroku.

Source: https://groups.google.com/g/google-appengine/c/-JJccGx5RRk/m...

Did I get this right?

You are awesome. We are just choosing to remember the past with different colored glasses.

AppEngine today is wildly different to the App Engine I fell in love with 15 years ago.

Since you're checking notes, please check out all the AE service deprecation notes.

Disclosure: I worked for Google for ~10 years, and I fought internally many of those deprecation decisions. I did not succeed.

Looking at that source, there's a pretty straightforward explanation of where the page views come from.

- Last month, Stack Overflow had ~142,575,642 visits.

- Last month, Google gave 127,896,508 visits to Stack Overflow

- Last month, Bing gave 7,491,274 visits to Stack Overflow

You could say that the Stack Overflow # of pageviews depends mainly on:

- How often people are searching Google/Bing for answer.

- How often Google/Bing rank Stack Overflow high enough for people to click into it.

A big hug to all my friends at O'Reilly. Their conferences have been a big part of my career. Not only as a speaker, but I've met so many awesome people at their lunch and social occasions.

As a for-profit endeavor they have also given amazing opportunities to a diversity of speakers and topics. For many speakers it means a lot when the conference is willing to pay for their travel expenses.

Looking forward to meet you all again!

6 million pages! A quick look at their distribution:

3.6M of these pages got less than 10 views during December. 4.3M pages got less than 100 views each. 2.3M got less than 1000 views. That's the long tail. On the other side 680K pages got more than 1,000 views, 111K pages got more than 10k views, only 6k pages got more than 100k views, and 90 pages were able to gather more than 1M views (Star Wars, The Mandalorian, The Witcher...).

In summary: The top 7.2% of Wikipedia pages earn 87% of all the monthly views.

Yesterday I posted a deeper analysis on how these pages get their daily views:

- https://towardsdatascience.com/interactive-the-top-2019-wiki...

Apparently the most popular pages are all related to movies (Avengers, Joker, ...), series (Ted Bundy, Chernobyl, Game of Thrones), and deaths.

Quoting their front page:

In fall of 2011, when a forced lull in kernel development gave him a chance to start a new project, Linux creator Linus Torvalds decided to tackle his frustration with the lack of decent divelog software on Linux.

Linus worked with a team of developers, and Subsurface is the result. It now supports Linux, Windows and MacOS and allows data import from many dive computers and several existing divelog programs. It provides a quick and easy way to see the key information provided by a modern dive computer and lets users track a wide variety of data about their dives. In fall of 2012 Dirk Hohndel took over as Subsurface maintainer.

License: GPLv2

My company blog first - yes! Except that I can go from idea to post in 12 hours with Medium, and that's not at all the experience for the official posts when multiple teams want to chime in...

The last sentence says "Subscribe now for a free 30-day trial of the new Praxis blog" - so I guess that's what this one is about.

I've been looking for Medium alternatives, but my audience wants me to continue on it.

123 votes to where should I publish my posts:

- 34% Medium

- 9% Dev.to

- 45% My company's official blog

- 12% LinkedIn, my domain, ???

This tells me that - even if Medium continues to annoy their fans with their new model, I should still consider it as a great platform for quick publishing.

Survey via Twitter to my 10k followers (https://twitter.com/felipehoffa/status/1148334055689031681).

Disclosure: I'm Felipe Hoffa and I work for Google Cloud - and I frequently post on Medium and elsewhere.