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.
Handle Large PostgreSQL Schemas with a GUI Tool

Handle Large PostgreSQL Schemas with a GUI Tool

6
Comments
3 min read
Qantler interview Questions

Qantler interview Questions

5
Comments
1 min read
concat() vs Group_concat()

concat() vs Group_concat()

1
Comments
1 min read
Combine Two JSON Collections with Nested Arrays: MongoDB and PostgreSQL Aggregations

Combine Two JSON Collections with Nested Arrays: MongoDB and PostgreSQL Aggregations

2
Comments
8 min read
SQLite dot commands: change directory command

SQLite dot commands: change directory command

1
Comments
1 min read
SQLite Scalar function: 3 valued iif and if scalar function

SQLite Scalar function: 3 valued iif and if scalar function

Comments
3 min read
From SQL to Python: Uniting Stored Power with Functional Flexibility

From SQL to Python: Uniting Stored Power with Functional Flexibility

Comments
5 min read
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
🔥 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
SQLite functions: unistr and unistr quote

SQLite functions: unistr and unistr quote

Comments
2 min read
Stop Writing SQL by Hand: Building My MVP to Chat With Databases

Stop Writing SQL by Hand: Building My MVP to Chat With Databases

Comments
2 min read
SQLite dot commands: run system shell commands

SQLite dot commands: run system shell commands

1
Comments
1 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
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
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
SQLite dot commands: read file or standard output

SQLite dot commands: read file or standard output

1
Comments
3 min read
Understanding the ACID Concept with PostgreSQL

Understanding the ACID Concept with PostgreSQL

Comments 1
5 min read
SQL Server Performance Optimization: Window Functions to Double Your Query Efficiency!

SQL Server Performance Optimization: Window Functions to Double Your Query Efficiency!

Comments
4 min read
SQLStorm & CogniSQL: An AI-Augmented SQL Dataset(202508)

SQLStorm & CogniSQL: An AI-Augmented SQL Dataset(202508)

Comments
4 min read
SQLite functions: Generate Series Examples

SQLite functions: Generate Series Examples

Comments
2 min read
Beyond Functional: Writing Professional and Performant SQL Queries

Beyond Functional: Writing Professional and Performant SQL Queries

3
Comments
2 min read
loading...