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 is SQL - Part 4

What is SQL - Part 4

7
Comments
7 min read
Building a Hybrid SQL + NoSQL E-Commerce Data Model

Building a Hybrid SQL + NoSQL E-Commerce Data Model

16
Comments
7 min read
No-Code: "It's a Trap!"

No-Code: "It's a Trap!"

7
Comments
9 min read
Kalman Filtering in SQL

Kalman Filtering in SQL

7
Comments
6 min read
Inside Presto Optimizer

Inside Presto Optimizer

7
Comments
9 min read
How to output raw SQL with filled parameters in TypeORM?

How to output raw SQL with filled parameters in TypeORM?

11
Comments 3
2 min read
What’s an Example of Good E-Commerce Database Design?

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

32
Comments 2
8 min read
KnexJS: how to convert a SQL join with aliases and ordered by values from another table

KnexJS: how to convert a SQL join with aliases and ordered by values from another table

2
Comments
1 min read
I analyzed my six years of food deliveries

I analyzed my six years of food deliveries

5
Comments 7
5 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 3
8 min read
What to do once you reach max integer value for an auto incremented column in Rails

What to do once you reach max integer value for an auto incremented column in Rails

7
Comments 2
2 min read
Creating Deployment & Rollback SQL Scripts from EntityFrameworkCore migrations

Creating Deployment & Rollback SQL Scripts from EntityFrameworkCore migrations

6
Comments
3 min read
introducción a las bases de datos

introducción a las bases de datos

4
Comments 2
2 min read
What is SQL - Part 3

What is SQL - Part 3

4
Comments
6 min read
Using indexes to speed up queries in PostgreSQL

Using indexes to speed up queries in PostgreSQL

6
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
How I Learned to Stop Worrying and Love NULL in SQL

How I Learned to Stop Worrying and Love NULL in SQL

2
Comments
5 min read
Final Ruby on Rails project for Flatiron School

Final Ruby on Rails project for Flatiron School

2
Comments 1
2 min read
What is SQL - Part 2

What is SQL - Part 2

4
Comments
4 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
One WEIRD Trick for Speeding Up ORDER BY That You Probably Shouldn't Use

One WEIRD Trick for Speeding Up ORDER BY That You Probably Shouldn't Use

37
Comments 3
3 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

9
Comments
3 min read
Practical example for Ranking with Window Functions

Practical example for Ranking with Window Functions

5
Comments
2 min read
Compiling MariaDB from Source - On FreeBSD

Compiling MariaDB from Source - On FreeBSD

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

How to Query Multiple Schemas With Postgresql

8
Comments
3 min read
SQL injection cheat sheet

SQL injection cheat sheet

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

Like, so confused...

14
Comments 2
2 min read
Mysql 5.7 Window Functions Workaround

Mysql 5.7 Window Functions Workaround

9
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
TIL PostgreSQL-style $facet

TIL PostgreSQL-style $facet

6
Comments
1 min read
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

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

6
Comments 4
3 min read
Advanced SQL - PostgreSQL

Advanced SQL - PostgreSQL

6
Comments
2 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
SQL 101: How To Select Data From Databases Using SQL

SQL 101: How To Select Data From Databases Using SQL

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

PostgreSQL MATERIALIZED VIEW non-blocking, yet updated frequently

7
Comments 2
1 min read
First steps with SQL

First steps with SQL

2
Comments
3 min read
How can i create a CRON operation to add numbers based on timed events in my database.

How can i create a CRON operation to add numbers based on timed events in my database.

6
Comments
1 min read
Search MySQL Like Google Using Match and Full-Text Search

Search MySQL Like Google Using Match and Full-Text Search

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

Dev life is easy with node-mssql

16
Comments 1
2 min read
Reimagining the SQL Curriculum: Change How SQL is Taught

Reimagining the SQL Curriculum: Change How SQL is Taught

4
Comments
9 min read
Farewell to our Enterprise License

Farewell to our Enterprise License

5
Comments
4 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

94
Comments 5
6 min read
Emacs as SQL client with LSP

Emacs as SQL client with LSP

34
Comments 1
5 min read
SQL Review - How to create an ERD in MySQL

SQL Review - How to create an ERD in MySQL

3
Comments
1 min read
SQLite - a developer's best friend

SQLite - a developer's best friend

27
Comments 6
8 min read
Understanding ActiveRecord left outer joins

Understanding ActiveRecord left outer joins

10
Comments
5 min read
Announcing EFCore.FSharp

Announcing EFCore.FSharp

11
Comments 1
3 min read
How Can i create a Secure SignIn Portal In PHP after Using Password Hash on SignUp Page.

How Can i create a Secure SignIn Portal In PHP after Using Password Hash on SignUp Page.

7
Comments 5
2 min read
SQL tips that will make you productive from day1 at your job.

SQL tips that will make you productive from day1 at your job.

4
Comments
1 min read
Understanding ActiveRecord inner joins

Understanding ActiveRecord inner joins

10
Comments
7 min read
loading...