Mario Davchevski davcevski

Share Counts

I have always struggled with getting all the various share buttons from Facebook, Twitter, Google Plus, Pinterest, etc to align correctly and to not look like a tacky explosion of buttons. Seeing a number of sites rolling their own share buttons with counts, for example The Next Web I decided to look into the various APIs on how to simply return the share count.

If you want to roll up all of these into a single jQuery plugin check out Sharrre

Many of these API calls and methods are undocumented, so anticipate that they will change in the future. Also, if you are planning on rolling these out across a site I would recommend creating a simple endpoint that periodically caches results from all of the APIs so that you are not overloading the services will requests.

Twitter

Install the following requirements:

brew info zeromq
npm install zmq
npm install socket.io
gem install ffi-rzmq

Within the app directory run the following commands in different panes.

ruby worker.rb

Turning PostgreSQL into a queue serving 10,000 jobs per second

RDBMS-based job queues have been criticized recently for being unable to handle heavy loads. And they deserve it, to some extent, because the queries used to safely lock a job have been pretty hairy. SELECT FOR UPDATE followed by an UPDATE works fine at first, but then you add more workers, and each is trying to SELECT FOR UPDATE the same row (and maybe throwing NOWAIT in there, then catching the errors and retrying), and things slow down.

On top of that, they have to actually update the row to mark it as locked, so the rest of your workers are sitting there waiting while one of them propagates its lock to disk (and the disks of however many servers you're replicating to). QueueClassic got some mileage out of the novel idea of randomly picking a row near the front of the queue to lock, but I can't still seem to get more than an an extra few hundred jobs per second out of it under heavy load.

So, many developers have started going straight t

WordPress database clean up queries

Orphan rows
Other

	<?php
	/*
	* dl-file.php
	*
	* Protect uploaded files with login.
	*
	* @link http://wordpress.stackexchange.com/questions/37144/protect-wordpress-uploads-if-user-is-not-logged-in
	*
	* @author hakre <http://hakre.wordpress.com/>
	* @license GPL-3.0+

	<?php
	/**
	* Plugin Name: Static Templates
	*
	* If most of your site content is in .php template files, and you're tired of
	* creating new pages, assigning them page templates, creating page templates
	* then doing it all over again on production, this plugin is for you.
	*
	* Examples:
	*

	<?php

	if ( ! defined( 'ABSPATH' ) ) exit;

	class WordPress_Plugin_Template_Settings {
	private $dir;
	private $file;
	private $assets_dir;
	private $assets_url;
	private $settings_base;

	function hexToHsl($hex) {
	$hex = array($hex[0].$hex[1], $hex[2].$hex[3], $hex[4].$hex[5]);
	$rgb = array_map(function($part) {
	return hexdec($part) / 255;
	}, $hex);

	$max = max($rgb);
	$min = min($rgb);

	$l = ($max + $min) / 2;

	<?php

	// ...

	if ($client->getAccessToken()) {
	// Create analytics service object.
	$youtube = new Google_Service_YouTube($client);

	/**
	* Retrive favourites videos of the user

	{
	search(type: REPOSITORY, query: "org:huboard-testing spooky-octo-pug", first: 1) {
	edges {
	node {
	__typename
	... on Repository {
	owner {
	id
	}
	name