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.
Duckdb — O novo banco de dados dos Big Data

Duckdb — O novo banco de dados dos Big Data

5
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
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
Getting Started with MongoDB Compass: A GUI for MongoDB

Getting Started with MongoDB Compass: A GUI for MongoDB

2
Comments
2 min read
Migrar de SQLite a MySQL.

Migrar de SQLite a MySQL.

1
Comments
5 min read
Reading and Interpreting PostgreSQL Query Plans – A Friendly Guide

Reading and Interpreting PostgreSQL Query Plans – A Friendly Guide

Comments
9 min read
GBASE数据库 | GBase 8a Distributed Execution Plan Principles

GBASE数据库 | GBase 8a Distributed Execution Plan Principles

Comments
7 min read
Architecting Your Own Database - Part 1

Architecting Your Own Database - Part 1

Comments
4 min read
Hands-on with Apache Iceberg & Dremio on Your Laptop within 10 Minutes

Hands-on with Apache Iceberg & Dremio on Your Laptop within 10 Minutes

Comments
19 min read
Understanding and Using Window Functions in SQL

Understanding and Using Window Functions in SQL

Comments
1 min read
Data Modeling - Entities and Events

Data Modeling - Entities and Events

Comments
6 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
We launched SupaCharts! Visualize Beautiful Charts from your Supabase Data.

We launched SupaCharts! Visualize Beautiful Charts from your Supabase Data.

4
Comments
1 min read
From Theory to Practice: Developing a Distributed Key-Value Database with Sharding and Replication

From Theory to Practice: Developing a Distributed Key-Value Database with Sharding and Replication

2
Comments
10 min read
PostgreSQL Query Performance Tuning Tips

PostgreSQL Query Performance Tuning Tips

1
Comments
8 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
Join us for the Open Source AI Challenge with pgai and Ollama: $3,000 in Prizes!

Join us for the Open Source AI Challenge with pgai and Ollama: $3,000 in Prizes!

170
Comments 8
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
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
How to connect and query multiple databases with a single REST API

How to connect and query multiple databases with a single REST API

Comments
3 min read
AWS Database - Part 3: Purpose-Built Databases

AWS Database - Part 3: Purpose-Built Databases

5
Comments
4 min read
Database Replication NLogN🔄

Database Replication NLogN🔄

Comments
2 min read
Boost Your MySQL Debugging Skills with the General Query Log

Boost Your MySQL Debugging Skills with the General Query Log

Comments
4 min read
Import CSV file using MariaDB CLI

Import CSV file using MariaDB CLI

Comments
1 min read
Transacciones en laravel

Transacciones en laravel

1
Comments 2
2 min read
loading...