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.
Materialized Views in SQL | Best Explanation

Materialized Views in SQL | Best Explanation

5
Comments
3 min read
Database driven task & membership

Database driven task & membership

Comments
1 min read
Difference between GROUP BY and DISTINCT in SQL

Difference between GROUP BY and DISTINCT in SQL

Comments
1 min read
Materialized View in SQL

Materialized View in SQL

Comments
5 min read
Best Practices for GanosBase Real-Time Heatmap Aggregation Query

Best Practices for GanosBase Real-Time Heatmap Aggregation Query

1
Comments
9 min read
Aggregate function & Windows functions

Aggregate function & Windows functions

Comments
2 min read
Maximizing Performance: Best Practices for Database Scaling

Maximizing Performance: Best Practices for Database Scaling

Comments
16 min read
How to import excel into oracle only 1 step

How to import excel into oracle only 1 step

Comments
2 min read
My Hacktoberfest Contribution To DiceDB

My Hacktoberfest Contribution To DiceDB

1
Comments 2
3 min read
SQL: The Backbone of Modern Data Management

SQL: The Backbone of Modern Data Management

Comments
5 min read
Unlocking the Power of Real-Time Data Management with RxDB

Unlocking the Power of Real-Time Data Management with RxDB

Comments
2 min read
Database sharding

Database sharding

Comments
8 min read
Unlock the Power of Database Management: 8 Free Tutorials for Aspiring Data Professionals

Unlock the Power of Database Management: 8 Free Tutorials for Aspiring Data Professionals

Comments
3 min read
5 Real-World Examples to Boost Your Spring Development with JDK 14 Records

5 Real-World Examples to Boost Your Spring Development with JDK 14 Records

Comments
10 min read
Cloudflare Tunnel - Connecting to Database

Cloudflare Tunnel - Connecting to Database

Comments
2 min read
SQL vs. NoSQL: Key Differences, Use Cases, and Choosing the Right Database for Your Project

SQL vs. NoSQL: Key Differences, Use Cases, and Choosing the Right Database for Your Project

Comments
5 min read
Why MySQL is the Superior Choice for Database Management Over MS Access

Why MySQL is the Superior Choice for Database Management Over MS Access

Comments
6 min read
Statement Timeout in PostgreSQL

Statement Timeout in PostgreSQL

Comments
4 min read
GBase 8c Distributed Cluster Backup Principles and Impact

GBase 8c Distributed Cluster Backup Principles and Impact

Comments
4 min read
Introduction to GBase 8s Locking and Concurrency Transaction Scheduling

Introduction to GBase 8s Locking and Concurrency Transaction Scheduling

Comments
5 min read
Build a Scalable AMQP-Based Messaging Framework on MongoDB in 5 Steps

Build a Scalable AMQP-Based Messaging Framework on MongoDB in 5 Steps

Comments
5 min read
[PT_BR] Repositório Genérico com Dapper.Contrib

[PT_BR] Repositório Genérico com Dapper.Contrib

Comments
4 min read
Code Structure with Dapper and Dapper.Contrib

Code Structure with Dapper and Dapper.Contrib

Comments
3 min read
How to prevent race conditions in Rails apps

How to prevent race conditions in Rails apps

Comments
2 min read
B-tree index in ORACLE SQL

B-tree index in ORACLE SQL

Comments
2 min read
Introduction to Three Cluster Modes in GBase 8s Database

Introduction to Three Cluster Modes in GBase 8s Database

Comments
4 min read
Introduction to GBase 8a Active-Active Disaster Recovery Solution Based on GVR Visual Sync Tool

Introduction to GBase 8a Active-Active Disaster Recovery Solution Based on GVR Visual Sync Tool

Comments
10 min read
Concurrency Issues in SQL and Distributed Systems

Concurrency Issues in SQL and Distributed Systems

Comments
25 min read
ReductStore v1.12.0 released: record deletion API and storage engine optimization

ReductStore v1.12.0 released: record deletion API and storage engine optimization

10
Comments
2 min read
Despliegue de migración de base de datos con .Net 6 y Entity Framework Core - Parte 1

