Forwarded from ๐บ๐ฆ Oleg Kovalov
๐3๐3๐ฅด3
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
This media is not supported in your browser
VIEW IN TELEGRAM
๐คฃ31๐ฅ6โค1๐1
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