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.
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
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
What is SQL - Part 1

What is SQL - Part 1

8
Comments
3 min read
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
Search MySQL Like Google Using Match and Full-Text Search

Search MySQL Like Google Using Match and Full-Text Search

20
Comments
7 min read
PostgreSQL MATERIALIZED VIEW non-blocking, yet updated frequently

PostgreSQL MATERIALIZED VIEW non-blocking, yet updated frequently

7
Comments 2
1 min read
Dev life is easy with node-mssql

Dev life is easy with node-mssql

16
Comments 1
2 min read
Let's talk about Views

Let's talk about Views

5
Comments
2 min read
TypeORM - Query Builder with Subquery

TypeORM - Query Builder with Subquery

122
Comments 5
6 min read
SQLite - a developer's best friend

SQLite - a developer's best friend

28
Comments 7
8 min read
Emacs as SQL client with LSP

Emacs as SQL client with LSP

38
Comments 1
5 min read
Understanding ActiveRecord left outer joins

Understanding ActiveRecord left outer joins

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