Mastodawn

Today's Poll... 👇

What does NULL mean in SQL?

#SQL #DatabaseTips #LearnSQL #DataScience #CodingBasics #NullInSQL #TechTips #ProgrammingFacts #SQLForBeginners #DataManagement

Zero

Empty string

18.2%

Unknown or missing value

81.8%

Poll ended at Aug 2 at 5:25am.

TuxAcademy Jul 31

Today's Poll.. 👇
Which SQL keyword is used to remove duplicate records?
#SQL #DataScience #TechTrivia #LearnSQL #ProgrammingPoll #TuxAcademy #DatabaseTips

UNIQUE

16.7%

DISTINCT

83.3%

FILTER

REMOVE

Poll ended at Aug 1 at 9:52am.

Tutorial Gateway Jun 13

🚀 Boost Your SQL Game with MERGE! Looking to streamline your database operations? The SQL MERGE statement is a powerful tool that lets you INSERT, UPDATE, or DELETE data in a single, efficient command. 💡 Whether you're syncing tables, managing data warehouses, or simplifying ETL processes — MERGE can save you time and reduce complexity.
 🔹 What SQL MERGE is 🔹 Real-world use cases 
https://www.tutorialgateway.org/sql-merge-statement/
#SQLServer #DatabaseTips #DataEngineering #SQLMerge #ETL #CodingTips

SQL MERGE Statement

Merge in SQL Server performs INSERT, DELETE, & UPDATE in single statement. SQL MERGE Statement modify target data based on source table data.

Tutorial Gateway

pgEdge Distributed PostgreSQL Jun 6

Every Tuesday at 11:00am ET, join the pgEdge team for #TechTuesday — all about mastering Distributed #PostgreSQL high availability, and edge-ready database solutions. Whether you’re scaling apps or seeking zero downtime, these sessions are packed with hands-on insights, real-world demos, and live Q&A with the experts.

Don’t miss out! Learn more here: https://hubs.la/Q03qbnT70

Join us on Tuesday at 11am ET here: https://hubs.la/Q03qbltY0

#pgEdge #EdgeComputing #OpenSource #WebDev #DatabaseTips

Tech Tuesdays

Tune in every Tuesday to join our Postgres experts and distributed Postgres solution architects

Mark Free May 26

"Bigger databases = slower queries. 🐢 Benchmarks on small datasets miss real-world performance cliffs. 📉 #DatabaseTips" https://milvus.io/ai-quick-reference/how-does-database-size-affect-benchmarking-results

How does database size affect benchmarking results?

Database size directly impacts benchmarking results by influencing performance metrics like query speed, resource usage,

Doug Ortiz Apr 22

🐘 PostgreSQL Pro Tip: Meta-commands can transform your data import workflow!

Just shared a new tutorial from my "Master Meta-Commands in PostgreSQL" course focusing on importing data into tables with minimal effort.

Learn how to import data with and leverage PostgreSQL's meta-commands for data migration.

Watch and level up: https://link.illustris.org/importdataintotables
#PostgreSQL #DatabaseTips #DataImport #SQL #LinkedInLearning

Querying PostgreSQL using Vanna.ai's RAG | LinkedIn Learning, formerly Lynda.com

Master the technique of formulating RAG queries through Vanna.ai, and practice retrieving and augmenting data from PostgreSQL using RAG.

Doug Ortiz Apr 18

Did you know PostgreSQL has its own built-in full-text search engine? 🔎📝

-- Create a tsvector column with GIN index
ALTER TABLE articles ADD COLUMN search_vector tsvector;
CREATE INDEX articles_search_idx ON articles USING GIN (search_vector);

UPDATE articles SET search_vector =
to_tsvector('english', title || ' ' || content);

-- Search
SELECT title FROM articles
WHERE search_vector @@ to_tsquery('english', 'postgresql & search');

#PostgreSQL #FullTextSearch #DatabaseTips #Performance

Izoate Apr 10

Getting MySQL Error 1175 when trying to update or delete? That’s Safe Update Mode kicking in. Learn how to disable it safely and run your queries smoothly.

Read the full guide: https://www.izoate.com/blog/how-to-fix-mysql-error-1175-disable-safe-update-mode-mysql/

#MySQL #Error1175 #WebDev #DatabaseTips #SQL #DevTips #SafeUpdateMode #MySQLTips #izoate #tech #technology #howto

How to fix MySQL error 1175: Disable safe update mode MySQL - Izoate

Stuck with MySQL error 1175? It means you're missing a WHERE clause in your update query. Learn how to fix it by temporarily disabling safe update mode with a simple SQL command.

Izoate

N-gated Hacker News Apr 9

🚀 Wow, who knew #PostgreSQL could be #fast if you just, you know, used it correctly? 🤯 Apparently, the secret sauce is all about "calculating" and "storing" things beforehand—mind-blowing! 😂 Thanks for the #groundbreaking revelation that doing things right makes them work better. 🏆
https://blog.vectorchord.ai/postgresql-full-text-search-fast-when-done-right-debunking-the-slow-myth #Calculating #Storing #DatabaseTips #HackerNews #ngated

Doug Ortiz Apr 8

Do You Know These Secret PostgreSQL Meta Commands? 🔍

Meta commands (starting with ) are PostgreSQL's hidden power tools for DBAs and developers!

These backslash commands let you explore database objects, get help, format output, and manage connections - all without writing complex SQL queries.

Learn how to access these productivity boosters: https://link.illustris.org/how2accessmetacommands
#PostgreSQL #DatabaseTips #MetaCommands #DBAdmin

Querying PostgreSQL using Vanna.ai's RAG | LinkedIn Learning, formerly Lynda.com

Master the technique of formulating RAG queries through Vanna.ai, and practice retrieving and augmenting data from PostgreSQL using RAG.