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.
Why Choose ULIDs Over Traditional UUIDs or IDs for Database Identification?

Why Choose ULIDs Over Traditional UUIDs or IDs for Database Identification?

Comments
3 min read
Get SQL-Server Stored Procedures with C#

Get SQL-Server Stored Procedures with C#

1
Comments
9 min read
Your Complete Guide to MongoDB: Part One ( Setup and Basics)

Your Complete Guide to MongoDB: Part One ( Setup and Basics)

1
Comments 2
5 min read
Exploring SQL Functions: Harnessing the Power of Built-in Functions

Exploring SQL Functions: Harnessing the Power of Built-in Functions

Comments
3 min read
How to Process Events Exactly-Once with Kafka and DBOS

How to Process Events Exactly-Once with Kafka and DBOS

3
Comments
4 min read
Weekly Updates - May 3, 2024

Weekly Updates - May 3, 2024

Comments
1 min read
Simplified SQL: Harnessing the Power of Aliases

Simplified SQL: Harnessing the Power of Aliases

Comments
2 min read
Using Temporary Tables in MariaDB

Using Temporary Tables in MariaDB

Comments
2 min read
A glimpse into the future of data processing infrastructure.

A glimpse into the future of data processing infrastructure.

Comments
9 min read
6 Best Embedded Databases for 2024 📊

6 Best Embedded Databases for 2024 📊

6
Comments 1
4 min read
The Essential Guide to Database Backup: Tips & Strategies

The Essential Guide to Database Backup: Tips & Strategies

Comments
11 min read
Find increases, latest values, and cumulative sums in SQL (postgres)

Find increases, latest values, and cumulative sums in SQL (postgres)

Comments
7 min read
How to ditch Neon

How to ditch Neon

Comments
3 min read
Exploring the Landscape of Database Paradigms - A Comprehensive Guide - Key-Value Databases

Exploring the Landscape of Database Paradigms - A Comprehensive Guide - Key-Value Databases

Comments
10 min read
System Design: Databases and DBMS

System Design: Databases and DBMS

Comments
6 min read
SQL AGGREGATE FUNCTIONS

SQL AGGREGATE FUNCTIONS

Comments
2 min read
Caching OpenAI Chat API Responses with LangChain and Xata

Caching OpenAI Chat API Responses with LangChain and Xata

Comments
11 min read
Setup Azure Cosmos DB for Gremlin in Spring Boot Java

Setup Azure Cosmos DB for Gremlin in Spring Boot Java

1
Comments
3 min read
Tracking Personal Finances with SQL: Learn As You Manage Your Money!

Tracking Personal Finances with SQL: Learn As You Manage Your Money!

1
Comments
2 min read
SQL | DDL, DQL, DML, DCL and TCL Commands

SQL | DDL, DQL, DML, DCL and TCL Commands

5
Comments
2 min read
What's coming to PostgreSQL ? 🐘

What's coming to PostgreSQL ? 🐘

59
Comments 6
5 min read
Why MongoDB is not great for complex reporting?

Why MongoDB is not great for complex reporting?

1
Comments
1 min read
INTRODUCTION TO SQL

INTRODUCTION TO SQL

Comments
4 min read
Asgard saviour: Neurelo

Asgard saviour: Neurelo

1
Comments
3 min read
SAP Basis snippets #3

SAP Basis snippets #3

Comments
1 min read
Modern Data Quality (MDQ): Everything You Need to Know

Modern Data Quality (MDQ): Everything You Need to Know

Comments
5 min read
Optimizing Firebase Updates: Batch Multiple Paths in a Single Commit

Optimizing Firebase Updates: Batch Multiple Paths in a Single Commit

Comments
2 min read
How to connect to Oracle, MySql and PostgreSQL databases using Python?

How to connect to Oracle, MySql and PostgreSQL databases using Python?

2
Comments
2 min read
Laravel Log DB Queries

Laravel Log DB Queries

Comments 2
1 min read
SQL DATA MANIPULATION

SQL DATA MANIPULATION

1
Comments
3 min read
How to efficiently migrate and manage database schema changes in a Laravel application?

