pavan pavanmehta91

Migrations & Seeding

What are migrations??

Migrations are a way to make database changes or updates, like creating or dropping tables, as well as updating a table with new columns with constraints via generated scripts. We can build these scripts via the command line using knex command line tool.

To learn more about migrations, check out this article on the different types of database migrations!

Creating/Dropping Tables

S3 Static Sites

⚠ This post is fairly old. I don't keep it up to date. Be sure to see comments where some people have posted updates

What this will cover

Host a static website at S3
Redirect www.website.com to website.com
Website can be an SPA (requiring all requests to return index.html)
Free AWS SSL certs
Deployment with CDN invalidation

	[Raster tiles][rt]	[Vector tiles][vt]	GeoJSON	virtual-dom	offline	map quality	React component	React Native
google maps	+		+			good	[4 unsupported][gm-react]	[+][gm-native]
leaflet *	+	[+][ll-vt]	+		[+/-][ll-offline]	depends	[+][ll-rect]
d3 *			+	[+/-][d3-vdom]	+/-	depends	[+][d3-react]
MapboxGL	+	+				depends	[+][mb-react]	[+][mb-native]
Yandex Maps	+

Following instructions at https://mariadb.com/kb/en/mariadb/preparing-for-columnstore-installation/

Install

sudo apt-get -y install libboost-all-dev expect perl openssl file sudo libdbi-perl libreadline-dev libdbd-mysql-perl
wget https://downloads.mariadb.com/ColumnStore/1.0.7/ubuntu/dists/xenial/main/binary_amd64/mariadb-columnstore-1.0.7-1-xenial.x86_64.deb.tar.gz
tar zxf mariadb-columnstore-1.0.7-1-xenial.x86_64.deb.tar.gz
sudo dpkg -i *.deb
sudo /usr/local/mariadb/columnstore/bin/postConfigure

Install MongoDB on macOS Sierra

This procedure explains how to install MongoDB using Homebrew on macOS Sierra 10.12.
Official MongoDB install documentation: here

Install Homebrew

Installing Homebrew is effortless, open Terminal and enter :
$ /usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"

Hello software developers,

Please check your code to ensure you're not making one of the following mistakes related to cryptography.

I. General Mistakes

Writing your own home-grown cryptography primitives (For example: Mifare Classic)
- Exception: For the sake of learning, but don't deploy it in production.
Using a fast hash function (e.g. MD5, SHA256) for storing passwords. Use bcrypt instead.
Not using a cryptographically secure random number generator


	#
	# Ubuntu 18.04 (Bionic Beaver)
	#
	# Basic packages i usually install.
	#
	# Author: Julius Beckmann <[email protected]>
	#
	# Upgraded Script from 17.04: https://gist.github.com/h4cc/09b7fe843bb737c8039ac62d831f244e
	# Upgraded Script from 16.04: https://gist.github.com/h4cc/fe48ed9d85bfff3008704919062f5c9b

	import hoistNonReactStatic from 'hoist-non-react-statics';
	import React from 'react';

	function getDisplayName(WrappedComponent) {
	return WrappedComponent.displayName \|\| WrappedComponent.name \|\| 'Component';
	}

	// See: https://facebook.github.io/react/docs/higher-order-components.html
	export default function mutatable({ mutationName = 'mutate' } = {}) {
	return (SourceComponent) => {

	var ConcatSource = require('webpack/lib/ConcatSource');
	var loaderUtils = require('loader-utils');

	module.exports = CombineChunksPlugin;

	// opts.filename = 'vendor.[contenthash].js'

	function CombineChunksPlugin(opts) {
	if (opts) {
	this.filename = opts.filename ? opts.filename : 'vendor.bundle.js';