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.
Different Types of SQL JOINs

Different Types of SQL JOINs

6
Comments 2
2 min read
Get The Most Out of Your Postgres Database with SeeQR

Get The Most Out of Your Postgres Database with SeeQR

2
Comments
4 min read
Window Functions, Visualized - Rankings

Window Functions, Visualized - Rankings

4
Comments
3 min read
Backup Postgres to S3

Backup Postgres to S3

19
Comments 6
1 min read
Faster SQL Bulk Inserts With C#

Faster SQL Bulk Inserts With C#

15
Comments 2
8 min read
Sort by timestamps (month and year) in PostgreSQL

Sort by timestamps (month and year) in PostgreSQL

7
Comments
1 min read
Assembling a query optimizer with Apache Calcite

Assembling a query optimizer with Apache Calcite

6
Comments
9 min read
How to parse Time in GOLANG work with SQL.

How to parse Time in GOLANG work with SQL.

14
Comments 4
2 min read
Window Function Calls in Postgres - a Visual Introduction

Window Function Calls in Postgres - a Visual Introduction

7
Comments
4 min read
Online Laravel migration!

Online Laravel migration!

5
Comments
1 min read
REDIS: NOSQL DBS

REDIS: NOSQL DBS

3
Comments
1 min read
Mastering your SQL commands (Part 2)

Mastering your SQL commands (Part 2)

19
Comments
3 min read
Who has ever integrated SQLITE3 with Django?, in Jupyterlab?

Who has ever integrated SQLITE3 with Django?, in Jupyterlab?

2
Comments
1 min read
The SQL Savant: Outer Joins in SQL

The SQL Savant: Outer Joins in SQL

9
Comments
3 min read
RDBMS Concept

RDBMS Concept

3
Comments
2 min read
SQL Concepts

SQL Concepts

3
Comments
1 min read
Becoming a SQL Guru with Recursive CTEs

Becoming a SQL Guru with Recursive CTEs

5
Comments
5 min read
Linq2DB CRUD Operations

Linq2DB CRUD Operations

7
Comments
2 min read
Mastering your SQL commands (Part 1)

Mastering your SQL commands (Part 1)

31
Comments
4 min read
Postman vs Sqlite3

Postman vs Sqlite3

2
Comments 2
1 min read
Working with geospatial data in Postgres.

Working with geospatial data in Postgres.

15
Comments
3 min read
Save Money and Frustration on Amazon using Azure Functions

Save Money and Frustration on Amazon using Azure Functions

28
Comments 4
26 min read
EF or Dapper?

EF or Dapper?

2
Comments 8
1 min read
Rails N+1 queries and eager loading

Rails N+1 queries and eager loading

46
Comments 10
3 min read
SQL & Databases

SQL & Databases

4
Comments
1 min read
SQL Aggregate Product

SQL Aggregate Product

6
Comments
1 min read
I've published my first WordPress plugin!

I've published my first WordPress plugin!

5
Comments
2 min read
Make table and index creation faster in a multi-region CockroachDB environment

Make table and index creation faster in a multi-region CockroachDB environment

12
Comments
2 min read
Django: makemigrations and migrate

Django: makemigrations and migrate

5
Comments 2
1 min read
Filtering Data with SQL

Filtering Data with SQL

5
Comments
4 min read
SQL queries I wish I'd known when I started in data. Part 1: the event funnel.

SQL queries I wish I'd known when I started in data. Part 1: the event funnel.

13
Comments
7 min read
5 Reasons to Choose NoSQL Databases

5 Reasons to Choose NoSQL Databases

2
Comments
4 min read
What's a best way to visualize Postgres schema?

What's a best way to visualize Postgres schema?

3
Comments 1
1 min read
PostgreSQL Foreign Data Wrapper tutorial

PostgreSQL Foreign Data Wrapper tutorial

2
Comments
2 min read
SQL vs NoSQL

SQL vs NoSQL

6
Comments 1
2 min read
Go further with Airtable using Postgres Arrays

Go further with Airtable using Postgres Arrays

9
Comments
8 min read
Azure Datafactory pricing simplified

Azure Datafactory pricing simplified

5
Comments
4 min read
Database Normalizarion

Database Normalizarion

8
Comments 1
3 min read
Run PostgreSQL + PGAdmin in pods using podman

Run PostgreSQL + PGAdmin in pods using podman

17
Comments 1
3 min read
Database Design and the GDPR

Database Design and the GDPR

31
Comments 7
3 min read
Use mycli and Learn MariaDB/MySQL comfortably in a terminal!

Use mycli and Learn MariaDB/MySQL comfortably in a terminal!

5
Comments
5 min read
The Future Of Data Science, Data Engineering And Tech: 6 Experts Views On Tech In 2021

The Future Of Data Science, Data Engineering And Tech: 6 Experts Views On Tech In 2021

9
Comments
7 min read
Filter records in a many to many relationship in rails

Filter records in a many to many relationship in rails

9
Comments
2 min read
Weekly Update #004

Weekly Update #004

4
Comments
1 min read
SQL Injection

SQL Injection

4
Comments
2 min read
SQL Tip - Weird Behaviour of SUM or any operator When joining more than 2 tables

SQL Tip - Weird Behaviour of SUM or any operator When joining more than 2 tables

4
Comments 1
1 min read
Don't miss this Data for Good panel at MS Create: Data

Don't miss this Data for Good panel at MS Create: Data

16
Comments 1
1 min read
UPDATE … FROM for database normalisation

UPDATE … FROM for database normalisation

6
Comments
1 min read
Move your sql database files to a separate hard drive

Move your sql database files to a separate hard drive

6
Comments
3 min read
Example of Stored Procedures in PostgreSQL

Example of Stored Procedures in PostgreSQL

11
Comments 1
2 min read
Built in String Functions in SQL

Built in String Functions in SQL

5
Comments
2 min read
Autoscaling Azure SQL Hyperscale

Autoscaling Azure SQL Hyperscale

9
Comments
10 min read
DB Administration tools on Linux

DB Administration tools on Linux

4
Comments 2
1 min read
Convert user story of a simple library to ER and Relational diagrams in less than 10mins

Convert user story of a simple library to ER and Relational diagrams in less than 10mins

20
Comments 2
2 min read
Supabase: nine months of building. 03:00

Supabase: nine months of building.

44
Comments 6
2 min read
Advent Of Code 2020 in SQL - Day 1: "Report Repair"

Advent Of Code 2020 in SQL - Day 1: "Report Repair"

2
Comments
4 min read
DRYing up Rails Scopes and Instance Methods

DRYing up Rails Scopes and Instance Methods

5
Comments
4 min read
Custom SQLite that did exactly what creator wanted? (Beyond default drivers, e.g. extensions / custom build)

Custom SQLite that did exactly what creator wanted? (Beyond default drivers, e.g. extensions / custom build)

2
Comments
1 min read
Office Hours With A Data Consultant To Develop Your Data Analytics Strategy For 2021

Office Hours With A Data Consultant To Develop Your Data Analytics Strategy For 2021

5
Comments
8 min read
Querying JSON and its nested objects with TSQL

Querying JSON and its nested objects with TSQL

6
Comments 1
2 min read
loading...