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.
Advent of Code - Day 4

Advent of Code - Day 4

5
Comments
3 min read
Why Are SQL Databases Outdated for the Real-Time Recommendation Engines

Why Are SQL Databases Outdated for the Real-Time Recommendation Engines

1
Comments
9 min read
Advent of Code - Day 3

Advent of Code - Day 3

4
Comments
6 min read
Types of SQL Joins

Types of SQL Joins

1
Comments
4 min read
INSERT ON CONFLICT returning old values

INSERT ON CONFLICT returning old values

5
Comments
3 min read
How to work with JSON data on SQL Server

How to work with JSON data on SQL Server

8
Comments
4 min read
Handling Duplicate Records

Handling Duplicate Records

4
Comments
3 min read
SQL Macros (aka Parameterized Views) in YugabyteDB with PostgreSQL UDF

SQL Macros (aka Parameterized Views) in YugabyteDB with PostgreSQL UDF

4
Comments
4 min read
SQL 基礎 Part 01 -- PostgreSQL サーバーを docker-compose で起動する

SQL 基礎 Part 01 -- PostgreSQL サーバーを docker-compose で起動する

2
Comments
2 min read
Intro to Postgres Row-Level Security

Intro to Postgres Row-Level Security

17
Comments 2
4 min read
Monitoring SQL Server Agent Jobs with Spring Batch

Monitoring SQL Server Agent Jobs with Spring Batch

7
Comments
4 min read
SQL Cheet Sheat

SQL Cheet Sheat

5
Comments
2 min read
Advanced Postgres Row Level Security

Advanced Postgres Row Level Security

3
Comments
6 min read
How to check if the PostgreSQL tables of the same structure have the identical data using aggregated hash and md5?

How to check if the PostgreSQL tables of the same structure have the identical data using aggregated hash and md5?

4
Comments
2 min read
Advent of Code - Day 10

Advent of Code - Day 10

5
Comments
4 min read
How sql engine handle join internally - part 2

How sql engine handle join internally - part 2

15
Comments 4
3 min read
Forget about migrations and use SQLSugar

Forget about migrations and use SQLSugar

4
Comments
2 min read
SQL Server 2022: Logical Functions - GREATEST & LEAST

SQL Server 2022: Logical Functions - GREATEST & LEAST

3
Comments
1 min read
Database Normalisation

Database Normalisation

27
Comments
4 min read
What is a "truly distributed UDF" ?

What is a "truly distributed UDF" ?

7
Comments
4 min read
Partial Index as an approximate Count(*) Materialized View

Partial Index as an approximate Count(*) Materialized View

2
Comments
3 min read
Arrays in SQL? Yay or Nay?

Arrays in SQL? Yay or Nay?

4
Comments 1
2 min read
Percentage calculations using SQL Window Functions

Percentage calculations using SQL Window Functions

2
Comments
6 min read
MySQL 8: short syntax for select all

MySQL 8: short syntax for select all

6
Comments 1
1 min read
How sql engine handle join internally-part 1

How sql engine handle join internally-part 1

25
Comments 5
3 min read
Why do SQL Server views need refreshing?

Why do SQL Server views need refreshing?

7
Comments 1
2 min read
OpenAI SQL Query generator with GPT-3 and Nextjs

OpenAI SQL Query generator with GPT-3 and Nextjs

9
Comments 1
6 min read
Scalable Job Queue in SQL (YugabyteDB)

Scalable Job Queue in SQL (YugabyteDB)

21
Comments 3
5 min read
How to add a condition in SQL with GROUP BY

How to add a condition in SQL with GROUP BY

6
Comments
1 min read
Advent of Code - Day 2

Advent of Code - Day 2

5
Comments
4 min read
Advent of Code - Day 1

Advent of Code - Day 1

11
Comments 3
4 min read
SQL Join explained!

SQL Join explained!

7
Comments 1
2 min read
Troubleshooting High CPU Utilization in PostgreSQL Databases: A How-To Guide

