PGCon2014 - Final Release
PGCon 2014
The PostgreSQL Conference
| Speakers | |
|---|---|
|
James Hanson |
| Schedule | |
|---|---|
| Day | Tutorials - Day 2 - Wed May 21 - 2014-05-21 |
| Room | Montpetit 201 |
| Start time | 13:00 |
| Duration | 03:00 |
| Info | |
| 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.