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 fix MySQL Syntax Error: Unexpected Identifier

How to fix MySQL Syntax Error: Unexpected Identifier

15
Comments 2
1 min read
Using Geospatial Queries in MySQL

Using Geospatial Queries in MySQL

8
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.

24
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

4
Comments
6 min read
Using Enum with EF Core

Using Enum with EF Core

28
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

2
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

1
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

50
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

5
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
Proxies for Alternative Data

Proxies for Alternative Data

2
Comments 1
12 min read
EF Core debugging part 1

EF Core debugging part 1

4
Comments 5
5 min read
Building a Data Lakehouse for Analyzing Elon Musk Tweets using MinIO, Apache Airflow, Apache Drill and Apache Superset

Building a Data Lakehouse for Analyzing Elon Musk Tweets using MinIO, Apache Airflow, Apache Drill and Apache Superset

16
Comments 2
8 min read
Reverse ETL

Reverse ETL

6
Comments
3 min read
🚩 Bitwise flags are amazing, and you should use them

🚩 Bitwise flags are amazing, and you should use them

3
Comments
6 min read
Introducing Hive UI: A Flutter Package for Easily Managing Your Hive Database

Introducing Hive UI: A Flutter Package for Easily Managing Your Hive Database

3
Comments
3 min read
CTEs, Views or Temp Tables?

CTEs, Views or Temp Tables?

7
Comments 1
8 min read
CLI Client for ReductStore v0.5.0 has been released

CLI Client for ReductStore v0.5.0 has been released

2
Comments
1 min read
loading...