Gabo Esquivel gaboesquivel

Optimizing postgresql table for more than 100K inserts per second

Create UNLOGGED table. This reduces the amount of data written to persistent storage by up to 2x.
Set WITH (autovacuum_enabled=false) on the table. This saves CPU time and IO bandwidth on useless vacuuming of the table (since we never DELETE or UPDATE the table).
Insert rows with COPY FROM STDIN. This is the fastest possible approach to insert rows into table.
Minimize the number of indexes in the table, since they slow down inserts. Usually an index on time timestamp with time zone is enough.
Add synchronous_commit = off to postgresql.conf.
Use table inheritance for fast removal of old data:

Weeklies

NodeJS Weekly http://nodeweekly.com/
Mobile Web Weekly http://mobilewebweekly.co/
Bitcoin Weekly http://bitcoinweekly.com/
Cloud Development Weekly http://clouddevweekly.co/
HTML5 Weekly http://html5weekly.com/
Javascript Weekly http://javascriptweekly.com/
Database Weekly http://dbweekly.com/
Web Operations Weekly http://webopsweekly.com/

CloudFormation snippet to create a VPC to be used for lambda functions. Qualities of the VPC:

4 subnets: 2 public, 2 private (lambda functions should be attached to the private ones).
2 Elastic IPs that can be used to identify traffic coming from lambda functions (e.g. for firewall holes).
Security group that can be used for lambda functions.

Notes:

uses regions us-east-1a, us-east-1b
uses ip block of 10.15.0.0/16 for VPC

Standard JS in create-react-app

I've been using create-react-app lately as I find it very useful to kick things off while starting a project. I almost always follow JavaScript Standard Style and I found myself googling it so I figured out I should write it down.

Get Standard JS

I really like keeping dependencies as local as possible but if you prefer you can install it globally.

yarn add standard --dev

or

NOTE: This assumes that you have Valet, Homebrew, Sublime Text and PHP properly installed and functioning and will only focus on the setup and installation and setup of Xdebug. There are other tutorials that go into great depth explaining how to get those tools installed on your mac.

Let's get started right away!

Installing Xdebug

You need to know which version of PHP you are running in your machine. To do so, from the terminal run the command php -v and this will display something like this

PHP 7.0.14 (cli) (built: Dec  8 2016 23:34:17) ( NTS )

TL;DR: If you want to see me perform a spoken word poem about JavaScript in front of 1000 people (and on video), please ⭐ star this gist. If you're on mobile, you'll need to request desktop site.

JavaScript Slam Poetry

eosio.system.abi

newaccount
setcode
setabi
updateauth
deleteauth

About EOSIO

The EOS.IO software introduces a new blockchain architecture designed to enable vertical and horizontal scaling of decentralized applications. This is achieved by creating an operating system-like construct upon which applications can be built. The software provides accounts, authentication, databases, asynchronous communication and the scheduling of applications across many CPU cores or clusters. The resulting technology is a blockchain architecture that may ultimately scale to millions of transactions per second, eliminates user fees, and allows for quick and easy deployment and maintenance of decentralized applications, in the context of a governed blockchain.

About this guide:

Full documentation can be found at https://developers.eos.io/

This means your portal is correctly setup for the hackathon.

	import React, { Component } from 'react';

	import TextField from 'components/base/TextField';

	const WAIT_INTERVAL = 1000;
	const ENTER_KEY = 13;

	export default class TextSearch extends Component {
	constructor(props) {
	super();

	#! /usr/bin/env python3
	"""Fixing bluetooth stereo headphone/headset problem in debian distros.

	Workaround for bug: https://bugs.launchpad.net/ubuntu/+source/indicator-sound/+bug/1577197
	Run it with python3.5 or higher after pairing/connecting the bluetooth stereo headphone.

	This will be only fixes the bluez5 problem mentioned above .

	Licence: Freeware