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.
Using indexes to speed up queries in PostgreSQL

Using indexes to speed up queries in PostgreSQL

7
Comments
2 min read
Improve SQL Performance for Date Range Queries

Improve SQL Performance for Date Range Queries

3
Comments
2 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
Final Ruby on Rails project for Flatiron School
Cover image for Final Ruby on Rails project for Flatiron School

Final Ruby on Rails project for Flatiron School

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

K8s on Windows/VirtualBox (and a DB)

7
Comments
9 min read
What is SQL - Part 2
Cover image for What is SQL - Part 2

What is SQL - Part 2

3
Comments
4 min read
How to access joined data with ActiveRecord
Cover image for How to access joined data with ActiveRecord

How to access joined data with ActiveRecord

14
Comments
5 min read
SQL Review - GROUP BY Query
Cover image for SQL Review - GROUP BY Query

SQL Review - GROUP BY Query

7
Comments 3
2 min read
Introduction to Database Transaction
Cover image for Introduction to Database Transaction

Introduction to Database Transaction

8
Comments
2 min read
Anatomy of a PostgreSQL Query Plan
Cover image for 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
Practical example for Ranking with Window Functions

Practical example for Ranking with Window Functions

5
Comments
2 min read
How to Query Multiple Schemas With Postgresql

How to Query Multiple Schemas With Postgresql

14
Comments
3 min read
SQL injection cheat sheet
Cover image for SQL injection cheat sheet

SQL injection cheat sheet

3
Comments
1 min read
Like, so confused...
Cover image for 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
Cover image for Optimistic lock on Ruby on Rails

Optimistic lock on Ruby on Rails

12
Comments
3 min read
A Deeper Dive Into SQL
Cover image for A Deeper Dive Into SQL

A Deeper Dive Into SQL

6
Comments 2
3 min read
Find the N+1 Query Problem in Rails Apps in Under 5 Mins
Cover image for Find the N+1 Query Problem in Rails Apps in Under 5 Mins
04:34

Find the N+1 Query Problem in Rails Apps in Under 5 Mins

29
Comments
1 min read
TIL PostgreSQL-style $facet

TIL PostgreSQL-style $facet

6
Comments
1 min read
What is SQL - Part 1
Cover image for What is SQL - Part 1

What is SQL - Part 1

8
Comments
3 min read
[Facts Alert]When to use which one ?MySQL Vs MongoDB
Cover image for [Facts Alert]When to use which one ?MySQL Vs MongoDB

[Facts Alert]When to use which one ?MySQL Vs MongoDB

6
Comments 4
3 min read
Advanced SQL - PostgreSQL
Cover image for Advanced SQL - PostgreSQL

Advanced SQL - PostgreSQL

6
Comments
2 min read
Understanding multiple joins in ActiveRecord
Cover image for Understanding multiple joins in ActiveRecord

Understanding multiple joins in ActiveRecord

18
Comments
5 min read
Anything I Want With Sequel And Postgres

Anything I Want With Sequel And Postgres

8
Comments 3
7 min read
loading...