How to efficiently migrate and manage database schema changes in a Laravel application?

Comments 1
3 min read
How to programmatically backup your Firestore database with simple steps

How to programmatically backup your Firestore database with simple steps

1
Comments
2 min read
Multiple operations in a single DynamoDB update expression

Multiple operations in a single DynamoDB update expression

Comments
3 min read
How to calculate the distance between Kyoto and Tokyo using a PostgreSQL database?

How to calculate the distance between Kyoto and Tokyo using a PostgreSQL database?

3
Comments 1
2 min read
Optimizing SQL Performance: Best Practices for Efficient Database Operations

Optimizing SQL Performance: Best Practices for Efficient Database Operations

Comments
3 min read
Unveiling the Future of Database Management: A Comprehensive Guide to Neon DB

Unveiling the Future of Database Management: A Comprehensive Guide to Neon DB

Comments
1 min read
Weekly Updates - Apr 26, 2024

Weekly Updates - Apr 26, 2024

Comments
2 min read
DevOps. Monitoring Databases. On-Premise and Cloud Environments.

DevOps. Monitoring Databases. On-Premise and Cloud Environments.

1
Comments
1 min read
PostgreSQL: Deleting all records from a table, except for the first and last ones.

PostgreSQL: Deleting all records from a table, except for the first and last ones.

2
Comments
2 min read
How to find the third and fifth-highest values in a PostgreSQL table?

How to find the third and fifth-highest values in a PostgreSQL table?

1
Comments
2 min read
Understanding of NULL in PostgreSQL database.

Understanding of NULL in PostgreSQL database.

3
Comments
2 min read
How to join tables in PostgreSQL using the WITH clause?

How to join tables in PostgreSQL using the WITH clause?

1
Comments
2 min read
PostgreSQL. How to check connections that are not using SSL encryption?

PostgreSQL. How to check connections that are not using SSL encryption?

1
Comments
2 min read
Statistical information about tables in a PostgreSQL Database.

Statistical information about tables in a PostgreSQL Database.

1
Comments
2 min read
About transaction identifier (transaction_id) in PostgreSQL.

About transaction identifier (transaction_id) in PostgreSQL.

6
Comments
2 min read
How to check if the PostgreSQL tables of the same structure have identical data using aggregated hash and md5?

How to check if the PostgreSQL tables of the same structure have identical data using aggregated hash and md5?

1
Comments
2 min read
Caching in depth

Caching in depth

1
Comments
7 min read
Unlocking the Power of Databases in Java with JDBC

Unlocking the Power of Databases in Java with JDBC

Comments
2 min read
Custom SQL Scripts in PostgreSQL PgBench

Custom SQL Scripts in PostgreSQL PgBench

2
Comments
6 min read
The Untold Truth: Data Quality Issues in Your Data Warehouse Nobody Will Tell You About

The Untold Truth: Data Quality Issues in Your Data Warehouse Nobody Will Tell You About

Comments
4 min read
Calculate the Total Price According to the Cumulative Price Table

Calculate the Total Price According to the Cumulative Price Table

6
Comments 3
1 min read
Seeking Insights from Application Developers

Seeking Insights from Application Developers

Comments
1 min read
OracleBootCamp - 4 May 2024

OracleBootCamp - 4 May 2024

Comments
1 min read
Levantando um SQL Server RDS em AWS

Levantando um SQL Server RDS em AWS

Comments
4 min read
How to schedule RDS instances (start/stop) easily

How to schedule RDS instances (start/stop) easily

3
Comments
6 min read
Serverless Postgres with Neon - My first impression

Serverless Postgres with Neon - My first impression

5
Comments
8 min read
Relational Databases on AWS: Comparing RDS and Aurora

Relational Databases on AWS: Comparing RDS and Aurora

11
Comments
8 min read
Local-first for FlutterFlow

Local-first for FlutterFlow

Comments 2
1 min read
My AWS Resume Challenge and the troubles I faced.

My AWS Resume Challenge and the troubles I faced.

Comments
2 min read
Modern Data Quality: Navigating the Landscape

Modern Data Quality: Navigating the Landscape

Comments
4 min read
loading...