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.
Mental Model For SQL Joins

Mental Model For SQL Joins

10
Comments 3
1 min read
ERROR: Timed out: BackfillIndex RPC

ERROR: Timed out: BackfillIndex RPC

8
Comments
3 min read
Some Teradata SQL Fun with Dates Differing by Months

Some Teradata SQL Fun with Dates Differing by Months

5
Comments 1
15 min read
Howto handle index key specification without a key length and key was too long

Howto handle index key specification without a key length and key was too long

7
Comments
4 min read
Query compressed logs that are stored in S3 using AWS Athena

Query compressed logs that are stored in S3 using AWS Athena

9
Comments
5 min read
Build a PostgreSQL Docker image with pg_hint_plan and pg_stat_statements

Build a PostgreSQL Docker image with pg_hint_plan and pg_stat_statements

6
Comments
2 min read
Improving performance in a hierarchical SQL table structure with column propagation

Improving performance in a hierarchical SQL table structure with column propagation

5
Comments
9 min read
YugabyteDB Predicate Push Down

YugabyteDB Predicate Push Down

5
Comments
6 min read
Como criar um banco de dados mariaDb com docker

Como criar um banco de dados mariaDb com docker

7
Comments
3 min read
Supabase Custom Claims

Supabase Custom Claims

22
Comments 9
7 min read
1 million rows insert

1 million rows insert

7
Comments
5 min read
🔓 tracing writes and locks in YugabyteDB

🔓 tracing writes and locks in YugabyteDB

6
Comments
6 min read
Parsing YugabyteDB version()

Parsing YugabyteDB version()

6
Comments
2 min read
pg_stat_statements in YugabyteDB

pg_stat_statements in YugabyteDB

6
Comments
2 min read
Is software immortal? And can we hide columns in Postgres?

Is software immortal? And can we hide columns in Postgres?

5
Comments
5 min read
PostgreSQL: An example of using WITH clauses to decompose the problem

PostgreSQL: An example of using WITH clauses to decompose the problem

7
Comments
2 min read
SQL Interview Questions CheatSheet

SQL Interview Questions CheatSheet

9
Comments 2
7 min read
STARTING WITH POSTGRESQL AND VALENTINA STUDIO THROUGH CLI

STARTING WITH POSTGRESQL AND VALENTINA STUDIO THROUGH CLI

7
Comments 1
3 min read
SQL Schema in Django Models

SQL Schema in Django Models

10
Comments
1 min read
In 48 hours, I’ve created License Key APIs using Supabase.

In 48 hours, I’ve created License Key APIs using Supabase.

7
Comments
2 min read
Announcing Atlas Project Files

Announcing Atlas Project Files

9
Comments
3 min read
How To Prevent SQL Injection In PHP: Three Essential Methods

How To Prevent SQL Injection In PHP: Three Essential Methods

14
Comments
4 min read
5 tips to optimize your CQL queries

5 tips to optimize your CQL queries

11
Comments
5 min read
Top 10 SQL Queries asked in Interviews

Top 10 SQL Queries asked in Interviews

11
Comments 2
3 min read
Connect your Java application with any SQL databases

Connect your Java application with any SQL databases

11
Comments
4 min read
"I want to try it" 🚀 YugabyteDB at KubeCon

"I want to try it" 🚀 YugabyteDB at KubeCon

12
Comments
3 min read
Entity Framework Core Add if not exist

Entity Framework Core Add if not exist

6
Comments
1 min read
How to create a View in SQL Server

How to create a View in SQL Server

10
Comments
9 min read
Modelagem Dimensional

Modelagem Dimensional

2
Comments
2 min read
How does Apache ShardingSphere implement distributed transactions?

How does Apache ShardingSphere implement distributed transactions?

4
Comments
8 min read
SQL: One to Many Join Query in an Optimal way with Node.js

SQL: One to Many Join Query in an Optimal way with Node.js

12
Comments 3
4 min read
Xamarin Android: Create Login Using SQLite Database | iFour Technolab

Xamarin Android: Create Login Using SQLite Database | iFour Technolab

6
Comments
5 min read
🐘OID <-> 🚀table_id

🐘OID <-> 🚀table_id

7
Comments
4 min read
SQL vs. NoSQL

SQL vs. NoSQL

17
Comments 9
2 min read
My Brush with Analytics Engineering

My Brush with Analytics Engineering

6
Comments
5 min read
Workout Programmer

Workout Programmer

10
Comments
6 min read
SQL-Quick tip #8 - Finding foreign key constraints

SQL-Quick tip #8 - Finding foreign key constraints

6
Comments
1 min read
SQL Basic - What you need to know! (Basics)

SQL Basic - What you need to know! (Basics)

8
Comments
2 min read
5 Best Public Datasets to Practice Your Data Analysis Skills

5 Best Public Datasets to Practice Your Data Analysis Skills

6
Comments
6 min read
SQL-Quick tip #12 - Available disk space

SQL-Quick tip #12 - Available disk space

5
Comments
2 min read
Think twice before using AGE in PotgreSQL

Think twice before using AGE in PotgreSQL

9
Comments
2 min read
🚀 YugabyteDB on fly.io - I - yugabyted

🚀 YugabyteDB on fly.io - I - yugabyted

14
Comments 2
8 min read
Postgres: Setup & Basics

Postgres: Setup & Basics

5
Comments 2
3 min read
SQL-Quick tip #7 - Find stored procedures

SQL-Quick tip #7 - Find stored procedures

6
Comments
1 min read
How to Use ShardingSphere-Proxy in Real Production Scenarios—Your Quick Start Guide

How to Use ShardingSphere-Proxy in Real Production Scenarios—Your Quick Start Guide

10
Comments
10 min read
SQL-Quick tip #10 - Select table definition

SQL-Quick tip #10 - Select table definition

7
Comments
1 min read
Optimizing database query - In a loop

Optimizing database query - In a loop

9
Comments
2 min read
Lessons learnt from the 8 week sql challenge: window functions & ranking

Lessons learnt from the 8 week sql challenge: window functions & ranking

10
Comments
3 min read
When Disaster Strikes: Production Troubleshooting

When Disaster Strikes: Production Troubleshooting

10
Comments 1
6 min read
MySQL Cheatsheet

MySQL Cheatsheet

10
Comments
8 min read
How Install MySQL and Workbench on Windows

How Install MySQL and Workbench on Windows

6
Comments
3 min read
Instantly query AWS with SQL in CloudShell

Instantly query AWS with SQL in CloudShell

18
Comments
3 min read
SQL-Quick tip #11 - Most intensive queries

SQL-Quick tip #11 - Most intensive queries

10
Comments
2 min read
The difference in the handling of the spaces between Oracle and SQL Server(In the event of linking different DBMS)

The difference in the handling of the spaces between Oracle and SQL Server(In the event of linking different DBMS)

6
Comments
4 min read
How to add SQL editor to your django admin.

How to add SQL editor to your django admin.

10
Comments
8 min read
SQL Basic Cheat Sheet

SQL Basic Cheat Sheet

34
Comments 1
3 min read
Optimiza tu aplicación rails utilizando índices en Postgres

Optimiza tu aplicación rails utilizando índices en Postgres

20
Comments 1
13 min read
🐘🚀 Update/Insert/Soft-Delete from a JSON payload

🐘🚀 Update/Insert/Soft-Delete from a JSON payload

6
Comments
4 min read
Read Committed is a must for Postgres-compatible distributed SQL databases

Read Committed is a must for Postgres-compatible distributed SQL databases

10
Comments
7 min read
The complete guide to System Design in 2022

The complete guide to System Design in 2022

44
Comments
27 min read
loading...