JOINs are not an Euler diagrams (if you didn’t know…)
https://x.com/milan_milanovic/status/1710639221893943323
https://x.com/milan_milanovic/status/1710639221893943323
👍17🤔2👎1
It's been a long time since last SQL-WTF SQL-TIL...
This construct doesn't work in Postgresql, Mysql, DuckDB, or Snowflake.
But it does work... in sqlite 🙂
SELECT * FROM (((t as t1) as t2) as t3);
This construct doesn't work in Postgresql, Mysql, DuckDB, or Snowflake.
But it does work... in sqlite 🙂
😱6
Forwarded from Технологический Болт Генона
- Anti-pattern #1. Using exotic databases for the wrong reasons
- Anti-pattern #2. Caching things unnecessarily
- Anti-pattern #3. Storing everything and a kitchen sink
. . .
Most importantly, study your database (and SQL). Learn it, love it, use it, abuse it. Spending a couple of days just leafing through that Postgres manual to see what it can do will probably make you a better engineer than spending more time on the next flavor-of-the-month JavaScript framework hotness. Again.
YOUR DATABASE SKILLS ARE NOT 'GOOD TO HAVE'
https://renegadeotter.com/2023/11/12/your-database-skills-are-not-good-to-have.html
😁9👍1