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.
Using Indexes in MySQL

Using Indexes in MySQL

4
Comments 1
4 min read
EXPLAIN from pg_stat_statements normalized queries: how to always get the generic plan in 🐘&🚀

EXPLAIN from pg_stat_statements normalized queries: how to always get the generic plan in 🐘&🚀

9
Comments 2
6 min read
How can I avoid multiple deduction from stocks in my SQL db in php while loop?

How can I avoid multiple deduction from stocks in my SQL db in php while loop?

7
Comments
2 min read
Apache PySpark for Data Engineering

Apache PySpark for Data Engineering

12
Comments 4
9 min read
UNPIVOT to key-value pair in Oracle SQL

UNPIVOT to key-value pair in Oracle SQL

1
Comments
1 min read
Stuck in SQL query

Stuck in SQL query

6
Comments 4
2 min read
MySQL Queries: Basics of MySQL

MySQL Queries: Basics of MySQL

13
Comments
9 min read
Book summary: SQL Antipatterns

Book summary: SQL Antipatterns

5
Comments 1
9 min read
Data Tokenization in Snowflake

Data Tokenization in Snowflake

1
Comments
9 min read
SQL Server Query Optimizer. And how it can hang your business.

SQL Server Query Optimizer. And how it can hang your business.

3
Comments
8 min read
Expect the unexpected...

Expect the unexpected...

1
Comments
5 min read
My first CRUD in Python without ORM

My first CRUD in Python without ORM

3
Comments
4 min read
Read local partition first, then global if not found locally

Read local partition first, then global if not found locally

5
Comments
7 min read
Django eficiente - select_related

Django eficiente - select_related

Comments
3 min read
how to search jsonb column in Postgresql ( not nested column )

how to search jsonb column in Postgresql ( not nested column )

5
Comments 2
1 min read
Is it possible to reference one column as multiple foreign keys? ( PostgreSQL )

Is it possible to reference one column as multiple foreign keys? ( PostgreSQL )

6
Comments 5
1 min read
SQL Injection Hacker Challenge

SQL Injection Hacker Challenge

1
Comments
3 min read
MariaDB Quick-tip #8 - All foreign key constraints

MariaDB Quick-tip #8 - All foreign key constraints

4
Comments
1 min read
The Principle of Apache Doris SQL Parsing

The Principle of Apache Doris SQL Parsing

Comments
13 min read
Now AWS supports setting up connectivity between your RDS database and EC2 compute instance in 1-click

Now AWS supports setting up connectivity between your RDS database and EC2 compute instance in 1-click

6
Comments
2 min read
How Would You Make It: Efficient and optimized way of tracking unread message per user

How Would You Make It: Efficient and optimized way of tracking unread message per user

1
Comments 5
5 min read
pg_hint_plan with subqueries

pg_hint_plan with subqueries

2
Comments
4 min read
Cost Explorer Isn't the Answer

Cost Explorer Isn't the Answer

1
Comments
6 min read
MariaDd Quick-tip #10 - Select table definition

MariaDd Quick-tip #10 - Select table definition

Comments 2
2 min read
O que é ORM - Mapeamento objeto-relacional

O que é ORM - Mapeamento objeto-relacional

5
Comments
2 min read
Calculate average delta change in KPIs over a period of time.

Calculate average delta change in KPIs over a period of time.

1
Comments
2 min read
Data Engineering 101:Introduction to Data Engineering

Data Engineering 101:Introduction to Data Engineering

4
Comments
3 min read
Online SQL Client for low code data management

Online SQL Client for low code data management

5
Comments 1
5 min read
SQL - Foundation of Databases

SQL - Foundation of Databases

1
Comments
5 min read
ActiveRecord (a Ruby gem): Common Methods

ActiveRecord (a Ruby gem): Common Methods

Comments
4 min read
Parallelizing aggregates in YugabyteDB

Parallelizing aggregates in YugabyteDB

2
Comments
4 min read
Introduction to data engineering

