This month we will have a two presentations.  Phil Waclawski will present "Using Hierarchical Data in MySQL, Trees vs Nests" and Ed Nicholson will present "Securing a SSH Bastion host with PrivacyIDEA and U2F"

Phil Waclawski: Using Hierarchical Data in MySQL, Trees vs Nests

Real world data is often made of hierarchical relationships, or "trees".
Representing that data in a Relational Database starts to get complicated as soon as you have more than two levels in your "Tree".
There are many strategies for handling such data, and I will cover examples of at least two of them (adjacency list and nested sets) and possibly more.

If you have access to a mysql instance, you can create the test tables and follow along, or get the code later.

About Phil:
Phil has been a faculty member, focusing on open source software at MCC for nearly two decades.

Phil teaches a variety of course, including MySQL Database, PHP, Python, Javascript, HTML 5 and CSS, Linux OS, Internet Server Set up and more.

This summer, Phil will once again be offering a "MCC Multimedia Madness" summer camp for 6-8th graders. Over the two weeks I will cover a wide range of open source software, including GIMP, Inkscape, Krita, Audacity, Blender, Hydrogen Drum Kit, Tux Guitar, Openshot, Linux Multimedia Studio, work with green screen and more.

For hobbies, Phil has too many. Blacksmithing, archery, Leatherworking, Wood Working, Jewelry, Sound Recording/editing and SCUBA diving.  Phil is also learning to play the Bass.

Phil has been using linux at home for desktops and servers since 1994.

Ed Nicholson: Securing a SSH Bastion host with PrivacyIDEA and U2F

Bastion Servers are an important tool for access control to your other
systems. PrivacyIDEA is a credential management system that can add
many types of authentication to your Jump Server, for example U2F.
FIDO Universal 2nd Factor Keys are a convenient standard implemented
by many to improve security. PrivacyIDEA is a great example of how
easy adding important levels of security to your systems can be.

About Ed:
Ed has been involved with Free Software for some time, and is most
interested in how people, organizations and populations use, create and
experience information. Recently, Ed is enjoying The Prescott National Forest
as his "personal office" and The Valley of The Sun as a home away from home.
Personal systems run either Fedora, Project Atomic, Android or OpenBSD.

February 2018
28 29 30 31 1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 1 2 3

Upcoming Events

Sat Mar 03 @10:00AM
PLUG East Meeting
Thu Mar 08 @ 7:00PM
Sat Mar 17 @10:00AM
Free Software Stammtisch
Tue Mar 20 @ 7:00PM

AzLoCo Events

Sierra Vista Ubuntu Hour
Thu Feb 22 @ 6:00PM
Ubuntu Hour Tempe Az
Thu Feb 22 @ 7:00PM
AZLOCO Weekly Meeting
Sun Feb 25 @ 9:00PM
Ubuntu Hour Tempe Az
Thu Mar 01 @ 7:00PM
Linux Installfest/Workshop
Sat Mar 03 @10:00AM

Copyright for each contribution is retained by the contributor unless otherwise noted.
Hosting generously provided by Duncan Multimedia