Forem

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.
From English to SQL: How LLMs Actually Understand Your Database Schema
vivekdraxlr profile

From English to SQL: How LLMs Actually Understand Your Database Schema

#sql #database #ai #tutorial
Comments
6 min read
HOW DO YOU FEEL??
srinaadd_pemmasani_28999b profile

HOW DO YOU FEEL??

#discuss #sql
Comments
2 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
I built a tool that lets you query websites using SQL
Cover image for I built a tool that lets you query websites using SQL
michael_ozersky_9624310ec profile

I built a tool that lets you query websites using SQL

#ai #webdev #programming #sql
Comments
1 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
Cover image for 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
Cover image for 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
Cleaning Messy Phone Numbers in PostgreSQL Using REGEXP_REPLACE
Cover image for 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.