Mastodawn

👴🧙‍♂️ Oh look, another "graybeard" programmer claiming to have conquered the #Postgres #search universe with a #GitHub repository and a sprinkle of fairy dust. 🚀✨ The article boasts about a magical #BM25 search extension like it's the iPhone of database queries, but spoiler alert: it's still just Postgres with a fancy name tag. 🏷️🤖
https://github.com/timescale/pg_textsearch #graybeardprogrammer #databasequeries #HackerNews #ngated

GitHub - timescale/pg_textsearch: PostgreSQL extension for BM25 relevance-ranked full-text search. Postgres OSS licensed.

PostgreSQL extension for BM25 relevance-ranked full-text search. Postgres OSS licensed. - timescale/pg_textsearch

GitHub

PrecisionSQL Jan 16

NULL = NULL Is FALSE In SQL?!

STOP SCROLLING! Comparing NULL to NULL in SQL returns FALSE, not TRUE! This breaks every assumption about equality. Your mind will explode! Watch now!

#sql #sqltricks #database #sqltutorial #sqlweird #nullcomparison #sqlquiz #codingchallenge #sqlshorts #sqlwtf #databasequeries #sqlbugs

https://www.youtube.com/watch?v=5x89cEbWuPg

NULL NULL Is FALSE In SQL?! #sqlweird

YouTube

N-gated Hacker News Dec 20

🚀🔍 Wow, someone invented a magical biscuit that makes your database queries faster than a toddler on a sugar high! Who knew mixing pastries with SQL could eliminate that pesky recheck overhead? 🤷‍♂️ Remember, kids, when in doubt, just bake your indexing problems away! 🍪
https://github.com/CrystallineCore/Biscuit #magicalbiscuit #databasequeries #SQLinnovation #techhumor #bakingindexing #HackerNews #ngated

GitHub - CrystallineCore/Biscuit: Biscuit is a specialized PostgreSQL index access method (IAM) designed for blazing-fast pattern matching on LIKE queries, with native support for multi-column searches. It eliminates the recheck overhead of trigram indexes while delivering significant performance improvements on wildcard-heavy queries.

Biscuit is a specialized PostgreSQL index access method (IAM) designed for blazing-fast pattern matching on LIKE queries, with native support for multi-column searches. It eliminates the recheck ov...

GitHub

PrecisionSQL Dec 17

SQL Division By Zero Returns WHAT?!

Your brain will short-circuit! Dividing by zero in SQL doesn't crash - it returns something unexpected. This breaks all math logic! Watch this!

#sql #sqltricks #database #sqltutorial #divisionbyzero #sqlmath #sqlquiz #codingchallenge #sqlshorts #sqlweird #databasequeries #sqlbugs

https://www.youtube.com/watch?v=222SWNwvMGE

SQL Division By Zero Returns WHAT?! #databasequeries

YouTube

PrecisionSQL Dec 17

String + NULL In SQL Creates WHAT?!

SQL string concatenation with NULL will shock you! Adding NULL to strings creates something you'd NEVER expect. This breaks string logic! Watch!

#sql #sqltricks #database #sqltutorial #stringconcatenation #nullhandling #sqlquiz #codingchallenge #sqlshorts #sqlbugs #databasequeries #sqlwtf

https://www.youtube.com/watch?v=8kS6be0mN6A

String NULL In SQL Creates WHAT?! #sqlquiz

YouTube

PrecisionSQL Dec 9

AND/OR With NULL Breaks Logic!

SQL boolean logic with NULL creates chaos! AND/OR operations with NULL give results that make NO sense. This is why queries fail! Watch now!

#sql #sqltricks #database #sqltutorial #booleanlogic #nullhandling #sqlquiz #codingchallenge #sqlshorts #sqlweird #databasequeries #sqlbugs

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

AND OR With NULL Breaks Logic! #sqltricks

YouTube

Gary Ackerman Jul 4, 2025

LibreOffice Base uses SQL (Structured Query Language), pronounced "sequel". You can enter queries in the GUI or directly as SQL code. SELECT, FROM, and WHERE are core commands! #SQLBasics #DatabaseQueries

zartom Feb 20, 2025

Retrieve Multiple SQL Records Based on Composite Key Values
Efficiently retrieve SQL multiple records using composite keys! Learn various methods: VALUES constructor, multiple OR conditions, and JOIN operations. Choose the best approach for your needs. SQLTips #DB2 #CompositeKeys #MultipleRecords #DatabaseQueries #EfficientQueries
https://tech-champion.com/database/db2luw/retrieve-multiple-sql-records-based-on-composite-key-values/