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.
What is Surrogate Key in SQL?

What is Surrogate Key in SQL?

Comments
2 min read
Time Series Blob Data: ReductStore vs. TimescaleDB

Time Series Blob Data: ReductStore vs. TimescaleDB

1
Comments
5 min read
Simplify Database Migrations using Python with Alembic

Simplify Database Migrations using Python with Alembic

31
Comments
7 min read
How to Handle N+1 Queries for Optimal Database Performance in Django?

How to Handle N+1 Queries for Optimal Database Performance in Django?

8
Comments
7 min read
End-to-End Basic Data Engineering Tutorial (Spark, Dremio, Superset)

End-to-End Basic Data Engineering Tutorial (Spark, Dremio, Superset)

12
Comments
11 min read
MongoDB Filtering in C# – Beginner’s Guide For Easy Filters

MongoDB Filtering in C# – Beginner’s Guide For Easy Filters

Comments
5 min read
Redis reborn, a new chapter begins

Redis reborn, a new chapter begins

42
Comments 15
3 min read
Database for newbies: Hands On

Database for newbies: Hands On

91
Comments 7
6 min read
MongoDB in C#: Simplified Guide For Inserting Data

MongoDB in C#: Simplified Guide For Inserting Data

2
Comments
7 min read
A Quick and Comprehensive Guide On Which Database to Use in your next Fullstack Application

A Quick and Comprehensive Guide On Which Database to Use in your next Fullstack Application

Comments
3 min read
MongoDB For Beginners(Using Docker)

MongoDB For Beginners(Using Docker)

2
Comments 4
9 min read
Database for newbies: Theorethical Approach

Database for newbies: Theorethical Approach

128
Comments 13
6 min read
Manipulating Dates with SQL Server

Manipulating Dates with SQL Server

1
Comments
5 min read
Optimizing PostgreSQL Trigger Execution: Balancing Precision with Control

Optimizing PostgreSQL Trigger Execution: Balancing Precision with Control

2
Comments
3 min read
Best Practices for dynamodb

Best Practices for dynamodb

9
Comments
3 min read
Prisma Part 1: Your Easy Tutorial to Set up Prisma

Prisma Part 1: Your Easy Tutorial to Set up Prisma

15
Comments
4 min read
End-To-End Polymorphism: From Database to UI, Achieving SOLID Design

End-To-End Polymorphism: From Database to UI, Achieving SOLID Design

22
Comments
10 min read
[HELP] PG Trigger on before update

[HELP] PG Trigger on before update

Comments
1 min read
Docker for beginners: Creating Database Containers

Docker for beginners: Creating Database Containers

7
Comments 2
10 min read
One-click Importing Excel Data into a Database

One-click Importing Excel Data into a Database

3
Comments
2 min read
SQL Pro Tips : industrial Oracle SQL using WITH

SQL Pro Tips : industrial Oracle SQL using WITH

3
Comments
4 min read
How to save datetime data that is relevant to multiple countries or time zones?

How to save datetime data that is relevant to multiple countries or time zones?

Comments 2
2 min read
How to Convert Dates in One Group into An Interval

How to Convert Dates in One Group into An Interval

10
Comments
2 min read
Vector Database solutions on AWS

Vector Database solutions on AWS

26
Comments 1
2 min read
PostgreSQL index Correlation with UPDATE

PostgreSQL index Correlation with UPDATE

12
Comments 7
17 min read
Clear Vision, Not So Clear (or.. The User Is Me)

Clear Vision, Not So Clear (or.. The User Is Me)

4
Comments 2
3 min read
High Frequency Data Analysis: Converting High-frequency Signals to Discrete Buy/Sell Signals

High Frequency Data Analysis: Converting High-frequency Signals to Discrete Buy/Sell Signals

Comments
3 min read
Vector Search at the Edge with Couchbase Mobile

Vector Search at the Edge with Couchbase Mobile

1
Comments
8 min read
How come there are tens of thousands of tables in a database

How come there are tens of thousands of tables in a database

2
Comments 1
5 min read
Variant in Apache Doris 2.1.0: a new data type 8 times faster than JSON for semi-structured data analysis

Variant in Apache Doris 2.1.0: a new data type 8 times faster than JSON for semi-structured data analysis

Comments
12 min read
Amazon DynamoDB: Scalable NoSQL for High-Performance Applications

