Sacha Arbonel sachaarbonel

Installing CartoDB on Ubuntu Server 12.04

Get CartoDB Rails application source

sudo apt-get update

sudo apt-get install git

cd ~

git clone --recursive https://github.com/CartoDB/cartodb20.git

API domains

https://desktopapps.ryanair.com

https://api.ryanair.com

Airports

https://api.ryanair.com/aggregate/3/common?embedded=airports,countries,cities,regions,nearbyAirports,defaultAirport&market=en-gb

This guide is still in-progress

Creating and Growing a Discord Server

Introduction

Hello! I'm jagrosh#4824! I'm writing this guide to try to help new server owners set up and grow their servers, which is a commonly-requested topic. It's very easy to go about this the wrong way, so it's best to be prepared and make smart decisions so that your community can flourish!

Background

You might be wondering: why am I qualified to write this guide? Excellent question! Well, I've created several successful Discord servers, including the Monster Hunter Gathering Hall (14,000+ members, game community) and a bot support server (3,000+ members). I also help moderate several large servers, and I am a Discord partner. Finally, I am very familiar with the technical aspects of Discord, which are useful for setting up servers and permissions.

Auto-Deploying via Travis CI

Because Travis CI can automatically execute scripts after successfully (or unsuccessfully!) executing tests, it is an obvious choice for a deployment tool. In order to deploy to a Git repository on a remote server, the process generally is as follows:

Set up SSH keys
Add the server's copy of the repository as a Git remote
Push to the remote
SSH into the server and execute any installation/compilation/miscellaneous commands

Before even touching `.travis.yml`...

Users

Postgres push triggers

Watch a table for changes and push a notification with a payload describing the change.

Example

In the Postgres shell:

-- Create the functions

	<?php
	//app/Plans.php

	namespace App;


	class Plans {
	public static $ONE_SHOW_A_MONTH = '1SHOW';
	public static $TWO_SHOWS_A_MONTH = '2SHOWS';
	public static $FAN = 'FAN';

	"""
	- Add some settings -
	Log in to your sandbox account and get your API keys plus your merchant ID.

	"""
	BRAINTREE_PRODUCTION = False # We'll need this later to switch between the sandbox and live account
	BRAINTREE_MERCHANT_ID = “your_merchant_id”
	BRAINTREE_PUBLIC_KEY = “your_public_key”
	BRAINTREE_PRIVATE_KEY = “your_private_key”

	#! /usr/bin/env python3

	import asyncio
	import contextlib


	async def ping(ip):
	p = await asyncio.create_subprocess_exec('ping', '-c', '4', ip, stdout=asyncio.subprocess.PIPE)
	async for line in p.stdout:
	print(line)

	CREATE TRIGGER person_notify AFTER INSERT OR UPDATE OR DELETE ON income
	FOR EACH ROW EXECUTE PROCEDURE notify_trigger(
	'id',
	'email',
	'username'
	);

	CREATE TRIGGER income_notify AFTER INSERT OR UPDATE OR DELETE ON income
	FOR EACH ROW EXECUTE PROCEDURE notify_trigger(
	'id',