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.
TimescaleDB 2.0 with Hasura Part 2 - Multi-Node

TimescaleDB 2.0 with Hasura Part 2 - Multi-Node

1
Comments
8 min read
How Do the Top 20 Words in Biden's Inauguration Speech Compare to Trump's?

How Do the Top 20 Words in Biden's Inauguration Speech Compare to Trump's?

28
Comments 3
7 min read
Couchbase: Scans And Pushdowns

Couchbase: Scans And Pushdowns

2
Comments
3 min read
Creating a database from scratch with Node.js - Day 17

Creating a database from scratch with Node.js - Day 17

10
Comments 2
1 min read
But how, exactly, databases use mmap?

But how, exactly, databases use mmap?

4
Comments
9 min read
How to Visualize Your SQLite Database with One Command (and Nothing to Install)

How to Visualize Your SQLite Database with One Command (and Nothing to Install)

4
Comments 10
1 min read
MongoDB Animated 🍩: Adding and removing elements from arrays

MongoDB Animated 🍩: Adding and removing elements from arrays

42
Comments 6
4 min read
Bottlenecks of Firebase vs Fauna

Bottlenecks of Firebase vs Fauna

26
Comments 4
9 min read
What’s asked for more? FrontEnd, Backend, Database, Maintaining

What’s asked for more? FrontEnd, Backend, Database, Maintaining

6
Comments 1
1 min read
Working easier with legacy databases

Working easier with legacy databases

6
Comments 2
3 min read
Creating a database from scratch with Node.js - Days 15-16

Creating a database from scratch with Node.js - Days 15-16

14
Comments
2 min read
UUIDs vs Auto-Incrementing Primary Keys in SQL

UUIDs vs Auto-Incrementing Primary Keys in SQL

30
Comments 1
7 min read
What exactly is API?

What exactly is API?

236
Comments 16
3 min read
GraphQL Tutorial: how to use fields, fragments, and more

GraphQL Tutorial: how to use fields, fragments, and more

21
Comments
8 min read
A Few Methods for Returning Default Values when Creating ActiveRecord Objects

A Few Methods for Returning Default Values when Creating ActiveRecord Objects

6
Comments 2
7 min read
Auditing PostgreSQL Using pgAudit

Auditing PostgreSQL Using pgAudit

5
Comments
9 min read
For relational algebra, there will be better alternatives to SQL (the language)?

For relational algebra, there will be better alternatives to SQL (the language)?

8
Comments 2
1 min read
SQL Extensions for Time-Series Data in QuestDB

SQL Extensions for Time-Series Data in QuestDB

2
Comments
6 min read
A brief insight on CI/CD for Database

A brief insight on CI/CD for Database

5
Comments
2 min read
Reporting in Power BI - Quick Steps

Reporting in Power BI - Quick Steps

3
Comments
1 min read
Part 4: Adding the category and home landing pages

Part 4: Adding the category and home landing pages

4
Comments
6 min read
Part 5: Adding CloudFront

Part 5: Adding CloudFront

5
Comments
6 min read
Part 1: Introduction to creating a Computeless Blog on AWS using API Gateway and DynamoDB

Part 1: Introduction to creating a Computeless Blog on AWS using API Gateway and DynamoDB

8
Comments
5 min read
Part 3: Adding API Gateway and the Article Page

Part 3: Adding API Gateway and the Article Page

7
Comments
6 min read
Part 2: Planning the Data Model

Part 2: Planning the Data Model

3
Comments
5 min read
Taking Ownership of Our Data Pipelines: Analytics Engineering Using dbt

Taking Ownership of Our Data Pipelines: Analytics Engineering Using dbt

7
Comments
14 min read
Persistence with Core Data and SwiftUI

Persistence with Core Data and SwiftUI

10
Comments
11 min read
MySQL or MongoDB?

MySQL or MongoDB?

5
Comments 3
1 min read
How To Model Data for Full-Stack Applications

How To Model Data for Full-Stack Applications

13
Comments 3
5 min read
Backup MySQL Database That Running on Docker Container

