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.
=================================
