Create accountLogin

Recent searches

No recent searches

Search options

Only available when logged in.
techhub.social is one of the many independent Mastodon servers you can use to participate in the fediverse.
A hub primarily for passionate technologists, but everyone is welcome

Administered by:

Server stats:

5.4K
active users

techhub.social: AboutStatusProfiles directoryPrivacy policy

Mastodon: AboutGet the appKeyboard shortcutsView source codev4.3.6

#sql

94 posts50 participants1 post today
QuanwenZhao<p>Nice ...<br />SQuizL 01-APR-25<br />1/6 guesses<br />118 seconds<br />🟩🟩🟩🟦🟩🟩🟩<br /><a href="https://bit.ly/SQuizL-game" target="_blank" rel="nofollow noopener noreferrer" translate="no"><span class="invisible">https://</span><span class="">bit.ly/SQuizL-game</span><span class="invisible"></span></a><br /><a href="https://techhub.social/tags/SQuizL" class="mention hashtag" rel="tag">#<span>SQuizL</span></a> <a href="https://techhub.social/tags/SQL" class="mention hashtag" rel="tag">#<span>SQL</span></a></p>
Umpire DB<p><a href="https://mstdn.plus/tags/PHP" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PHP</span></a> operations on <a href="https://mstdn.plus/tags/mysqli" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>mysqli</span></a> are a treat. They return either the expected object, or a true/false boolean. <br> <br>Connection fails? Boolean. Succeeds? Connection object. Preparing an <a href="https://mstdn.plus/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> statement fails? Boolean. Succeeds? Statement object. Binding parameters to prepared statement fails? Boolean. Succeeds? Boolean. Executing the statement fails? Boolean. Succeeds? Boolean as well, or an associative array, depending on intent. <br> <br>And thanks.</p>
Andrei Kaleshka<p>Efficient and productive <a href="https://ruby.social/tags/WebDev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>WebDev</span></a> without <a href="https://ruby.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a>? I don’t think so. I’m strong in <a href="https://ruby.social/tags/Ruby" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Ruby</span></a> — better than in <a href="https://ruby.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> — but with SQL, I’m 5x (or more) productive when tackling data-related issues. <a href="https://ruby.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> is as fundamental to web development as logic is to math. It’s the foundation. Period.</p>
weirdjokes<p><a href="https://mastodon.world/tags/Programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Programming</span></a> <a href="https://mastodon.world/tags/Coding" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Coding</span></a> <a href="https://mastodon.world/tags/IT" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>IT</span></a> <a href="https://mastodon.world/tags/Tech" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Tech</span></a> <a href="https://mastodon.world/tags/Software" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Software</span></a> <a href="https://mastodon.world/tags/Python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Python</span></a> <a href="https://mastodon.world/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> <a href="https://mastodon.world/tags/Computer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Computer</span></a> <a href="https://mastodon.world/tags/webdevelopment" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>webdevelopment</span></a> <a href="https://mastodon.world/tags/Statistics" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Statistics</span></a> <a href="https://mastodon.world/tags/DataAnalysis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DataAnalysis</span></a> <a href="https://mastodon.world/tags/MachineLearning" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MachineLearning</span></a> <a href="https://mastodon.world/tags/DataScience" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DataScience</span></a> <a href="https://mastodon.world/tags/Jokes" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Jokes</span></a> <a href="https://mastodon.world/tags/Memes" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Memes</span></a> <a href="https://mastodon.world/tags/Funny" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Funny</span></a> <a href="https://mastodon.world/tags/NeuralNetworks" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>NeuralNetworks</span></a> <a href="https://mastodon.world/tags/SEO" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SEO</span></a> <a href="https://mastodon.world/tags/AI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>AI</span></a> <a href="https://mastodon.world/tags/DevOps" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DevOps</span></a><br>💻<br>Python Knowledge Base<br><a href="https://python-code.pro/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">python-code.pro/</span><span class="invisible"></span></a></p>
Esparta :ruby:<p>How fast can an ActiveRecord SQL query run?, by Fritz Meissner<br><a href="https://thoughtbot.com/blog/how-fast-can-an-activerecord-sql-query-run" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">thoughtbot.com/blog/how-fast-c</span><span class="invisible">an-an-activerecord-sql-query-run</span></a></p><p>&gt; Your database monitoring (perhaps Amazon RDS performance insights, Skylight, or the <a href="https://ruby.social/tags/Postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Postgres</span></a> pg_stat_activity view) is telling you that one particular query in your Rails app is causing heavy load. Unfortunately, it already seems pretty fast. What are the odds that you can get it to run any faster?</p><p><a href="https://ruby.social/tags/ruby" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ruby</span></a> <a href="https://ruby.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> <a href="https://ruby.social/tags/ActiveRecord" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ActiveRecord</span></a></p>
weirdjokes<p><a href="https://mastodon.world/tags/Programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Programming</span></a> <a href="https://mastodon.world/tags/Coding" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Coding</span></a> <a href="https://mastodon.world/tags/IT" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>IT</span></a> <a href="https://mastodon.world/tags/Tech" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Tech</span></a> <a href="https://mastodon.world/tags/Software" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Software</span></a> <a href="https://mastodon.world/tags/Python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Python</span></a> <a href="https://mastodon.world/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> <a href="https://mastodon.world/tags/Computer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Computer</span></a> <a href="https://mastodon.world/tags/webdevelopment" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>webdevelopment</span></a> <a href="https://mastodon.world/tags/Statistics" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Statistics</span></a> <a href="https://mastodon.world/tags/DataAnalysis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DataAnalysis</span></a> <a href="https://mastodon.world/tags/MachineLearning" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MachineLearning</span></a> <a href="https://mastodon.world/tags/DataScience" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DataScience</span></a> <a href="https://mastodon.world/tags/Jokes" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Jokes</span></a> <a href="https://mastodon.world/tags/Memes" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Memes</span></a> <a href="https://mastodon.world/tags/Funny" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Funny</span></a> <a href="https://mastodon.world/tags/NeuralNetworks" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>NeuralNetworks</span></a> <a href="https://mastodon.world/tags/SEO" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SEO</span></a> <a href="https://mastodon.world/tags/AI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>AI</span></a> <a href="https://mastodon.world/tags/DevOps" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DevOps</span></a><br>💻<br>Python Knowledge Base<br><a href="https://python-code.pro/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">python-code.pro/</span><span class="invisible"></span></a></p>
Truls<p>I am a (relational) database guy and have been for decades. </p><p>When I read "feature drop" it sounds to me, as if something was removed, not added. </p><p><a href="https://mastodon.social/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sql</span></a> <a href="https://mastodon.social/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a> <a href="https://mastodon.social/tags/wording" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>wording</span></a> <a href="https://mastodon.social/tags/featureDrop" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>featureDrop</span></a></p>
:rss: DevelopersIO<p>JSONデータをRedshiftに取り込みたい<br><a href="https://dev.classmethod.jp/articles/json-redshift/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">dev.classmethod.jp/articles/js</span><span class="invisible">on-redshift/</span></a></p><p><a href="https://rss-mstdn.studiofreesia.com/tags/dev_classmethod" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>dev_classmethod</span></a> <a href="https://rss-mstdn.studiofreesia.com/tags/Amazon_Redshift" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Amazon_Redshift</span></a> <a href="https://rss-mstdn.studiofreesia.com/tags/JSON" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>JSON</span></a> <a href="https://rss-mstdn.studiofreesia.com/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a></p>
weirdjokes<p><a href="https://mastodon.world/tags/Programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Programming</span></a> <a href="https://mastodon.world/tags/Coding" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Coding</span></a> <a href="https://mastodon.world/tags/IT" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>IT</span></a> <a href="https://mastodon.world/tags/Tech" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Tech</span></a> <a href="https://mastodon.world/tags/Software" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Software</span></a> <a href="https://mastodon.world/tags/Python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Python</span></a> <a href="https://mastodon.world/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> <a href="https://mastodon.world/tags/Computer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Computer</span></a> <a href="https://mastodon.world/tags/webdevelopment" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>webdevelopment</span></a> <a href="https://mastodon.world/tags/Statistics" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Statistics</span></a> <a href="https://mastodon.world/tags/DataAnalysis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DataAnalysis</span></a> <a href="https://mastodon.world/tags/MachineLearning" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MachineLearning</span></a> <a href="https://mastodon.world/tags/DataScience" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DataScience</span></a> <a href="https://mastodon.world/tags/Jokes" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Jokes</span></a> <a href="https://mastodon.world/tags/Memes" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Memes</span></a> <a href="https://mastodon.world/tags/Funny" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Funny</span></a> <a href="https://mastodon.world/tags/NeuralNetworks" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>NeuralNetworks</span></a> <a href="https://mastodon.world/tags/SEO" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SEO</span></a> <a href="https://mastodon.world/tags/AI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>AI</span></a> <a href="https://mastodon.world/tags/DevOps" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DevOps</span></a><br>💻<br>Python Knowledge Base<br><a href="https://python-code.pro/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">python-code.pro/</span><span class="invisible"></span></a></p>
David Wilson<p>🔴 On today's Crafter Hours stream, I'll show some progress I made on hosting both the emacspackages site and the new Guile-backed System Crafters site on the same Guix server.</p><p>I kinda made a mess with it though, so we'll have to find our way out of that, too :)</p><p>Join us here:</p><p>- <a href="https://youtube.com/live/OITQtQnz9X8" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">youtube.com/live/OITQtQnz9X8</span><span class="invisible"></span></a><br>- <a href="https://twitch.tv/SystemCrafters" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">twitch.tv/SystemCrafters</span><span class="invisible"></span></a></p><p><a href="https://fosstodon.org/tags/guile" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>guile</span></a> <a href="https://fosstodon.org/tags/scheme" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>scheme</span></a> <a href="https://fosstodon.org/tags/guix" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>guix</span></a> <a href="https://fosstodon.org/tags/programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>programming</span></a> <a href="https://fosstodon.org/tags/webdev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>webdev</span></a> <a href="https://fosstodon.org/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sql</span></a></p>
QuanwenZhao<p>Amazing.<br />SQuizL 31-MAR-25<br />1/6 guesses<br />129 seconds<br />🟩🟩🟩🟩🟩🟩🟩<br /><a href="https://bit.ly/SQuizL-game" target="_blank" rel="nofollow noopener noreferrer" translate="no"><span class="invisible">https://</span><span class="">bit.ly/SQuizL-game</span><span class="invisible"></span></a><br /><a href="https://techhub.social/tags/SQuizL" class="mention hashtag" rel="tag">#<span>SQuizL</span></a> <a href="https://techhub.social/tags/SQL" class="mention hashtag" rel="tag">#<span>SQL</span></a></p>
Public
Edward :mastocol:

