Med-Mastodon

Peter SolnicaGonna release drops_relation 0.1.0 on Monday. You can check out the README to see how the API looks like.I'm really excited about this one 🙃<a href="https://hachyderm.io/tags/ElixirLang" class="mention hashtag" rel="nofollow noopener" target="_blank">#ElixirLang</a> <a href="https://hachyderm.io/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQL</a> <a href="https://hachyderm.io/tags/OpenSource" class="mention hashtag" rel="nofollow noopener" target="_blank">#OpenSource</a><a href="https://github.com/solnic/drops_relation" rel="nofollow noopener" translate="no" target="_blank">https://github.com/solnic/drops_relation</a>

Ryan KennedyHey, <a href="https://hachyderm.io/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQL</a> nerds…looking for a clever way to order results by a list passed in as part of a WHERE…IN query. e.g.SELECT language, label FROM thing_labels WHERE thing_id=13 AND language IN ['en', 'de', 'fr', 'es', 'it'] ORDER BY ??? LIMIT 1I want to get the row where language=en, if it exists…if not, then the row where language=de…and so on. Think of it as a label prioritized by a list of languages, as provided by the caller (i.e. not by some ordering present in the database).I can think of ways to do this with a CTE or temporary table that stores a language-to-priority mapping that I can join against and then ORDER BY. But I'm wondering if there's a clever SQL-ism I'm unaware of that can help to avoid needing that.

pvergain (framapiaf)- <a href="https://forum.grist.libre.sh/t/la-lettre-de-grist-gouv-juillet-2025/1582" rel="nofollow noopener" translate="no" target="_blank">https://forum.grist.libre.sh/t/la-lettre-de-grist-gouv-juillet-2025/1582</a> (La lettre de Grist.Gouv - Juillet 2025) par Aude--<-- L’équipe a concocté une nouvelle page d’accueil : <a href="https://lasuite.numerique.gouv.fr/produits/grist" rel="nofollow noopener" translate="no" target="_blank">https://lasuite.numerique.gouv.fr/produits/grist</a> qui est affichée aux utilisateur·ice·s non connecté·e·s. Effet waouh garanti 🤩 ...# grist, ical, n8n guillaume a réussi à générer des flux iCal en utilisant Grist et n8n, si vous souhaitez qu’il le documente, vous pouvez aller voir son post ici: <a href="https://forum.grist.libre.sh/t/flux-ical-avec-grist-n8n/1557" rel="nofollow noopener" translate="no" target="_blank">https://forum.grist.libre.sh/t/flux-ical-avec-grist-n8n/1557</a>....-->--<a href="https://framapiaf.org/tags/grist" class="mention hashtag" rel="nofollow noopener" target="_blank">#grist</a> <a href="https://framapiaf.org/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQL</a> <a href="https://framapiaf.org/tags/GUI" class="mention hashtag" rel="nofollow noopener" target="_blank">#GUI</a> <a href="https://framapiaf.org/tags/NoCode" class="mention hashtag" rel="nofollow noopener" target="_blank">#NoCode</a> <a href="https://framapiaf.org/tags/n8n" class="mention hashtag" rel="nofollow noopener" target="_blank">#n8n</a> <a href="https://framapiaf.org/tags/ical" class="mention hashtag" rel="nofollow noopener" target="_blank">#ical</a>

Hacker News 50SQL Injection as a FeatureLink: <a href="https://idiallo.com/blog/sql-injection-as-a-feature" rel="nofollow noopener" translate="no" target="_blank">https://idiallo.com/blog/sql-injection-as-a-feature</a> Discussion: <a href="https://news.ycombinator.com/item?id=44638304" rel="nofollow noopener" translate="no" target="_blank">https://news.ycombinator.com/item?id=44638304</a><a href="https://social.lansky.name/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#sql</a>

Jerry OrrAn entertaining story about how a simple report page was gradually "enhanced" over time into an open textbox for users to enter their own SQL: <a href="https://idiallo.com/blog/sql-injection-as-a-feature" rel="nofollow noopener" translate="no" target="_blank">https://idiallo.com/blog/sql-injection-as-a-feature</a><a href="https://fosstodon.org/tags/programming" class="mention hashtag" rel="nofollow noopener" target="_blank">#programming</a> <a href="https://fosstodon.org/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#sql</a>

