AlexRogalskiy

There are a number of good introductory SQL resources available for free and online. There are also some paid resources which I recommend for beginners, that are very effective, and well worth expensing in my opinion.

A couple of notes:

• I haven’t used all of these resources, but they come with strong recommendations around the web or myself/my peers.
• You absolutely don’t need to use every single resource. Find a couple that work for you, and go to town.
• You can always reach out to me if you have questions. I always paste this online when people are new to asking very technical questions – it’s not meant to be snarky – it's a gentle guide on how to compose your questions and gather necessary resources in order to best give technical people the information needed to get a quick/effective response: http://www.mikeash.com/getting_answers.html

Video/Class/Mini-course based:

1. Stanford Self-paced ‘Database’ course

• The original Coursera

AlexRogalskiy

Latency numbers every programmer should know

L1 cache reference ......................... 0.5 ns
Branch mispredict ............................ 5 ns
L2 cache reference ........................... 7 ns
Mutex lock/unlock ........................... 25 ns
Main memory reference ...................... 100 ns             
Compress 1K bytes with Zippy ............. 3,000 ns  =   3 µs
Send 2K bytes over 1 Gbps network ....... 20,000 ns  =  20 µs
SSD random read ........................ 150,000 ns  = 150 µs

Read 1 MB sequentially from memory ..... 250,000 ns = 250 µs

AlexRogalskiy

@Component
public class Demo {
    @HystrixCommand(commandKey = "#key",groupKey = "#key",fallbackMethod = "fail")
    public String exec(String key){
        if (RandomUtils.nextBoolean()) {
            System.out.println(1 / 0);
        }
        return key;
    }
    public String fail(String key){

AlexRogalskiy

{
  "type" : "record",
  "name" : "TimeExamples",
  "namespace": "com.example",
  "fields" : [
    {
      "name": "aDate",
      "type": "int"
      "logicalType": "date"
    },

AlexRogalskiy

@SuppressWarnings - IntelliJ modes

Information

This list may grow each year with either new versions or patches. Enjoy!

Usage

Following is an example related to the usage of the various ignore capabilities.

AlexRogalskiy

1. Setup ssh key on server

follow this guide https://support.atlassian.com/bitbucket-cloud/docs/set-up-an-ssh-key/

or

ssh-keygen eval $(ssh-agent) ssh-add ~/.ssh/

AlexRogalskiy

image: atlassian/default-image:2

pipelines:
  branches:
    master:  # Trigger this for any pushes to the master branch.
      - step:
          name: Build and Deploy Snapshot Artifact
          trigger: automatic
          caches:
            - maven # Cache any dependencies we download, speeds up build times.

AlexRogalskiy

version: "3.5"

services:
  mongo:
    image: mongo:latest
    container_name: mongo
    environment:
      MONGO_INITDB_ROOT_USERNAME: admin
      MONGO_INITDB_ROOT_PASSWORD: admin
    ports:

AlexRogalskiy

[
   {
      "abbrev":"AF",
      "name":"Afghanistan",
      "postal":"[0-9]{4}"
   },
   {
      "abbrev":"AL",
      "name":"Albania",
      "postal":"(120|122)[0-9]{2}"

AlexRogalskiy

// Country list source: https://www.dhl.com/en/country_profile.html#.XwODEJNKjOQ 
// Country abbreviation source: https://planetarynames.wr.usgs.gov/Abbreviations
// Postal code: https://gist.githubusercontent.com/jamesbar2/1c677c22df8f21e869cca7e439fc3f5b/raw/21662445653ac861f8ab81caa8cfaee3185aed15/postal-codes.json
// Postal code: https://en.wikipedia.org/wiki/List_of_postal_codes

// Country/territory items with no postal code regexes or ranges either do not require postal codes
// or there may not be enough information for that country/territory

export const COUNTRY_ADDRESS_POSTALS = [{
    abbrev: 'AF',