toad.social is one of the many independent Mastodon servers you can use to participate in the fediverse.
Mastodon server operated by David Troy, a tech pioneer and investigative journalist addressing threats to democracy. Thoughtful participation and discussion welcome.

Administered by:

Server stats:

230
active users

#sql

4 posts4 participants0 posts today
wobweger :verified:<p>attention eBook worms 📚 <br>humble bundle offers SQL and Databases by O'Reilly</p><p><a href="https://www.humblebundle.com/books/sql-and-databases-oreilly-books?hmb_source=&amp;hmb_medium=product_tile&amp;hmb_campaign=mosaic_section_1_layout_index_1_layout_type_threes_tile_index_3_c_sqlanddatabasesoreilly_bookbundle" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">humblebundle.com/books/sql-and</span><span class="invisible">-databases-oreilly-books?hmb_source=&amp;hmb_medium=product_tile&amp;hmb_campaign=mosaic_section_1_layout_index_1_layout_type_threes_tile_index_3_c_sqlanddatabasesoreilly_bookbundle</span></a></p><p><a href="https://mstdn.social/tags/book" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>book</span></a> <a href="https://mstdn.social/tags/books" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>books</span></a> <a href="https://mstdn.social/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sql</span></a> <a href="https://mstdn.social/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>database</span></a> <a href="https://mstdn.social/tags/OReillyMedia" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>OReillyMedia</span></a></p>
pvergain (framapiaf)<p>- <a href="https://forum.grist.libre.sh/t/la-lettre-de-grist-gouv-juillet-2025/1582" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">forum.grist.libre.sh/t/la-lett</span><span class="invisible">re-de-grist-gouv-juillet-2025/1582</span></a> (La lettre de Grist.Gouv - Juillet 2025) par Aude</p><p>--&lt;--<br>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"><span class="invisible">https://</span><span class="ellipsis">lasuite.numerique.gouv.fr/prod</span><span class="invisible">uits/grist</span></a> qui est affichée aux utilisateur·ice·s non connecté·e·s. </p><p>Effet waouh garanti 🤩 </p><p>...</p><p># grist, ical, n8n </p><p>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"><span class="invisible">https://</span><span class="ellipsis">forum.grist.libre.sh/t/flux-ic</span><span class="invisible">al-avec-grist-n8n/1557</span></a>.</p><p>...</p><p>--&gt;--</p><p><a href="https://framapiaf.org/tags/grist" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>grist</span></a> <a href="https://framapiaf.org/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQL</span></a> <a href="https://framapiaf.org/tags/GUI" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>GUI</span></a> <a href="https://framapiaf.org/tags/NoCode" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>NoCode</span></a> <a href="https://framapiaf.org/tags/n8n" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>n8n</span></a> <a href="https://framapiaf.org/tags/ical" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>ical</span></a></p>
Hacker News 50<p>SQL Injection as a Feature</p><p>Link: <a href="https://idiallo.com/blog/sql-injection-as-a-feature" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">idiallo.com/blog/sql-injection</span><span class="invisible">-as-a-feature</span></a><br>Discussion: <a href="https://news.ycombinator.com/item?id=44638304" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">news.ycombinator.com/item?id=4</span><span class="invisible">4638304</span></a></p><p><a href="https://social.lansky.name/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sql</span></a></p>
Posit<p>Announcing streamlined MLOps with Orbital on Databricks 🛰️🧱</p><p>Orbital translates <a href="https://fosstodon.org/tags/ScikitLearn" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>ScikitLearn</span></a> <a href="https://fosstodon.org/tags/Python" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Python</span></a> or <a href="https://fosstodon.org/tags/tidymodels" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>tidymodels</span></a> <a href="https://fosstodon.org/tags/RStats" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>RStats</span></a> to native <a href="https://fosstodon.org/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQL</span></a> for direct database model execution.</p><p>Edgar Ruiz's post uses <a href="https://fosstodon.org/tags/Databricks" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Databricks</span></a> as an integrated environment.</p><p>Learn more: <a href="https://posit.co/blog/databricks-orbital-r-python-model-deployment/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">posit.co/blog/databricks-orbit</span><span class="invisible">al-r-python-model-deployment/</span></a></p>
TechKeysX<p>Apply migration without data loss with Entity Framework in C# Tip #110 <a href="https://mastodon.social/tags/visualstudiocode" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>visualstudiocode</span></a> <a href="https://mastodon.social/tags/databases" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>databases</span></a> <a href="https://mastodon.social/tags/softwaredeveloper" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>softwaredeveloper</span></a> <a href="https://mastodon.social/tags/codingbasics" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>codingbasics</span></a> <a href="https://mastodon.social/tags/codinglife" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>codinglife</span></a> <a href="https://mastodon.social/tags/learncoding" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>learncoding</span></a> <a href="https://mastodon.social/tags/codingforbeginners" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>codingforbeginners</span></a> <a href="https://mastodon.social/tags/dotnet" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>dotnet</span></a> <a href="https://mastodon.social/tags/coding" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>coding</span></a> <a href="https://mastodon.social/tags/linq" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>linq</span></a> <a href="https://mastodon.social/tags/datascience" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>datascience</span></a> <a href="https://mastodon.social/tags/learntocode" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>learntocode</span></a> <a href="https://mastodon.social/tags/visualstudio" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>visualstudio</span></a> <a href="https://mastodon.social/tags/softwareengineer" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>softwareengineer</span></a> <a href="https://mastodon.social/tags/webdevelopment" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>webdevelopment</span></a> <a href="https://mastodon.social/tags/computerscience" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>computerscience</span></a> <a href="https://mastodon.social/tags/sqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlserver</span></a> <a href="https://mastodon.social/tags/csharp" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>csharp</span></a> <a href="https://mastodon.social/tags/vscode" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>vscode</span></a> <a href="https://mastodon.social/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sql</span></a></p>
Senna 🌷<p>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.</p><p><a href="https://www.sql-practice.com/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="">sql-practice.com/</span><span class="invisible"></span></a></p><p><a href="https://mindly.social/tags/webDev" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>webDev</span></a> <a href="https://mindly.social/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQL</span></a></p>
TechKeysX<p>EnsureDeleted in Entity Framework in C# Tip #108 <a href="https://mastodon.social/tags/linq" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>linq</span></a> <a href="https://mastodon.social/tags/codingforbeginners" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>codingforbeginners</span></a> <a href="https://mastodon.social/tags/codingbasics" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>codingbasics</span></a> <a href="https://mastodon.social/tags/sqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlserver</span></a> <a href="https://mastodon.social/tags/webdevelopment" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>webdevelopment</span></a> <a href="https://mastodon.social/tags/softwareengineer" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>softwareengineer</span></a> <a href="https://mastodon.social/tags/visualstudiocode" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>visualstudiocode</span></a> <a href="https://mastodon.social/tags/databases" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>databases</span></a> <a href="https://mastodon.social/tags/softwaredeveloper" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>softwaredeveloper</span></a> <a href="https://mastodon.social/tags/computerscience" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>computerscience</span></a> <a href="https://mastodon.social/tags/codinglife" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>codinglife</span></a> <a href="https://mastodon.social/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sql</span></a> <a href="https://mastodon.social/tags/learncoding" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>learncoding</span></a> <a href="https://mastodon.social/tags/csharp" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>csharp</span></a> <a href="https://mastodon.social/tags/dotnet" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>dotnet</span></a> <a href="https://mastodon.social/tags/coding" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>coding</span></a> <a href="https://mastodon.social/tags/datascience" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>datascience</span></a> <a href="https://mastodon.social/tags/learntocode" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>learntocode</span></a> <a href="https://mastodon.social/tags/vscode" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>vscode</span></a> <a href="https://mastodon.social/tags/visualstudio" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>visualstudio</span></a></p>
Dave Mason<p>Fun fact: <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQL</span></a> is over 50 years old now.</p><p>Do any of the litany of frameworks stay relevant for 50 weeks?</p>
Dave Mason<p>When I was on the bird site, I followed the <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQL</span></a> hash tag to learn about Structured Query Language, databases, and the like.</p><p>I follow <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQL</span></a> in the Fediverse too. </p><p>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.</p><p>I don't know how we got here.</p>
Mark T. Tomczak<p>General SQL "zen" question.</p><p>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.</p><p>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</p><pre><code>select whatever from foo<br>LEFT JOIN bar AS bar1 on bar1.id = foo.x<br>LEF JOIN bar as bar2 on bar2.id = foo.y<br></code></pre><p>And like... now that I know the <code>as</code> keyword applies here, that makes perfect sense, but how would I <em>get</em> there? Is there a list somewhere of "This is a keyword in SQL and here's all the contexts it could be applied?"</p><p><a href="https://mastodon.fixermark.com/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sql</span></a></p>
TechKeysX<p>Why Migrations are needed in Entity Framework in C# Tip #107 <a href="https://mastodon.social/tags/coding" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>coding</span></a> <a href="https://mastodon.social/tags/dotnet" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>dotnet</span></a> <a href="https://mastodon.social/tags/csharp" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>csharp</span></a> <a href="https://mastodon.social/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sql</span></a> <a href="https://mastodon.social/tags/linq" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>linq</span></a> <a href="https://mastodon.social/tags/codingforbeginners" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>codingforbeginners</span></a> <a href="https://mastodon.social/tags/codingbasics" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>codingbasics</span></a> <a href="https://mastodon.social/tags/sqlserver" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sqlserver</span></a> <a href="https://mastodon.social/tags/webdevelopment" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>webdevelopment</span></a> <a href="https://mastodon.social/tags/softwareengineer" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>softwareengineer</span></a> <a href="https://mastodon.social/tags/visualstudiocode" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>visualstudiocode</span></a> <a href="https://mastodon.social/tags/databases" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>databases</span></a> <a href="https://mastodon.social/tags/softwaredeveloper" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>softwaredeveloper</span></a> <a href="https://mastodon.social/tags/computerscience" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>computerscience</span></a> <a href="https://mastodon.social/tags/codinglife" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>codinglife</span></a> <a href="https://mastodon.social/tags/learncoding" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>learncoding</span></a> <a href="https://mastodon.social/tags/datascience" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>datascience</span></a> <a href="https://mastodon.social/tags/learntocode" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>learntocode</span></a> <a href="https://mastodon.social/tags/vscode" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>vscode</span></a> <a href="https://mastodon.social/tags/visualstudio" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>visualstudio</span></a></p>