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.
Database Notes 📖

Database Notes 📖

7
Comments
2 min read
Migración de la base de datos SQL local a la base de Azure SQL Database

Migración de la base de datos SQL local a la base de Azure SQL Database

16
Comments
11 min read
Google Cloud BigQuery vs. AWS Redshift

Google Cloud BigQuery vs. AWS Redshift

18
Comments 1
5 min read
Mocking Database in Go

Mocking Database in Go

84
Comments 5
3 min read
On.NET Episode: Lesser known features of the Cosmos DB SDK for .NET

On.NET Episode: Lesser known features of the Cosmos DB SDK for .NET

13
Comments
1 min read
Database triggers not working

Database triggers not working

9
Comments 2
1 min read
What every relational database developer needs to know about NoSQL

What every relational database developer needs to know about NoSQL

153
Comments 11
2 min read
Document vs Relational Databases

Document vs Relational Databases

45
Comments 7
3 min read
Simple data-driven way for building React forms

Simple data-driven way for building React forms

15
Comments
9 min read
Real-Time Analytics on Connected Car IoT Data Streams from Apache Kafka

Real-Time Analytics on Connected Car IoT Data Streams from Apache Kafka

9
Comments
8 min read
How to version control the database?

How to version control the database?

5
Comments 3
1 min read
Java(Spring Boot) Best Database Practices

Java(Spring Boot) Best Database Practices

6
Comments
2 min read
Implementing Message Outbox Pattern with Oban

Implementing Message Outbox Pattern with Oban

14
Comments
5 min read
An introduction to Prisma 2

An introduction to Prisma 2

51
Comments 1
14 min read
Archiving large MySQL tables (part I - intro)

Archiving large MySQL tables (part I - intro)

24
Comments 4
5 min read
How to use Change Data Capture (CDC) with Postgres

How to use Change Data Capture (CDC) with Postgres

22
Comments 4
3 min read
What have the STORED PROCEDURES ever done for us?

What have the STORED PROCEDURES ever done for us?

14
Comments 6
4 min read
Archiving large MySQL tables (part II - initial migrations)

Archiving large MySQL tables (part II - initial migrations)

10
Comments
11 min read
Adventures in SQL Source Control with SSDT

Adventures in SQL Source Control with SSDT

13
Comments 2
7 min read
Archiving large MySQL tables (part III - automation)

Archiving large MySQL tables (part III - automation)

9
Comments
4 min read
T-SQL CRUD procedures auto-generator

T-SQL CRUD procedures auto-generator

39
Comments 2
4 min read
First steps to caching PostgreSQL queries with Redis

First steps to caching PostgreSQL queries with Redis

57
Comments
5 min read
How to Implement Transactions in MongoDB Using Node.js

How to Implement Transactions in MongoDB Using Node.js

42
Comments 3
12 min read
The Best MYSQL Courses for Beginners

The Best MYSQL Courses for Beginners

12
Comments
5 min read
Database schema changes with Hibernate and Spring Boot

Database schema changes with Hibernate and Spring Boot

19
Comments 3
6 min read
How to Manage Big Data With 5 Python Libraries

How to Manage Big Data With 5 Python Libraries

56
Comments
7 min read
Using the IFS variable to do things with CSV files

Using the IFS variable to do things with CSV files

5
Comments
5 min read
How to Synchronize relational databases with Dotmim.Sync

How to Synchronize relational databases with Dotmim.Sync

22
Comments 5
5 min read
Run a DynamoDB instance locally with Node.js

Run a DynamoDB instance locally with Node.js

17
Comments 6
4 min read
Introduction to Profiling and Optimizing SQL Queries for Software Engineers

Introduction to Profiling and Optimizing SQL Queries for Software Engineers

14
Comments 2
11 min read
Complete MySQL Course: Beginner to Advanced

Complete MySQL Course: Beginner to Advanced

30
Comments
1 min read
Notes on Migrating from MS SQL Server to PostgreSQL

Notes on Migrating from MS SQL Server to PostgreSQL

