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.
<https://www.google.com/maps/place/251+Desert+Breeze+Blvd+W,+Chandler,+AZ+85226/@33.3076899,-111.9220921,17z/data=%214m5%213m4%211s0x872b06cdd50c43c7:0x7d3e9c66bdb7f8a2%218m2%213d33.3070191%214d-111.9193025?hl=en>
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
<
http://phxlinux.org/meetings/14-east-valley-meeting.html> for more
information.
See you there,
Brian Cluff
_______________________________________________
PLUG-announce mailing list -
PLUG-announce@lists.phxlinux.org
http://lists.phxlinux.org/mailman/listinfo/plug-announce
PLUG Website at
http://plug.phoenix.az.us---------------------------------------------------
PLUG-discuss mailing list -
PLUG-discuss@lists.phxlinux.org
To subscribe, unsubscribe, or to change your mail settings:
http://lists.phxlinux.org/mailman/listinfo/plug-discuss 
(text/plain)
