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.
How to migrate SQL Databases to a new version

How to migrate SQL Databases to a new version

10
Comments 4
2 min read
Quickly populating a second AWS Amplify GraphQL environment with data

Quickly populating a second AWS Amplify GraphQL environment with data

7
Comments
2 min read
Recursive SQL Queries with PostgreSQL

Recursive SQL Queries with PostgreSQL

50
Comments
7 min read
Creating Professional Reports From MySQL Data

Creating Professional Reports From MySQL Data

14
Comments
3 min read
designing database

designing database

6
Comments 7
1 min read
A stable alternative to SQLite for offline desktop app?

A stable alternative to SQLite for offline desktop app?

9
Comments 18
1 min read
Streaming Corona Posts from Reddit to Slack

Streaming Corona Posts from Reddit to Slack

5
Comments
1 min read
How To Read a Transaction Log in a SQL Server

How To Read a Transaction Log in a SQL Server

6
Comments
3 min read
Ravendb vs CosmosDB

Ravendb vs CosmosDB

16
Comments 3
18 min read
Comparison of Two Database Schemas in SQL Server

Comparison of Two Database Schemas in SQL Server

8
Comments
3 min read
Database: SQL or NoSQL

Database: SQL or NoSQL

40
Comments
3 min read
Data Lineage On Redshift

Data Lineage On Redshift

11
Comments
3 min read
Charting the spread of COVID-19 using data

Charting the spread of COVID-19 using data

68
Comments 2
12 min read
How to write a query with the IN operator using Dapper and NPGSql

How to write a query with the IN operator using Dapper and NPGSql

9
Comments
2 min read
Pick your preferred monitoring memcached tool

Pick your preferred monitoring memcached tool

8
Comments
1 min read
Next.js API Routes using SQL Database

Next.js API Routes using SQL Database

21
Comments 1
1 min read
How to setup a basic VPC with EC2 and RDS using Terraform

How to setup a basic VPC with EC2 and RDS using Terraform

45
Comments 6
6 min read
Run specific select raw queries on write database in order to have fresh data on replication lag

Run specific select raw queries on write database in order to have fresh data on replication lag

5
Comments 1
1 min read
Trees and the Database.

Trees and the Database.

41
Comments 11
4 min read
Playing with a public dataset, and playing with food

Playing with a public dataset, and playing with food

8
Comments 6
5 min read
How to set up a free PostgreSQL database on Heroku

How to set up a free PostgreSQL database on Heroku

234
Comments 13
3 min read
How to handle an initial schema on database that had previously no migration scripts?

How to handle an initial schema on database that had previously no migration scripts?

5
Comments 5
1 min read
Data Engineering 101: From Batch Processing To Streaming

Data Engineering 101: From Batch Processing To Streaming

43
Comments
7 min read
Easiest Chat-as-a-Service

Easiest Chat-as-a-Service

6
Comments 10
1 min read
Migrating Production Data in Elixir

Migrating Production Data in Elixir

11
Comments
4 min read
DynamoDB Cheatsheet – Everything you need to know about Dynamo DB for the 2020 AWS Certified Developer Associate Certification

DynamoDB Cheatsheet – Everything you need to know about Dynamo DB for the 2020 AWS Certified Developer Associate Certification

155
Comments 3
9 min read
How to use horizontal sharding in Rails 6.1

How to use horizontal sharding in Rails 6.1

22
Comments 2
3 min read
[PT-BR] Funcionalidades do DBeaver

[PT-BR] Funcionalidades do DBeaver

103
Comments 6
2 min read
A simple Database Suggestion

A simple Database Suggestion

6
Comments
2 min read
Let’s Build: Workout tracker with React and Firebase part 4: database and deployment

Let’s Build: Workout tracker with React and Firebase part 4: database and deployment

16
Comments
7 min read
Diving into Gremlin queries in Azure Cosmos DB

Diving into Gremlin queries in Azure Cosmos DB

8
Comments
7 min read
Stuffing all of Human History into a Single Knowledge Graph

Stuffing all of Human History into a Single Knowledge Graph

7
Comments
3 min read
Working with databases in CodeIgniter 4

Working with databases in CodeIgniter 4

6
Comments 2
1 min read
🧟 Emojis can be wicked

🧟 Emojis can be wicked

4
Comments 2
4 min read
Overcoming The Limitations Of MongoDB C# Driver

Overcoming The Limitations Of MongoDB C# Driver

17
Comments 6
3 min read
Redis: “psync scheduled to be closed ASAP for overcoming of output buffer limits” and the client-output-buffer-limit

Redis: “psync scheduled to be closed ASAP for overcoming of output buffer limits” and the client-output-buffer-limit

8
Comments 1
12 min read
MariaDB Galera Cluster on Centos8

MariaDB Galera Cluster on Centos8

3
Comments
1 min read
Setting up MySQL InnoDB cluster on Private Network

Setting up MySQL InnoDB cluster on Private Network

11
Comments
3 min read
Best practices: Avoid race conditions 🚘💥🚗😰

Best practices: Avoid race conditions 🚘💥🚗😰

64
Comments 2
2 min read
Async iterators in JS - database iteration in NodeJS

Async iterators in JS - database iteration in NodeJS

15
Comments
6 min read
Using Common Table Expressions to solve Sudoku in Microsoft SQL Server

Using Common Table Expressions to solve Sudoku in Microsoft SQL Server

6
Comments
5 min read
Reading Snippets [48 => Blockcain] 🔗

Reading Snippets [48 => Blockcain] 🔗

4
Comments
1 min read
Deploy a REST API calling node.js App to Heroku

Deploy a REST API calling node.js App to Heroku

9
Comments
6 min read
Embracing the Power of the Self-Referential Join

Embracing the Power of the Self-Referential Join

6
Comments
4 min read
Part 2: How to Synchronize relational databases with Dotmim.Sync

Part 2: How to Synchronize relational databases with Dotmim.Sync

9
Comments 4
6 min read
Why consider database deployment automation?

Why consider database deployment automation?

8
Comments
4 min read
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 1
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
loading...