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.
Introducing Map Projection in Apache AGE Open Cypher

Introducing Map Projection in Apache AGE Open Cypher

5
Comments 2
2 min read
Breaking IndexedDB consistency to explore its transactions

Breaking IndexedDB consistency to explore its transactions

Comments
10 min read
Data Transformation in API Integrations

Data Transformation in API Integrations

Comments
5 min read
PostgreSQL index Correlation with UPDATE

PostgreSQL index Correlation with UPDATE

10
Comments
17 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
The Role of Ontologies in Data Management

The Role of Ontologies in Data Management

Comments
6 min read
ReductStore v1.9.0 Released

ReductStore v1.9.0 Released

2
Comments
2 min read
How to Downsample Your Data Efficiently?

How to Downsample Your Data Efficiently?

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
Managing Concurrent Database Writes in a Distributed System with Redis or PostgreSQL

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

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

The Six Pillars of Database-Driven Application Performance

Comments
5 min read
Meus aprendizados com a Rinha de Backend 2023 Q3

Meus aprendizados com a Rinha de Backend 2023 Q3

6
Comments
4 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

Comments
3 min read
Databases: A Beginner’s Guide

Databases: A Beginner’s Guide

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

How to Create a Database Front End in 4 Steps

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

A Light-hearted Look at Pagination Optimization

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

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

13
Comments 1
6 min read
Tutorial: Install P3X Redis UI

Tutorial: Install P3X Redis UI

4
Comments
2 min read
Handling NEW and OLD Immutability in PostgreSQL Triggers

Handling NEW and OLD Immutability in PostgreSQL Triggers

Comments
2 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
AI Softwareentwicklung mit Ninox und arcBot

AI Softwareentwicklung mit Ninox und arcBot

Comments
4 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!

6
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

3
Comments
3 min read
Understanding the Battle of Database Storage: Row-Oriented vs. Columnar

Understanding the Battle of Database Storage: Row-Oriented vs. Columnar

1
Comments 1
6 min read
Data API for Amazon Aurora Serverless v2 with AWS SDK for Java - Part 4 Working with database transactions

Data API for Amazon Aurora Serverless v2 with AWS SDK for Java - Part 4 Working with database transactions

1
Comments
4 min read
Python Database Connectivity and SQL Basics for EDA 🐍📊

Python Database Connectivity and SQL Basics for EDA 🐍📊

6
Comments
4 min read
The Django ORM: The Magic between the Application and the Database

The Django ORM: The Magic between the Application and the Database

1
Comments
6 min read
Chat with your SQL database

Chat with your SQL database

1
Comments
3 min read
Typesafe PostgreSQL queries with Kysely and Neon

Typesafe PostgreSQL queries with Kysely and Neon

1
Comments
10 min read
What to do if the query calculation is moved out of database but is too slow using java

What to do if the query calculation is moved out of database but is too slow using java

6
Comments
6 min read
SQL vs NoSQL: Choosing the Right One, Future Trends & Best Practices

SQL vs NoSQL: Choosing the Right One, Future Trends & Best Practices

6
Comments
11 min read
Pare de instalar bancos de dados

Pare de instalar bancos de dados

7
Comments
3 min read
Implementing Soft Delete With EF Core

Implementing Soft Delete With EF Core

Comments
6 min read
Mastering the Art of Database Engineering Management: Key Skills for Success

Mastering the Art of Database Engineering Management: Key Skills for Success

1
Comments 2
2 min read
Understanding How Databases Utilize Indexes

Understanding How Databases Utilize Indexes

1
Comments
5 min read
A New Way to Provision Databases on Kubernetes

A New Way to Provision Databases on Kubernetes

15
Comments
2 min read
Taming the Tiny Titan: Database Solutions for RAM-Constrained IoT Devices

Taming the Tiny Titan: Database Solutions for RAM-Constrained IoT Devices

1
Comments
4 min read
Why we are betting on Rust!

Why we are betting on Rust!

14
Comments
4 min read
What is a Relational Database for Beginners

What is a Relational Database for Beginners

3
Comments
2 min read
Choosing Between Insert Functions and Raw Queries: A Practical Guide

Choosing Between Insert Functions and Raw Queries: A Practical Guide

1
Comments 1
4 min read
PostGreSql-StoryFrom(Day89-100)

PostGreSql-StoryFrom(Day89-100)

Comments
19 min read
Basics of Caching

Basics of Caching

3
Comments
5 min read
Performance comparison: ReductStore Vs. Minio

Performance comparison: ReductStore Vs. Minio

5
Comments
5 min read
How we handled MySQL deadlocks in Productive - Part 1

How we handled MySQL deadlocks in Productive - Part 1

46
Comments
6 min read
Frugal SQL data access with Athena and Blue / Green support

Frugal SQL data access with Athena and Blue / Green support

5
Comments
4 min read
Implementing a RAG System on DuckDB Using JinaAI and SuperDuperDB

Implementing a RAG System on DuckDB Using JinaAI and SuperDuperDB

10
Comments
1 min read
No More Free Tier on PlanetScale, Here Are Free Alternatives

No More Free Tier on PlanetScale, Here Are Free Alternatives

21
Comments 3
2 min read
Optimizing Database Performance with Views Functions and Triggers in PostgreSQL

Optimizing Database Performance with Views Functions and Triggers in PostgreSQL

1
Comments
6 min read
What are Object-Relational Mappers (ORMs)?

What are Object-Relational Mappers (ORMs)?

3
Comments 1
2 min read
Highlights of RisingWave v1.6: The Open-Source Distributed SQL Streaming Database

Highlights of RisingWave v1.6: The Open-Source Distributed SQL Streaming Database

Comments
7 min read
Helpful Tools for Quant丨Efficiently Calculate Transaction Costs from Tick Data

Helpful Tools for Quant丨Efficiently Calculate Transaction Costs from Tick Data

Comments
2 min read
Crafting DDL Statements for an Online Food Ordering Service Database

Crafting DDL Statements for an Online Food Ordering Service Database

Comments
2 min read
Oracle Database: How to Create/Delete New User and Grant Privilege?

Oracle Database: How to Create/Delete New User and Grant Privilege?

Comments
2 min read
How to Keep a History of MQTT Data With Python

How to Keep a History of MQTT Data With Python

6
Comments
5 min read
OLAP Cubes and Multidimensional Modeling with SQL Server Analysis Services

OLAP Cubes and Multidimensional Modeling with SQL Server Analysis Services

1
Comments
8 min read
Spin up a Free Hosted MongoDB Database in 5 Minutes

Spin up a Free Hosted MongoDB Database in 5 Minutes

Comments
2 min read
loading...