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

7
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

16
Comments 4
3 min read
Concurrent HTTP Call Using SemaphoreSlim in .NET

Concurrent HTTP Call Using SemaphoreSlim in .NET

17
Comments 2
3 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
Python For Beginners

Python For Beginners

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

Arrays in SQL? Yay or Nay?

4
Comments 1
2 min read
🎄JS Advent #5 - Strict vs loose equality🎄

🎄JS Advent #5 - Strict vs loose equality🎄

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

How sql engine handle join internally-part 1

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

Why do SQL Server views need refreshing?

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

OpenAI SQL Query generator with GPT-3 and Nextjs

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

Scalable Job Queue in SQL (YugabyteDB)

21
Comments 3
5 min read
Part Six: Functions

Part Six: Functions

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

How to add a condition in SQL with GROUP BY

8
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
loading...