Stl Linux Unix Users Group

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.

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