Llevo unos meses usando #Zed, y este editor de código desarrollado en #rustlang me ha encantado. Quiero contarles un poco más sobre el #ide, algunas características y extensiones (#python #markdown #sql #ortografía #just entre otros) que me han sido útiles en esta entrada de mi blog cosmoscalibur.com/es/blog/2025

zed es un editor de código y texto de código abierto, diseñado para ser rápido y fácil de usar. Está construido en Rust y utiliza una interfaz de usuario mod...
CosmoscaliburZed: un editor rápido y moderno de código abierto
More from Edward :mastocol:
Public
joocer

📦 CTEs are back, baby!

We’ve reintroduced Common Table Expressions (CTEs) to Opteryx—bringing back clarity, structure, and that sweet, sweet query composability.

Write cleaner SQL, break down complex logic, and nest away to your heart’s content.

Check it out and drop us a ⭐!
🔗 github.com/mabel-dev/opteryx

🦖 A SQL-on-everything Query Engine you can execute over multiple databases and file formats. Query your data, where it lives. - mabel-dev/opteryx
GitHubGitHub - mabel-dev/opteryx: 🦖 A SQL-on-everything Query Engine you can execute over multiple databases and file formats. Query your data, where it lives.🦖 A SQL-on-everything Query Engine you can execute over multiple databases and file formats. Query your data, where it lives. - mabel-dev/opteryx
#OpenSource#SQL#Databases
ExploreLive feeds
About