ALTERNATE UNIVERSE DEV

Database

Posts on building, using, and learning about databases.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
Bases de Datos Serverless: Por qué Turso Está Cambiando el Juego

Bases de Datos Serverless: Por qué Turso Está Cambiando el Juego

Comments
2 min read
How to Set Up PostgreSQL Logical Replication: Use Cases and Step-by-Step Guide.

How to Set Up PostgreSQL Logical Replication: Use Cases and Step-by-Step Guide.

Comments
5 min read
Failover in Amazon RDS Multi-AZ Architectures

Failover in Amazon RDS Multi-AZ Architectures

2
Comments
7 min read
One and Done: An oral history of the creation and enhancement of bulkWrite()

One and Done: An oral history of the creation and enhancement of bulkWrite()

Comments
1 min read
Understanding Data Partitioning vs. Sharding: Key Concepts for Effective Data Management

Understanding Data Partitioning vs. Sharding: Key Concepts for Effective Data Management

Comments
3 min read
Essential OOP/Database/Data Structures Interview Questions for Developers

Essential OOP/Database/Data Structures Interview Questions for Developers

Comments
4 min read
TableSavvy ( MYSQL DATABASE MANAGEMENT SOFTWARE )

TableSavvy ( MYSQL DATABASE MANAGEMENT SOFTWARE )

Comments
2 min read
Understanding MongoDB Tools and Features: From Monitoring to Cloud Scalability

Understanding MongoDB Tools and Features: From Monitoring to Cloud Scalability

Comments
4 min read
Having "permission denied" error while creating table in DBeavers using postgres?

Having "permission denied" error while creating table in DBeavers using postgres?

Comments
1 min read
Mastering MongoDB: Key Concepts and Operations Explained

Mastering MongoDB: Key Concepts and Operations Explained

Comments
4 min read
Mastering MongoDB Indexing: Performance Optimization and Best Practices

Mastering MongoDB Indexing: Performance Optimization and Best Practices

Comments
3 min read
Comprehensive Guide to MongoDB Aggregation Framework

Comprehensive Guide to MongoDB Aggregation Framework

Comments
3 min read
Understanding Replication and Sharding in MongoDB: Key Concepts and Best Practices

Understanding Replication and Sharding in MongoDB: Key Concepts and Best Practices

Comments
3 min read
Exploring the mongo Shell: A Command-Line Interface for MongoDB

Exploring the mongo Shell: A Command-Line Interface for MongoDB

Comments
2 min read
Is MongoDB Truly Schema-Less? Exploring Schema Flexibility in NoSQL

Is MongoDB Truly Schema-Less? Exploring Schema Flexibility in NoSQL

Comments
2 min read
Essential MongoDB Operations: A Guide to CRUD and Administration

Essential MongoDB Operations: A Guide to CRUD and Administration

Comments
3 min read
Advanced MongoDB Querying and Aggregation Techniques

Advanced MongoDB Querying and Aggregation Techniques

Comments
3 min read
Connecting to MongoDB: A Guide for Clients and Applications

Connecting to MongoDB: A Guide for Clients and Applications

Comments
2 min read
Understanding Databases in MongoDB: The Logical Container for Collections

Understanding Databases in MongoDB: The Logical Container for Collections

Comments
2 min read
MongoDB Documents: The Core of Flexible Data Modeling

MongoDB Documents: The Core of Flexible Data Modeling

Comments
2 min read
Understanding MongoDB: Why It’s a NoSQL Powerhouse

Understanding MongoDB: Why It’s a NoSQL Powerhouse

Comments
3 min read
They Stopped Using Load Tests - And Here Is Why

They Stopped Using Load Tests - And Here Is Why

Comments
3 min read
Understanding SQL Triggers: Automating Database Tasks with Ease

Understanding SQL Triggers: Automating Database Tasks with Ease

Comments
3 min read
Understanding ACID Properties: The Pillars of Reliable Databases

Understanding ACID Properties: The Pillars of Reliable Databases

Comments
3 min read
Mastering SQL Views: Simplify, Secure, and Optimize Your Database Queries

Mastering SQL Views: Simplify, Secure, and Optimize Your Database Queries

Comments
3 min read
SQL Transactions: Ensuring Data Integrity and Consistency

SQL Transactions: Ensuring Data Integrity and Consistency

Comments
3 min read
Understanding BSON: The Backbone of MongoDB's Data Format

Understanding BSON: The Backbone of MongoDB's Data Format

Comments
2 min read
Main Features of MongoDB: A Comprehensive Overview

Main Features of MongoDB: A Comprehensive Overview

Comments
2 min read
Top 5 Text2SQL Tools for Effortless SQL Generation

Top 5 Text2SQL Tools for Effortless SQL Generation

Comments
7 min read
MongoDB vs. Relational Databases: A Comprehensive Comparison

