Monthly St.L Unix Users Grp general mtng ~"Select" not "Loops" in Postgress...an SQL Rant, Flipper Zero pocket knife Wednesday, May 10 Monthly on the second Wednesday notes Description:Meetings are every 2nd Wednesday of the month from 6:30 PM to 9:00 PM. BASE Topic: Flipper Zero Presenter: Rob Dodson Flipper Zero - A Swiss Army Knife? Flipper Zero has garnered a great deal of attention as an ultimate Hacking Tool. The first shipment to the US was held up by customs so the government could determine what threat it posed to information technology and related services. Amazon removed it from their site stating it could be used as a card skimmer. The big question, is it? Learn the pros and cons of the tool, what it is good for and how it works. Is it a toy, as most people think or does it have a role in security? What can you do to expand its capabilities, and does this make it more dangerous? ... Find out at this next meeting... Something more advanced, detailed, important, new, profound, significant, timely or useful. MAIN Topic: Making effective use of select in Postgress... an SQL Rant. (or, poetically, "Dof they for loops"): Presenter: Stephen Lembark Preliminary narrative Face it: Most of what we all write for queries isn't poetry, let alone True Art. All too often we hack a 'select * from foobar' and figure that "the code can handle it" or some such. Blech. This month let's look at how to use simple data structures and SQL to generate straightforward tables for time-based analysis with SQL -- nary a loop or block required! This talk uses and shows how to create the basis of a complete data analysis framework using SQL, sequences, and range data types. It's efficient in time and space, flexible for handling calendar and fiscal periods, and it'll impress your friends in bar bets. Or, to state this a bit more poetically... Doff thy for loops and take joy in select! Thus is the way we shall make use of SQL*: generate what is needed with nary a loop! KISS what is real, and so make it your own! Sets are your friends, no loops needed! With Apologies to The Bard (of course). * "squeal", as in the noise of a pig. ============================== The Saint Louis Unix Users Group (SLUUG) is an IRS 501c(6) designated not-for-profit professional association dedicated to education and communication among computer users. SLUUG members include many Linux and UNIX professionals, Networking experts, System experts, hobbyists, retirees, students, plus many others who are interested in Unix, Unix-like Operating Systems, Linux, BSD and other Free Open Source Software (FOSS) applications, products, projects and services. SLUUG is your forum for exchanging information about OPEN standards, OPEN systems, OPEN source, products, services and architectures. We usually start the general meeting with our BASE introductory level session (often focused on personal computing), which may include either simple tutorials, displays of newly discovered web sites, command line wonders, demonstrations of useful applications, amazing graphical packages, major resolution of long standing anomalies, blinking lights, or quantum shifts in both time and space. Then we will have our usually quick welcome, introduction, administrative announcements, and a Call For Help - Questions and Answers Period. After all that, we may take a break before our MAIN event. ======================================= http://www.sluug.org/ The URL link to connection instructions for this meetng is posted earlier on the day of the meetng, at the above home page. It is the link called "linked here". ONLINE MEETINGS ONLY until further notice. ONLINE sessions will use a remote video meeting service. HOW TO CONNECT instructions will be on the https://www.sluug.org/ web page and on our mailing lists. Note that your browser cache may need to be refreshed each time you check the web page for the instructions. We will open the remote session at about 6:00 PM, so that you can join early to test sharing your microphone, screen and video camera. =================================