vladholubiev

openapi: "3.0.1"
info:
  title: "demo-test-verification"
  version: "2019-12-27T23:52:02Z"
servers:
- url: "https://xxx.execute-api.us-east-1.amazonaws.com/{basePath}"
  variables:
    basePath:
      default: "/prod"
paths:

vladholubiev

git config --global alias.clean-branches '!git branch | grep -v "master\|develop" | xargs git branch -D'

vladholubiev

## This is a list of RPM packages available on AWS Lambda, Node.js 8.10 runtime, 22 May 2019, Amazon Linux 2018.03
## See https://github.com/claudiajs/lambda-vm-info for how this list was generated and to get an updated version

Installed Packages

ImageMagick.x86_64                 6.7.8.9-15.21.amzn1             @amzn-main   
alsa-lib.x86_64                    1.0.22-3.9.amzn1                @amzn-main   
audit-libs.x86_64                  2.6.5-3.28.amzn1                @amzn-main   
avahi-libs.x86_64                  0.6.25-12.17.amzn1              @amzn-main   
basesystem.noarch                  10.0-4.9.amzn1                  @amzn-main   

vladholubiev

# AWS Lambda `ldconfig -p`, region `us-east-1`, nodejs 8.10 runtime, 22 May 2019, Amazon Linux 2018.03
# See https://github.com/claudiajs/lambda-vm-info for how this was generated and to create an updated version

241 libs found in cache `/etc/ld.so.cache'
	libz.so.1 (libc6,x86-64) => /lib64/libz.so.1
	libxslt.so.1 (libc6,x86-64) => /usr/lib64/libxslt.so.1
	libxshmfence.so.1 (libc6,x86-64) => /usr/lib64/libxshmfence.so.1
	libxml2.so.2 (libc6,x86-64) => /usr/lib64/libxml2.so.2
	libxcb.so.1 (libc6,x86-64) => /usr/lib64/libxcb.so.1
	libxcb-xvmc.so.0 (libc6,x86-64) => /usr/lib64/libxcb-xvmc.so.0

vladholubiev

digraph architecture {
  rankdir=LR;

  // Storage - #303F9F (dark blue)
  node[fillcolor="#303F9F" style="filled" fontcolor="white"];
  database[label="DB"]; cache[label="Redis"];
  
  // Client-side Apps - #FFEB3B (yellow)
  node[fillcolor="#FFEB3B" style="filled" fontcolor="black"];
  front_end[label="Front-end App"]; extension[label="Browser Extension"];

vladholubiev

digraph architecture {
  rankdir=LR;

  subgraph client_side_apps {
      front_end -> {auth_api, my_app_api};
      extension -> {auth_api, my_app_api};
      
      {rank=same; front_end, extension, auth_api};
  }
  

vladholubiev

REPORT Duration: 353.52 ms Billed Duration: 400 ms Memory Size: 1536 MB
REPORT Duration: 340.44 ms Billed Duration: 400 ms Memory Size: 1536 MB
REPORT Duration: 356.91 ms Billed Duration: 400 ms Memory Size: 1536 MB
REPORT Duration: 280.49 ms Billed Duration: 300 ms Memory Size: 1536 MB
REPORT Duration: 336.75 ms Billed Duration: 400 ms Memory Size: 1536 MB

vladholubiev

REPORT Duration: 2120.67 ms Billed Duration: 2200 ms Memory Size: 128 MB
REPORT Duration: 2778.51 ms Billed Duration: 2800 ms Memory Size: 128 MB
REPORT Duration: 2185.11 ms Billed Duration: 2200 ms Memory Size: 128 MB
REPORT Duration: 1883.18 ms Billed Duration: 1900 ms Memory Size: 128 MB

vladholubiev

require(dplyr)
require(data.table)

questions <- tbl_df(fread(input = "questions.csv", header = TRUE, sep = ",")) %>%
  mutate(Score = as.integer(Score)) %>%
  mutate(ViewCount = as.integer(ViewCount)) %>%
  mutate(CreationDate = as.Date(CreationDate)) %>%
  mutate(Tags = Tags %>%
           gsub("<", "", .) %>%
           gsub(">", ",", .) %>%

vladholubiev

Returns a list of locations of users who asked a question about MongoDB.

SELECT Users.Location
FROM Posts
INNER JOIN Users
ON Posts.OwnerUserId = Users.Id
WHERE Posts.Tags LIKE '%mongodb%'
AND Users.Location IS NOT NULL
AND RTrim(Users.Location) > ''