Skip to content

Instantly share code, notes, and snippets.

Work on stuff that matters

Alexander AlexRogalskiy

Work on stuff that matters
View GitHub Profile
AlexRogalskiy /
Created May 25, 2023 06:49 — forked from momer/
SQL learning Resources for Beginners

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:

Video/Class/Mini-course based:

  1. Stanford Self-paced ‘Database’ course
  • The original Coursera
AlexRogalskiy / latency.markdown
Created May 14, 2023 06:51 — forked from hellerbarde/latency.markdown
Latency numbers every programmer should know
View latency.markdown

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 /
Created April 19, 2023 10:36 — forked from anjia0532/
@HystrixCommand support dynamic command key
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){
View time-avro-example.avsc
"type" : "record",
"name" : "TimeExamples",
"namespace": "com.example",
"fields" : [
"name": "aDate",
"type": "int"
"logicalType": "date"
AlexRogalskiy /
Created March 27, 2023 11:18 — forked from vegaasen/
SuppressWarnings with IntelliJ Idea

@SuppressWarnings - IntelliJ modes


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


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

AlexRogalskiy /
Created February 10, 2023 22:35 — forked from shankar-bavan/
CI CD with bitbucket pipleline and shell script
AlexRogalskiy / bitbucket-pipelines.yml
Created February 10, 2023 22:16 — forked from 64BitChris/bitbucket-pipelines.yml
Example BitBucket Pipeline YML file for Maven Projects
View bitbucket-pipelines.yml
image: atlassian/default-image:2
master: # Trigger this for any pushes to the master branch.
- step:
name: Build and Deploy Snapshot Artifact
trigger: automatic
- maven # Cache any dependencies we download, speeds up build times.
AlexRogalskiy / docker-compose.yml
Created January 12, 2023 07:29 — forked from adamelliotfields/docker-compose.yml
Docker Compose Mongo with Mongo Express
View docker-compose.yml
version: "3.5"
image: mongo:latest
container_name: mongo
AlexRogalskiy / postal_codes_regex.json
Created December 25, 2022 22:26 — forked from lkopocinski/postal_codes_regex.json
JSON file with postal codes regex patterns
View postal_codes_regex.json
AlexRogalskiy / countriesAddressPostal.js
Created December 25, 2022 22:26 — forked from ShreyKumar/countriesAddressPostal.js
List of countries and their respective postal codes with ranges (August 2020)
View countriesAddressPostal.js
// Country list source:
// Country abbreviation source:
// Postal code:
// Postal code:
// 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
abbrev: 'AF',