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.
The Afternoon We Put Magento's Schema on SQL Server

The Afternoon We Put Magento's Schema on SQL Server

1
Comments
40 min read
WHERE $1::timestamptz IS NULL OR "timestamp" > $1

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

Comments
7 min read
Solving the Division Problem in SQL and Relational Algebra Using Python Reasoning

Solving the Division Problem in SQL and Relational Algebra Using Python Reasoning

Comments
3 min read
SQL Design & Query Reference

SQL Design & Query Reference

1
Comments
35 min read
Top N per group is the query `LIMIT` can't write

Top N per group is the query `LIMIT` can't write

Comments
3 min read
BUILDING GREENWOOD ACADEMY DATABASE USING POSTGRESQL

BUILDING GREENWOOD ACADEMY DATABASE USING POSTGRESQL

1
Comments
5 min read
SQLite vs PostgreSQL: Choosing the Right Database

SQLite vs PostgreSQL: Choosing the Right Database

Comments
5 min read
Your BigQuery bill is a query-shape problem. We cut one 72% in three weeks.

Your BigQuery bill is a query-shape problem. We cut one 72% in three weeks.

Comments 1
3 min read
Following ROWIDs Through an Oracle Unique Index Update

Following ROWIDs Through an Oracle Unique Index Update

Comments
13 min read
Building a School Database with PostgreSQL: My SQL Week 2 Journey

Building a School Database with PostgreSQL: My SQL Week 2 Journey

1
Comments
4 min read
Why I Built a Free SSMS Extension to Stop Destructive Queries

Why I Built a Free SSMS Extension to Stop Destructive Queries

Comments 1
3 min read
A Small, Annoying Reminder About MySQL, Next.js, and Reality

A Small, Annoying Reminder About MySQL, Next.js, and Reality

1
Comments
2 min read
Why SQL Is Still the Most Important Skill for Data Engineers

Why SQL Is Still the Most Important Skill for Data Engineers

Comments
3 min read
You don't need a backend to store form submissions. You need a place to ask "how many."

You don't need a backend to store form submissions. You need a place to ask "how many."

1
Comments 1
2 min read
Lucidchart ERD Alternative: A Desktop ERD Tool That Connects to Your Database

Lucidchart ERD Alternative: A Desktop ERD Tool That Connects to Your Database

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