Create accountLogin

Recent searches

No recent searches

Search options

Not available on dice.camp.
dice.camp is one of the many independent Mastodon servers you can use to participate in the fediverse.
A Mastodon server for RPG folks to hang out and talk. Not owned by a billionaire.

Administered by:

Server stats:

1.7K
active users

dice.camp: AboutProfiles directoryPrivacy policy

Mastodon: AboutGet the appKeyboard shortcutsView source codev4.3.7

#sql

25 posts24 participants2 posts today
Jobs for Developers<p>Brex is hiring Senior Data Scientist, Finance</p><p>🔧 <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/seniorengineer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>seniorengineer</span></a><br>🌎 New York City, New York<br>⏰ Full-time<br>🏢 Brex</p><p>Job details <a href="https://jobsfordevelopers.com/jobs/senior-data-scientist-finance-at-brex-com-mar-4-2025-55acd3?utm_source=mastodon.world&amp;utm_medium=social&amp;utm_campaign=posting" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">jobsfordevelopers.com/jobs/sen</span><span class="invisible">ior-data-scientist-finance-at-brex-com-mar-4-2025-55acd3?utm_source=mastodon.world&amp;utm_medium=social&amp;utm_campaign=posting</span></a><br><a href="https://mastodon.world/tags/jobalert" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>jobalert</span></a> <a href="https://mastodon.world/tags/jobsearch" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>jobsearch</span></a> <a href="https://mastodon.world/tags/hiring" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>hiring</span></a></p>
Olivier Leroy<p>Folks who prefer GROUP BY 1 instead of ORDER BY my_first_col why? </p><p>Ordering should be done last and you make me read one more abstraction (oh wait what is the first column).</p><p><a href="https://fosstodon.org/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a></p>
codeDude :archlinux: :neovim:<p>For sure this is interesting. <a href="https://vanna.ai/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">vanna.ai/</span><span class="invisible"></span></a> <a href="https://fosstodon.org/tags/VannaAI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>VannaAI</span></a> help you to <a href="https://fosstodon.org/tags/wirte" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>wirte</span></a> <a href="https://fosstodon.org/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sql</span></a> queries. it's is <a href="https://fosstodon.org/tags/openSource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>openSource</span></a> <a href="https://github.com/vanna-ai/vanna" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">github.com/vanna-ai/vanna</span><span class="invisible"></span></a> sounds other <a href="https://fosstodon.org/tags/ai" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ai</span></a> interesting thing to test</p>
Prairie Postgres<p>It's official - we are now a community-recognized NPO by the PostgreSQL Global Development Group! </p><p>What does this mean? 🐘 </p><p>We support the open source <a href="https://cityofchicago.live/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostgreSQL</span></a> RDBMS as our primary mission, and manage our organization in accordance with the official PGDG Nonprofit Organizations policy. Learn more here: </p><p><a href="https://www.postgresql.org/community/recognised-npos/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">postgresql.org/community/recog</span><span class="invisible">nised-npos/</span></a></p><p><a href="https://cityofchicago.live/tags/tech" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>tech</span></a> <a href="https://cityofchicago.live/tags/technonprofit" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>technonprofit</span></a> <a href="https://cityofchicago.live/tags/nonprofit" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>nonprofit</span></a> <a href="https://cityofchicago.live/tags/technology" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>technology</span></a> <a href="https://cityofchicago.live/tags/data" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>data</span></a> <a href="https://cityofchicago.live/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a> <a href="https://cityofchicago.live/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sql</span></a> <a href="https://cityofchicago.live/tags/foss" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>foss</span></a> <a href="https://cityofchicago.live/tags/oss" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>oss</span></a> <a href="https://cityofchicago.live/tags/opensource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>opensource</span></a> <a href="https://cityofchicago.live/tags/freesoftware" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>freesoftware</span></a></p>
Data Bene<p>On June 12, join our CEO <span class="h-card" translate="no"><a href="https://mastodon.tetaneutral.net/@c2main" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>c2main</span></a></span> at 11:30 AM CEST for a FREE livestream @ <span class="h-card" translate="no"><a href="https://mastodon.social/@posetteconf" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>posetteconf</span></a></span> regarding Pressure Stall Information within the world of <a href="https://fosstodon.org/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PostgreSQL</span></a>. </p><p>Use this link to add the livestream to your calendar &amp; optionally register, or follow us to get the recording after the conference when it becomes available! </p><p>posetteconf.com/2025/talks/resource-control-admission-i-have-a-date-with-my-psi/</p><p><a href="https://fosstodon.org/tags/POSETTEConf" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>POSETTEConf</span></a> <a href="https://fosstodon.org/tags/Postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Postgres</span></a> <a href="https://fosstodon.org/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> <a href="https://fosstodon.org/tags/Linux" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Linux</span></a> <a href="https://fosstodon.org/tags/opensource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>opensource</span></a> <a href="https://fosstodon.org/tags/FOSS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>FOSS</span></a> <a href="https://fosstodon.org/tags/OSS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>OSS</span></a> <a href="https://fosstodon.org/tags/developer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>developer</span></a> <a href="https://fosstodon.org/tags/tech" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>tech</span></a> <a href="https://fosstodon.org/tags/techevent" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>techevent</span></a> <a href="https://fosstodon.org/tags/DevOps" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DevOps</span></a></p>
Christos Argyropoulos MD, PhD<p>It is all <a href="https://mstdn.science/tags/rstats" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>rstats</span></a> fun and giggles until the dataset is too big to fit in memory. Then, it is time for the database servers and <a href="https://mstdn.science/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> to save the day.</p>
Christos Argyropoulos<p>It is all <a href="https://mast.hpc.social/tags/rstats" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>rstats</span></a> fun and giggles until the dataset is too big to fit in memory. Then, it is time for the database servers and <a href="https://mast.hpc.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> to save the day.</p>
Christos Argyropoulos MD, PhD, FASN 🇺🇸<p>It is all <a class="hashtag" href="https://bsky.app/search?q=%23rstats" rel="nofollow noopener noreferrer" target="_blank">#rstats</a> fun and giggles until the dataset is too big to fit in memory. Then, it is time for the database servers and <a class="hashtag" href="https://bsky.app/search?q=%23SQL" rel="nofollow noopener noreferrer" target="_blank">#SQL</a> to save the day.</p>
Le Journal du hacker<p>retour sur SQL noir <a href="https://www.journalduhacker.net/s/jjidcp/retour_sur_sql_noir" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">journalduhacker.net/s/jjidcp/r</span><span class="invisible">etour_sur_sql_noir</span></a> <a href="https://linuxfr.org/users/gilcot/journaux/retour-sur-sql-noir" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">linuxfr.org/users/gilcot/journ</span><span class="invisible">aux/retour-sur-sql-noir</span></a> <a href="https://framapiaf.org/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sql</span></a></p>
Lutin Discret<p>Why would someone use the `COALESCE` function passing a single argument (it's allowed according to the docs)? 🤔</p><p><a href="https://www.postgresql.org/docs/current/functions-conditional.html#FUNCTIONS-COALESCE-NVL-IFNULL" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">postgresql.org/docs/current/fu</span><span class="invisible">nctions-conditional.html#FUNCTIONS-COALESCE-NVL-IFNULL</span></a></p><p><a href="https://mastodon.libre-entreprise.com/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sql</span></a> <a href="https://mastodon.libre-entreprise.com/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgresql</span></a></p>
QuanwenZhao<p>Impressive.<br>SQuizL 13-APR-25<br>2/6 guesses<br>330 seconds<br>⬜⬜🟦🟩🟩🟩🟩<br>🟩🟩🟦🟩🟩🟩🟩<br><a href="https://bit.ly/SQuizL-game" rel="nofollow noopener noreferrer" translate="no" target="_blank"><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="nofollow noopener noreferrer" target="_blank">#<span>SQuizL</span></a> <a href="https://techhub.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a></p>
Marcos Dione<p>Not sure if I asked this before: Does anyone use anything in particular to inject <a href="https://en.osm.town/tags/apache" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>apache</span></a> logs into <a href="https://en.osm.town/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> databases? I have been looking around and asking around and the only solid I got was "do not expect an apache module for that; it would introduce too much latency to each request" in <a href="https://en.osm.town/tags/httpd" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>httpd</span></a>@libera.chat.</p><p><a href="https://en.osm.town/tags/SysAdmin" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SysAdmin</span></a> <a href="https://en.osm.town/tags/SRE" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SRE</span></a></p>
QuanwenZhao<p>Happy Saturday!<br>SQuizL 12-APR-25<br>1/6 guesses<br>87 seconds<br>🟩🟩🟦🟩🟩🟩🟩<br><a href="https://bit.ly/SQuizL-game" rel="nofollow noopener noreferrer" translate="no" target="_blank"><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="nofollow noopener noreferrer" target="_blank">#<span>SQuizL</span></a> <a href="https://techhub.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a></p>
A.J. Armstrong<p>Report on Dell Warranty Statuses for all machines using SCCM &amp; Dell Client Integration Pack&nbsp;|&nbsp;<a href="https://techygeekshome.info/report-on-dell-warranty-statuses/?fsp_sid=17844&nbsp;|&nbsp;#Guide" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">techygeekshome.info/report-on-</span><span class="invisible">dell-warranty-statuses/?fsp_sid=17844&nbsp;|&nbsp;#Guide</span></a> <a href="https://techhub.social/tags/Query" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Query</span></a> <a href="https://techhub.social/tags/SCCM" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SCCM</span></a> <a href="https://techhub.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> <a href="https://techhub.social/tags/WSUS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>WSUS</span></a>&nbsp;<br><a href="https://techygeekshome.info/report-on-dell-warranty-statuses/?fsp_sid=17844" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">techygeekshome.info/report-on-</span><span class="invisible">dell-warranty-statuses/?fsp_sid=17844</span></a></p>
Philippe Massicotte<p>Just released duckfetch v0.4.0 which allows you to manage DuckDB installation on Linux/Windows and macOS</p><p><a href="https://github.com/PMassicotte/duckfetch/releases/tag/v0.4.0" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">github.com/PMassicotte/duckfet</span><span class="invisible">ch/releases/tag/v0.4.0</span></a></p><p><a href="https://fosstodon.org/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sql</span></a> <a href="https://fosstodon.org/tags/duckdb" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>duckdb</span></a></p>
avelino<p>Implementing SQL JOIN Support in ChronDB via PostgreSQL Protocol</p><p>The game of creating databases using <a href="https://clj.social/tags/git" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>git</span></a> internals continues<br>this week was the time to implement inner/left/right join in the <a href="https://clj.social/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgresql</span></a> protocol</p><p>I tried to explain a little about the architecture implemented to perform joins</p><p><a href="https://www.moclojer.com/blog/implementing-sql-join-support-in-chrondb-via-postgresql-protocol/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">moclojer.com/blog/implementing</span><span class="invisible">-sql-join-support-in-chrondb-via-postgresql-protocol/</span></a></p><p><a href="https://clj.social/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sql</span></a> <a href="https://clj.social/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sql</span></a> <a href="https://clj.social/tags/opensource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>opensource</span></a> <span class="h-card" translate="no"><a href="https://lemmy.ml/c/opensource" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>opensource</span></a></span> <span class="h-card" translate="no"><a href="https://beehaw.org/c/foss" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>foss</span></a></span></p>
Python Rennes<p>une proposition d'évolution de <a href="https://social.breizhcamp.org/tags/python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>python</span></a> (PEP) a été proposée pour ajouter le concept de t-string : <a href="https://peps.python.org/pep-0750/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">peps.python.org/pep-0750/</span><span class="invisible"></span></a>. </p><p>"t" pour <a href="https://social.breizhcamp.org/tags/template" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>template</span></a>, le concept ressemble beaucoup aux f-strings avec un découplage entre la création du template et l'intégration des valeurs à y mettre dedans. Cela permet notamment d'implémenter différentes vérifications et transformations de valeur pour éviter les risques d'injection <a href="https://social.breizhcamp.org/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> ou <a href="https://social.breizhcamp.org/tags/HTML" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>HTML</span></a> par exemple</p>
Corné Hoskam<p>Solved the SQL Murder Mystery! Quite a fun exercise to practice your SQL skills, would recommend! 🔍<br><a href="https://mystery.knightlab.com/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">mystery.knightlab.com/</span><span class="invisible"></span></a> <a href="https://umbracocommunity.social/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sql</span></a></p>
Andrii Kuznietsov<p>🛢️ <a href="https://social.kyiv.dcomm.net.ua/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> roadmap</p>
geraldew<p>Back on tech matters, lately I've been revisiting the Mahalanobis distance.</p><p>I had an intention ten years ago to seek an SQL method for deriving it, but it never became pressing enough, and the process using it - via an external call out - was only once once annually.</p><p>Returning to the same process ten years later, I've dug a little deeper and found that the callout had only been doing on each separate "variable" - and was thus equivalent to doing each as a simple "z-score".<br><a href="https://fosstodon.org/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> <a href="https://fosstodon.org/tags/mathstodon" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>mathstodon</span></a></p>
ExploreLive feeds
About