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.
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
Advanced downsampling with the LTTB algorithm

Advanced downsampling with the LTTB algorithm

7
Comments
4 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
How PostgreSQL database tables rows are allocated?

How PostgreSQL database tables rows are allocated?

Comments
14 min read
Data Storage perception

Data Storage perception

2
Comments
2 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

5
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
Rails Live Coding

Rails Live Coding

2
Comments
3 min read
Using In-Memory Databases in Data Science

Using In-Memory Databases in Data Science

2
Comments
7 min read
Batch Processing vs Stream Processing

Batch Processing vs Stream Processing

1
Comments
4 min read
Roadmap to becoming a 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁 for 𝗙𝗥𝗘𝗘

Roadmap to becoming a 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁 for 𝗙𝗥𝗘𝗘

3
Comments
1 min read
IndexedDB, your offline and serverless DB in your browser with React

IndexedDB, your offline and serverless DB in your browser with React

70
Comments 3
8 min read
Postgres Database in a Docker Container

Postgres Database in a Docker Container

2
Comments
3 min read
connect MongoDB to Node.js

connect MongoDB to Node.js

5
Comments
1 min read
PostgreSQL database INSERT multiple rows: how the number of rows impacts timing?

PostgreSQL database INSERT multiple rows: how the number of rows impacts timing?

7
Comments 1
5 min read
Qual ORM usar no seu próximo projeto Python?

Qual ORM usar no seu próximo projeto Python?

37
Comments 2
10 min read
How to populate a table in PostgreSQL database using INSERT multiple rows and flash-by-chunks approach?

How to populate a table in PostgreSQL database using INSERT multiple rows and flash-by-chunks approach?

1
Comments
2 min read
PostgreSQL 14.5 on OpenBSD 7.2: インストール

PostgreSQL 14.5 on OpenBSD 7.2: インストール

1
Comments
2 min read
How to populate a table in PostgreSQL database using INSERT multiple rows approach?

How to populate a table in PostgreSQL database using INSERT multiple rows approach?

Comments
2 min read
How to populate a table with one million records in PostgreSQL database?

How to populate a table with one million records in PostgreSQL database?

Comments
2 min read
Database 101: Data Consistency for Beginners

Database 101: Data Consistency for Beginners

461
Comments 44
7 min read
3 Powerful Queries to Find Patterns in Your Knowledge Graph You Haven’t Noticed Before

3 Powerful Queries to Find Patterns in Your Knowledge Graph You Haven’t Noticed Before

2
Comments
5 min read
Understanding Relationships in TypeORM

Understanding Relationships in TypeORM

31
Comments
6 min read
When you plan to build a dApp, you need DB3 Network

When you plan to build a dApp, you need DB3 Network

4
Comments
4 min read
SQLite New Features

SQLite New Features

8
Comments
3 min read
Understanding File Structure for Backend API development using NodeJS, Express, and PostgreSQL

Understanding File Structure for Backend API development using NodeJS, Express, and PostgreSQL

5
Comments
2 min read
The impasse of SQL performance optimizing

The impasse of SQL performance optimizing

1
Comments
9 min read
Perform What-if Analysis of Your Network Directly in Storage Without Compromising Data Integrity

Perform What-if Analysis of Your Network Directly in Storage Without Compromising Data Integrity

1
Comments
9 min read
When are PostgreSQL prepared statements fully prepared for execution?

When are PostgreSQL prepared statements fully prepared for execution?

4
Comments
5 min read
Best Database for C++ Development

Best Database for C++ Development

7
Comments
2 min read
Redis: What It Is, What It Does, and Why You Should Care

Redis: What It Is, What It Does, and Why You Should Care

3
Comments
10 min read
MySQL: How to create One-to-Many Relationship

MySQL: How to create One-to-Many Relationship

29
Comments
6 min read
Analysing Github Stars - Extracting and analyzing data from Github using Apache NiFi®, Apache Kafka® and Apache Druid®

Analysing Github Stars - Extracting and analyzing data from Github using Apache NiFi®, Apache Kafka® and Apache Druid®

3
Comments
9 min read
How to Improve the Performance of Your Rails App by Eliminating N+1 Database Queries

How to Improve the Performance of Your Rails App by Eliminating N+1 Database Queries

12
Comments
4 min read
Easy backend for React

Easy backend for React

2
Comments
5 min read
Get the count of affected rows with ease: The power of the RETURNING clause in Postgres

Get the count of affected rows with ease: The power of the RETURNING clause in Postgres

6
Comments 1
2 min read
PostgreSQL vs MySQL: Which Best Suits Your Business?

PostgreSQL vs MySQL: Which Best Suits Your Business?

1
Comments
3 min read
How to Build a Spotify Recommendation Engine Using Kafka and Memgraph

How to Build a Spotify Recommendation Engine Using Kafka and Memgraph

1
Comments
5 min read
loading...