PLUG Meeting April 13th ------------------------------------------------------------------------ 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" For more info, Meeting time and location see: http://phxlinux.org/index.php/meetings/14-east-valley-meeting.html ** ------------------------------------------------------------------------ *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. ------------------------------------------------------------------------ The meeting will start at 7pm at The Desert Breeze Substation. People start arriving as early as 6pm, so if you would like to help setup and/or chat for a while, arrive a little early. *Meeting Location*: Desert Breeze Substation 251 North Desert Breeze Blvd West Chandler, AZ 85226 The Desert Breeze Substation is on Chandler Blvd and Desert Breeze Blvd, which is half way between McClintock and Rural. It is very close to both the south 202 and 101 freeways. Public transportation is available into the late hours. We will go for food to BJs at the Chandler Fashion Center Mall after the meeting so we can chat with each other comfortably. Please feel free to join us. Please come even if you aren't hungry, the food is not mandatory. See the meeting information on our web site for more information. See you there, Brian Cluff