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.
I got tired of writing the same history table boilerplate, so I built a Postgres extension
laydownpipe_24 profile

I got tired of writing the same history table boilerplate, so I built a Postgres extension

#postgres #opensource #sql #database
5
Comments
3 min read
Oracle ORA-00289 Error: Causes and Solutions Complete Guide
dbmserror profile

Oracle ORA-00289 Error: Causes and Solutions Complete Guide

#oracle #database #dba #sql
Comments
3 min read
PostgreSQL 2201E Error: Causes and Solutions Complete Guide
dbmserror profile

PostgreSQL 2201E Error: Causes and Solutions Complete Guide

#postgres #database #dba #sql
Comments
3 min read
How do I answer "what did my data look like last month" in Postgres?
wondadav profile

How do I answer "what did my data look like last month" in Postgres?

#ai #dataengineering #sql #temporalqueries
2
Comments 2
4 min read
Day 9 of 100 Days of ClickHouse®: Mastering Data Aggregation from GROUP BY to CUBE
kanishga_subramani_49ad73 profile

Day 9 of 100 Days of ClickHouse®: Mastering Data Aggregation from GROUP BY to CUBE

#analytics #database #dataengineering #sql
1
Comments
4 min read
PostgreSQL 22015 Error: Causes and Solutions Complete Guide
dbmserror profile

PostgreSQL 22015 Error: Causes and Solutions Complete Guide

#postgres #database #dba #sql
Comments
3 min read
Oracle ORA-00265 Error: Causes and Solutions Complete Guide
dbmserror profile

Oracle ORA-00265 Error: Causes and Solutions Complete Guide

#oracle #database #dba #sql
1
Comments
3 min read
Scaling PostgreSQL in Production: Indexing, RPC Functions, Views, and Query Optimization
poojang profile

Scaling PostgreSQL in Production: Indexing, RPC Functions, Views, and Query Optimization

#database #performance #postgres #sql
Comments
6 min read
How I Cut 769 Database Queries With One Window Function
secona profile

How I Cut 769 Database Queries With One Window Function

#database #performance #postgres #sql
Comments
9 min read
Stop Using Offset for Pagination: Switching to Cursor-Based Filtering for Massive Datasets
aasimghaffar profile

Stop Using Offset for Pagination: Switching to Cursor-Based Filtering for Massive Datasets

#database #performance #webdev #sql
Comments
2 min read
ORA-00060 Deadlock: Find It, Fix It, Prevent It
uptimearchitect profile

ORA-00060 Deadlock: Find It, Fix It, Prevent It

#oracle #database #sql #performance
Comments
10 min read
Oracle ORA-00264 Error: Causes and Solutions Complete Guide
dbmserror profile

Oracle ORA-00264 Error: Causes and Solutions Complete Guide

#oracle #database #dba #sql
1
Comments
3 min read
When Text Becomes Code: Defending LLM–Database Integrations from Prompt Injection
stack_builders profile

When Text Becomes Code: Defending LLM–Database Integrations from Prompt Injection

#sql #ai #security
Comments
7 min read
Why LLM Agents Still Can't Query NoSQL Databases
camma_smith_1 profile

Why LLM Agents Still Can't Query NoSQL Databases

#sql #aws #ai #dynamodb
Comments
5 min read
Why We Built an SQL Layer for DynamoDB
camma_smith_1 profile

Why We Built an SQL Layer for DynamoDB

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