Name: "Select" not "Loops" in Postgress... an SQL Rant., Flipper Zero pocket knife
Start: 2023-05-10T19:00:00-05:00
End: 2023-05-10T21:00:00-05:00

**[https://www.sluug.org/](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](https://www.google.com/url?q=https://www.sluug.org/bio/Stephen_Lembark&sa=D&source=calendar&usd=2&usg=AOvVaw3Fh2QKIvGtTo3gUTn_4Ys1)

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 ](https://www.google.com/url?q=https://en.wikipedia.org/wiki/Flipper_Zero&sa=D&source=calendar&usd=2&usg=AOvVaw2ytj_kGXn_dNCb8D53oZKY)\- 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](https://www.sluug.org/)/ when available.

Don Ellis

Lee Lammert

stan reichardt

Stl Linux Unix Users Group

Technology

Cloud Computing

Technology Professionals

Docker

Virtualization

Computer Programming

Configuration Management

Information Technology

System Administration

Linux

Unix

Open Source

Data Center and Operations Automation

DevOps

Software Development

Rego Va

Tammy Ernst

Mark Orimoloye

Trip Tucker

Steve

Craig Buchek

de 'Gator

"Select" not "Loops" in Postgress... an SQL Rant., Flipper Zero pocket knife

PostgreSQL

Online event

Share

"Select" not "Loops" in Postgress... an SQL Rant., Flipper Zero pocket knife

Stl Linux Unix Users Group

Details

Members are also interested in