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.
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
Include API Key In HTTP Requests

Include API Key In HTTP Requests

10
Comments 4
3 min read
SQL Join explained!

SQL Join explained!

7
Comments 1
2 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
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
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
Online PHP & SQL sandbox with ChatGPT support

Online PHP & SQL sandbox with ChatGPT support

62
Comments 6
2 min read
How to configure WordPress in Nextjs using REST API

How to configure WordPress in Nextjs using REST API

1
Comments
4 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
PostgreSQL and YugabyteDB partitioning and indexes

PostgreSQL and YugabyteDB partitioning and indexes

4
Comments
7 min read
loading...