Amazon DynamoDB: Scalable NoSQL for High-Performance Applications

5
Comments
3 min read
PostgreSQL setup via homebrew for junior devs

PostgreSQL setup via homebrew for junior devs

1
Comments
1 min read
The Undistributed System

The Undistributed System

Comments
3 min read
Introducing Map Projection in Apache AGE Open Cypher

Introducing Map Projection in Apache AGE Open Cypher

6
Comments 2
2 min read
Scaling App Data in DynamoDB With Vertical Partitioning

Scaling App Data in DynamoDB With Vertical Partitioning

1
Comments
4 min read
Desentrañando el Proceso ETL: La Columna Vertebral de la Ciencia de Datos

Desentrañando el Proceso ETL: La Columna Vertebral de la Ciencia de Datos

Comments
2 min read
Unlocking the Potential: Best Databases for Python Projects

Unlocking the Potential: Best Databases for Python Projects

2
Comments
3 min read
Rails ActiveRecord count, size and length, map and pluck

Rails ActiveRecord count, size and length, map and pluck

5
Comments 1
2 min read
Couchbase Server 7.6 Top New Features For Developers

Couchbase Server 7.6 Top New Features For Developers

Comments
3 min read
Cómo Crear tu Primer Data Warehouse: Una Guía para Principiantes

Cómo Crear tu Primer Data Warehouse: Una Guía para Principiantes

2
Comments
3 min read
Propriedades ACID de uma transação em banco de dados.

Propriedades ACID de uma transação em banco de dados.

1
Comments
2 min read
Integrating Predictive Analytics Models into SQL Queries

Integrating Predictive Analytics Models into SQL Queries

9
Comments
14 min read
Managing Concurrent Database Writes in a Distributed System with Redis or PostgreSQL

Managing Concurrent Database Writes in a Distributed System with Redis or PostgreSQL

8
Comments
3 min read
The Six Pillars of Database-Driven Application Performance

The Six Pillars of Database-Driven Application Performance

Comments
5 min read
The Six Pillars of Database-Driven Application Performance

The Six Pillars of Database-Driven Application Performance

Comments
5 min read
DocumentDB Vacuum Locks

DocumentDB Vacuum Locks

1
Comments
3 min read
Optimizing PostgreSQL Queries with Function Volatility: Volatile, Stable, and Immutable

Optimizing PostgreSQL Queries with Function Volatility: Volatile, Stable, and Immutable

2
Comments
3 min read
Databases: A Beginner’s Guide

Databases: A Beginner’s Guide

3
Comments
8 min read
How to Create a Database Front End in 4 Steps

How to Create a Database Front End in 4 Steps

2
Comments
19 min read
Advanced Querying Techniques in Vector Databases

Advanced Querying Techniques in Vector Databases

19
Comments
7 min read
Next JS 14 | Setting Up Your Database

Next JS 14 | Setting Up Your Database

6
Comments
4 min read
⚙️🔥 Automating Database Schema Change workflow Using GitHub Actions 🐙🚀

⚙️🔥 Automating Database Schema Change workflow Using GitHub Actions 🐙🚀

19
Comments 1
6 min read
A Light-hearted Look at Pagination Optimization

A Light-hearted Look at Pagination Optimization

6
Comments
3 min read
Handling NEW and OLD Immutability in PostgreSQL Triggers

Handling NEW and OLD Immutability in PostgreSQL Triggers

1
Comments
2 min read
small/swoole-db 1.0.0

small/swoole-db 1.0.0

1
Comments
1 min read
Exploring the Database Spectrum. A Look at SQL and NoSQL Technologies.

Exploring the Database Spectrum. A Look at SQL and NoSQL Technologies.

1
Comments
11 min read
Automated End to End tests using Property Based Testing | Part I

Automated End to End tests using Property Based Testing | Part I

Comments
5 min read
How to Bulk Import a CSV File Using Multer With Node.js and MongoDB

How to Bulk Import a CSV File Using Multer With Node.js and MongoDB

Comments
3 min read
UUID or ULID: Awesomeness of Unique Identifiers!

UUID or ULID: Awesomeness of Unique Identifiers!

12
Comments
6 min read
Understanding ON DELETE CASCADE and ON UPDATE CASCADE in SQL Foreign Key Relationships

Understanding ON DELETE CASCADE and ON UPDATE CASCADE in SQL Foreign Key Relationships

16
Comments
3 min read
loading...