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.
What’s an Example of Good E-Commerce Database Design?

What’s an Example of Good E-Commerce Database Design?

43
Comments 2
8 min read
How Do You Design a Shopping Cart Database for E-Commerce?

How Do You Design a Shopping Cart Database for E-Commerce?

50
Comments 5
8 min read
What is SQL - Part 3

What is SQL - Part 3

4
Comments
6 min read
How to spot and fix Django ORM anti-patterns 04:55

How to spot and fix Django ORM anti-patterns

33
Comments 1
1 min read
K8s on Windows/VirtualBox (and a DB)

K8s on Windows/VirtualBox (and a DB)

7
Comments
9 min read
How to access joined data with ActiveRecord

How to access joined data with ActiveRecord

14
Comments
5 min read
SQL Review - GROUP BY Query

SQL Review - GROUP BY Query

7
Comments 3
2 min read
Introduction to Database Transaction

Introduction to Database Transaction

8
Comments
2 min read
Anatomy of a PostgreSQL Query Plan

Anatomy of a PostgreSQL Query Plan

9
Comments
10 min read
Postgres Triggers

Postgres Triggers

10
Comments
3 min read
How to Query Multiple Schemas With Postgresql

How to Query Multiple Schemas With Postgresql

14
Comments
3 min read
Like, so confused...

Like, so confused...

13
Comments 2
2 min read
Mysql 5.7 Window Functions Workaround

Mysql 5.7 Window Functions Workaround

12
Comments
3 min read
Optimistic lock on Ruby on Rails

Optimistic lock on Ruby on Rails

12
Comments
3 min read
A Deeper Dive Into SQL

A Deeper Dive Into SQL

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