The Wayback Machine - https://web.archive.org/web/20210417210625/https://dev.to/t/sql

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

3 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?

5
8 min read
Improve SQL Performance for Date Range Queries

Improve SQL Performance for Date Range Queries

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

introducción a las bases de datos

3 2
2 min read
What is SQL - Part 3

What is SQL - Part 3

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

Using indexes to speed up queries in PostgreSQL

2
2 min read
Optimistic lock on Ruby on Rails

Optimistic lock on Ruby on Rails

9
3 min read
SQL Review - GROUP BY Query

SQL Review - GROUP BY Query

6 3
2 min read
Introduction to Database Transaction

Introduction to Database Transaction

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

How to spot and fix Django ORM anti-patterns

27
1 min read
What is SQL - Part 2

What is SQL - Part 2

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

K8s on Windows/VirtualBox (and a DB)

6
9 min read
How to access joined data with ActiveRecord

How to access joined data with ActiveRecord

12
5 min read
Postgres Triggers

Postgres Triggers

6
3 min read
Advanced SQL - PostgreSQL

Advanced SQL - PostgreSQL

5
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

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

PostgreSQL MATERIALIZED VIEW non-blocking, yet updated frequently

6
1 min read
SQL injection cheat sheet

SQL injection cheat sheet

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

Creating Deployment & Rollback SQL Scripts from EntityFrameworkCore migrations

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

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

5 4
3 min read
Announcing EFCore.FSharp

Announcing EFCore.FSharp

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

Five classic SQL & database posts - April 2021

16
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

25 2
3 min read
Anatomy of a PostgreSQL Query Plan

Anatomy of a PostgreSQL Query Plan

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

SQL 101: How To Select Data From Databases Using SQL

6
4 min read
Practical example for Ranking with Window Functions

Practical example for Ranking with Window Functions

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

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

2
1 min read
Compiling MariaDB from Source - On FreeBSD

Compiling MariaDB from Source - On FreeBSD

6
2 min read
How to Query Multiple Schemas With Postgresql

How to Query Multiple Schemas With Postgresql

6
3 min read
Like, so confused...

Like, so confused...

8 2
2 min read
Mysql 5.7 Window Functions Workaround

Mysql 5.7 Window Functions Workaround

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

Hackerrak Basic SQL| Sql Questions|| Introduction to SQL

2
7 min read
A Deeper Dive Into SQL

A Deeper Dive Into SQL

4
3 min read
The Wrong Migration

The Wrong Migration

6
3 min read
TIL PostgreSQL-style $facet

TIL PostgreSQL-style $facet

6
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

27
1 min read
What is SQL - Part 1

What is SQL - Part 1

2
3 min read
The Ultimate Hasura Development Setup

The Ultimate Hasura Development Setup

5
3 min read
Understanding multiple joins in ActiveRecord

Understanding multiple joins in ActiveRecord

15
5 min read
Anything I Want With Sequel And Postgres

Anything I Want With Sequel And Postgres

7 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

6
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.

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

SQL & database monthly wrap up - March 2021

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

Search MySQL Like Google Using Match and Full-Text Search

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

Dev life is easy with node-mssql

15 1
2 min read
Home Improvement Database

Home Improvement Database

6 2
4 min read
Farewell to our Enterprise License

Farewell to our Enterprise License

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

Reimagining the SQL Curriculum: Change How SQL is Taught

4
9 min read
Python with MySQL

Python with MySQL

5
7 min read
Let's talk about Views

Let's talk about Views

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

SQL Review - How to create an ERD in MySQL

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

SQLite - a developer's best friend

15 3
8 min read
Emacs as SQL client with LSP

Emacs as SQL client with LSP

9
5 min read
Understanding ActiveRecord left outer joins

Understanding ActiveRecord left outer joins

9
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.

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

SQL Server Management Studio (Professors Example)

7
9 min read
TypeORM - Query Builder with Subquery

TypeORM - Query Builder with Subquery

34 1
5 min read
LINQ Group By

LINQ Group By

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

Five classic SQL & database posts - March 2021

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

11
1 min read
loading...