DEV Community

Database

Posts on building, using, and learning about databases.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
How to Set Up Postgres Using Docker

How to Set Up Postgres Using Docker

10
Comments
1 min read
GBASE数据库 | Introduction to GBase 8a MPP Cluster Data Loading and Performance Tuning

GBASE数据库 | Introduction to GBase 8a MPP Cluster Data Loading and Performance Tuning

5
Comments
7 min read
Understanding SQL Subqueries and Common Table Expressions (CTEs)

Understanding SQL Subqueries and Common Table Expressions (CTEs)

Comments
4 min read
Geolocation in web apps made easy with haversine

Geolocation in web apps made easy with haversine

1
Comments
4 min read
GBASE数据库 | Detailed Guide to Using the ontape Tool for Backup and Recovery in GBase 8s Database

GBASE数据库 | Detailed Guide to Using the ontape Tool for Backup and Recovery in GBase 8s Database

5
Comments
10 min read
Leveraging Python's Pattern Matching and Comprehensions for Data Analytics

Leveraging Python's Pattern Matching and Comprehensions for Data Analytics

Comments
12 min read
Why Should I use Nosql?

Why Should I use Nosql?

Comments
1 min read
System Design 01 - Data Storage: Pick Your Poison Wisely

System Design 01 - Data Storage: Pick Your Poison Wisely

Comments
2 min read
How to Document Your Database with a GUI Tool

How to Document Your Database with a GUI Tool

Comments 2
8 min read
Should We Rethink About IDs? A Deep Dive into "Snowflake IDs"

Should We Rethink About IDs? A Deep Dive into "Snowflake IDs"

Comments
4 min read
Pagination in raw SQL with OFFSET

Pagination in raw SQL with OFFSET

Comments
5 min read
Desvendando o Atlas: Gerencie Seus Esquemas de Banco de Dados com Estilo🚀

Desvendando o Atlas: Gerencie Seus Esquemas de Banco de Dados com Estilo🚀

2
Comments
2 min read
Duckdb — O novo banco de dados dos Big Data

Duckdb — O novo banco de dados dos Big Data

6
Comments 1
5 min read
Avoiding Connection Pinning in Lambda and RDS Proxy with NestJS and Proxy Splitting

Avoiding Connection Pinning in Lambda and RDS Proxy with NestJS and Proxy Splitting

1
Comments
3 min read
Deploying a MongoDB Collection Generator on Kubernetes

Deploying a MongoDB Collection Generator on Kubernetes

Comments
3 min read
Data structures and algorithms | Algorithms | DSA

Data structures and algorithms | Algorithms | DSA

Comments
3 min read
Mastering MySQL Views

Mastering MySQL Views

Comments
6 min read
Architecting Your Own Database - Part 1

Architecting Your Own Database - Part 1

Comments
4 min read
Understanding and Using Window Functions in SQL

Understanding and Using Window Functions in SQL

Comments
1 min read
GBASE数据库 | GBase 8c 500 Primary-Standby Maintenance: Common Issues and Solutions

GBASE数据库 | GBase 8c 500 Primary-Standby Maintenance: Common Issues and Solutions

5
Comments
2 min read
Data Modeling - Entities and Events

Data Modeling - Entities and Events

Comments
6 min read
Speeding Up Foreign Key Constraints During Migrations

Speeding Up Foreign Key Constraints During Migrations

Comments
4 min read
How indexes power your database

How indexes power your database

3
Comments
4 min read
Top 🐘👀 Postgres Monitoring Tools 🧰 and Best Practices in 2024 🔝

Top 🐘👀 Postgres Monitoring Tools 🧰 and Best Practices in 2024 🔝

5
Comments
4 min read
Essential SQL Database Security Practices to Protect Your Data

Essential SQL Database Security Practices to Protect Your Data

Comments
4 min read
Understanding and Optimizing AWS RDS Performance Using Performance Insights

Understanding and Optimizing AWS RDS Performance Using Performance Insights

Comments
3 min read
Automating PostgreSQL Table Monitoring with Bash

Automating PostgreSQL Table Monitoring with Bash

Comments
4 min read
Seeders no Lithe: Preenchendo seu Banco de Dados Facilmente

Seeders no Lithe: Preenchendo seu Banco de Dados Facilmente

