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.
IvorySQL - I've tested some Oracle-PostgreSQL compatibility of version 2.1

IvorySQL - I've tested some Oracle-PostgreSQL compatibility of version 2.1

Comments
10 min read
SQL 基礎 Part 03 -- docker-compose で立てたコンテナで立ち上げ時に DB と全権力ユーザーを作成して、外部からログインする

SQL 基礎 Part 03 -- docker-compose で立てたコンテナで立ち上げ時に DB と全権力ユーザーを作成して、外部からログインする

Comments
2 min read
'; SQL_Injection ( ) ;--

'; SQL_Injection ( ) ;--

6
Comments 2
7 min read
Working with Azure SQL Triggers in Azure Functions

Working with Azure SQL Triggers in Azure Functions

16
Comments 3
7 min read
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

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

How to work with JSON data on SQL Server

10
Comments
4 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
Advanced Postgres Row Level Security

Advanced Postgres Row Level Security

6
Comments
6 min read
SQL extensions for time series data in QuestDB part II

SQL extensions for time series data in QuestDB part II

8
Comments
8 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

2
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
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

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

Why do SQL Server views need refreshing?

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

OpenAI SQL Query generator with GPT-3 and Nextjs

13
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

8
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

30
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

5
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
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
Weather Observation Station 17 Hackerrank Solution

Weather Observation Station 17 Hackerrank Solution

3
Comments
1 min read
SQL vs NoSQL

SQL vs NoSQL

14
Comments
4 min read
Basics of PostgreSQL

Basics of PostgreSQL

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