MongoDB vs. Relational Databases: A Comprehensive Comparison

Comments
2 min read
Prisma & MongoDB: server to be run as a replica set

Prisma & MongoDB: server to be run as a replica set

Comments
1 min read
Understanding Stored Procedures: A Guide to Efficient SQL Programming

Understanding Stored Procedures: A Guide to Efficient SQL Programming

Comments
3 min read
Understanding Database Normalization: Ensuring Efficient and Consistent Data Storage

Understanding Database Normalization: Ensuring Efficient and Consistent Data Storage

Comments
3 min read
Denormalization in Databases: Enhancing Performance with Redundant Data

Denormalization in Databases: Enhancing Performance with Redundant Data

Comments
3 min read
Clustered vs Non-Clustered Indexes: Key Differences for Database Optimization

Clustered vs Non-Clustered Indexes: Key Differences for Database Optimization

Comments
3 min read
Understanding Normal Forms in Database Design: A Comprehensive Guide

Understanding Normal Forms in Database Design: A Comprehensive Guide

Comments
4 min read
Understanding SQL Subqueries: A Complete Guide with Examples

Understanding SQL Subqueries: A Complete Guide with Examples

1
Comments
2 min read
SQL UNION vs UNION ALL: Key Differences Explained

SQL UNION vs UNION ALL: Key Differences Explained

1
Comments
2 min read
Mastering SQL DISTINCT: Removing Duplicates Made Simple

Mastering SQL DISTINCT: Removing Duplicates Made Simple

1
Comments
2 min read
Mastering SQL LIMIT Clause: Controlling the Number of Rows in Queries

Mastering SQL LIMIT Clause: Controlling the Number of Rows in Queries

Comments
3 min read
Mastering SQL GROUP BY: Organizing and Summarizing Your Data

Mastering SQL GROUP BY: Organizing and Summarizing Your Data

Comments
2 min read
Mastering the ORDER BY Clause in SQL: Sorting Your Data Effectively

Mastering the ORDER BY Clause in SQL: Sorting Your Data Effectively

Comments
2 min read
Mastering SQL Joins: LEFT JOIN vs RIGHT JOIN Explained with Examples

Mastering SQL Joins: LEFT JOIN vs RIGHT JOIN Explained with Examples

1
Comments
2 min read
INNER JOIN vs OUTER JOIN: Understanding SQL Joins in Depth

INNER JOIN vs OUTER JOIN: Understanding SQL Joins in Depth

1
Comments
3 min read
Understanding Unique Keys in SQL: Ensuring Data Integrity

Understanding Unique Keys in SQL: Ensuring Data Integrity

Comments
2 min read
Understanding the Difference Between WHERE and HAVING in SQL

Understanding the Difference Between WHERE and HAVING in SQL

Comments
2 min read
Mastering the SQL SELECT Statement: A Comprehensive Guide

Mastering the SQL SELECT Statement: A Comprehensive Guide

Comments
3 min read
Understanding NULL Values Understanding NULL Values in SQL: Managing Missing Data

Understanding NULL Values Understanding NULL Values in SQL: Managing Missing Data

Comments
3 min read
CHAR vs VARCHAR in SQL: Key Differences Explained

CHAR vs VARCHAR in SQL: Key Differences Explained

Comments
2 min read
What is SQL and Why It’s Essential for Data Management

What is SQL and Why It’s Essential for Data Management

1
Comments
3 min read
Understanding DDL, DML, DCL, and TCL in SQL: Key Differences Explained

Understanding DDL, DML, DCL, and TCL in SQL: Key Differences Explained

Comments
3 min read
Understanding the Different Types of SQL Commands

Understanding the Different Types of SQL Commands

Comments
3 min read
Introducing Milvus 2.5: Built-in Full-Text Search, Advanced Query Optimization, and More 🚀

Introducing Milvus 2.5: Built-in Full-Text Search, Advanced Query Optimization, and More 🚀

5
Comments
4 min read
Series de tiempo en MongoDB

Series de tiempo en MongoDB

Comments
6 min read
Inside the Database: Query To Execution Explained

Inside the Database: Query To Execution Explained

Comments
3 min read
Database Design Trade-offs

Database Design Trade-offs

Comments
2 min read
Algorithmic Concepts in MongoDB Design

Algorithmic Concepts in MongoDB Design

Comments
2 min read
Improve Your SQL Server Database Design and Management in 2025 with a GUI Tool

Improve Your SQL Server Database Design and Management in 2025 with a GUI Tool

3
Comments
6 min read
2024.2: Faster with Shared Memory Between PostgreSQL and TServer Layers

2024.2: Faster with Shared Memory Between PostgreSQL and TServer Layers

Comments
4 min read
Top AI Tools for Generating SQL in 2024

Top AI Tools for Generating SQL in 2024

Comments
8 min read
loading...