Eamon Keane EamonKeane

Query Oracle databases with Python and SQLAlchemy

N.B. SQLAlchemy now incorporates all of this information in its documentation; I’m leaving this post here, but recommend referring to SQLAlchemy instead of these instructions.

Install requirements

We’ll assume you already have SQLAlchemy and Pandas installed; these are included by default in many Python distributions.
Install the cx_Oracle package in your Python environment, using either pip or conda, for example:

How to connect to Azure AKS Kubernetes worker node by SSH

Nodes are not assigned public IP. If you have accessible VM in the same VNET as worker nodes, then you can use that VM as jump host and connect the worker via private IP.

Alternatively public IP can be assigned to a worker node. This readme shows how to do that.

Steps how to attach public IP to a worker node

find out the resource group that AKS created for the node VMs

Quick Tips for Fast Code on the JVM

I was talking to a coworker recently about general techniques that almost always form the core of any effort to write very fast, down-to-the-metal hot path code on the JVM, and they pointed out that there really isn't a particularly good place to go for this information. It occurred to me that, really, I had more or less picked up all of it by word of mouth and experience, and there just aren't any good reference sources on the topic. So… here's my word of mouth.

This is by no means a comprehensive gist. It's also important to understand that the techniques that I outline in here are not 100% absolute either. Performance on the JVM is an incredibly complicated subject, and while there are rules that almost always hold true, the "almost" remains very salient. Also, for many or even most applications, there will be other techniques that I'm not mentioning which will have a greater impact. JMH, Java Flight Recorder, and a good profiler are your very best friend! Mea

	#!/usr/bin/groovy

	/*
	* Copyright (c) 2016, Andrey Makeev <[email protected]>
	* All rights reserved.
	*
	* Redistribution and use in source and binary forms, with or without
	* modification, are permitted provided that the following conditions
	* are met:
	* 1. Redistributions of source code must retain the above copyright

	sudo add-apt-repository "deb http://apt.postgresql.org/pub/repos/apt/ xenial-pgdg main"
	wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc \| sudo apt-key add -
	sudo apt-get update
	sudo apt-get install postgresql-9.6

	sudo apt-get install postgresql-9.6-postgis-2.3
	sudo apt-get install postgresql-9.6-pgrouting

	sudo add-apt-repository ppa:ubuntugis/ubuntugis-unstable
	sudo apt-get update

	# How to encrypt/decrypt your text/blob secret with AWS KMS with AWS cli

	KEY_ID=alias/my-key
	SECRET_BLOB_PATH=fileb://my-secret-blob
	SECRET_TEXT="my secret text"

	ENCRYPTED_SECRET_AS_BLOB=encrypted_secret_blob
	DECRYPTED_SECRET_AS_BLOB=decrypted_secret_blob # Result of decrypt-blob target

	encrypt-text:

	FROM php:7.1-apache

	ADD . /var/www
	ADD ./site.conf /etc/apache2/sites-enabled/000-default.conf

	RUN apt-get update && apt-get install -y libmcrypt-dev mysql-client && \
	docker-php-ext-install mcrypt pdo_mysql opcache && \
	pecl install redis-3.1.2 && docker-php-ext-enable redis && \
	a2enmod rewrite

	pipeline {
	agent { node { label 'swarm-ci' } }

	environment {
	TEST_PREFIX = "test-IMAGE"
	TEST_IMAGE = "${env.TEST_PREFIX}:${env.BUILD_NUMBER}"
	TEST_CONTAINER = "${env.TEST_PREFIX}-${env.BUILD_NUMBER}"
	REGISTRY_ADDRESS = "my.registry.address.com"

	SLACK_CHANNEL = "#deployment-notifications"

	After automatically updating Postgres to 10.0 via Homebrew, the pg_ctl start command didn't work.
	The error was "The data directory was initialized by PostgreSQL version 9.6, which is not compatible with this version 10.0."

	Database files have to be updated before starting the server, here are the steps that had to be followed:

	# need to have both 9.6.x and latest 10.0 installed, and keep 10.0 as default
	brew unlink postgresql
	brew install [email protected]
	brew unlink [email protected]
	brew link postgresql

	[options]

	#
	# WARNING:
	# If you use the Odoo Database utility to change the master password be aware
	# that the formatting of this file WILL be LOST! A copy of this file named
	# /etc/odoo/openerp-server.conf.template has been made in case this happens
	# Note that the copy does not have any first boot changes
	#-----------------------------------------------------------------------------
	# Odoo Server Config File - TurnKey Linux