DEV Community

loading...

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

👋 Sign in for the ability sort posts by top and latest.
I analyzed my six years of food deliveries

I analyzed my six years of food deliveries

Reactions 3 Comments 1
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?

Reactions 5 Comments
8 min read
Improve SQL Performance for Date Range Queries

Improve SQL Performance for Date Range Queries

Reactions 2 Comments
2 min read
introducción a las bases de datos

introducción a las bases de datos

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

What is SQL - Part 3

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

Using indexes to speed up queries in PostgreSQL

Reactions 2 Comments
2 min read
Optimistic lock on Ruby on Rails

Optimistic lock on Ruby on Rails

Reactions 9 Comments
3 min read
SQL Review - GROUP BY Query

SQL Review - GROUP BY Query

Reactions 6 Comments 3
2 min read
Introduction to Database Transaction

Introduction to Database Transaction

Reactions 7 Comments
2 min read
How to spot and fix Django ORM anti-patterns 04:55

How to spot and fix Django ORM anti-patterns

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

What is SQL - Part 2

Reactions 5 Comments
4 min read
K8s on Windows/VirtualBox (and a DB)

K8s on Windows/VirtualBox (and a DB)

Reactions 6 Comments
9 min read
How to access joined data with ActiveRecord

How to access joined data with ActiveRecord

Reactions 12 Comments
5 min read
Postgres Triggers

Postgres Triggers

Reactions 6 Comments
3 min read
Advanced SQL - PostgreSQL

Advanced SQL - PostgreSQL

Reactions 5 Comments
2 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

Reactions 2 Comments
1 min read
PostgreSQL MATERIALIZED VIEW non-blocking, yet updated frequently

PostgreSQL MATERIALIZED VIEW non-blocking, yet updated frequently

Reactions 6 Comments
1 min read
SQL injection cheat sheet

SQL injection cheat sheet

Reactions 3 Comments
1 min read
Creating Deployment & Rollback SQL Scripts from EntityFrameworkCore migrations

Creating Deployment & Rollback SQL Scripts from EntityFrameworkCore migrations

Reactions 6 Comments
3 min read
[Facts Alert]When to use which one ?MySQL Vs MongoDB

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

Reactions 5 Comments 4
3 min read
Announcing EFCore.FSharp

Announcing EFCore.FSharp

Reactions 11 Comments 1
3 min read
Five classic SQL & database posts - April 2021

Five classic SQL & database posts - April 2021

Reactions 16 Comments
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

Reactions 25 Comments 2
3 min read
Anatomy of a PostgreSQL Query Plan

Anatomy of a PostgreSQL Query Plan

Reactions 7 Comments
10 min read
SQL 101: How To Select Data From Databases Using SQL

SQL 101: How To Select Data From Databases Using SQL

Reactions 6 Comments
4 min read
Practical example for Ranking with Window Functions

Practical example for Ranking with Window Functions

Reactions 5 Comments
2 min read
osquery – SQL powered operating system instrumentation, monitoring, and analytics framework

osquery – SQL powered operating system instrumentation, monitoring, and analytics framework

Reactions 2 Comments
1 min read
Compiling MariaDB from Source - On FreeBSD

Compiling MariaDB from Source - On FreeBSD

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

How to Query Multiple Schemas With Postgresql

Reactions 6 Comments
3 min read
Like, so confused...

Like, so confused...

Reactions 8 Comments 2
2 min read
Mysql 5.7 Window Functions Workaround

Mysql 5.7 Window Functions Workaround

Reactions 7 Comments
3 min read
Hackerrak Basic SQL| Sql Questions|| Introduction to SQL

Hackerrak Basic SQL| Sql Questions|| Introduction to SQL

Reactions 2 Comments
7 min read
A Deeper Dive Into SQL

A Deeper Dive Into SQL

Reactions 4 Comments
3 min read
The Wrong Migration

The Wrong Migration

Reactions 6 Comments
3 min read
TIL PostgreSQL-style $facet

TIL PostgreSQL-style $facet

Reactions 6 Comments
1 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

Reactions 27 Comments
1 min read
What is SQL - Part 1

What is SQL - Part 1

Reactions 2 Comments
3 min read
The Ultimate Hasura Development Setup

The Ultimate Hasura Development Setup

Reactions 5 Comments
3 min read
Understanding multiple joins in ActiveRecord

Understanding multiple joins in ActiveRecord

Reactions 15 Comments
5 min read
Anything I Want With Sequel And Postgres

Anything I Want With Sequel And Postgres

Reactions 7 Comments 1
7 min read
EXPLAIN Like I'm Five: Five ways to run EXPLAIN on your Rails database queries

EXPLAIN Like I'm Five: Five ways to run EXPLAIN on your Rails database queries

Reactions 6 Comments
4 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.

Reactions 6 Comments
1 min read
SQL & database monthly wrap up - March 2021

SQL & database monthly wrap up - March 2021

Reactions 30 Comments 1
2 min read
Search MySQL Like Google Using Match and Full-Text Search

Search MySQL Like Google Using Match and Full-Text Search

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

Dev life is easy with node-mssql

Reactions 15 Comments 1
2 min read
Home Improvement Database

Home Improvement Database

Reactions 6 Comments 2
4 min read
Farewell to our Enterprise License

Farewell to our Enterprise License

Reactions 5 Comments
4 min read
Reimagining the SQL Curriculum: Change How SQL is Taught

Reimagining the SQL Curriculum: Change How SQL is Taught

Reactions 4 Comments
9 min read
Python with MySQL

Python with MySQL

Reactions 5 Comments
7 min read
Let's talk about Views

Let's talk about Views

Reactions 5 Comments
2 min read
SQL Review - How to create an ERD in MySQL

SQL Review - How to create an ERD in MySQL

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

SQLite - a developer's best friend

Reactions 15 Comments 3
8 min read
Emacs as SQL client with LSP

Emacs as SQL client with LSP

Reactions 9 Comments
5 min read
Understanding ActiveRecord left outer joins

Understanding ActiveRecord left outer joins

Reactions 9 Comments
5 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.

Reactions 7 Comments 5
2 min read
SQL Server Management Studio (Professors Example)

SQL Server Management Studio (Professors Example)

Reactions 7 Comments
9 min read
TypeORM - Query Builder with Subquery

TypeORM - Query Builder with Subquery

Reactions 34 Comments 1
5 min read
LINQ Group By

LINQ Group By

Reactions 1 Comments
1 min read
Five classic SQL & database posts - March 2021

Five classic SQL & database posts - March 2021

Reactions 25 Comments
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.

Reactions 11 Comments
1 min read
loading...