Darren Rogan darrenrogan

Fast CouchDB setup in AWS

CouchDB is a NoSQL database for storing JSON documents. It comes with a REST API out of the box so your client applications can persist data while requiring you to write little or no server-side code. CouchDB's killer feature is its ability to easily replicate, which allows for horizontal scaling, easy backup, and for client adapters to synchronize documents. This is perfect if you want to write an application that is offline-first. It's become my go-to database when creating new

Keybase proof

I hereby claim:

I am darren-rogan on github.
I am darrenrogan (https://keybase.io/darrenrogan) on keybase.
I have a public key ASCg-SbYyrkueRKfdmQbYJp4Pl3ITS5r5yMHahptKMrd7wo

To claim this, I am signing this object:

	Mine:
	https://www.youtube.com/channel/UCyHVW0gl0HxDpuAFEW5xwJA

	Locals:
	https://www.youtube.com/user/BadenURen
	https://www.youtube.com/channel/UCr8O8l5cCX85Oem1d18EezQ
	https://www.youtube.com/watch?v=wifKdSG-KZs


	Vloggy + Tech Educator


	Unicode table - List of most common Unicode characters *
	* This summary list contains about 2000 characters for most common ocidental/latin languages and most printable symbols but not chinese, japanese, arab, archaic and some unprintable.
	Contains character codes in HEX (hexadecimal), decimal number, name/description and corresponding printable symbol.
	What is Unicode?

	Unicode is a standard created to define letters of all languages and characters such as punctuation and technical symbols. Today, UNICODE (UTF-8) is the most used character set encoding (used by almost 70% of websites, in 2013). The second most used character set is ISO-8859-1 (about 20% of websites), but this old encoding format is being replaced by Unicode.
	How to identify the Unicode number for a character?

	Type or paste a character:

	https://www.pyimagesearch.com/2018/08/17/install-opencv-4-on-macos/

	cmake -D CMAKE_BUILD_TYPE=RELEASE \
	-D CMAKE_INSTALL_PREFIX=/usr/local \
	-D OPENCV_EXTRA_MODULES_PATH=~/opencv_contrib/modules \
	-D PYTHON3_LIBRARY=`python -c 'import subprocess ; import sys ; s = subprocess.check_output("python-config --configdir", shell=True).decode("utf-8").strip() ; (M, m) = sys.version_info[:2] ; print("{}/libpython{}.{}.dylib".format(s, M, m))'` \
	-D PYTHON3_INCLUDE_DIR=`python -c 'import distutils.sysconfig as s; print(s.get_python_inc())'` \
	-D PYTHON3_EXECUTABLE=$VIRTUAL_ENV/bin/python \
	-D BUILD_opencv_python2=OFF \
	-D BUILD_opencv_python3=ON \

	SELECT pg_terminate_backend(pid)
	FROM pg_stat_activity
	WHERE datname = 'mydb';

	dropdb -h db.dev1.server.internal -U dbuser databasename

	createdb -h db.dev1.server.internal -U dbuser databasename

	psql -h db.dev1.server.internal -U dbuser databasename < db.sql