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.
Beyond ORM and Stored Procedures

Beyond ORM and Stored Procedures

2
Comments
12 min read
SQL cheat sheet/crash course

SQL cheat sheet/crash course

8
Comments
4 min read
Mapping your AWS attack surface

Mapping your AWS attack surface

8
Comments
6 min read
Playing Window Function in Postgres

Playing Window Function in Postgres

Comments
4 min read
Open-source SPL that can execute SQL without RDB

Open-source SPL that can execute SQL without RDB

Comments
11 min read
How SQL engine implement the isolation levels in MySQL

How SQL engine implement the isolation levels in MySQL

9
Comments
3 min read
To SQL or to NoSQL (with a simple NoSQL Example)

To SQL or to NoSQL (with a simple NoSQL Example)

6
Comments
11 min read
Data Segregation with PostgreSQL

Data Segregation with PostgreSQL

2
Comments
9 min read
TOP 5 WEBSITES TO LEARN SQL

TOP 5 WEBSITES TO LEARN SQL

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

SQL extensions for time series data in QuestDB part II

7
Comments
8 min read
Create an SQL Report API in 5 minutes

Create an SQL Report API in 5 minutes

1
Comments 2
2 min read
Building Streaming Applications with Cloudera SQL StreamBuilder and Apache Pulsar

Building Streaming Applications with Cloudera SQL StreamBuilder and Apache Pulsar

5
Comments
5 min read
A very short demo on updates in YugabyteDB

A very short demo on updates in YugabyteDB

1
Comments
3 min read
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
Goodbye, Stored Procedures - the Love/Hate Thing

Goodbye, Stored Procedures - the Love/Hate Thing

3
Comments
12 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

9
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

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

4
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

27
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

6
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

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