andrewscaya

<?php

namespace App\Support;

use ArrayIterator;
use Countable;
use DatePeriod;
use DateTime;
use DateInterval;
use IteratorAggregate;

andrewscaya

# DOCKER-VERSION        1.3.2

FROM php:7.2-cli-alpine3.8

# Compile-time dependencies
RUN echo 'http://dl-cdn.alpinelinux.org/alpine/v3.6/community' >> /etc/apk/repositories
RUN apk update && \
  apk add --no-cache 'tidyhtml-dev==5.2.0-r1'

# Install the extension

andrewscaya

Installing the OpenWhisk Server

This guide contains instructions on manually setting up Openwhisk and CouchDB on a fresh Ubuntu 14.04 server.

The guide is based on the OpenWhisk Ansible README, which at the time of writing is missing some key steps and gotchas - hence this guide.

1. Installation

sudo su -

andrewscaya

Latency Comparison Numbers
--------------------------
L1 cache reference                           0.5 ns
Branch mispredict                            5   ns
L2 cache reference                           7   ns                      14x L1 cache
Mutex lock/unlock                           25   ns
Main memory reference                      100   ns                      20x L2 cache, 200x L1 cache
Compress 1K bytes with Zippy             3,000   ns        3 us
Send 1K bytes over 1 Gbps network       10,000   ns       10 us
Read 4K randomly from SSD*             150,000   ns      150 us          ~1GB/sec SSD

andrewscaya

<?php

/**
 * @param double $cReal
 * @param double $cImag
 * @param int $maxIterations
 * @return int
 */
function mandelbrotIteration($cReal, $cImag, $maxIterations)
{

andrewscaya

WITH RECURSIVE tree_list AS (
   SELECT 
     id, item, parent_id, CAST(item AS varchar(1000)) AS path
  FROM
    tree
  WHERE parent_id IS NULL
  UNION ALL
  SELECT
    child.id, child.item, child.parent_id, CAST(parent.path || '->' || child.item As varchar(1000)) AS path
  FROM

andrewscaya

 SELECT 
   d.id,
   d.name,
   e_info.avg_salary,
   e_info.num_employees
FROM department d,
       LATERAL (SELECT 
            AVG(e.salary) AS avg_salary,
            COUNT(*) AS num_employees
           FROM employees e

andrewscaya

SELECT
  day,
  month,
  year,
  sum(total)
FROM 
  revenue
GROUP BY GROUPING SETS (
  (day, month, year),
  (month, year),

andrewscaya

SELECT
  event_id,
  date - lag(date) OVER (PARTITION BY event_id ORDER BY date) as difference
FROM
  events;

andrewscaya

SELECT 
  SUM(total) as total,
  SUM(CASE WHEN collected IS TRUE THEN total END) as collected,
  year
 FROM
  invoices
GROUP BY
  year