Upgrade to Pro — share decks privately, control downloads, hide ads and more …

The beauty that is PostgreSQL

The beauty that is PostgreSQL

Shrayas Rajagopal

July 25, 2015
Tweet

More Decks by Shrayas Rajagopal

Other Decks in Technology

Transcript

  1. JULY 2015
    select * from meetups
    where name = ‘chennaipy’

    View full-size slide

  2. The beauty that is
    PostgreSQL

    View full-size slide

  3. The beauty that is
    PostgreSQL
    PART 1

    View full-size slide

  4. Shrayas Karthik

    View full-size slide

  5. Shrayas Karthik

    View full-size slide


  6. World’s most advanced
    open source database

    View full-size slide

  7. INSERT
    statements
    1

    View full-size slide

  8. JSON
    support
    2

    View full-size slide

  9. API
    UI
    Structured
    Unstructured

    View full-size slide

  10. API
    UI
    Structured
    Unstructured

    View full-size slide

  11. API
    UI
    Unstructured
    Structured

    View full-size slide

  12. API
    UI
    Data
    Data

    View full-size slide

  13. 9.2
    JSON
    TEXT Format

    View full-size slide

  14. 9.2
    JSON
    TEXT Format OK

    View full-size slide

  15. 9.2
    JSON
    TEXT Format OK
    row_to_json
    array_to_json

    View full-size slide

  16. 9.2
    JSON
    TEXT Format
    row_to_json
    array_to_json

    View full-size slide

  17. 9.4
    JSONB
    BINARY Format

    View full-size slide

  18. 9.4
    JSONB
    BINARY Format
    row_to_jsonb
    array_to_jsonb
    ++

    View full-size slide

  19. {
    "notificationType": "Bounce",
    "bounce": {
    "bounceType": "",
    "bounceSubType": "",
    "bouncedRecipients": [
    {
    "emailAddress": ""
    }
    ],
    "timestamp": "",
    "feedbackId": ""
    },
    "mail": {
    "timestamp": "",
    "messageId": "",
    "source": "",
    "sourceArn": "",
    "sendingAccountId": "",
    "destination": []
    }
    } Bounce

    View full-size slide

  20. {
    "notificationType": "Delivery",
    "mail": {
    "timestamp": "",
    "messageId": "",
    "source": "",
    "sourceArn": "",
    "sendingAccountId": "",
    "destination": []
    },
    "delivery": {
    "timestamp": "",
    "recipients": [],
    "processingTimeMillis": 546,
    "reportingMTA": "",
    "smtpResponse": ""
    }
    }
    Delivery

    View full-size slide

  21. JAI HO
    PostgreSQL

    View full-size slide

  22. Le Fin
    @shrayasr
    @argvk

    View full-size slide