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.
ACID Properties in Databases

ACID Properties in Databases

11
Comments 1
2 min read
Building and Running SQL Queries with Knex.js

Building and Running SQL Queries with Knex.js

30
Comments
5 min read
On.NET Episode: Streaming and Batching with the Cosmos DB SDK for .NET

On.NET Episode: Streaming and Batching with the Cosmos DB SDK for .NET

16
Comments
1 min read
5 things to consider before developing a web application

5 things to consider before developing a web application

7
Comments
4 min read
How to use Knex migrations to change database schema

How to use Knex migrations to change database schema

12
Comments
3 min read
Big Data from the Ground up

Big Data from the Ground up

78
Comments 2
7 min read
Dynamic ETL from RDS to Redshift using AWS Glue

Dynamic ETL from RDS to Redshift using AWS Glue

6
Comments
3 min read
Important Health Checks for your MySQL Master-Slave Servers

Important Health Checks for your MySQL Master-Slave Servers

8
Comments
5 min read
Make websites work offline - Offline Storage. Making IndexedDB the Hero!

Make websites work offline - Offline Storage. Making IndexedDB the Hero!

174
Comments 11
3 min read
AWS Databases Deep Dive: Season 1 Recap

AWS Databases Deep Dive: Season 1 Recap

63
Comments 1
4 min read
Basic DB Using SQL Server (Part 4) - SQL JOIN

Basic DB Using SQL Server (Part 4) - SQL JOIN

10
Comments
5 min read
Modeling a Swiss Tournament in a Relational Database

Modeling a Swiss Tournament in a Relational Database

12
Comments
4 min read
How we killed project with NoSQL

How we killed project with NoSQL

31
Comments 19
4 min read
Postgres Arrays: JOIN table with matching ids

Postgres Arrays: JOIN table with matching ids

6
Comments
1 min read
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
Implementing Message Outbox Pattern with Oban

Implementing Message Outbox Pattern with Oban

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

Java(Spring Boot) Best Database Practices

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

21
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

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

Archiving large MySQL tables (part III - automation)

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

T-SQL CRUD procedures auto-generator

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

First steps to caching PostgreSQL queries with Redis

56
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

18
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
Run a DynamoDB instance locally with Node.js

Run a DynamoDB instance locally with Node.js

17
Comments 6
4 min read
How to Synchronize relational databases with Dotmim.Sync

How to Synchronize relational databases with Dotmim.Sync

22
Comments 4
5 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

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

Best way to store array type data inside database?

28
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
loading...