https://www.sluug.org/

### ~7:15pm

## MAIN Topic: Making effective use of select in Postgress... an SQL Rant. (or, poetically, "Dof they for loops"):

### Presenter: Stephen Lembark

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 say it in poetry:
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 Main topic (Postgress/SQL Rant above) begins @~7:15pm after ...
...after general Q&A and announcements @~7pm after ...
The basic/tutorial (Flipper Zero) starts at @6:30pm.

The abstract for the tutorial is...

## BASE Topic: Flipper Zero - A Swiss Army Knife?

### Presenter: Rob Dodson

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 maybe...
+-+-+-+-+-+-+-+-+-+
The url link to this Zoom mtng is posted earlier on the day of the mtng at the above home page. It is the link called "linked here".
ONLINE MEETINGS ONLY until further notice.
ONLINE session will use remote video software.
HOW TO CONNECT instructions on[ https://www.sluug.org/](https://www.sluug.org/) web page and our mailing lists. Note that your browser cache may need to be refreshed each time you check the above web page for the instructions. We will open the remote session at about 6:00 PM, so that you can join early to test your microphone, screen and video sharing.

The Main topic (SQL Rant) begins @~7:15pm after ...
...after general Q&A and announcements @~7pm after ...
The basic/tutorial (Flipper Zero) starts at @6:30pm.

Details will be published on https://www.sluug.org/ when available.