PGCon2014 - Final Release

PGCon 2014
The PostgreSQL Conference

James Hanson
Day Tutorials - Day 2 - Wed May 21 - 2014-05-21
Room Montpetit 201
Start time 13:00
Duration 03:00
ID 712
Event type Workshop
Track Tutorial
Language used for presentation English

Working with PostgreSQL network data types: A hands-on workshop

Working examples of how to validate, load, store and operate on IPv4/6 and MAC address data

PostgreSQL network data types (IP v4/6 plus MAC addresses) enable handing network data without casts, conversion or custom code, which opens new capabilities to work directly with web-log, network device and other IA (Information Assurance) data in its native form – things that can't be done in MySQL, Oracle, MSSql or NoSQL databases! This workshop is a hands-on walk through of gathering, validating and loading network data using both SQL INSERT statements and the COPY command. We then show how to use the built-in network operators to perform fast and simple analysis with SQL.

This workshop is a hands-on exploration of the capabilities and potential usage of PostgreSQL network data types and operators. It includes technical specifics on how to validate and load (using both SQL INSERT and COPY) network data as well as working examples of the custom network-data operators. The workshop ends with an exploration and discussion of how these capabilities can be used for web-application logging and monitoring, Information Assurance (IA) and other areas.