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.
Set-oriented Syntax – Using SQL as an Example

Set-oriented Syntax – Using SQL as an Example

6
Comments 1
4 min read
Configuring Delete Behaviour for One to Many Related Objects in SQLAlchemy 2.0

Configuring Delete Behaviour for One to Many Related Objects in SQLAlchemy 2.0

Comments
1 min read
Isolation Levels - part VIII: Cursor Stability

Isolation Levels - part VIII: Cursor Stability

3
Comments
1 min read
Views, Sequences e Synonyms: Um tutorial prático

Views, Sequences e Synonyms: Um tutorial prático

6
Comments
7 min read
SQL - Joins (Tutorial Prático)

SQL - Joins (Tutorial Prático)

Comments 1
8 min read
Quick 📸 on 🐘 wait events from pg_stat_activity

Quick 📸 on 🐘 wait events from pg_stat_activity

6
Comments
2 min read
Triggers

Triggers

Comments
2 min read
Type-safe Data Access in Go using Prisma and sqlc

Type-safe Data Access in Go using Prisma and sqlc

13
Comments 5
5 min read
Level UP your RDBMS Productivity in GO

Level UP your RDBMS Productivity in GO

8
Comments
11 min read
Use SQL without Databases

Use SQL without Databases

18
Comments 8
9 min read
The Top 10 GitHub Repositories Making Waves 🌊📊

The Top 10 GitHub Repositories Making Waves 🌊📊

87
Comments 8
4 min read
Isolation Levels - part VII: Repeatable Read

Isolation Levels - part VII: Repeatable Read

6
Comments
3 min read
Isolation Levels - part VI: Snapshot Isolation

Isolation Levels - part VI: Snapshot Isolation

Comments
2 min read
Oracle Database - Dynamic Stale Stats Utility for ETL Databases

Oracle Database - Dynamic Stale Stats Utility for ETL Databases

Comments
3 min read
Yet Another Newsletter LOL: Const is the GOAT

Yet Another Newsletter LOL: Const is the GOAT

9
Comments 3
4 min read
Desvendando o Potencial da Função COUNT no SQL

Desvendando o Potencial da Função COUNT no SQL

2
Comments
4 min read
Elevate Your Software Engineering Career: The Impact of Learning SQL and SQLAlchemy for Personal Projects

Elevate Your Software Engineering Career: The Impact of Learning SQL and SQLAlchemy for Personal Projects

Comments
3 min read
Intro to PostgreSQL

Intro to PostgreSQL

1
Comments
3 min read
Isolation Levels - part V: Read Only

Isolation Levels - part V: Read Only

3
Comments 1
3 min read
Simplifying Dynamic SQL Queries with Dapper

Simplifying Dynamic SQL Queries with Dapper

1
Comments
7 min read
Set up and configure an Azure SQL Database

Set up and configure an Azure SQL Database

Comments
2 min read
Isolation Levels - part IV: Serializable

Isolation Levels - part IV: Serializable

1
Comments
3 min read
Generating Dynamic Breadcrumb Menus Using Tree Table & Recursive CTE

Generating Dynamic Breadcrumb Menus Using Tree Table & Recursive CTE

3
Comments
4 min read
Introduction to Relational Databases

Introduction to Relational Databases

2
Comments
2 min read
Story of an SQL query ~10x speed-up with a simple tweak

Story of an SQL query ~10x speed-up with a simple tweak

1
Comments 1
13 min read
loading...