Introduction to data engineering

5
Comments
4 min read
New in Entity Framework 7: Bulk Operations with ExecuteDelete and ExecuteUpdate

New in Entity Framework 7: Bulk Operations with ExecuteDelete and ExecuteUpdate

8
Comments 2
5 min read
Adding business days to a date using SQL

Adding business days to a date using SQL

8
Comments 3
1 min read
Databases: SQL vs NoSQL

Databases: SQL vs NoSQL

4
Comments
6 min read
How to configure Azure SQL Always Encrypted for Mac users

How to configure Azure SQL Always Encrypted for Mac users

Comments
9 min read
Using Rails Model or SQL query in Ruby On Rails

Using Rails Model or SQL query in Ruby On Rails

3
Comments
1 min read
Find the Retention Rates – Salesforce SQL Interview Question

Find the Retention Rates – Salesforce SQL Interview Question

2
Comments
7 min read
Write your first QueryBuilder with PDO and PHP

Write your first QueryBuilder with PDO and PHP

9
Comments 1
7 min read
The Mystery of RDS Costs

The Mystery of RDS Costs

9
Comments 1
5 min read
DistSQL Applications: Building a Dynamic Distributed Database

DistSQL Applications: Building a Dynamic Distributed Database

5
Comments
9 min read
Freelancing or Part time job in Data Analysis or Visualisation

Freelancing or Part time job in Data Analysis or Visualisation

6
Comments
1 min read
MySQL

MySQL

1
Comments
3 min read
Forget SQL, All My Homies Use LINQ

Forget SQL, All My Homies Use LINQ

22
Comments 1
2 min read
MongoDB $weeklyUpdate #82 (August 12, 2022): Community Cafe, Atlas Search, & International MUGs!

MongoDB $weeklyUpdate #82 (August 12, 2022): Community Cafe, Atlas Search, & International MUGs!

6
Comments
3 min read
3 Ways of Integrating Python With SQL Server Every Data Professional Should Know About

3 Ways of Integrating Python With SQL Server Every Data Professional Should Know About

10
Comments
4 min read
Finding mean, median, and mode using SQL.

Finding mean, median, and mode using SQL.

9
Comments
2 min read
Bookmarklet for YugabyteDB table's tablets

Bookmarklet for YugabyteDB table's tablets

4
Comments
2 min read
SQL DB Backup with PowerShell GUI - Tutorial

SQL DB Backup with PowerShell GUI - Tutorial

5
Comments
9 min read
Understanding INNER, OUTER, LEFT, and RIGHT Joins in SQL

Understanding INNER, OUTER, LEFT, and RIGHT Joins in SQL

6
Comments
11 min read
SQL Injections Explained

SQL Injections Explained

8
Comments 1
5 min read
Visual Studio Database Project and Always Encrypted

Visual Studio Database Project and Always Encrypted

7
Comments
4 min read
Insert and query jsonb in rails and postgres

Insert and query jsonb in rails and postgres

18
Comments 2
8 min read
Predicting Supermarket Future Sales Using Machine Learning with MindsDB.

Predicting Supermarket Future Sales Using Machine Learning with MindsDB.

3
Comments
6 min read
Exploratory Data Analysis Using SQL.

Exploratory Data Analysis Using SQL.

56
Comments 2
3 min read
Codewars Challenge Day 5: JS, Python + SQL and PHP

Codewars Challenge Day 5: JS, Python + SQL and PHP

5
Comments
2 min read
Update & delete JSONB in rails and postgres

Update & delete JSONB in rails and postgres

16
Comments
8 min read
Oracle TO_DATE Function - Complete Guide

Oracle TO_DATE Function - Complete Guide

3
Comments
3 min read
Joins In SQL Server mesameergaikwad

Joins In SQL Server mesameergaikwad

6
Comments
1 min read
TypeORM unique indices with multiple fields

TypeORM unique indices with multiple fields

6
Comments 4
2 min read
loading...