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

2
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

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

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

How to work with JSON data on SQL Server

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

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

2
Comments
2 min read
C# How to Initialize an Array: 1-d, n-d, and Jagged

C# How to Initialize an Array: 1-d, n-d, and Jagged

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

Monitoring SQL Server Agent Jobs with Spring Batch

6
Comments
4 min read
Advanced Postgres Row Level Security

Advanced Postgres Row Level Security

8
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 sql engine handle join internally - part 2

How sql engine handle join internally - part 2

17
Comments 4
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.