Hans Hsu ogckw

If you're using a high-end bluetooth headset on your Macbook Pro it's likely your mac is using an audio codec which favors battery efficiency over high quality. This results in a drastic degradation of sound, the SBC codec is the likely culprit, read more about it here.

Find out what codec you're using

Play a song on your headphones
Option (⌥) click the Bluetooth button at the top of your screen
If you're using AAC or aptX, you can stop here—those are the highest quality codecs.

Change your codec to AAC or aptX

Meltdown fix impact on Redis performances in virtualized environments

UPDATE: apparently kernel difference may have a serious impact, so I'll redo the test from scratch.

Test performed with AOF enabled, fsync policy 1 second, allowing the rewrites to be triggered.

Command lines used:

| Title | Description

Useful Links / Sources

PrestoDB Selects Doc

Housekeeping

change column type

ALTER TABLE logs.trades CHANGE recentprice price int;

A curated list of AWS resources to prepare for the AWS Certifications

A curated list of awesome AWS resources you need to prepare for the all 5 AWS Certifications. This gist will include: open source repos, blogs & blogposts, ebooks, PDF, whitepapers, video courses, free lecture, slides, sample test and many other resources.

AWS ELB with Node.js and WebSockets

This assumes that:

You are using Nginx.
You want to accept incoming connections on port 80.
Your Node.js app is listening on port 3000.
You want to be able to connect to your Node.js instance directly as well as via the load balancer.

####1. Create load balancer

How to: Allow Node to bind to port 80 without sudo

TL;DR

Only do this if you understand the consequences: all node programs will be able to bind on ports < 1024

sudo setcap 'cap_net_bind_service=+ep' /usr/local/bin/node

Important: your node location may vary. Use which node to find it, or use it directly in the command:

	from flask import Flask

	application = Flask(__name__)

	@application.route("/")
	def hello():
	return "Hello World!"

	# GOAL: On a CentOS 6.7 minimal install, set up nginx as a reverse proxy to uWSGI Emperor with python 2.7.11 as a plugin to run Flask apps

	# ::NOTE:: All instructions below are run as a sudoer, not as root. Talk to your sysadmins if you're not a sudoer.

	# Install bare essentials:
	sudo yum install -y epel-release
	sudo yum groupinstall 'Development Tools'
	sudo yum install -y vim openssl unzip nginx openssl-devel zlib-devel sqlite-devel bzip2-devel libffi-devel lapack-devel blas-devel libpng-devel freetype-devel

	# Set SELINUX=disabled in the file below, and reboot, or this tutorial will get unnecessarily complicated:

	import pymssql
	import pandas as pd

	## instance a python db connection object- same form as psycopg2/python-mysql drivers also
	conn = pymssql.connect(server="172.0.0.1", user="howens",password="some_fake_password", port=63642) # You can lookup the port number inside SQL server.

	## Hey Look, college data
	stmt = "SELECT * FROM AlumniMirror..someTable"
	# Excute Query here
	df = pd.read_sql(stmt,conn)