https://queryquest.de ist mein Vorschlag als Alternative zum bekannten SQL Island: SQL spielerisch mit einer Inselflucht lernen ohne zu töten, machbare Lernkurve, Aufgaben überspringen, Tipps, für Lehrkräfte beobachtbarer Lernfortschritt.

Query Quest lässt sich leicht um eigene Datenbanken und Missionen erweitern. Schreib mir gern, wenn du Ideen hast.

General SQL "zen" question.

So I find myself struggling sometimes with SQL syntax because I just don't have a good sense of its composability. As in... All the things I've learned so far don't seem to tend to add up to being able to guess what a slight extension on my current syntax knowledge might be, and it's hard to find in search engines because the syntax is all English particles and verbs.

Example: I'm over here looking at a situation where there's a table with multiple foreign keys to the same other table. And I'm like "Okay... So I know how to do a LEFT JOIN on one table, but this is a LEFT JOIN on the same table over and over with different filters... How?" And it turns out you can change the local name of a joined-to table with the AS keyword to do this, so

select whatever from foo
LEFT JOIN bar AS bar1 on bar1.id = foo.x
LEF JOIN bar as bar2 on bar2.id = foo.y

And like... now that I know the as keyword applies here, that makes perfect sense, but how would I get there? Is there a list somewhere of "This is a keyword in SQL and here's all the contexts it could be applied?"

PSA for #mechanicalkeyboard enthusiasts who are also using #SQL:

group buy ≠ groupby

(SCNR)

Using Regular Expressions (Regex) in SQL Server 2025: A Complete Guide.

https://www.red-gate.com/simple-talk/featured/using-regex-in-sql-server-2025-complete-guide/

Supabase MCP can leak your entire SQL database

｢ The cursor assistant operates the Supabase database with elevated access via the service_role, which bypasses all row-level security (RLS) protections. At the same time, it reads customer-submitted messages as part of its input. If one of those messages contains carefully crafted instructions, the assistant may interpret them as commands and execute SQL unintentionally ｣

https://simonwillison.net/2025/Jul/6/supabase-mcp-lethal-trifecta/

#SQL Joins

#SQL #databases #LEGO

'This paper introduces the LEGO® Database, a large natural dataset that can be used to teach Structured Query Language (SQL) and relational database concepts.'

https://eric.ed.gov/?id=EJ1468081

Who in the #TSQL language implementation team at Microsoft thought it was a good idea to differentiate between INSERT INTO - SELECT and SELECT INTO? Who thought it would be reasonable to expect that us users of those statements would find it obvious that one of them creates a new table and the other doesn't, but the one that doesn't also can't be used to insert rows into an existing table? Is this a thing other #SQL dialects do too?

Two open positions in my lab to develop scientific software with python and javascript.

Software: CATMAID

Documentation:
https://catmaid.readthedocs.io/en/stable/

Source code:
https://github.com/catmaid/CATMAID/

Example:
https://l1em.catmaid.virtualflybrain.org/?pid=1&zp=108250&yp=82962&xp=54211&tool=tracingtool&sid0=1&s0=3&help=true

If you have experience with #SQL (#postgresql), #python and its many libraries (particularly #django), #rust, and #javascript, write to me and let's discuss.

Examples of open issues: https://github.com/catmaid/CATMAID/issues

"#Supabase #MCP can leak your entire #SQL #database"

#Security #LLM

https://www.generalanalysis.com/blog/supabase-mcp-blog

What the Decline of #Sql Server Quality means for #Developers and #DBAs https://kendralittle.com/2025/03/10/what-the-decline-of-sql-server-quality-means-developers-dbas/ #MSSQL

I want to be your next #FediHire ! I've been a programmer since 1985 (as a child), I've been an IT professional since 1995 (pulling wires and swapping cards and configuring MS Windows). I graduated from University of Arkansas Fayetteville with a BS in CS in December of 2003. A full resume is available.

I currently require a 100% remote position. I cannot relocate from Cove, #Arkansas. I would prefer W-2 employment with a base salary of at least 130k USD/yr, plus some sort of retirement offering (401k or similar) and healthcare benefits (HDCP + HSA or similar).

I prefer something where I can be a high-performing individual contributor: reading, writing and improving source text the majority of my day, with some time spent knowledge-sharing with other developers -- learning and teaching. I'd like to work with #Haskell, #Purescript, or #Idris as the primary source language. I've previously delivered value in Haskell, #Javascript, #SQL, #Python, #Scala, #Java, #C, and #Cxx among others. I can be productive in almost any language (no PHP, please; I promised myself never again).

Xero is hiring Senior Machine Learning Engineer

#python #aws #sql #machinelearning #seniorengineer
Toronto, Canada
Full-time
Xero

Job details https://jobsfordevelopers.com/jobs/senior-machine-learning-engineer-at-xero-com-jun-20-2025-2dab33?utm_source=mastodon.world&utm_medium=social&utm_campaign=posting
#jobalert #jobsearch #hiring

Rust CLIs with Clap
https://tucson-josh.com/posts/rust-clap-cli/
#ycombinator #rust #clickhouse #sql #software #photography #clap #cli #SemVer

Ever tried to build a #database for "names" for humans? And ran into exception over exception? Building a database for #Aviation data is equally complicated! There are more exceptions than rules.

Falsehoods Programmers Believe About Aviation

https://flightaware.engineering/falsehoods-programmers-believe-about-aviation/

You will never forget the first time you saw a 30-table join spanning 30 systems in a single query.

https://coffingdw.com/30-table-join-across-30-different-systems-shocks-the-it-world/

Thrid lesson of handling dates on computers.

Your day is not "11/8/2025". It's 1.762.560.000.

pro tip for user interface designers:

if you have hundreds of millions of dollars of venture capital and you want to make a user facing data analytics tool of some kind and you think it's reasonable to ask an average human being to type this:

CAST('2023-05-01' AS TIMESTAMP)

to do literally anything with a date or time in your application's user interface, just stop right there. do not pass go, do not collect $200, and do not ever attempt to offer feedback to a UX designer ever again. something is deeply broken inside you that means there are certain mysteries of the universe that even the guys who designed the postgres command line can access that you will never know, and that's ok. You can still live a really rad life.