Nick Glynn 17twenty

Hey guys!

There's a TON of content out there on SEO - guides, articles, courses, videos, scams, people yelling about it on online forums, etc etc..

Most of it, however, is super impractical. If you want to start doing SEO TODAY and start getting results ASAP, you'll need to do a TON of digging to figure out what's important and what's not.

So we wanted to make everyone's lives super easy and distill our EXACT process of working w/ clients into a stupid-simple, step-by-step practical guide. And so we did. Here we are.

A bit of backstory:

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

Be as available as possible This is probably the best piece of advice I received from a friend prior to starting my new job. Things move quickly back at the home office, and since you’re not there, there’s a built-in delay for someone wishing to communicate with you.

If it always takes hours for someone to get your ear for just a minute, you’ll build a reputation as someone who’s “never around”–even if only subconsciously–among your coworkers.

As a remote employee, you have to work harder at being available to avoid the impression that you’re never available.

Strive to build a reputation as someone who is quick to respond. Be eager to hear the latest developments on projects so that you’re never out of sync with everyone else in your office.

Using golang-migrate AKA mattes/migrate with Docker, Postgres and creating new schemas.

Prerequisites

We use the golang-migrate tool (formerly known as mattes/migrate) - build it with postgres support.

$ go get -v -u -tags 'postgres' github.com/golang-migrate/migrate/cli
$ migrate -h
Usage: migrate OPTIONS COMMAND [arg...]

	package types

	import (
	"encoding/json"
	"io"
	"reflect"
	"strings"
	)

	// JSONFilteredByWhitelist filters an incoming JSON payload against a while list,

	package main

	import (
	"fmt"
	"regexp"
	"strings"
	)


	// Regex

	package main

	import (
	"bytes"
	"encoding/json"
	"fmt"
	"log"
	"os"
	"strconv"
	)

	package main

	// #include <stdlib.h>
	// #include <string.h>
	// #include <sys/shm.h>
	// #include <sys/types.h>
	// #include <stddef.h>
	// int my_shm_open(char* filename, int open_flag){
	// int shm_id;
	// key_t key;

	package main

	import (
	"database/sql/driver"
	"encoding/json"
	"fmt"
	"strings"
	)

	type paymentOption int64

	package quicka

	import (
	"fmt"
	"strings"

	"github.com/shopspring/decimal"
	)

	// FormatMoneyDecimal ...