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.
Is Select * actually expensive

Is Select * actually expensive

10
Comments
3 min read
What is Data?

What is Data?

Comments
3 min read
Installing Apache AGE with Docker on Windows

Installing Apache AGE with Docker on Windows

2
Comments
3 min read
6 weeks with Rust

6 weeks with Rust

Comments
4 min read
The 5 rules for writing faster SQL

The 5 rules for writing faster SQL

3
Comments 1
8 min read
Object-Oriented Ruby Basics

Object-Oriented Ruby Basics

2
Comments
4 min read
Redis Performance Tuning: How to Optimize Redis for High-Traffic Applications

Redis Performance Tuning: How to Optimize Redis for High-Traffic Applications

194
Comments 2
7 min read
My lecture at the Stockholm Tech Show 2023.

My lecture at the Stockholm Tech Show 2023.

1
Comments
2 min read
Introduction to Graph Databases

Introduction to Graph Databases

4
Comments
3 min read
HTAP: Learning from Xiaohongshu

HTAP: Learning from Xiaohongshu

1
Comments
5 min read
Multi-Stream Joins With SQL

Multi-Stream Joins With SQL

8
Comments
8 min read
Multiple Airflow deployment in Single DB

Multiple Airflow deployment in Single DB

2
Comments 1
2 min read
Entendendo RelaçÔes Genéricas no framework Django

Entendendo RelaçÔes Genéricas no framework Django

2
Comments
5 min read
An easy way to use a MySQL database in Node.js (Node.js MySQL vs Node.js MySQL + NanoQL)

An easy way to use a MySQL database in Node.js (Node.js MySQL vs Node.js MySQL + NanoQL)

1
Comments
2 min read
Apache AGE Intro

Apache AGE Intro

1
Comments
1 min read
Getting Started with SQLite in Python: Events Database

Getting Started with SQLite in Python: Events Database

3
Comments 1
3 min read
HTAP database cannot handle HTAP requirements

HTAP database cannot handle HTAP requirements

Comments
13 min read
Symfony/Doctrine migrations for multiple databases

Symfony/Doctrine migrations for multiple databases

5
Comments 1
1 min read
How to debug AGE source code on VSCode

How to debug AGE source code on VSCode

5
Comments
3 min read
Querying SQL from Databricks without PyODBC

Querying SQL from Databricks without PyODBC

2
Comments
3 min read
PostgreSQL 14: TLS 掄続

PostgreSQL 14: TLS 掄続

3
Comments
2 min read
How PostgreSQL plant a tree

How PostgreSQL plant a tree

3
Comments
4 min read
PostgreSQL on OpenBSD: 14 から 15 ăžăźă‚ąăƒƒăƒ—ă‚°ăƒŹăƒŒăƒ‰ - pg_upgrade äœżç”š

PostgreSQL on OpenBSD: 14 から 15 ăžăźă‚ąăƒƒăƒ—ă‚°ăƒŹăƒŒăƒ‰ - pg_upgrade äœżç”š

1
Comments
4 min read
PostgreSQL 12: TLS 掄続

PostgreSQL 12: TLS 掄続

1
Comments
2 min read
Introduction to Age Viewer: A Web-Based Visualization Tool for Apache Age

Introduction to Age Viewer: A Web-Based Visualization Tool for Apache Age

4
Comments
3 min read
PostgreSQL on OpenBSD: 12 から 13 ăžăźă‚ąăƒƒăƒ—ă‚°ăƒŹăƒŒăƒ‰ - pg_dumpall äœżç”š

PostgreSQL on OpenBSD: 12 から 13 ăžăźă‚ąăƒƒăƒ—ă‚°ăƒŹăƒŒăƒ‰ - pg_dumpall äœżç”š

1
Comments
2 min read
Project: Label with a junction table and indexes

Project: Label with a junction table and indexes

4
Comments 1
2 min read
Exploring EF Core Updates Land: Join Us on an Exciting Journey

Exploring EF Core Updates Land: Join Us on an Exciting Journey

2
Comments
10 min read
How Database Indexes Affect MongoDB and Application Performance

How Database Indexes Affect MongoDB and Application Performance

