Here are the slides for my #rsecon24 talk yesterday.
SQLite for Everyone.
It is an intro to SQL, plus a tour of useful tools including the `sqlitebrowser` GUI front-end.
If you start the presentation on a laptop/desktop and press 's', you can get the speaker mode. This has full notes so you can see what I said.
github.com/volcan01010/RSECon2…
The `data` folder contains CSV and Python files to recreate the database and try the queries for yourself.
1/n
🚀 The 2nd Annual Forever Open Source Jam runs all thru 2024!
😲 Dive deep into the realm of open gaming, where all resources & entries stay *forever* open licensed!
🎲 Come enjoy the free license #TTRPG love.
itch.io/jam/forever-open-sourc…
“In what is the most detailed explanation of the rationale behind the incursion, Syrskyi outlined the key objectives of the operation: to stop #Russia from using Kursk as a launchpad for a new offensive, to divert Moscow’s forces from other areas, to create a security zone and prevent cross-border shelling of civilian objects, to take prisoners of war and to boost the morale of the Ukrainian troops and the nation overall” #Ukraine
What research says about preventing school shootings
Experts on school violence say a key to prevening such tragedies is identifying and supporting students in crisis before they hurt others.
#news #npr #publicradio #usa
posted by pod_feeder_v2
Whuffo likes this.
alternativeto.net/news/2024/9/…
Linutil is a distro-agnostic toolbox designed to simplify everyday Linux tasks.
GitHub - ChrisTitusTech/linutil: Chris Titus Tech's Linux Toolbox - Linutil is a distro-agnostic toolbox designed to simplify everyday Linux tasks.
Chris Titus Tech's Linux Toolbox - Linutil is a distro-agnostic toolbox designed to simplify everyday Linux tasks. - ChrisTitusTech/linutilGitHub
reshared this
Titus is fairly trustable (he's made a few videos on the dangers of custom Windows ISOs like AtlasOS) but the thing is written in good chunks with AI assisted development and it's also the dude's Rust learning experience as well, so the code is not great. Parts of it are meant to run under ArchISO to install Arch (another sin, an automatic Arch installer) so it makes sense to want to just one-liner download and run the prebuilt binary.
I wouldn't use it personally but his audience is for it. It targets quick and easy, not proper and secure. It's mostly meant to easily install and clone his setup, it's too early in development to really be that useful for everyone.
On the winutil side he also does the | iex PowerShell sin, but the toolbox do be really useful to debloat a Windows install.
Titus is fairly trustable
Like winutil, which installs from one day to another Chocolatey without asking? No, thanks no.
mastodon.social/@Jayslacks/113…
FediForum is in one week from today!
At this time (about 8:30am pacific), we will be watching demos of cool Fediverse software you may not have used yet, followed shortly by making the agenda for the day together.
Join us to discuss how we move the fediverse forward? fediforum.org
My wife ordered this watch for me 3 months ago, for my birthday. It finally turned up and it is incredible. These pictures do it absolutely no justice at all.
This is the Selten Salvage Bronze, for anyone who is interested.
Donald Trump’s own admission that he lost “by a whisker” in 2020 could wreck his trial before it even begins.
space.com/nasa-europa-clipper-…
Para os meus seguidores que falam português, estarei às 20h no Instagram (@japanologia_jp) respondendo perguntas que tenho recebido sobre xintoísmo.
For my followers who speak Portuguese, I’ll be at 8pm on Instagram (@japanologia_jp) answering the questions I have received about Shinto.
Dr John A Stevenson
in reply to Dr John A Stevenson • • •There is a bonus video beyond the final slide. I decided there wasn't time to include it in the final presentation.
It gives an overview of using #QGIS form widgets to set up a form with constraints, drop-downs, defaults and date pickers.
QGIS really is a nice way to make a simple data-entry front-end for any database tables.
You can watch it here.
volcan01010.github.io/RSECon24…
#gis #rsecon24 2/2
Dr John A Stevenson
in reply to Dr John A Stevenson • • •For those interested in #json with #sqlite, here's a link to the docs.
I use it to store arrays of items with multiple nested attributes. I don't use the items elsewhere, so it isn't worth the extra effort to define normalised tables.
It's not a free-for-all, however, as I create the items as #Python #pydantic models and use `item.model_dump_json()` to get the JSON string to insert.
The SQLite `for_each` function iterates and retrieves the attributes.
sqlite.org/json1.html#jeach
#rsecon24 3/2!