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.
Event sourcing: The single source of truth

Event sourcing: The single source of truth

6
Comments
6 min read
Demystifying Database Systems, Part 1: An Introduction to Transaction Isolation Levels

Demystifying Database Systems, Part 1: An Introduction to Transaction Isolation Levels

5
Comments
15 min read
Demystifying Database Systems, Part 3: Introduction to Consistency Levels

Demystifying Database Systems, Part 3: Introduction to Consistency Levels

3
Comments
10 min read
Demystifying Database Systems, Part 2: Correctness Anomalies Under Serializable Isolation

Demystifying Database Systems, Part 2: Correctness Anomalies Under Serializable Isolation

3
Comments
13 min read
FaunaDB Serverless Scheduling: Cooperative Scheduling with QoS

FaunaDB Serverless Scheduling: Cooperative Scheduling with QoS

2
Comments
7 min read
Serializability vs “Strict” Serializability: The Dirty Secret of Database Isolation Levels

Serializability vs “Strict” Serializability: The Dirty Secret of Database Isolation Levels

6
Comments
9 min read
A Comparison of Scalable Database Isolation Levels

A Comparison of Scalable Database Isolation Levels

3
Comments
3 min read
Back to the Future with Relational NoSQL

Back to the Future with Relational NoSQL

7
Comments
8 min read
Partitioned Consensus and Its Impact on Spanner’s Latency

Partitioned Consensus and Its Impact on Spanner’s Latency

5
Comments
9 min read
Airbnb’s Airflow Versus Spotify’s Luigi

Airbnb’s Airflow Versus Spotify’s Luigi

73
Comments
7 min read
GraphQL for PostgreSQL - Why?

GraphQL for PostgreSQL - Why?

13
Comments 18
1 min read
Pagination in MongoDB and the Bucket Pattern

Pagination in MongoDB and the Bucket Pattern

10
Comments
4 min read
QuestDB - fast relational time-series DB, zero GC java

QuestDB - fast relational time-series DB, zero GC java

22
Comments 5
1 min read
Whats WITH CTE

Whats WITH CTE

20
Comments 4
9 min read
SQL: Outer Joins

SQL: Outer Joins

76
Comments 10
4 min read
Reading Notes #402

Reading Notes #402

8
Comments 2
2 min read
Types of Indexing in Databases

Types of Indexing in Databases

53
Comments 2
2 min read
Bulk Insert With Dapper - with Table Type Parameter

Bulk Insert With Dapper - with Table Type Parameter

11
Comments 4
3 min read
How To: Database clustering with MariaDB and Galera.

How To: Database clustering with MariaDB and Galera.

13
Comments
10 min read
Database Storage

Database Storage

10
Comments
2 min read
Data Mining?

Data Mining?

8
Comments
3 min read
Beyond CRUD n' Cruft Data-Modeling

Beyond CRUD n' Cruft Data-Modeling

9
Comments 1
12 min read
A New Way to Monitor Your SQL Server Instances

A New Way to Monitor Your SQL Server Instances

8
Comments
3 min read
ScyllaDB Trends – How Users Deploy The Real-Time Big Data Database

ScyllaDB Trends – How Users Deploy The Real-Time Big Data Database

8
Comments
10 min read
Deciding where to store data

Deciding where to store data

7
Comments 2
7 min read
A MongoDB survival pill

A MongoDB survival pill

10
Comments
1 min read
Getting started with AWS - A layman's guide

Getting started with AWS - A layman's guide

11
Comments
3 min read
10 Tips for Seamless Software Hand-offs & Technical Documentation

10 Tips for Seamless Software Hand-offs & Technical Documentation

38
Comments
3 min read
Best Practice for Creating Indexes on your MySQL Tables

Best Practice for Creating Indexes on your MySQL Tables

40
Comments
4 min read
Performance of a Database Application

Performance of a Database Application

15
Comments 9
3 min read
A Quick Dive Into Firebae (Firebase)

A Quick Dive Into Firebae (Firebase)

167
Comments 13
8 min read
General and Unconventional Pagination Techniques in Postgres

General and Unconventional Pagination Techniques in Postgres

11
Comments
4 min read
A guide to accessing databases in Java

A guide to accessing databases in Java

30
Comments 2
22 min read
Why MS Excel is So Popular

Why MS Excel is So Popular

8
Comments 4
1 min read
TiDB in the Browser: Running a Golang Database on WebAssembly

TiDB in the Browser: Running a Golang Database on WebAssembly

6
Comments
4 min read
Meza: From PostgreSQL table to a JSON file

Meza: From PostgreSQL table to a JSON file

8
Comments
1 min read
How to add columns with a default value to large tables

How to add columns with a default value to large tables

13
Comments 2
2 min read
DynamoDB or Aurora/RDS? Should we always use DynamoDB?

DynamoDB or Aurora/RDS? Should we always use DynamoDB?

27
Comments 2
5 min read
The Challenges of Writing Business Apps/Tools

The Challenges of Writing Business Apps/Tools

4
Comments 2
3 min read
DynamoDB Importer

DynamoDB Importer

11
Comments
5 min read
A quick tip for dynamic SQL

A quick tip for dynamic SQL

11
Comments
1 min read
Let's deploy to production

Let's deploy to production

7
Comments 1
1 min read
How to Paginate (the right way) in SQL

How to Paginate (the right way) in SQL

19
Comments
4 min read
Making it Easier to Manage a Production PostgreSQL Database

Making it Easier to Manage a Production PostgreSQL Database

7
Comments
4 min read
Using Slack Webhook

Using Slack Webhook

5
Comments
2 min read
How to handle: API-first development; data encryption; & pre-production complexity

How to handle: API-first development; data encryption; & pre-production complexity

35
Comments
2 min read
How are chat messages stored in firestore?

How are chat messages stored in firestore?

4
Comments 1
1 min read
Modern databases & their differences

Modern databases & their differences

30
Comments
6 min read
Cheap count(*) in Postgres

Cheap count(*) in Postgres

6
Comments 1
1 min read
PostgreSQL backups to S3 with retention limits

PostgreSQL backups to S3 with retention limits

11
Comments
4 min read
C#: Extract Data from Database Files without SQL

C#: Extract Data from Database Files without SQL

9
Comments
2 min read
Base de Datos en memoria con ASP.NET Core 3.0 MVC + Entity Framework Core

Base de Datos en memoria con ASP.NET Core 3.0 MVC + Entity Framework Core

12
Comments 5
4 min read
How to delete all the data from your Firestore database

How to delete all the data from your Firestore database

8
Comments
1 min read
Modern Trends Of Cyber Attacks

Modern Trends Of Cyber Attacks

9
Comments
1 min read
Database designer for web developers and beginner

Database designer for web developers and beginner

15
Comments
2 min read
Tips for: MongoDB security, choosing right DB, & surviving legacy software

Tips for: MongoDB security, choosing right DB, & surviving legacy software

18
Comments
2 min read
Storing data like git - TerminusDB

Storing data like git - TerminusDB

12
Comments 1
3 min read
How to run Oracle DB on a Mac with Docker

How to run Oracle DB on a Mac with Docker

8
Comments 1
2 min read
Master of Data Science... but I'm a graphic designer

Master of Data Science... but I'm a graphic designer

8
Comments 2
1 min read
Storing data like git — TerminusDB

Storing data like git — TerminusDB

9
Comments
3 min read
loading...