DEV Community

select * from SQL

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

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
Choosing Between On-Premises and Cloud SQL Hosting: What Businesses Should Consider

Choosing Between On-Premises and Cloud SQL Hosting: What Businesses Should Consider

Comments
2 min read
SQLite functions: unistr and unistr quote

SQLite functions: unistr and unistr quote

Comments
2 min read
🔥 Stop Wasting Time With REST – Build Real-Time Apps with SQL Over WebSockets!

🔥 Stop Wasting Time With REST – Build Real-Time Apps with SQL Over WebSockets!

Comments
4 min read
Finally, a Database That Actually Listens to You

Finally, a Database That Actually Listens to You

1
Comments
3 min read
SQLite dot commands: run system shell commands

SQLite dot commands: run system shell commands

1
Comments
1 min read
Cursor & Trigger in SQL with Examples

Cursor & Trigger in SQL with Examples

3
Comments
2 min read
Understanding Database Normalization (1NF, 2NF, 3NF) with SQL Examples

Understanding Database Normalization (1NF, 2NF, 3NF) with SQL Examples

4
Comments
2 min read
Introducing MindsDB’s Integration with Gong: AI Analytics on Call Data

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

5
Comments
7 min read
ACID, Isolation Levels, and MVCC: Architecture and Execution in Relational Databases

ACID, Isolation Levels, and MVCC: Architecture and Execution in Relational Databases

2
Comments
10 min read
How to write Hello World in Oracle SQL

How to write Hello World in Oracle SQL

Comments
1 min read
SQLite dot commands: read command is recursive?

SQLite dot commands: read command is recursive?

1
Comments
2 min read
SQL LIKE Operator: What It Is, How It Works, and Best Practices

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

Comments
2 min read
Indexing, Hashing & Query Optimization in DBMS

Indexing, Hashing & Query Optimization in DBMS

5
Comments
3 min read
Indexing, Hashing & Query Optimization in SQL

Indexing, Hashing & Query Optimization in SQL

2
Comments
2 min read
Transactions, Deadlocks & Log Based Recovery in SQL

Transactions, Deadlocks & Log Based Recovery in SQL

2
Comments
2 min read
Understanding ACID Properties in SQL Transactions

Understanding ACID Properties in SQL Transactions

3
Comments
2 min read
SQL Rewriting vs. Indexing: How AI-Powered Structural Optimization Achieves 20x Scalability Gains

SQL Rewriting vs. Indexing: How AI-Powered Structural Optimization Achieves 20x Scalability Gains

1
Comments 1
14 min read
🚀 Indexing, Hashing & Query Optimization in SQL (Tutorial Example on Students Table)

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

Comments
2 min read
Why I Ditched SSMS for VS Code's MSSQL Extension (And Never Looked Back)

Why I Ditched SSMS for VS Code's MSSQL Extension (And Never Looked Back)

8
Comments
4 min read
Demystifying Normalization in RDBMS: From 1NF to 3NF

Demystifying Normalization in RDBMS: From 1NF to 3NF

3
Comments
5 min read
Indexing, Hashing, and Query

Indexing, Hashing, and Query

1
Comments
1 min read
SQLite dot commands: read file or standard output

SQLite dot commands: read file or standard output

1
Comments
3 min read
Fuzzy String Matching in PostgreSQL with pg_trgm (Trigram Search Tutorial)

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

2
Comments
2 min read
Understanding the ACID Concept with PostgreSQL

Understanding the ACID Concept with PostgreSQL

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

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

5
Comments
1 min read
loading...