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.
Database indexing and selectivity

Database indexing and selectivity

2
Comments
1 min read
Practical Experiments for Optimizing Django query with the power of SQL joins

Practical Experiments for Optimizing Django query with the power of SQL joins

5
Comments
7 min read
Order-based Merge Join

Order-based Merge Join

5
Comments
6 min read
How to setup MySql on MacOS using Brew.

How to setup MySql on MacOS using Brew.

Comments
1 min read
Relational Databases: PostgreSQL Vs. MariaDB Vs. MySQL Vs. SQLite

Relational Databases: PostgreSQL Vs. MariaDB Vs. MySQL Vs. SQLite

14
Comments 4
12 min read
Server-side cache for YugabyteDB sequences to workaround the Nspgl `DISCARD SEQUENCES`

Server-side cache for YugabyteDB sequences to workaround the Nspgl `DISCARD SEQUENCES`

2
Comments
4 min read
Dapper mappings, which is best?

Dapper mappings, which is best?

7
Comments 4
2 min read
From GUI to CLI: Transforming my query workflow with usql and jq

From GUI to CLI: Transforming my query workflow with usql and jq

2
Comments 1
3 min read
Inside SQL Joins

Inside SQL Joins

2
Comments
4 min read
Populating a table in PostgreSQL with one million records of random data.

Populating a table in PostgreSQL with one million records of random data.

2
Comments
1 min read
The ARRAY_TO_STRING() function in PostgreSQL

The ARRAY_TO_STRING() function in PostgreSQL

Comments
2 min read
The main methods of joining tables in PostgreSQL.

The main methods of joining tables in PostgreSQL.

Comments
3 min read
More foreign-key joins

More foreign-key joins

6
Comments
5 min read
Oracle SQL vs MySQL: A Comprehensive Comparison

Oracle SQL vs MySQL: A Comprehensive Comparison

2
Comments
3 min read
Mastering Oracle SQL Interview Questions: Tips and Answers

Mastering Oracle SQL Interview Questions: Tips and Answers

2
Comments
2 min read
Multi-Tenant SaaS Architecture - Database Per Tenant

Multi-Tenant SaaS Architecture - Database Per Tenant

3
Comments 1
6 min read
Crash on clock skew: performance vs availability

Crash on clock skew: performance vs availability

2
Comments
7 min read
Fetching Data (Next.js)

Fetching Data (Next.js)

1
Comments
2 min read
Foreign-key pre-join

Foreign-key pre-join

6
Comments
5 min read
⚡️ Gowebly CLI now supports the PocketBase framework

⚡️ Gowebly CLI now supports the PocketBase framework

7
Comments 1
2 min read
Introdução aos Princípios do SQL: Fundamentos Teóricos e Práticos

Introdução aos Princípios do SQL: Fundamentos Teóricos e Práticos

7
Comments
17 min read
OLAP: CUBE, ROLLUP, AND GROUPING SETS

OLAP: CUBE, ROLLUP, AND GROUPING SETS

5
Comments 1
4 min read
Final association query solution

Final association query solution

5
Comments
4 min read
Advisory/Custom/Application Lock with YugabyteDB

Advisory/Custom/Application Lock with YugabyteDB

Comments
5 min read
Journey to modern databases

Journey to modern databases

Comments
9 min read
loading...