Despliegue de migración de base de datos con .Net 6 y Entity Framework Core - Parte 1

1
Comments
7 min read
Unlock 200 Years of Computing Secrets: Babbage's Lost Machine

Unlock 200 Years of Computing Secrets: Babbage's Lost Machine

Comments
2 min read
Master Bidirectional One-to-One Relations in 5 Steps: Boost Spring Data JPA Efficiency

Master Bidirectional One-to-One Relations in 5 Steps: Boost Spring Data JPA Efficiency

Comments
5 min read
Debugging Postgres

Debugging Postgres

Comments
6 min read
Optimizing PostgreSQL Mass Deletions with Table Partitioning

Optimizing PostgreSQL Mass Deletions with Table Partitioning

1
Comments
3 min read
Relationships in databases

Relationships in databases

8
Comments
2 min read
Laravel Database: O que é e para que serve

Laravel Database: O que é e para que serve

2
Comments
2 min read
Create Efficient Database Indexes for Optimal Long-Term Performance

Create Efficient Database Indexes for Optimal Long-Term Performance

Comments
1 min read
A brief example of an SQL serializable transaction

A brief example of an SQL serializable transaction

Comments
7 min read
The main steps I follow when kicking off Node.js projects

The main steps I follow when kicking off Node.js projects

Comments
4 min read
Mastering Java: Roadmap to Complete Mastery

Mastering Java: Roadmap to Complete Mastery

8
Comments 1
2 min read
Creating a backup table in ORACLE SQL

Creating a backup table in ORACLE SQL

8
Comments
1 min read
PostgreSQL Semi Join, Unique-ify RHS, Materialized CTEs, and Rows Estimation

PostgreSQL Semi Join, Unique-ify RHS, Materialized CTEs, and Rows Estimation

1
Comments
9 min read
What is ORM

What is ORM

Comments
1 min read
Cut AWS Costs by 90%: How We Saved Big and Gained Flexibility

Cut AWS Costs by 90%: How We Saved Big and Gained Flexibility

Comments
7 min read
Big Data Challenges and Solutions: Navigating the Complex Landscape

Big Data Challenges and Solutions: Navigating the Complex Landscape

Comments
7 min read
How to Set Up MongoDB with Next.js

How to Set Up MongoDB with Next.js

Comments
3 min read
pgSphere and Q3C on Distributed SQL

pgSphere and Q3C on Distributed SQL

Comments
4 min read
EF Core - Explosão Cartesiana

EF Core - Explosão Cartesiana

Comments
3 min read
Handling Data in SQL: Signed vs. Unsigned Types

Handling Data in SQL: Signed vs. Unsigned Types

Comments
1 min read
🚀 Introducing LacertaDB: A Simple and Powerful JavaScript Database

🚀 Introducing LacertaDB: A Simple and Powerful JavaScript Database

Comments
2 min read
Use Transactions When Manually Accessing SQL Databases

Use Transactions When Manually Accessing SQL Databases

Comments
3 min read
Troubleshooting PostgreSQL Low Free Memory

Troubleshooting PostgreSQL Low Free Memory

Comments
11 min read
Exceptional Handling in PLSQL | Main Part

Exceptional Handling in PLSQL | Main Part

5
Comments
4 min read
SQL ain't that Scary

SQL ain't that Scary

Comments
11 min read
Frequent Re-Connections improved by Connection Manager

Frequent Re-Connections improved by Connection Manager

Comments
4 min read
Recuperar una Base de Datos Oracle Después de un Error en el Archivo spfile.ora

Recuperar una Base de Datos Oracle Después de un Error en el Archivo spfile.ora

Comments
3 min read
Database Interactions in Go: From SQL to NoSQL

Database Interactions in Go: From SQL to NoSQL

Comments
5 min read
Locking Mechanisms in High-Load Systems

Locking Mechanisms in High-Load Systems

Comments
4 min read
Maintaining Throughput With Less Physical Connections

Maintaining Throughput With Less Physical Connections

Comments
6 min read
Troubleshooting GBase 8c Database Scaling Failure

Troubleshooting GBase 8c Database Scaling Failure

Comments
4 min read
loading...