Comments
2 min read
📚 Understand More About RDBMS and NoSQL Through Analyzing PostgreSQL and MongoDB

📚 Understand More About RDBMS and NoSQL Through Analyzing PostgreSQL and MongoDB

1
Comments
12 min read
How to you collect data about your app?

How to you collect data about your app?

Comments
1 min read
SQL Server: Usare l'Istruzione LIKE all'Interno di una WHERE

SQL Server: Usare l'Istruzione LIKE all'Interno di una WHERE

Comments
3 min read
SQL Indexes

SQL Indexes

Comments
3 min read
Introduction to DBMS

Introduction to DBMS

Comments
4 min read
SQL "SELECT INTO" vs "INSERT INTO SELECT" statements.

SQL "SELECT INTO" vs "INSERT INTO SELECT" statements.

Comments
1 min read
How to implement CREATE TABLE IF NOT EXISTS in Oracle

How to implement CREATE TABLE IF NOT EXISTS in Oracle

Comments
3 min read
How Pipe Syntax Fix SQL Design Problems

How Pipe Syntax Fix SQL Design Problems

Comments
5 min read
Real-Time Processing of Big Data: Tools and Best Practices

Real-Time Processing of Big Data: Tools and Best Practices

Comments
9 min read
Identifying Unused Indexes in PostgreSQL: A Bash Script Solution

Identifying Unused Indexes in PostgreSQL: A Bash Script Solution

Comments
4 min read
Procedure vs Function | PLSQL

Procedure vs Function | PLSQL

1
Comments
2 min read
📛Stop Hardcoding Database Calls: Simplify with a Config Manager

📛Stop Hardcoding Database Calls: Simplify with a Config Manager

1
Comments
4 min read
Why Doesn't Postgres Use My Index

Why Doesn't Postgres Use My Index

Comments
16 min read
A CDC Way to Sync Data from ElasticSearch to ElasticSearch with BladePipe

A CDC Way to Sync Data from ElasticSearch to ElasticSearch with BladePipe

2
Comments
4 min read
Connecting to a MySQL Database in PHP

Connecting to a MySQL Database in PHP

Comments
4 min read
How To Manage EF Core DbContext Lifetime

How To Manage EF Core DbContext Lifetime

Comments
4 min read
How to Query CSV Files with SQLite

How to Query CSV Files with SQLite

Comments
8 min read
What Are Stored Procedures?

What Are Stored Procedures?

Comments
8 min read
Graph Databases Are So Cool, Use neo4j

Graph Databases Are So Cool, Use neo4j

Comments
3 min read
Simple Ways to Identify the MySQL Port

Simple Ways to Identify the MySQL Port

1
Comments
2 min read
Preventing Duplicate Requests in Laravel: The AtomicLockMiddleware

Preventing Duplicate Requests in Laravel: The AtomicLockMiddleware

Comments
6 min read
Creating tables & generating code in ChartDB

Creating tables & generating code in ChartDB

11
Comments
3 min read
Simulating Database Operations with PostgreSQL on Kubernetes

Simulating Database Operations with PostgreSQL on Kubernetes

Comments
3 min read
Backend challenge #5

Backend challenge #5

Comments
2 min read
Load Testing PostgreSQL on Kubernetes: A YAML-Only Approach

Load Testing PostgreSQL on Kubernetes: A YAML-Only Approach

Comments
3 min read
The Strength of Vertica DB: A Case Study in Sales Analytics

The Strength of Vertica DB: A Case Study in Sales Analytics

Comments
3 min read
Populating a Vertica Database with Random Data

Populating a Vertica Database with Random Data

Comments
4 min read
How to Install Vertica DB Client (vsql) on Ubuntu 24.04

How to Install Vertica DB Client (vsql) on Ubuntu 24.04

Comments
2 min read
Normalization | 1 NF

Normalization | 1 NF

7
Comments
1 min read
DevOps. Monitoring Databases. On-Premise and Cloud environments.

DevOps. Monitoring Databases. On-Premise and Cloud environments.

Comments
1 min read
Partitioning in ORACLE SQL | Horizontal and Vertical Partitioning

Partitioning in ORACLE SQL | Horizontal and Vertical Partitioning

9
Comments
3 min read
Key terms In data analytics

Key terms In data analytics

Comments
1 min read
loading...