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.
Additive column can 500 every login (Drizzle + Better Auth + preview deploys)
omar_bni_f6856a8bb0e021e9 profile

Additive column can 500 every login (Drizzle + Better Auth + preview deploys)

#database #sql #devops #webdev
3
Comments
9 min read
Build a Natural Language to SQL API in Python
sonam_50a41a4ced7e6b4f3fa profile

Build a Natural Language to SQL API in Python

#python #ai #flask #sql
Comments
2 min read
Why Do We Keep Forgetting About the Plan Cache in SQL Server?
azhadsuhaimi profile

Why Do We Keep Forgetting About the Plan Cache in SQL Server?

#sql #database #performance
Comments
2 min read
Two Frameworks - dbt & SQLMesh, One Owner
5c4989ca297ed profile

Two Frameworks - dbt & SQLMesh, One Owner

#sql #opensource #python #dataengineering
2
Comments
6 min read
Google Dorking in 2026: The Ultimate Guide for Security Researchers
vickybuilds profile

Google Dorking in 2026: The Ultimate Guide for Security Researchers

#sql #security #google #cybersecurity
6
Comments
11 min read
Postgres: force drop a database that is being accessed by other users
philip_mcclarence_2ef9475 profile

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

#database #postgres #sql #tutorial
Comments
4 min read
WHERE $1::timestamptz IS NULL OR "timestamp" > $1
franckpachot profile

WHERE $1::timestamptz IS NULL OR "timestamp" > $1

#database #performance #postgres #sql
1
Comments 2
7 min read
Build a Natural Language to SQL API in Python
sonam_50a41a4ced7e6b4f3fa profile

Build a Natural Language to SQL API in Python

#python #ai #flask #sql
1
Comments
2 min read
SQLite Internals: lcd-ex vs hctree; PostgreSQL 19 SQL/PGQ Rewrites & pg_timetable Migration
soytuber profile
soy

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

#database #sql #sqlite
Comments
3 min read
Find Your Worst Postgres Query in 15 Minutes with pg_stat_statements
mukesh_13 profile
Mukesh

Find Your Worst Postgres Query in 15 Minutes with pg_stat_statements

#postgres #performance #database #sql
1
Comments
4 min read
Microsoft SQL Server and its Components
kathir_2911 profile

Microsoft SQL Server and its Components

#architecture #database #microsoft #sql
Comments
5 min read
Understanding Subqueries and CTEs in SQL: A Complete Guide
samuel_mwai profile

Understanding Subqueries and CTEs in SQL: A Complete Guide

#beginners #database #sql #tutorial
1
Comments
4 min read
DuckDB Iceberg MERGE, PostgreSQL GUCs, SQLite Optimization Checklist
soytuber profile
soy

DuckDB Iceberg MERGE, PostgreSQL GUCs, SQLite Optimization Checklist

#database #sql #sqlite
Comments
3 min read
We Don't Need Another Go ORM. We Need a Better One.
nelthaarion profile

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

#sql #go #orm #postgres
Comments
2 min read
SQL: JOIN Queries
yuripeixinho profile

SQL: JOIN Queries

#beginners #database #sql #tutorial
Comments
5 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.