Ryan Kennedy<p>Hey, <a href="https://hachyderm.io/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQL</span></a> nerds…looking for a clever way to order results by a list passed in as part of a WHERE…IN query. e.g.</p><p>SELECT language, label<br>FROM thing_labels<br>WHERE thing_id=13 AND language IN ['en', 'de', 'fr', 'es', 'it']<br>ORDER BY ???<br>LIMIT 1</p><p>I 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).</p><p>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.</p>
#sql
1 post1 participant0 posts today
Xero is hiring Senior Machine Learning Engineer
#python #aws #sql #machinelearning #seniorengineer
Toronto, Canada
Full-time
Xero
Job details https://jobsfordevelopers.com/jobs/senior-machine-learning-engineer-at-xero-com-jun-20-2025-2dab33?utm_source=mastodon.world&utm_medium=social&utm_campaign=posting
#jobalert #jobsearch #hiring
Ever tried to build a #database for "names" for humans? And ran into exception over exception? Building a database for #Aviation data is equally complicated! There are more exceptions than rules.
Falsehoods Programmers Believe About Aviation
https://flightaware.engineering/falsehoods-programmers-believe-about-aviation/
Angle of Attack · Falsehoods Programmers Believe About AviationThere are a lot of assumptions one could make when designing data types and schemas for aviation data that turn out to be inaccurate. In the spirit of Patrick McKenzie’s classic piece on names, here are some false assumptions one might make about aviation.
I'm told that the purpose of #SQL was to allow people to query the #database without needing to concern themselves with how exactly the database works. Just ask it for what you want, and let it figure out how to make it happen.
Except…if the database isn't indexed appropriately for your query, it'll be slow, so you still do need to know how the database works. 
I wonder if RDBMSes should automatically create indexes as needed? But there's probably a reason why they don't.
Thrid lesson of handling dates on computers.
Your day is not "11/8/2025". It's 1.762.560.000.
pro tip for user interface designers:
if you have hundreds of millions of dollars of venture capital and you want to make a user facing data analytics tool of some kind and you think it's reasonable to ask an average human being to type this:
CAST('2023-05-01' AS TIMESTAMP)
to do literally anything with a date or time in your application's user interface, just stop right there. do not pass go, do not collect $200, and do not ever attempt to offer feedback to a UX designer ever again. something is deeply broken inside you that means there are certain mysteries of the universe that even the guys who designed the postgres command line can access that you will never know, and that's ok. You can still live a really rad life.
scariest shit i've seen in years
One of my clients tasked me with the optimization and tuning of a few of their more worrisome #SQL -based data extractions. I have a bit of experience in the field. Strategies include caching and reducing data load and processing. Here's an article I wrote about my latest endeavor: https://www.patreon.com/posts/optimizing-sql-131898474
PatreonOptimizing SQL Queries for Speed and CPU pressure: changing when things happen | aev_softwareGet more from aev_software on Patreon
Configuration Manager Report Query for Servers not rebooted in the last week | https://techygeekshome.info/configuration-manager-report-query-for_3/?fsp_sid=26022 | #Guide #Microsoft #Query #SCCM #SQL
https://techygeekshome.info/configuration-manager-report-query-for_3/?fsp_sid=26022
The new PostgreSQL extension for VScode is amazing! 
The VSCode team recently released a new extension for working with Postgres, and its features are mind-blowing. This includes the following features:
Support both connections to local and cloud-based Postgres databases Schema visualizations 
Copilot SQL agent Docker supports 
SQL editor
More details on the extension documentation: https://marketplace.visualstudio.com/items?itemName=ms-ossdata.vscode-pgsql
So I am thinking about launching a #FOSS #searchengine locally. It would cache so when I don't have internet access, I could browse the small web and enjoy great articles. I could also give access to interested friends and family.
Do you have suggestions other than #yacy and #wiby?
Yacy seems better but the search quality is not good. And regarding wiby, it uses #sql for the database :/
Boosts very much appreciated.
PS: The blogs which do #linkdump like @82mhz would be a very good seed. Already roasted meat ready to be served :)
Edit: I thought development of Yacy has stopped. But checking their repo, they are still active:
Edit2: On Yacy forum, people complain about bugs and no update. I also have found this: https://marginalia-search.com/
GitHubYaCy Search EngineSearch Engine Software for Web and Intranet Search - YaCy Search Engine