Saloua Litayem slitayem

Currently, there is an explosion of tools that aim to manage secrets for automated, cloud native infrastructure management. Daniel Somerfield did some work classifying the various approaches, but (as far as I know) no one has made a recent effort to summarize the various tools.

This is an attempt to give a quick overview of what can be found out there. The list is alphabetical. There will be tools that are missing, and some of the facts might be wrong--I welcome your corrections. For the purpose, I can be reached via @maxvt on Twitter, or just leave me a comment here.

There is a companion feature matrix of various tools. Comments are welcome in the same manner.

An Ansible summary

Jon Warbrick, July 2014, V3.2 (for Ansible 1.7)

Configuration file

intro_configuration.html

First one found from of

Note: the commands were tested on Postgres 9.5.4

PSQL

Connect with the user USER_NAME

psql -h REMOTE_SERVER_ADDRESS -U USER_NAME

The Best of the Best Practices (BOBP) Guide for Python

A "Best of the Best Practices" (BOBP) guide to developing in Python.

In General

Values

"Build tools for others that you want to be built for you." - Kenneth Reitz
"Simplicity is alway better than functionality." - Pieter Hintjens

Note: This was tested on macOS Sierra Pre-installed

python
Homebrew

Install cql & cassandra-driver

pip install cql

SQL to MongoDB Mapping Chart

SQL to MongoDB Mapping Chart¶

In addition to the charts that follow, you might want to consider the Frequently Asked Questions section for a selection of common questions about MongoDB.

Executables¶

The following table presents the MySQL/Oracle executables and the corresponding MongoDB executables.

MongoDB cheat sheet

Overview

MongoDB is a document database that provides high performance, high availability, and easy scalability.

Document Database

Note: Tested on mongodb 3.4.1

Creating Collections, Documents, Indexes

See: MongoDB CRUD Operations

Command	Description
`db.createCollection("movies")`	Explicitly create a collection

	## credit: http://fabian-affolter.ch/blog/the-lineinfile-module-of-ansible/
	---
	- hosts: alpine_install
	user: root

	tasks:
	# - name: create a complete empty file
	# command: /usr/bin/touch /test/test.conf

	- name: create a new file with lineinfile

	CREATE OR REPLACE FUNCTION random_int_array(dim integer, min integer, max integer) RETURNS integer[] AS $BODY$
	begin
	return (select array_agg(round(random() * (max - min)) + min) from generate_series (0, dim));
	end
	$BODY$ LANGUAGE plpgsql;

	CREATE EXTENSION pgcrypto;

	CREATE TABLE test_table as select id, md5(random()::text) \|\| id as name, random_int_array(500000, 100, 10000) as arr, gen_random_uuid() uid from generate_Series(1,3) id
	;