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.
Turn Any API Into a SQL Database
mukhtar_onif profile

Turn Any API Into a SQL Database

#api #database #sql #tooling
5
Comments
7 min read
Preventing double-bookings with PostgreSQL exclusion constraints
ripazocom profile

Preventing double-bookings with PostgreSQL exclusion constraints

#postgres #sql #supabase #database
Comments
6 min read
SQLite Journaling on SMB, TypeGraph for SQL Graphs, Cross-Engine Migrations
soytuber profile
soy

SQLite Journaling on SMB, TypeGraph for SQL Graphs, Cross-Engine Migrations

#database #sql #sqlite
Comments
3 min read
How to Prompt AI Tools to Write Accurate SQL Queries (And Why Most Developers Get This Wrong)
vivekdraxlr profile

How to Prompt AI Tools to Write Accurate SQL Queries (And Why Most Developers Get This Wrong)

#sql #database #ai #tutorial
Comments
6 min read
Learning SQL As If You Built It Yourself
edriso profile

Learning SQL As If You Built It Yourself

#learning #database #sql
1
Comments
12 min read
Can ClickHouse DELETE Data? A 2026 PR-by-PR Analysis
manveer_chawla_64a7283d5a profile

Can ClickHouse DELETE Data? A 2026 PR-by-PR Analysis

#database #sql #dataengineering #data
6
Comments
31 min read
Meet QueryDen: The Modern Database Client Built for Developers
kix007 profile

Meet QueryDen: The Modern Database Client Built for Developers

#opensource #rust #database #sql
Comments
2 min read
PostgreSQL: New Time-Series Extension & Replication Monitor; DuckDB in Production
soytuber profile
soy

PostgreSQL: New Time-Series Extension & Replication Monitor; DuckDB in Production

#database #sql #sqlite
Comments
3 min read
Come estrarre una singola tabella da un file dump MySQL
minnogit profile

Come estrarre una singola tabella da un file dump MySQL

#mysql #sql
Comments
1 min read
Native SQL in Java without JDBC boilerplate — meet Ujorm3
pponec profile

Native SQL in Java without JDBC boilerplate — meet Ujorm3

#backend #database #java #sql
Comments
4 min read
In some scenarios, relying on LLMs to generate SQL is neither rigorous nor reliable.Right way to teach LLMs to generate SQL is here
jaco_siu_748a48197d7f91e9 profile
Coco

In some scenarios, relying on LLMs to generate SQL is neither rigorous nor reliable.Right way to teach LLMs to generate SQL is here

#ai #sql #database #opensource
Comments
4 min read
Cleaning Messy Phone Numbers in PostgreSQL Using REGEXP_REPLACE
sharonnyabuto profile

Cleaning Messy Phone Numbers in PostgreSQL Using REGEXP_REPLACE

#sql #postgres #beginners
Comments
6 min read
Eight window-function tricks beyond LAG and ROW_NUMBER
fixelsmith profile

Eight window-function tricks beyond LAG and ROW_NUMBER

#sql #analytics #frauddetection #database
Comments
6 min read
DuckDB EC2 Optimization, Postgres FDW Pushdown, SQLite NetBeans Connectivity
soytuber profile
soy

DuckDB EC2 Optimization, Postgres FDW Pushdown, SQLite NetBeans Connectivity

#database #sql #sqlite
1
Comments
4 min read
Data Analyst Interviews in 2026: How to Clear SQL, Case Studies, and Behavioral in the Same Loop
manyoffer_career profile

Data Analyst Interviews in 2026: How to Clear SQL, Case Studies, and Behavioral in the Same Loop

#career #interview #dataanalysis #sql
Comments
4 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.
HTTPS · dev.to
← Home