Thewatch<a href="https://mastodon.social/tags/data" class="mention hashtag" rel="nofollow noopener" target="_blank">#data</a> <a href="https://mastodon.social/tags/dataengineering" class="mention hashtag" rel="nofollow noopener" target="_blank">#dataengineering</a> <a href="https://mastodon.social/tags/datascience" class="mention hashtag" rel="nofollow noopener" target="_blank">#datascience</a> <a href="https://mastodon.social/tags/etl" class="mention hashtag" rel="nofollow noopener" target="_blank">#etl</a> <a href="https://mastodon.social/tags/DataPipe" class="mention hashtag" rel="nofollow noopener" target="_blank">#DataPipe</a> <a href="https://mastodon.social/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#sql</a> <a href="https://mastodon.social/tags/sqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#sqlserver</a> <a href="https://mastodon.social/tags/meme" class="mention hashtag" rel="nofollow noopener" target="_blank">#meme</a> <a href="https://mastodon.social/tags/memes" class="mention hashtag" rel="nofollow noopener" target="_blank">#memes</a>

PositAnnouncing streamlined MLOps with Orbital on Databricks 🛰️🧱Orbital translates <a href="https://fosstodon.org/tags/ScikitLearn" class="mention hashtag" rel="nofollow noopener" target="_blank">#ScikitLearn</a> <a href="https://fosstodon.org/tags/Python" class="mention hashtag" rel="nofollow noopener" target="_blank">#Python</a> or <a href="https://fosstodon.org/tags/tidymodels" class="mention hashtag" rel="nofollow noopener" target="_blank">#tidymodels</a> <a href="https://fosstodon.org/tags/RStats" class="mention hashtag" rel="nofollow noopener" target="_blank">#RStats</a> to native <a href="https://fosstodon.org/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQL</a> for direct database model execution.Edgar Ruiz's post uses <a href="https://fosstodon.org/tags/Databricks" class="mention hashtag" rel="nofollow noopener" target="_blank">#Databricks</a> as an integrated environment.Learn more: <a href="https://posit.co/blog/databricks-orbital-r-python-model-deployment/" rel="nofollow noopener" translate="no" target="_blank">https://posit.co/blog/databricks-orbital-r-python-model-deployment/</a>

Senna 🌷This is a neat little site to practice SQL queries on. Works better on desktop than mobile. I wish there was a mobile-friendly version of this concept that maybe just had a list of buttons that you could click to build the query. I guess I could make it but it seems like it would be a lot of work. Maybe sometime down the road.<a href="https://www.sql-practice.com/" rel="nofollow noopener" translate="no" target="_blank">https://www.sql-practice.com/</a><a href="https://mindly.social/tags/webDev" class="mention hashtag" rel="nofollow noopener" target="_blank">#webDev</a> <a href="https://mindly.social/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQL</a>

Dave MasonFun fact: <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQL</a> is over 50 years old now.Do any of the litany of frameworks stay relevant for 50 weeks?

Dave MasonWhen I was on the bird site, I followed the <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQL</a> hash tag to learn about Structured Query Language, databases, and the like.I follow <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQL</a> in the Fediverse too. But here, the vast majority of posts are about frameworks, ORM's, and other tools folks can use so they don't have to learn (or understand) a 4G language that's likely a lot simpler than the other tech complexities they've mastered.I don't know how we got here.

Mark T. TomczakGeneral 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<pre><code>select whatever from foo LEFT JOIN bar AS bar1 on bar1.id = foo.x LEF JOIN bar as bar2 on bar2.id = foo.y </code></pre>And like... now that I know the <code>as</code> 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?"<a href="https://mastodon.fixermark.com/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#sql</a>

Jonathan PeacherVibed a nice little <a href="https://fosstodon.org/tags/Django" class="mention hashtag" rel="nofollow noopener" target="_blank">#Django</a> Admin <a href="https://fosstodon.org/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQL</a> runner to debug queries ✨

Rafael PerezSoftware developer Heval Hazal Kurt discusses the pros and cons of relational databases, in comparison with their document-based counterparts, in this July 2025 article. Polyglot systems combining both paradigms are discussed as an ideal solution to differing data access needs within a same project. "When to Choose NoSQL Over SQL" <a href="https://hevalhazalkurt.com/blog/when-to-choose-nosql-over-sql/" rel="nofollow noopener" translate="no" target="_blank">https://hevalhazalkurt.com/blog/when-to-choose-nosql-over-sql/</a><a href="https://mastodon.social/tags/programming" class="mention hashtag" rel="nofollow noopener" target="_blank">#programming</a> <a href="https://mastodon.social/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#sql</a> <a href="https://mastodon.social/tags/nosql" class="mention hashtag" rel="nofollow noopener" target="_blank">#nosql</a> <a href="https://mastodon.social/tags/databases" class="mention hashtag" rel="nofollow noopener" target="_blank">#databases</a>

