Google Sheets API – Read Data – Part 1

Read data from a Google Sheet from an HTML form using the Google Sheets API. Step by step instruction to create an API project, configure access credentials, obtain an oAuth token and read data from the sheet using HTML, PHP and Javascript.

This is part 1. Setting up a project, and testing the read functionality of the sheets api

Github: https://github.com/acbrunso/Tutorial_…

How Postgres is more than a relational database: Extensions

Let’s not stop with the basic ones, how crazy can we get? How about HyperLogLog. HyperLogLog is based on a research paper from Google. It implements K-minimum value, bit observable patterns, stochastic averaging, and harmonic averaging. If you’re like me and had to google pretty much every one of those things the simple way to explain it: HyperLogLog is great for approximate distincts which can be stored in a really small disk space, then composed over time to find intersections/unions of uniques across various buckets. If you’re building a web analytics tool or an ad network HyperLogLog may end up being your best friend. You’ve also got more common approximation datatypes like TopN which is great for building leaderboards.

Damage Control at Facebook: 6 Takeaways From The Times’s Investigation

In fall 2016, Mark Zuckerberg, Facebook’s chief executive, was publicly declaring it a “crazy idea” that his company had played a role in deciding the election. But security experts at the company already knew otherwise.

They found signs as early as spring 2016 that Russian hackers were poking around the Facebook accounts of people linked to American presidential campaigns. Months later, they saw Russian-controlled accounts sharing information from hacked Democratic emails with reporters. Facebook accumulated evidence of Russian activity for over a year before executives opted to share what they knew with the public — and even their own board of directors.

In 2015, when the presidential candidate Donald J. Trump called for a ban of Muslim immigrants, Facebook employees and outside critics called on the company to punish Mr. Trump. Mr. Zuckerberg considered it — asking subordinates whether Mr. Trump had violated the company’s rules and whether his account should be suspended or the post removed.

But while Mr. Zuckerberg was personally offended, he deferred to subordinates who warned that penalizing Mr. Trump would set off a damaging backlash among Republicans.

Mr. Trump’s post remained up.

As criticism grew over Facebook’s belated admissions of Russian influence, the company launched a lobbying campaign — overseen by Sheryl Sandberg, the company’s chief operating officer — to combat critics and shift anger toward rival tech firms.

Facebook hired Senator Mark Warner’s former chief of staff to lobby him; Ms. Sandberg personally called Senator Amy Klobuchar to complain about her criticism. The company also deployed a public relations firm to push negative stories about its political critics and cast blame on companies like Google.

Those efforts included depicting the billionaire liberal donor George Soros as the force behind a broad anti-Facebook movement, and publishing stories praising Facebook and criticizing Google and Apple on a conservative news site.

Facebook faced worldwide outrage in March after The Times, The Observer of London and The Guardian published a joint investigation into how user data had been appropriated by Cambridge Analytica to profile American voters. But inside Facebook, executives thought they could contain the damage. The company installed a new chief of American lobbying to help quell the bipartisan anger in Congress, and it quietly shelved an internal communications campaign, called “We Get It,” meant to assure employees that the company was committed to getting back on track in 2018.

Sensing Facebook’s vulnerability, some rival tech firms in Silicon Valley sought to use the outcry to promote their own brands. After Tim Cook, Apple’s chief executive, quipped in an interview that his company did not traffic in personal data, Mr. Zuckerberg ordered his management team to use only Android phones. After all, he reasoned, the operating system had far more users than Apple’s.

Washington’s senior Democrat, Senator Chuck Schumer of New York, raised more money from Facebook employees than any other member of Congress during the 2016 election cycle — and he was there when the company needed him.

This past summer, as Facebook’s troubles mounted, Mr. Schumer confronted Mr. Warner, who by then had emerged as Facebook’s most insistent inquisitor in Congress. Back off, Mr. Schumer told Mr. Warner, and look for ways to work with Facebook, not vilify it. Lobbyists for Facebook — which also employs Mr. Schumer’s daughter — were kept abreast of Mr. Schumer’s efforts.

 

Related:

What Facebook Knew and Tried to Hide (28 min audio)

Google Cloud for Startups program

Startups in our program have access to:

  • Google Cloud credits, free users on G Suite, Hire by Google (US only), Qwiklabs, and more
  • Special events, mentorship, and technical training
  • News and product updates

Qualified startups

  • Have received no more than a Series A funding round
  • Are less than five years old
  • Are based in an approved territory
  • Have not previously received Cloud credits outside of the free-tier offering

Startups who are part of an incubator or accelerator program, or have received VC funding, should check with that organization before applying here as they may be eligible for larger credit levels.