psql2csv

Run a query in psql and output the result as CSV.

$ psql2csv dbname “select * from table” > data.csv

$ psql2csv dbname < query.sql > data.csv

$ psql2csv –no-header –delimiter=$’\t’ –encoding=latin1 dbname < SELECT *
> FROM some_table
> WHERE some_condition
> LIMIT 10
> sql

Mark Zuckerberg, Let Me Fix That Op-Ed You Wrote

I can tell the people what it is you’re really trying to say.

Mark Zuckerberg has written an op-ed, and I wish he had not.

It was titled “The Facts About Facebook.” I would give that one tweak. I’d call it “Mark’s Facts About Facebook.”

In a piece for The Wall Street Journal timed to the social networking giant’s 15th anniversary, its once-young, now-not-so-young chief executive and founder tried and tried to persuade readers that they shouldn’t be afraid of what he has wrought.

But the post was essentially the greatest hits that we have heard Mr. Zuckerberg sing for a while now. He focused on the enormous advertising system that powers Facebook, while ignoring almost entirely the news from the last disastrous year, including Russian abuse of the platform, sloppy management of data, recent revelations that the company throws some pretty sharp elbows when it needs to, and more. You kind of get why Mr. Zuckerberg would want to forget it all.

Should I be annoyed by this? One person who favors Mr. Zuckerberg told me no, pointing out that the media is irked when he says nothing and even more bothered when he says something, so he cannot win whatever he does.

.. O.K., so instead of just criticizing, I thought I would help him with his piece, given I do this for a living and he does not, by rewriting his work. Here goes:

MARK WROTE: “Facebook turns 15 next month. When I started Facebook, I wasn’t trying to build a global company. I realized you could find almost anything on the internet — music, books, information — except the thing that matters most: people. So I built a service people could use to connect and learn about each other. Over the years, billions have found this useful, and we’ve built more services that people around the world love and use every day. Recently I’ve heard many questions about our business model, so I want to explain the principles of how we operate.”

KARA TRANSLATES: We old now. We big now. It came from my one really good idea: AOL sucked and I could do better and I did. Now the noise has reached me up on Billionaire Mountain, so I am going to have to pretend that I care.

MARK: “I believe everyone should have a voice and be able to connect. If we’re committed to serving everyone, then we need a service that is affordable to everyone. The best way to do that is to offer services for free, which ads enable us to do.”

KARA: No rich person is going to pay too much for this muffler, um, social media service, and poor people aren’t going to pay us at all because they apparently don’t have money. So everyone will have to endure the ads that we shovel out and stop griping, because free ain’t free, people.

Facebook’s Monopoly Tyranny is no Longer a Zuckerberg Secret

Meanwhile a huge trove of Facebook emails that just leaked and it shows the true nature of the Zuckerberg legacy. The UK Parliament published a trove of top-secret Facebook executive emails on December 5th. tl;dr it’s exactly what you’d expect.

  • Mark Zuckerberg personally approved Facebook’s decision to cut off social network Vine’s data. (so much for a capitalism of fair competition)
  • Facebook tried to figure out how to grab users’ call data without asking permission. (likely spying on their real-time conversations)
  • Certain key apps were white-listed and given greater access to user data even after a broader clampdown. (Netflix and Airbnb among the favored friends)
  • Mark Zuckerberg privately admitted that what’s good for the world isn’t necessarily what’s good for Facebook. (Where’s the world tour Mark?)
  • Mark Zuckerberg suggested users’ data was worth 10 cents a year. (Heck, is that even worth selling?)

In the process of creating one of the most corrupt business models ever invented, Facebook chose profits over its users. In a weird twist of fate it’s the UK that seems to have stood up to Facebook, where American doesn’t even regulate its offending tech companies.

.. The leaked Emails show Execs discussed the single biggest threat to Facebook. They ended up disrupting journalism, diverting internet traffic and turning into a weaponized platform used against the state, democracy and capitalism, slowing down rivals and thwarting innovation itself allowing Chinese companies like Tencent and ByteDance to overtake them.

.. Facebook staff in 2012 discussed selling access to user data to major advertisers, basically selling your info without your consent. Facebook’s profit seeking greed led to the centralization of data where the richer get richer on the poor public’s data.

.. There is evidence that Facebook’s refusal to share data with some apps caused them to fail. Facebook picked the winners in a fake internet, even deceiving advertising that video (on its platform) was the next big thing. Facebook was later found to have falsified video metrics significantly to deceive advertisers and brands.

You can view all 250 pages of the Facebook documents right here.

Facebook to Banks: Give Us Your Data, We’ll Give You Our Users

Facebook has asked large U.S. banks to share detailed financial information about customers as it seeks to boost user engagement

The social media giant has asked large U.S. banks to share detailed financial information about their customers, including card transactions and checking account balances, as part of an effort to offer new services to users.

Facebook increasingly wants to be a platform where people buy and sell goods and services, besides connecting with friends. The company over the past year asked JPMorgan Chase JPM +0.33% & Co., Wells Fargo & Co., Citigroup Inc. C +0.28% and U.S. BancorpUSB +0.43% to discuss potential offerings it could host for bank customers on Facebook Messenger, said people familiar with the matter.

Facebook has talked about a feature that would show its users their checking-account balances, the people said. It has also pitched fraud alerts, some of the people said.

.. Facebook has told banks that the additional customer information could be used to offer services that might entice users to spend more time on Messenger
.. Facebook said it wouldn’t use the bank data for ad-targeting purposes or share it with third parties.
.. Banks face pressure to build relationships with big online platforms, which reach billions of users and drive a growing share of commerce. They also are trying to reach more users digitally. Many struggle to gain traction in mobile payments.Yet banks are hesitant to hand too much control to third-parties platforms such as Facebook. They prefer to keep customers on their own websites and apps.

.. As part of the proposed deals, Facebook asked banks for information about where its users are shopping with their debit and credit cards outside of purchases they make using Facebook Messenger,

.. Alphabet Inc.’s Google and Amazon.com Inc. also have asked banks to share data if they join with them, in order to provide basic banking services on applications such as Google Assistant and Alex
.. Bank executives are worried about the breadth of information being sought, even if it means not being available on certain platforms that their customers use. It is unclear whether bank customers would need to opt-in to the proposed Facebook services or what other privacy protections might be offered.
.. In recent years, Facebook has tried to transform Messenger into a hub for customer service and commerce,