12
Comments 3
5 min read
A Quick Intro to Relational Database Components

A Quick Intro to Relational Database Components

2
Comments
2 min read
Oplog Update Version ($v) Digest

Oplog Update Version ($v) Digest

Comments
2 min read
Database in Django

Database in Django

1
Comments 1
4 min read
Online Schema Changes with CRDB

Online Schema Changes with CRDB

1
Comments
5 min read
PostgreSQL on OpenBSD: Upgrade 14 to 15 with pg_upgrade

PostgreSQL on OpenBSD: Upgrade 14 to 15 with pg_upgrade

3
Comments
6 min read
Python – Dynamically accessing object properties

Python – Dynamically accessing object properties

3
Comments
3 min read
Managing Dataflow and SQL Database with Concurrency Control

Managing Dataflow and SQL Database with Concurrency Control

2
Comments
8 min read
Where did Microservices go

Where did Microservices go

136
Comments 13
8 min read
Handling NULL in the DBs

Handling NULL in the DBs

5
Comments 1
2 min read
Unwrap Oracle Home .plb

Unwrap Oracle Home .plb

12
Comments
1 min read
Memgraph, Client Adapters and WebAssembly. What?

Memgraph, Client Adapters and WebAssembly. What?

Comments
4 min read
A guide to Solana Geyser Plugins

A guide to Solana Geyser Plugins

48
Comments
4 min read
From data storage to data analysis: Tutorial on CrateDB and pandas 2

From data storage to data analysis: Tutorial on CrateDB and pandas 2

1
Comments
3 min read
Use Chance.js and Fony.js in your SQL queries😎

Use Chance.js and Fony.js in your SQL queries😎

Comments
20 min read
The Battle of With vs Load in Eloquent: Which One Wins?

The Battle of With vs Load in Eloquent: Which One Wins?

12
Comments 3
6 min read
PR preview environments with Neon, GitHub Actions, and AWS Lambda

PR preview environments with Neon, GitHub Actions, and AWS Lambda

1
Comments
10 min read
Identifying Essential Proteins Using Betweenness Centrality & Memgraph MAGE

Identifying Essential Proteins Using Betweenness Centrality & Memgraph MAGE

Comments
5 min read
“Multi-AZ” in Amazon RDS and how it may differ from High Availability or resilience to failures

“Multi-AZ” in Amazon RDS and how it may differ from High Availability or resilience to failures

12
Comments
12 min read
How a large transaction can be a source of DB deadlocks and how this can be fixed.

How a large transaction can be a source of DB deadlocks and how this can be fixed.

2
Comments 1
3 min read
Real-time databases: what developers need to know

Real-time databases: what developers need to know

2
Comments
14 min read
How to Deploy and configure servers and database for Azure SQL

How to Deploy and configure servers and database for Azure SQL

2
Comments
4 min read
Comand Line Tools to Export SQL Server Query to CSV

Comand Line Tools to Export SQL Server Query to CSV

7
Comments
5 min read
Querying microservices in real-time with materialized views

Querying microservices in real-time with materialized views

18
Comments
7 min read
Understanding SQL Joins: A Beginner's Guide

Understanding SQL Joins: A Beginner's Guide

Comments
5 min read
Step-by-step Guide to Building a High-Performing Risk Data Mart

Step-by-step Guide to Building a High-Performing Risk Data Mart

Comments
7 min read
Quick Comparison Cheat Sheet: Amazon Aurora vs. Amazon RDS

Quick Comparison Cheat Sheet: Amazon Aurora vs. Amazon RDS

2
Comments
4 min read
Exposed in Your Project - Part 1

Exposed in Your Project - Part 1

Comments
5 min read
ClickHouse Basic Tutorial: Table Engines

ClickHouse Basic Tutorial: Table Engines

23
Comments 1
6 min read
The current Lakehouse is like a false proposition

The current Lakehouse is like a false proposition

Comments
11 min read
Developer Q&A: Monitoring global API latency with chronark

Developer Q&A: Monitoring global API latency with chronark

Comments
8 min read
The Part of PostgreSQL we Don’t know the most

The Part of PostgreSQL we Don’t know the most

2
Comments
3 min read
loading...