Backup MySQL Database That Running on Docker Container

14
Comments 1
1 min read
Reading and Writing from a Database with React (simplified)

Reading and Writing from a Database with React (simplified)

7
Comments 1
7 min read
SQL is 50 Years Old. What Can We Learn From Its Success?

SQL is 50 Years Old. What Can We Learn From Its Success?

5
Comments
11 min read
What is Redis? Get started with data types, commands, and more

What is Redis? Get started with data types, commands, and more

17
Comments 2
10 min read
SQL for Beginners

SQL for Beginners

2
Comments
4 min read
NoSQL Database Design for E-Commerce Apps in 2021

NoSQL Database Design for E-Commerce Apps in 2021

190
Comments
6 min read
ETLT Data Integration: The Best of Both Worlds

ETLT Data Integration: The Best of Both Worlds

6
Comments
8 min read
MongoDB Installation w10

MongoDB Installation w10

2
Comments
1 min read
CREATE, UPDATE, ADD and DELETE SEQUELIZE MIGRATION

CREATE, UPDATE, ADD and DELETE SEQUELIZE MIGRATION

21
Comments 5
5 min read
Creating a database from scratch with Node.js - Days 13-14

Creating a database from scratch with Node.js - Days 13-14

12
Comments
3 min read
Trigger Warning! A Complete Guide to SQL Triggers - Setting up DB Tracking in Postgres

Trigger Warning! A Complete Guide to SQL Triggers - Setting up DB Tracking in Postgres

2
Comments
10 min read
SQLite findings (on JSON and others)

SQLite findings (on JSON and others)

7
Comments
3 min read
MongoDB $weeklyUpdate #16 (Jan 11, 2021): Latest Tutorials, Events, Podcasts, & Streams!

MongoDB $weeklyUpdate #16 (Jan 11, 2021): Latest Tutorials, Events, Podcasts, & Streams!

10
Comments
4 min read
Django For APIs Notes- Part II

Django For APIs Notes- Part II

9
Comments 4
4 min read
Immutable ActiveRecord

Immutable ActiveRecord

4
Comments
5 min read
Creating a database from scratch with Node.js - Day 12

Creating a database from scratch with Node.js - Day 12

7
Comments 2
2 min read
Oracle 19c with Docker

Oracle 19c with Docker

27
Comments
3 min read
Do you use Redis?

Do you use Redis?

2
Comments 5
1 min read
Get The Most Out of Your Postgres Database with SeeQR

Get The Most Out of Your Postgres Database with SeeQR

2
Comments
4 min read
Creating a database from scratch with Node.js - Day 11

Creating a database from scratch with Node.js - Day 11

19
Comments 2
2 min read
Do you pay for database storage?

Do you pay for database storage?

23
Comments 19
1 min read
CloudFormation Example for Serverless RDS

CloudFormation Example for Serverless RDS

5
Comments
3 min read
How to interface Oracle Database with Python and execute queries

How to interface Oracle Database with Python and execute queries

9
Comments
6 min read
How to setup Oracle Database 11g XE on Windows and unlock the "HR" user

How to setup Oracle Database 11g XE on Windows and unlock the "HR" user

12
Comments
3 min read
5 Ways to Use HarperDB in Your Next Project

5 Ways to Use HarperDB in Your Next Project

37
Comments
6 min read
Building a Scalable E-Commerce Data Model

Building a Scalable E-Commerce Data Model

166
Comments 8
8 min read
How to handle DB errors in Golang correctly

How to handle DB errors in Golang correctly

80
Comments 2
11 min read
Mac installing MariaDB

Mac installing MariaDB

10
Comments 2
2 min read
How to Manage an Object Storage Data Lake

How to Manage an Object Storage Data Lake

4
Comments
3 min read
Creating a database from scratch with Node.js - Day 10

Creating a database from scratch with Node.js - Day 10

6
Comments
1 min read
Assembling a query optimizer with Apache Calcite

Assembling a query optimizer with Apache Calcite

6
Comments
9 min read
loading...