Med-Mastodon

Adam🚨 BOOK BUNDLE DEALLevel up your SQL and database skills in this book bundle deal from O'Reilly by supporting Code for America via Humble Bundle.➡️ <a href="https://www.humblebundle.com/books/sql-and-databases-oreilly-books" rel="nofollow noopener" translate="no" target="_blank">https://www.humblebundle.com/books/sql-and-databases-oreilly-books</a><a href="https://fosstodon.org/tags/books" class="mention hashtag" rel="nofollow noopener" target="_blank">#books</a> <a href="https://fosstodon.org/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#sql</a> <a href="https://fosstodon.org/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#database</a> <a href="https://fosstodon.org/tags/tech" class="mention hashtag" rel="nofollow noopener" target="_blank">#tech</a> <a href="https://fosstodon.org/tags/technology" class="mention hashtag" rel="nofollow noopener" target="_blank">#technology</a>

GBIF🐊 How do skills acquired through DataCamp translate to a better understanding of biodiversity data?For Ibrahim Abdel Basir Gomaa, who completed courses in <a href="https://biodiversity.social/tags/Pandas" class="mention hashtag" rel="nofollow noopener" target="_blank">#Pandas</a>, <a href="https://biodiversity.social/tags/Seaborn" class="mention hashtag" rel="nofollow noopener" target="_blank">#Seaborn</a>, machine learning, <a href="https://biodiversity.social/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQL</a> and statistics, these skills enabled him to confidently query large biodiversity datasets from sources like GBIF. 🔎“One of my proudest achievements was developing a predictive model to assess species distribution patterns based on environmental factors...."

Dave MasonHeadline: The most popular programming languages in 2025 (and what that even means) Quote: "In my previous article on this topic, there was a debate about whether HTML (the language of web pages) or SQL (a query language for databases) are actually languages."Me: Ummm...Have we all forgotten (or never known?) what the "L" in those acronyms stands for? 🤔 <a href="https://www.zdnet.com/article/the-most-popular-programming-languages-in-2024-and-what-that-even-means/" rel="nofollow noopener" translate="no" target="_blank">https://www.zdnet.com/article/the-most-popular-programming-languages-in-2024-and-what-that-even-means/</a><a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQL</a> <a href="https://mastodon.social/tags/HTML" class="mention hashtag" rel="nofollow noopener" target="_blank">#HTML</a> <a href="https://mastodon.social/tags/Programming" class="mention hashtag" rel="nofollow noopener" target="_blank">#Programming</a>

Dave MasonFree eBook: DuckDB in Action<a href="https://github.com/HanhMyNguyen/Data-book/blob/main/DuckDB_In_Action_Final_MotherDuck.pdf" rel="nofollow noopener" translate="no" target="_blank">https://github.com/HanhMyNguyen/Data-book/blob/main/DuckDB_In_Action_Final_MotherDuck.pdf</a><a href="https://mastodon.social/tags/Data" class="mention hashtag" rel="nofollow noopener" target="_blank">#Data</a> <a href="https://mastodon.social/tags/RStats" class="mention hashtag" rel="nofollow noopener" target="_blank">#RStats</a> <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQL</a> <a href="https://mastodon.social/tags/Analytics" class="mention hashtag" rel="nofollow noopener" target="_blank">#Analytics</a>

TuxAcademyToday's Poll.. 👇 Which SQL keyword is used to remove duplicate records? <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQL</a> <a href="https://mastodon.social/tags/DataScience" class="mention hashtag" rel="nofollow noopener" target="_blank">#DataScience</a> <a href="https://mastodon.social/tags/TechTrivia" class="mention hashtag" rel="nofollow noopener" target="_blank">#TechTrivia</a> <a href="https://mastodon.social/tags/LearnSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#LearnSQL</a> <a href="https://mastodon.social/tags/ProgrammingPoll" class="mention hashtag" rel="nofollow noopener" target="_blank">#ProgrammingPoll</a> <a href="https://mastodon.social/tags/TuxAcademy" class="mention hashtag" rel="nofollow noopener" target="_blank">#TuxAcademy</a> <a href="https://mastodon.social/tags/DatabaseTips" class="mention hashtag" rel="nofollow noopener" target="_blank">#DatabaseTips</a>

