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.
Easy way to Import and Export Heroku Postgres Databases

Easy way to Import and Export Heroku Postgres Databases

2
Comments
2 min read
A Comprehensive Guide to Databases: Types, Management Systems, Design, and Security

A Comprehensive Guide to Databases: Types, Management Systems, Design, and Security

1
Comments 1
3 min read
Administración de bases de datos con SQL Server

Administración de bases de datos con SQL Server

1
Comments
7 min read
SQL-Server: Exploration of datetime2(7) precision (C#)

SQL-Server: Exploration of datetime2(7) precision (C#)

21
Comments
4 min read
Apache Doris Roadmap 2023

Apache Doris Roadmap 2023

6
Comments
4 min read
HarperDB: Staking a Claim as the Only Globally Distributed Edge Data Platform

HarperDB: Staking a Claim as the Only Globally Distributed Edge Data Platform

11
Comments
7 min read
Unlock the Power of CTEs: Simplify and Optimize Your SQL Queries

Unlock the Power of CTEs: Simplify and Optimize Your SQL Queries

4
Comments
2 min read
Adding real-time full-text search to a Next.js app with Tigris

Adding real-time full-text search to a Next.js app with Tigris

4
Comments
14 min read
How to fix MySQL Syntax Error: Unexpected Identifier

How to fix MySQL Syntax Error: Unexpected Identifier

19
Comments 2
1 min read
Using Geospatial Queries in MySQL

Using Geospatial Queries in MySQL

9
Comments 1
2 min read
Installation of Apache age and PostgreSQL from source in linux part 1

Installation of Apache age and PostgreSQL from source in linux part 1

1
Comments
2 min read
Initialization and creating a database for testing the installation of Postgres and Age part 2.

Initialization and creating a database for testing the installation of Postgres and Age part 2.

Comments
2 min read
The Async Side of SQLModel Relationships — Part 2

The Async Side of SQLModel Relationships — Part 2

1
Comments 1
5 min read
Intro to Building a Ruby on Rails Back End

Intro to Building a Ruby on Rails Back End

4
Comments 3
10 min read
Redis Stack: The backbone for efficient MicroServices

Redis Stack: The backbone for efficient MicroServices

2
Comments
12 min read
Postgres Full Text Search

Postgres Full Text Search

3
Comments
8 min read
PolarDB Global Hackathon 2023_Win Up to $10K USD as Prizes

PolarDB Global Hackathon 2023_Win Up to $10K USD as Prizes

2
Comments
1 min read
The Async Side of SQLModel Relationships — Part 1

The Async Side of SQLModel Relationships — Part 1

1
Comments
7 min read
7 Tips for Query Optimization in SQL Servers

7 Tips for Query Optimization in SQL Servers

3
Comments
5 min read
Testing LSM-Tree merge for Size Amplification in YugabyteDB

Testing LSM-Tree merge for Size Amplification in YugabyteDB

Comments
6 min read
LSM-Tree compaction in YugabyteDB - starting a series of posts

LSM-Tree compaction in YugabyteDB - starting a series of posts

Comments
3 min read
Compress and serve big JSON dataset files in JavaScript like never before

Compress and serve big JSON dataset files in JavaScript like never before

17
Comments 14
3 min read
Password Hashing in Node.js Using bcryptjs Library.

Password Hashing in Node.js Using bcryptjs Library.

30
Comments 2
6 min read
Elasticsearch vs MongoDB - A detailed comparison of Document-Oriented Databases

Elasticsearch vs MongoDB - A detailed comparison of Document-Oriented Databases

8
Comments 2
8 min read
Setting Up PMM For Monitoring Your Databases on Windows

Setting Up PMM For Monitoring Your Databases on Windows

1
Comments
7 min read
Analyze Sydney property prices with Amazon Redshift Serverless in GA

Analyze Sydney property prices with Amazon Redshift Serverless in GA

5
Comments 4
7 min read
SQL-Server: Computed columns with Ef Core

SQL-Server: Computed columns with Ef Core

9
Comments
6 min read
Using Enum with EF Core

Using Enum with EF Core

38
Comments
3 min read
Columnar database and Row database — how are they different?

Columnar database and Row database — how are they different?

1
Comments
3 min read
Introducing the New Release of ReductStore Python SDK: v1.3.0: Labels Support and More

Introducing the New Release of ReductStore Python SDK: v1.3.0: Labels Support and More

1
Comments
3 min read
Redis Commands Cheat Sheet Part 1 - Keys and Strings

Redis Commands Cheat Sheet Part 1 - Keys and Strings

Comments
4 min read
Redis Commands Cheat Sheet Part 2 - Hashes and Lists

Redis Commands Cheat Sheet Part 2 - Hashes and Lists

Comments
3 min read
Introduction to Stream Processing

Introduction to Stream Processing

Comments
6 min read
Ultimate Guide to Understanding and Sizing AWS RDS and Aurora Instances

Ultimate Guide to Understanding and Sizing AWS RDS and Aurora Instances

3
Comments 2
5 min read
How to Document Your Trino Database with One Command (and Nothing to Install)

How to Document Your Trino Database with One Command (and Nothing to Install)

Comments
2 min read
Redshift Cost Optimization with Cost Explorer

Redshift Cost Optimization with Cost Explorer

4
Comments
5 min read
What are Materialized Views? A 5-Minute Introduction

What are Materialized Views? A 5-Minute Introduction

2
Comments
6 min read
ReductStore v1.3.0 Released!

ReductStore v1.3.0 Released!

1
Comments
2 min read
Mastering Database Indexing: A Comprehensive Guide

Mastering Database Indexing: A Comprehensive Guide

11
Comments 3
3 min read
Maximizing PostgreSQL Performance: Advanced Features and Techniques

Maximizing PostgreSQL Performance: Advanced Features and Techniques

2
Comments
2 min read
MySQL in a Nutshell: A Handy Cheatsheet of Frequently Used Queries

MySQL in a Nutshell: A Handy Cheatsheet of Frequently Used Queries

1
Comments
3 min read
Spotify Advanced SQL Interview Question on PARTITION BY Clause

Spotify Advanced SQL Interview Question on PARTITION BY Clause

1
Comments
9 min read
Why So Slow? Using Profilers to Pinpoint the Reasons of Performance Degradation

Why So Slow? Using Profilers to Pinpoint the Reasons of Performance Degradation

Comments
6 min read
SQL Count using Where Clause or Case Statement

SQL Count using Where Clause or Case Statement

2
Comments
3 min read
O QUE É UM BANCO DE DADOS E QUANTO UM DEV PRECISA SABER SOBRE?

O QUE É UM BANCO DE DADOS E QUANTO UM DEV PRECISA SABER SOBRE?

7
Comments
6 min read
Initiating a NestJs app with PostgreSQL using Docker

Initiating a NestJs app with PostgreSQL using Docker

9
Comments 1
6 min read
ORM: Prisma or Sequelize?

ORM: Prisma or Sequelize?

1
Comments 2
1 min read
INTRODUÇÃO A MODELAGEM DE DADOS

INTRODUÇÃO A MODELAGEM DE DADOS

6
Comments
15 min read
F/OSS Spotlight: 🦆 DuckDB

F/OSS Spotlight: 🦆 DuckDB

1
Comments
1 min read
SERIAL in SQLite

SERIAL in SQLite

2
Comments
1 min read
Plugging into MongoDB

Plugging into MongoDB

1
Comments
4 min read
Database Views & Rails Active Record: defining new Model classes out of views

Database Views & Rails Active Record: defining new Model classes out of views

8
Comments 2
14 min read
What's new in SeaQuery 0.28.0

What's new in SeaQuery 0.28.0

6
Comments
5 min read
Holy Sheet! Building A (Really) Simple Blog with Google Sheets as the Database

Holy Sheet! Building A (Really) Simple Blog with Google Sheets as the Database

52
Comments 8
6 min read
Functional Database Concept

Functional Database Concept

Comments
8 min read
How to Document Your Cassandra Database with One Command (and Nothing to Install)

How to Document Your Cassandra Database with One Command (and Nothing to Install)

4
Comments 3
2 min read
Snowflake for Postgres Lovers

Snowflake for Postgres Lovers

6
Comments 1
9 min read
Become a data scientist for free 🎉 in 2023 🚀

Become a data scientist for free 🎉 in 2023 🚀

6
Comments
2 min read
Create Nice-looking Schema Diagrams in PlantUML

Create Nice-looking Schema Diagrams in PlantUML

5
Comments
2 min read
Unleashing the Power of GPT-3 with a Serverless Node.js REST API: A Step-by-Step Guide

Unleashing the Power of GPT-3 with a Serverless Node.js REST API: A Step-by-Step Guide

2
Comments 1
4 min read
loading...