9
Comments
8 min read
Database Replication: Master-Slave Replication Architecture

Database Replication: Master-Slave Replication Architecture

16
Comments
3 min read
Connect to a single MongoDB instance from rust

Connect to a single MongoDB instance from rust

10
Comments 1
1 min read
The Wild SQL Query I Wrote For Work This Week

The Wild SQL Query I Wrote For Work This Week

61
Comments 1
7 min read
Intro to SQL User Defined Functions (UDFs) in Redshift

Intro to SQL User Defined Functions (UDFs) in Redshift

8
Comments
5 min read
The need for Database Replication

The need for Database Replication

13
Comments
3 min read
Modality 1.0 - a lightweight Java ORM library

Modality 1.0 - a lightweight Java ORM library

3
Comments 1
1 min read
[PT-BR] Usando o Notepad++ para montar queries

[PT-BR] Usando o Notepad++ para montar queries

22
Comments
2 min read
Best way to store array type data inside database?

Best way to store array type data inside database?

30
Comments 22
1 min read
The pros and cons of updatable views in Postgres

The pros and cons of updatable views in Postgres

5
Comments
6 min read
Understanding Autopilot Mode in Azure Cosmos DB

Understanding Autopilot Mode in Azure Cosmos DB

14
Comments
6 min read
Solved! Mongoose Unique Index Not Working

Solved! Mongoose Unique Index Not Working

30
Comments 7
2 min read
🐾 Does your microservice deserve its own database?

🐾 Does your microservice deserve its own database?

44
Comments 1
4 min read
Tutorial: Flow External Services for Salesforce Admins

Tutorial: Flow External Services for Salesforce Admins

10
Comments
11 min read
How to take a leap from the Data Analyst to Data Scientist?

How to take a leap from the Data Analyst to Data Scientist?

6
Comments
4 min read
🤔 How to create a MySQL connection and run queries with Python3

🤔 How to create a MySQL connection and run queries with Python3

13
Comments 1
1 min read
Good sources (courses, books, sites) on database design and data modeling?

Good sources (courses, books, sites) on database design and data modeling?

14
Comments 2
1 min read
The Beginner's Guide To MongoDB Aggregation Pipeline Part 1

The Beginner's Guide To MongoDB Aggregation Pipeline Part 1

14
Comments
2 min read
Database generic way of achieving Query Result Change Notification

Database generic way of achieving Query Result Change Notification

7
Comments 1
1 min read
SMSS -'Connect to Server' Hell

SMSS -'Connect to Server' Hell

6
Comments
1 min read
Data Fingerprinting in JavaScript

Data Fingerprinting in JavaScript

58
Comments 1
6 min read
Basic DB Using SQL Server (Part 3) - retrieve data using SQL

Basic DB Using SQL Server (Part 3) - retrieve data using SQL

11
Comments
6 min read
Basic DB Using SQL Server (Part 2) - modify columns and learn some constraints

Basic DB Using SQL Server (Part 2) - modify columns and learn some constraints

8
Comments
8 min read
Secure Data Lake with AWS Lake Formation Tutorial

Secure Data Lake with AWS Lake Formation Tutorial

7
Comments 1
4 min read
Eager Loading: Fetching Associated Data with Sequelize

Eager Loading: Fetching Associated Data with Sequelize

13
Comments 1
4 min read
From 15,000 database connections to under 100: DigitalOcean's tale of tech debt

From 15,000 database connections to under 100: DigitalOcean's tale of tech debt

220
Comments 20
7 min read
PostgreSQL Tutorial for beginners to Advance level.

PostgreSQL Tutorial for beginners to Advance level.

95
Comments 2
18 min read
[PT-BR] Conhecendo o DBeaver

[PT-BR] Conhecendo o DBeaver

53
Comments 9
2 min read
Perform Direct and Reverse image search like Google Images with AquilaDB

Perform Direct and Reverse image search like Google Images with AquilaDB

5
Comments
15 min read
loading...