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.
Build a Natural Language to SQL API in Python

Build a Natural Language to SQL API in Python

Comments
2 min read
Build a Natural Language to SQL API in Python

Build a Natural Language to SQL API in Python

Comments
2 min read
Google Dorking in 2026: The Ultimate Guide for Security Researchers

Google Dorking in 2026: The Ultimate Guide for Security Researchers

6
Comments
11 min read
Managed Databases: Relational vs NoSQL in the Cloud

Managed Databases: Relational vs NoSQL in the Cloud

Comments
6 min read
Postgres: force drop a database that is being accessed by other users

Postgres: force drop a database that is being accessed by other users

Comments
4 min read
SQLite Internals: lcd-ex vs hctree; PostgreSQL 19 SQL/PGQ Rewrites & pg_timetable Migration

SQLite Internals: lcd-ex vs hctree; PostgreSQL 19 SQL/PGQ Rewrites & pg_timetable Migration

Comments
3 min read
FastAPI SQLAlchemy Session Leak Detection: Diagnose and Fix Long-Running DB Sessions in Production

FastAPI SQLAlchemy Session Leak Detection: Diagnose and Fix Long-Running DB Sessions in Production

Comments
4 min read
Microsoft SQL Server and its Components

Microsoft SQL Server and its Components

Comments
5 min read
FastAPI Session Leak Detection: How to Find and Fix Long-Running SQLAlchemy Sessions in Production?

FastAPI Session Leak Detection: How to Find and Fix Long-Running SQLAlchemy Sessions in Production?

Comments
3 min read
DuckDB Iceberg MERGE, PostgreSQL GUCs, SQLite Optimization Checklist

DuckDB Iceberg MERGE, PostgreSQL GUCs, SQLite Optimization Checklist

Comments
3 min read
We Don't Need Another Go ORM. We Need a Better One.

We Don't Need Another Go ORM. We Need a Better One.

Comments
2 min read
SQL: JOIN Queries

SQL: JOIN Queries

Comments
5 min read
SQL: Aggregate Queries

SQL: Aggregate Queries

Comments
4 min read
Query Optimization in IFS: The Hidden Performance Killer

Query Optimization in IFS: The Hidden Performance Killer

Comments
5 min read
SQL: Normalização e Formas Normais

SQL: Normalização e Formas Normais

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