nixCraft 🐧The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, and SQLite <a href="https://github.com/launchbadge/sqlx" rel="nofollow noopener" translate="no" target="_blank">https://github.com/launchbadge/sqlx</a><a href="https://mastodon.social/tags/rustlang" class="mention hashtag" rel="nofollow noopener" target="_blank">#rustlang</a> <a href="https://mastodon.social/tags/opensource" class="mention hashtag" rel="nofollow noopener" target="_blank">#opensource</a> <a href="https://mastodon.social/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#sql</a>

SirWumpus 👾🍁Message in a bottle time again <a href="https://tilde.zone/tags/GetFediHired" class="mention hashtag" rel="nofollow noopener" target="_blank">#GetFediHired</a> (not a peep from anyone yet).Growing desperate in search for (remote) software developer work in the <a href="https://tilde.zone/tags/Ottawa" class="mention hashtag" rel="nofollow noopener" target="_blank">#Ottawa</a> <a href="https://tilde.zone/tags/Montreal" class="mention hashtag" rel="nofollow noopener" target="_blank">#Montreal</a> areas. <a href="https://tilde.zone/tags/C" class="mention hashtag" rel="nofollow noopener" target="_blank">#C</a> C# <a href="https://tilde.zone/tags/Erlang" class="mention hashtag" rel="nofollow noopener" target="_blank">#Erlang</a> <a href="https://tilde.zone/tags/Java" class="mention hashtag" rel="nofollow noopener" target="_blank">#Java</a> <a href="https://tilde.zone/tags/NodeJS" class="mention hashtag" rel="nofollow noopener" target="_blank">#NodeJS</a> <a href="https://tilde.zone/tags/Shell" class="mention hashtag" rel="nofollow noopener" target="_blank">#Shell</a> <a href="https://tilde.zone/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQL</a> <a href="https://tilde.zone/tags/BSD" class="mention hashtag" rel="nofollow noopener" target="_blank">#BSD</a> <a href="https://tilde.zone/tags/Linux" class="mention hashtag" rel="nofollow noopener" target="_blank">#Linux</a> <a href="https://tilde.zone/tags/English" class="mention hashtag" rel="nofollow noopener" target="_blank">#English</a> <a href="https://tilde.zone/tags/French" class="mention hashtag" rel="nofollow noopener" target="_blank">#French</a> and more. Very versatile, adaptable, experienced.<a href="http://www.snert.com/resume/" rel="nofollow noopener" translate="no" target="_blank">http://www.snert.com/resume/</a>Hey! If its remote, its possible to work world wide too!

Hacker News 50SQLx – Rust SQL ToolkitLink: <a href="https://github.com/launchbadge/sqlx" rel="nofollow noopener" translate="no" target="_blank">https://github.com/launchbadge/sqlx</a> Discussion: <a href="https://news.ycombinator.com/item?id=44690914" rel="nofollow noopener" translate="no" target="_blank">https://news.ycombinator.com/item?id=44690914</a><a href="https://social.lansky.name/tags/rust" class="mention hashtag" rel="nofollow noopener" target="_blank">#rust</a> <a href="https://social.lansky.name/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#sql</a>

wobweger :verified:attention eBook worms 📚 humble bundle offers SQL and Databases by O'Reilly<a href="https://www.humblebundle.com/books/sql-and-databases-oreilly-books?hmb_source=&hmb_medium=product_tile&hmb_campaign=mosaic_section_1_layout_index_1_layout_type_threes_tile_index_3_c_sqlanddatabasesoreilly_bookbundle" rel="nofollow noopener" translate="no" target="_blank">https://www.humblebundle.com/books/sql-and-databases-oreilly-books?hmb_source=&hmb_medium=product_tile&hmb_campaign=mosaic_section_1_layout_index_1_layout_type_threes_tile_index_3_c_sqlanddatabasesoreilly_bookbundle</a><a href="https://mstdn.social/tags/book" class="mention hashtag" rel="nofollow noopener" target="_blank">#book</a> <a href="https://mstdn.social/tags/books" class="mention hashtag" rel="nofollow noopener" target="_blank">#books</a> <a href="https://mstdn.social/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#sql</a> <a href="https://mstdn.social/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#database</a> <a href="https://mstdn.social/tags/OReillyMedia" class="mention hashtag" rel="nofollow noopener" target="_blank">#OReillyMedia</a>

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>

Recent searches

Search options

Administered by:

Server stats:

#SQL