Djoerd Hiemstra 🍉Seems interesting: Enhanced <a href="https://idf.social/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQL</a> error messages facilitate faster error fixing<a href="https://doi.org/10.1007/s10664-025-10695-1" rel="nofollow noopener" translate="no" target="_blank">https://doi.org/10.1007/s10664-025-10695-1</a>

Axel ⌨🐧🐪🚴😷 | R.I.P NatenomPSA for <a href="https://chaos.social/tags/mechanicalkeyboard" class="mention hashtag" rel="nofollow noopener" target="_blank">#mechanicalkeyboard</a> enthusiasts who are also using <a href="https://chaos.social/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQL</a>:group buy ≠ groupby(SCNR)

Deus Ex MacGuffin :damnified:Goblin mode:When signing up for an account at a new website, set your initial password to “; DROP TABLE CUSTOMERS; COMMIT; —“<a href="https://metalhead.club/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#sql</a> <a href="https://metalhead.club/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#database</a> <a href="https://metalhead.club/tags/sqlinjection" class="mention hashtag" rel="nofollow noopener" target="_blank">#sqlinjection</a>

Alvin Ashcraft 🐿️Using Regular Expressions (Regex) in SQL Server 2025: A Complete Guide.<a href="https://www.red-gate.com/simple-talk/featured/using-regex-in-sql-server-2025-complete-guide/" rel="nofollow noopener" translate="no" target="_blank">https://www.red-gate.com/simple-talk/featured/using-regex-in-sql-server-2025-complete-guide/</a> <a href="https://hachyderm.io/tags/regex" class="mention hashtag" rel="nofollow noopener" target="_blank">#regex</a> <a href="https://hachyderm.io/tags/sqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#sqlserver</a> <a href="https://hachyderm.io/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#database</a> <a href="https://hachyderm.io/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#sql</a> <a href="https://hachyderm.io/tags/regularexpressions" class="mention hashtag" rel="nofollow noopener" target="_blank">#regularexpressions</a>

jbz💧 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 ｣<a href="https://simonwillison.net/2025/Jul/6/supabase-mcp-lethal-trifecta/" rel="nofollow noopener" translate="no" target="_blank">https://simonwillison.net/2025/Jul/6/supabase-mcp-lethal-trifecta/</a><a href="https://indieweb.social/tags/supabase" class="mention hashtag" rel="nofollow noopener" target="_blank">#supabase</a> <a href="https://indieweb.social/tags/databreach" class="mention hashtag" rel="nofollow noopener" target="_blank">#databreach</a> <a href="https://indieweb.social/tags/mcp" class="mention hashtag" rel="nofollow noopener" target="_blank">#mcp</a> <a href="https://indieweb.social/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#sql</a>

Towards Data Science⭐ New Author Alert! ⭐ Data model changes causing headaches?? Meet Dave Flynn, one of our newest authors at Towards Data Science. His first article dives into change-aware data validation with column-level lineage, a game-changer for debugging complex <a href="https://hachyderm.io/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQL</a> data pipelines. <a href="https://towardsdatascience.com/change-aware-data-validation-with-column-level-lineage/" rel="nofollow noopener" translate="no" target="_blank">https://towardsdatascience.com/change-aware-data-validation-with-column-level-lineage/</a>

Calishat<a href="https://researchbuzz.masto.host/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQL</a> <a href="https://researchbuzz.masto.host/tags/databases" class="mention hashtag" rel="nofollow noopener" target="_blank">#databases</a> <a href="https://researchbuzz.masto.host/tags/LEGO" class="mention hashtag" rel="nofollow noopener" target="_blank">#LEGO</a> 'This paper introduces the LEGO® Database, a large natural dataset that can be used to teach Structured Query Language (SQL) and relational database concepts.'<a href="https://eric.ed.gov/?id=EJ1468081" rel="nofollow noopener" translate="no" target="_blank">https://eric.ed.gov/?id=EJ1468081</a>

Recent searches

Search options

Administered by:

Server stats:

#SQL