Lead Software Developer 

full stack and then some

postgREST contributor

SQL or PostgreSQL expert

Network Security Expert

Your Application

Web Server

Database

Request

Response

HTTP Request Handling

ERROR HANDLING

Authentication

Authorization

Request Parsing

Request Validation

Database Communication

Database Response Handling

HTTP Response Building

Your Application

Your Code

Data Handling Library

Object Relational Mapper

Authentication Framework

Application Framework

Active Record cut my lines of code in half!

oAuth lets me stop worrying about my API security!

Play Framework makes writing web apps so easy!

I updated Active Record and the API broke.  How to fix?

The last version of oAuth had a security flaw that leaked our customer emails to spambots

Play Framework updated again, time for another rewrite!  And updating to Java 8.  And updating to Gradle 2.8.  And... 

But know the tradeoffs

Mark's Social Network

Gordon's Coffee Shop

David's DVD Store

Larry's Search Engine

Jeff's Warehouse

Daniel's Streaming Service

GET

POST

PATCH

DELETE

SELECT

INSERT

UPDATE

DELETE

Your Application

Web Server

Database

Request

Response

TL;DR: subsecond response times for up to 2000 requests/sec on Heroku free tier.

TL;DR;TL;DR: Wicked Fast!

Haskell

PostgreSQL

Warp Web Server

10.0.3.2

:5432

/dvdrental

:3000

Sakila Sample Database

JSON Web Tokens

{
  "user": "seth",
  "role": "administrator"
}

+

eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VybmFtZSI6InNldGgiLCJyb2xlIjoiYWRtaW5pc3RyYXRvciJ9.3KPWRfCmFTsMN7D8p8Uz0s4Xsxxuuu9QOB83TkSnLq0

Anonymous

Authenticator

{
  "user": "seth",
  "role": "administrator"
}

eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VybmFtZSI6InNldGgiLCJyb2xlIjoiYWRtaW5pc3RyYXRvciJ9.3KPWRfCmFTsMN7D8p8Uz0s4Xsxxuuu9QOB83TkSnLq0

All Access

Michael Bluth

List & modifies payments

Also has Worker permissions

Gob Bluth

Lists films, categories, actors, languages, & customers

List & Creates Rentals

George Michael Bluth

Lists films

John Q

public

apiv1

Probably not...

mongodb-rest

phprestsql

-- SAMPLE FUNCTION
CREATE FUNCTION tf1 (acct_no integer, debit numeric) 
RETURNS numeric AS $$
    UPDATE bank
        SET balance = balance - $2
        WHERE accountno = $1
    RETURNING balance;
$$ LANGUAGE SQL;

-- SAMPLE TRIGGER
CREATE TRIGGER emp_stamp 
    BEFORE INSERT OR UPDATE ON employees
    FOR EACH ROW EXECUTE PROCEDURE emp_stamp();

Interoperability

Ease of Consumption

Ease of Development

https://

api.twitter.com

/1.1

/users/suggestions.json

?id=foo

HTTP Method

Request Headers

Request Body

{
  "glossary": {
    "title": "example glossary",
  "GlossDiv": {
      "title": "S",
    "GlossList": {
        "GlossEntry": {
          "ID": "SGML",
      "SortAs": "SGML",
      "GlossTerm": "Standard Generalized Markup Language",
      "Acronym": "SGML",
      "Abbrev": "ISO 8879:1986",
      "GlossDef": {
            "para": "A meta-markup language, used to create markup languages such as DocBook.",
      "GlossSeeAlso": ["GML", "XML"]
          },
      "GlossSee": "markup"
        }
      }
    }
  }
}

Status Code

Response Headers

Response Body

{
  "glossary": {
    "title": "example glossary",
  "GlossDiv": {
      "title": "S",
    "GlossList": {
        "GlossEntry": {
          "ID": "SGML",
      "SortAs": "SGML",
      "GlossTerm": "Standard Generalized Markup Language",
      "Acronym": "SGML",
      "Abbrev": "ISO 8879:1986",
      "GlossDef": {
            "para": "A meta-markup language, used to create markup languages such as DocBook.",
      "GlossSeeAlso": ["GML", "XML"]
          },
      "GlossSee": "markup"
        }
      }
    }
  }
}

{
  "Count": 1670,
  "Username": "jdurham",
  "IsPresent": true,
  "JobTitles": [
    "Software Developer",
    "Software Engineer",
    "Sysadmin",
    "Supervisor"
  ],
  "Addresses": [
    {
      "Name": "home",
      "Street": "123 Main St.",
      "City": "Wichita",
      "State": "Kansas",
      "Zip": 67212
    },
    {
      "Name": "work",
      "Street": "266 N Main St.",
      "City": "Wichita",
      "State": "Kansas",
      "Zip": 67202
    }
  ]
}