Skip to content

DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

👋 Sign in for the ability to sort posts by relevant, latest, or top.

MindsDB Team for MindsDB

Sep 11 '25

Introducing MindsDB’s Integration with Gong: AI Analytics on Call Data

#ai #sql

7 min read

Oct 12 '25

Battling Laravel's Sneaky DELETEs: How I Got ORDER BY and LIMIT to Play Nice with Joins

#laravel #mysql #database #sql

3 min read

Meet Rajesh Gor

Sep 15 '25

SQLite dot commands: read command is recursive?

#sql #sqlite #database #programming

2 min read

Sep 11 '25

SQL LIKE Operator: What It Is, How It Works, and Best Practices

#sql #mysql #postgressql

2 min read

Naveens K

Oct 3 '25

Indexing, Hashing & Query Optimization in SQL

#database #performance #algorithms #sql

2 min read

Naveens K

Oct 3 '25

Transactions, Deadlocks & Log Based Recovery in SQL

#acid #deadlock #logging #sql

2 min read

Ayomide Ajewole

Oct 13 '25

Understanding Subqueries in SQL and Building JSON Directly in PostgreSQL

#sql #postgres #webdev #typeorm

5 min read

Naveens K

Oct 3 '25

Understanding ACID Properties in SQL Transactions

#database #architecture #beginners #sql

2 min read

Thushitha

Oct 3 '25

🚀 Indexing, Hashing & Query Optimization in SQL (Tutorial Example on Students Table)

#mysql #programming #beginners #sql

2 min read

Naveens K

Oct 2 '25

Demystifying Normalization in RDBMS: From 1NF to 3NF

#dbms #data #sql #normalization

5 min read

Oct 2 '25

Indexing, Hashing, and Query

#database #computerscience #performance #sql

1 min read

Meet Rajesh Gor

Sep 14 '25

SQLite dot commands: read file or standard output

#sqlite #sql #database #programming

3 min read

Oct 1 '25

Fuzzy String Matching in PostgreSQL with pg_trgm (Trigram Search Tutorial)

#postgres #trigram #database #sql

2 min read

Oct 12 '25

Suppose you have duplicate rows in a table. How can you delete all duplicates but keep one copy using SQL only?

#sql #rownumber

1 min read

Santhosh_M

Oct 1 '25

NORMALIZATION

#database #sql #beginners #tutorial

3 min read

👋 Sign in for the ability to sort posts by relevant, latest, or top.