SUM Of Empty Set Returns WHAT?!

SUM of an empty set or all NULLs returns something unexpected! This breaks all math assumptions. Your mind will explode! Watch now!

#sql #sqltricks #database #sqltutorial #sum #aggregate #sqlquiz #codingchallenge #sqlshorts #sqlbugs #nullhandling #sqlwtf

https://www.youtube.com/watch?v=Z-94Yr5vElY

Build a successful tech career with Python Full Stack training at TryCatch Classes. Learn Python, Django, React, SQL and APIs through hands-on projects, expert mentorship and complete placement support to get job-ready faster.

#Python #Django #React #SQL #education

Wallarm is hiring Senior Go Developer

🔧 #golang #c #python #ruby #react #api #graphql #rest #cicd #elasticsearch #kubernetes #postgresql #redis #awss3 #sql #terraform #seniorengineer
🌎 Remote
⏰ Full-time
🏢 Wallarm

Job details https://jobsfordevelopers.com/jobs/senior-go-developer-at-wallarm-com-aug-27-2025-1dc028?utm_source=mastodon.world&utm_medium=social&utm_campaign=posting
#jobalert #jobsearch #hiring

SQuizL 30-DEC-25
1/6 guesses
91 seconds
🟩🟩🟩🟦🟩🟩🟩

https://bit.ly/SQuizL-game
#SQuizL #SQL

This is pretty sweet. #litehug, a #SQL library for #lua which lets you write your queries directly in SQL. Think #SQLc, but for lua. 😎

https://git.sr.ht/~technomancy/litehug

SQL Injection In ORDER BY Drops Your Table?!

SECURITY NIGHTMARE! Everyone secures WHERE clause but ORDER BY is VULNERABLE! User input in ORDER BY can DROP TABLES! Even prepared statements won't save you! Watch this attack!

#sql #sqlinjection #security #orderby #droptable #sqlvulnerability #sqlfails #productionbug #sqlshorts #databasedisaster #sqlwtf #injectionattack

https://www.youtube.com/watch?v=QeSaSAX24sQ

I've been doing a lot of data analysis and performance optimisation recently, and one thing I've found is unbelievably quick is to move calculations from $language into SQL User Defined Functions.

For example, if I have a table of invoices with columns for the price inc. VAT and the VAT rate and I want to get the price ex. VAT, I can write an EX_VAT(inc_vat, vat_rate) function in SQL which is far faster than iterating over each row and calling an ex_vat($inc_vat, $vat_rate) PHP function.

#SQL

Avi Chawla (@_avichawla)

Postgres에 있어 중요한 순간이라며 AI 코딩 도구들이 Postgres 코드를 잘 못 써온 이유를 지적합니다. 모델이 둔해서가 아니라 학습 데이터(인터넷에 있는 오래된 Stack Overflow 답변 등)에 기인한다며 LLM 학습 방식과 SQL 생태계의 문제를 지적하는 내용입니다.

https://x.com/_avichawla/status/2005527034127433933

#postgres #llm #aicoding #sql

Braze is hiring Senior Full-stack Engineer, Product Partnerships

🔧 #ruby #react #rubyonrails #api #nosql #sql #seniorengineer
🌎 San Francisco, California
⏰ Full-time
🏢 Braze

Job details https://jobsfordevelopers.com/jobs/senior-full-stack-engineer-product-partnerships-at-braze-com-nov-24-2025-b65596?utm_source=mastodon.world&utm_medium=social&utm_campaign=posting
#jobalert #jobsearch #hiring