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

5
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?

8
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

6
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

5
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
AWS Databases Cheat-sheet/Write-up

AWS Databases Cheat-sheet/Write-up

8
Comments
11 min read
Introduction au SQL

Introduction au SQL

Comments
2 min read
Learn the theory behind how to deal with streaming graph data by using Dynamic PageRank

Learn the theory behind how to deal with streaming graph data by using Dynamic PageRank

1
Comments
5 min read
Put this in your {app} and {control} it, or how Sinatra serenades our data

Put this in your {app} and {control} it, or how Sinatra serenades our data

4
Comments
5 min read
Monitoring an on-premises CrateDB cluster with Prometheus and Grafana

Monitoring an on-premises CrateDB cluster with Prometheus and Grafana

Comments
8 min read
Advanced downsampling with the LTTB algorithm

Advanced downsampling with the LTTB algorithm

9
Comments
4 min read
Data Storage perception

Data Storage perception

2
Comments
2 min read
How PostgreSQL database tables rows are allocated?

How PostgreSQL database tables rows are allocated?

Comments
14 min read
Introducing VeloxDB

Introducing VeloxDB

3
Comments
4 min read
Optimizing DynamoDB cost: Tips and Tricks

Optimizing DynamoDB cost: Tips and Tricks

24
Comments 2
3 min read
Aerospike Kubernetes - Talking Cluster to Cluster using XDR-Proxy

Aerospike Kubernetes - Talking Cluster to Cluster using XDR-Proxy

Comments
14 min read
Our Top 5 Picks for the Best Open Source Database Software

Our Top 5 Picks for the Best Open Source Database Software

5
Comments 1
5 min read
Ingesting with CrateDB

Ingesting with CrateDB

Comments
7 min read
Working with cursors with SQL commands in CrateDB

Working with cursors with SQL commands in CrateDB

Comments
2 min read
YugabyteDB Helm Chart services: LoadBalancer and headless ClusterIP ☸️🚀

YugabyteDB Helm Chart services: LoadBalancer and headless ClusterIP ☸️🚀

3
Comments
6 min read
Python Django: Create a more secure database by using a custom field

Python Django: Create a more secure database by using a custom field

3
Comments
2 min read
Serverless Technology

Serverless Technology

8
Comments 6
2 min read
In-Memory Databases that Work Great with Python

In-Memory Databases that Work Great with Python

7
Comments
5 min read
Innodb_buffer_pool_size

Innodb_buffer_pool_size

1
Comments
4 min read
The rise of GraphQL APIs on data warehouses

The rise of GraphQL APIs on data warehouses

2
Comments
10 min read
Migrating Elasticsearch’s warm & cold data to object storage with JuiceFS

Migrating Elasticsearch’s warm & cold data to object storage with JuiceFS

6
Comments
6 min read
loading...