Troubleshooting High CPU Utilization in PostgreSQL Databases: A How-To Guide

5
Comments
11 min read
What is SQL Injection and How to prevent it?

What is SQL Injection and How to prevent it?

11
Comments 1
10 min read
5 ways to store market data: CSV, SQLite, Postgres, Mongo, Arctic

5 ways to store market data: CSV, SQLite, Postgres, Mongo, Arctic

3
Comments
5 min read
The best indexes for an execution plan that never gets (too) wrong

The best indexes for an execution plan that never gets (too) wrong

2
Comments
15 min read
Using Postgres as a task queue for rowdy Gophers

Using Postgres as a task queue for rowdy Gophers

4
Comments
13 min read
Online PHP & SQL sandbox with ChatGPT support

Online PHP & SQL sandbox with ChatGPT support

8
Comments 4
2 min read
sql-export - create .md / .json files from database content

sql-export - create .md / .json files from database content

2
Comments
2 min read
Free Course - Learn: A Full Stack Application with Azure SQL and Prisma

Free Course - Learn: A Full Stack Application with Azure SQL and Prisma

37
Comments
2 min read
SQL Vs NoSQL

SQL Vs NoSQL

6
Comments
1 min read
PostgreSQL and YugabyteDB partitioning and indexes

PostgreSQL and YugabyteDB partitioning and indexes

4
Comments
7 min read
ANALYSING & VISUALISING DATA With PostgreSQL and Arctype SQL CLIENT

ANALYSING & VISUALISING DATA With PostgreSQL and Arctype SQL CLIENT

7
Comments
4 min read
ClickHouse Fundamentals: Part 2

ClickHouse Fundamentals: Part 2

4
Comments
4 min read
How We Reduced Online Serving Latency from 1.11s to 123.6ms on a Distributed SQL Database

How We Reduced Online Serving Latency from 1.11s to 123.6ms on a Distributed SQL Database

5
Comments
9 min read
sqly - execute SQL against CSV / TSV / LTSV / JSON with shell

sqly - execute SQL against CSV / TSV / LTSV / JSON with shell

5
Comments 1
2 min read
Cloud Scheduler to stop a Cloud SQL database

Cloud Scheduler to stop a Cloud SQL database

4
Comments
4 min read
PostgreSQL do different equality predicates make a difference?

PostgreSQL do different equality predicates make a difference?

9
Comments 2
2 min read
NHOST: AN INTRODUCTION TO BACK-END AS A SERVICE.

NHOST: AN INTRODUCTION TO BACK-END AS A SERVICE.

2
Comments
5 min read
Create Upsert Yourself for Amazon Redshift Databases

Create Upsert Yourself for Amazon Redshift Databases

2
Comments
6 min read
EF Core 7 is here - Welcome typed entity id 🍾

EF Core 7 is here - Welcome typed entity id 🍾

7
Comments 1
5 min read
Deja de escribir código SQL dentro de código Go, ¡la solución está aquí!

Deja de escribir código SQL dentro de código Go, ¡la solución está aquí!

5
Comments
2 min read
YugabyteDB auto-sharding (showing tablet size with Grafana)

YugabyteDB auto-sharding (showing tablet size with Grafana)

4
Comments
8 min read
Eğlenceli SQL Kaynakları 🙂

Eğlenceli SQL Kaynakları 🙂

4
Comments
1 min read
Weather Observation Station 17 Hackerrank Solution

Weather Observation Station 17 Hackerrank Solution

3
Comments
1 min read
Basics of PostgreSQL

Basics of PostgreSQL

9
Comments
2 min read
SQL vs NoSQL

SQL vs NoSQL

14
Comments
4 min read
Apache Spark SQL: CTAS USING CSV with specific delimiter

Apache Spark SQL: CTAS USING CSV with specific delimiter

3
Comments
1 min read
SQL and Table Relationships

SQL and Table Relationships

1
Comments 2
3 min read
Flashback query in YugabyteDB

Flashback query in YugabyteDB

1
Comments
6 min read
loading...