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.
How to Map a JSON Column in Spring Boot With JPA 3 and Hibernate 6

How to Map a JSON Column in Spring Boot With JPA 3 and Hibernate 6

5
Comments
8 min read
2nd,Create Tables In Supabase

2nd,Create Tables In Supabase

Comments
1 min read
Text-to-SQL from Scratch — Tutorial For Dummies (Using PocketFlow!)

Text-to-SQL from Scratch — Tutorial For Dummies (Using PocketFlow!)

5
Comments
14 min read
Mastering SQL Server CONTAINS for Advanced Text Search

Mastering SQL Server CONTAINS for Advanced Text Search

Comments
1 min read
Twitter Stuck Signing Up? No Email, Phone Field Broken?

Twitter Stuck Signing Up? No Email, Phone Field Broken?

Comments
2 min read
Postgresql soft-delete strategies: balancing data retention

Postgresql soft-delete strategies: balancing data retention

Comments
3 min read
Importing month names into SQLite3 can be useful

Importing month names into SQLite3 can be useful

Comments 3
3 min read
Build a Shared-Nothing Distributed Queue with SQLite and Python

Build a Shared-Nothing Distributed Queue with SQLite and Python

Comments
2 min read
Convert LONG to LOB on import(23ai)

Convert LONG to LOB on import(23ai)

1
Comments
2 min read
Statistics by time window: SPL VS SQL #16

Statistics by time window: SPL VS SQL #16

6
Comments
3 min read
Deduplicate between an Uncertain Number of Columns — From SQL to SPL #21

Deduplicate between an Uncertain Number of Columns — From SQL to SPL #21

7
Comments 1
2 min read
Indexing in PostgreSQL: Pros, Cons, and Best Practices

Indexing in PostgreSQL: Pros, Cons, and Best Practices

2
Comments
3 min read
Database Normalization Summary

Database Normalization Summary

1
Comments
1 min read
🔍 Data Cleaning Techniques Using SQL

🔍 Data Cleaning Techniques Using SQL

2
Comments
1 min read
Deploying a FastAPI + PostgreSQL App Using Google Cloud Run and Cloud SQL

Deploying a FastAPI + PostgreSQL App Using Google Cloud Run and Cloud SQL

2
Comments
2 min read
🚀 Mastering Unit of Work in SQLAlchemy: Efficient Transactions in 2025

🚀 Mastering Unit of Work in SQLAlchemy: Efficient Transactions in 2025

Comments
1 min read
🚀 SQL Query Optimization in 2025: 7 Techniques for Faster Performance

🚀 SQL Query Optimization in 2025: 7 Techniques for Faster Performance

Comments
1 min read
How to Optimize SQLite Performance With Indexed Views and Write-Ahead Logging

How to Optimize SQLite Performance With Indexed Views and Write-Ahead Logging

Comments
2 min read
Essential SQL Commands: A Quick Reference Guide

Essential SQL Commands: A Quick Reference Guide

5
Comments
8 min read
SQL Server for NoSQL

SQL Server for NoSQL

Comments
1 min read
Top 3 PostgreSQL Performance Issues: Diagnosis and Proven Solutions

Top 3 PostgreSQL Performance Issues: Diagnosis and Proven Solutions

1
Comments
5 min read
🗃️ Introduction to Database Design: Concepts Every Beginner Should Know

🗃️ Introduction to Database Design: Concepts Every Beginner Should Know

Comments
4 min read
Find the Closest Date Match for Each Record from Two Tables — From SQL to SPL #20

Find the Closest Date Match for Each Record from Two Tables — From SQL to SPL #20

6
Comments 1
2 min read
SQL Joins Made Easy: INNER, OUTER, LEFT, RIGHT Joins

SQL Joins Made Easy: INNER, OUTER, LEFT, RIGHT Joins

4
Comments 1
1 min read
Are SQL Joins Expensive?

Are SQL Joins Expensive?

5
Comments
2 min read
loading...