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.
Understanding Joins in SQL

Understanding Joins in SQL

4
Comments 2
3 min read
Optimizing Pagination: Range-Based Queries with Cursors and Happy Databases 🚀

Optimizing Pagination: Range-Based Queries with Cursors and Happy Databases 🚀

3
Comments
4 min read
Comparing SQL and Cypher Query Language

Comparing SQL and Cypher Query Language

2
Comments
2 min read
Exploring Citus: Enhancing PostgreSQL with Scalability

Exploring Citus: Enhancing PostgreSQL with Scalability

Comments
2 min read
How We Achieved Minimal Downtime During Our PostgreSQL Database Upgrade

How We Achieved Minimal Downtime During Our PostgreSQL Database Upgrade

1
Comments
1 min read
How to use IndexedDB to store images and other files in your browser

How to use IndexedDB to store images and other files in your browser

2
Comments 1
7 min read
🚀Remove by query API in API Maker

🚀Remove by query API in API Maker

10
Comments
2 min read
Building Interactive Snowflake Data Apps with Streamlit

Building Interactive Snowflake Data Apps with Streamlit

4
Comments
3 min read
Getting Started with Apache Age and Age Viewer

Getting Started with Apache Age and Age Viewer

4
Comments
3 min read
🐘Top Postgres GUI Clients to Master Postgres☄️🦖

🐘Top Postgres GUI Clients to Master Postgres☄️🦖

43
Comments 3
3 min read
Discover the Hidden Powers of PostgreSQL: Lateral Joins and JSON Columns Decoded!

Discover the Hidden Powers of PostgreSQL: Lateral Joins and JSON Columns Decoded!

Comments
2 min read
Streaming Databases: Everything You Wanted to Know

Streaming Databases: Everything You Wanted to Know

Comments
6 min read
Automatically Provision AWS Resources with Terraform

Automatically Provision AWS Resources with Terraform

Comments
6 min read
Beyond the Basics:Custom Data Types and Functions in Postgresql

Beyond the Basics:Custom Data Types and Functions in Postgresql

3
Comments
3 min read
Troubleshooting PostgreSQL High CPU Usage - Part 2

Troubleshooting PostgreSQL High CPU Usage - Part 2

2
Comments
5 min read
Effective Data Modeling in PostgreSQL for Java Backend Developers

Effective Data Modeling in PostgreSQL for Java Backend Developers

Comments
3 min read
Adminer replace phpmyadmin, run with php build in webserver

Adminer replace phpmyadmin, run with php build in webserver

Comments
1 min read
Efficient Representation of Relationships with Graph Databases

Efficient Representation of Relationships with Graph Databases

2
Comments
2 min read
Database Review: Top Five Missing Features from Database APIs

Database Review: Top Five Missing Features from Database APIs

9
Comments 1
6 min read
Developing with Dragonfly: Solve Caching Problems

Developing with Dragonfly: Solve Caching Problems

1
Comments
11 min read
Chatting with your database: What did I learn by letting AI generate SQL?

Chatting with your database: What did I learn by letting AI generate SQL?

9
Comments 1
2 min read
Be Cautious When Using Hibernate for Date Type Manipulation with Databases

Be Cautious When Using Hibernate for Date Type Manipulation with Databases

5
Comments
3 min read
How to Design a SurrealDB schema and create a basic client for TypeScript

How to Design a SurrealDB schema and create a basic client for TypeScript

18
Comments
6 min read
I made ERD and documents genertor of Prisma ORM

I made ERD and documents genertor of Prisma ORM

68
Comments 4
5 min read
Apache AGE and PostgreSQL: Your Guide to Understanding Database Systems

Apache AGE and PostgreSQL: Your Guide to Understanding Database Systems

4
Comments
2 min read
Solving the Notorious N+1 Problem: Optimizing Database Queries for Java Backend Developers

Solving the Notorious N+1 Problem: Optimizing Database Queries for Java Backend Developers

18
Comments
3 min read
MongoDB Replication Why and How?

MongoDB Replication Why and How?

2
Comments
6 min read
Web Scraping Car Sites to Help Me Shop Better

Web Scraping Car Sites to Help Me Shop Better

4
Comments 2
7 min read
What Are Window Functions in SQL & How To Use Them

What Are Window Functions in SQL & How To Use Them

1
Comments
6 min read
SQL-Server insert record get primary key back

SQL-Server insert record get primary key back

3
Comments 1
4 min read
Mastering PostgreSQL JSONB: Advanced Techniques for Flexible Data Modeling

Mastering PostgreSQL JSONB: Advanced Techniques for Flexible Data Modeling

3
Comments
2 min read
How to get started with MongoDB as a Student

How to get started with MongoDB as a Student

9
Comments 5
4 min read
SQL Server - Timing out because of table variables

SQL Server - Timing out because of table variables

Comments
3 min read
Index Optimization in Database Query Performance: Guidelines and Real-world Examples

Index Optimization in Database Query Performance: Guidelines and Real-world Examples

27
Comments 6
2 min read
ReductStore vs. MinIO & InfluxDB on LTE Network: Who Really Wins the Speed Race?

ReductStore vs. MinIO & InfluxDB on LTE Network: Who Really Wins the Speed Race?

5
Comments
5 min read
From Participant to Intern - Zou Wei's Journey with Greptime and OSPP 2023

From Participant to Intern - Zou Wei's Journey with Greptime and OSPP 2023

Comments
4 min read
Optimize AWS Storage Costs with Amazon S3 Lifecycle Configurations

Optimize AWS Storage Costs with Amazon S3 Lifecycle Configurations

5
Comments
8 min read
Exploring Graph Analytics with Apache AGE: A Comprehensive Overview

Exploring Graph Analytics with Apache AGE: A Comprehensive Overview

1
Comments
2 min read
Building an International Dollar Node: A Deep Dive

Building an International Dollar Node: A Deep Dive

Comments
3 min read
No Backend: How This Firebase Alternative Changing The Game

No Backend: How This Firebase Alternative Changing The Game

2
Comments 1
3 min read
🚀 Array operations API in API Maker

🚀 Array operations API in API Maker

10
Comments
4 min read
Implementing hassle-free audits in the SQL database

Implementing hassle-free audits in the SQL database

3
Comments
11 min read
Database 101: How does migration between databases work in the real world?

Database 101: How does migration between databases work in the real world?

577
Comments 54
9 min read
Comparing SQL and Cypher Query Language

Comparing SQL and Cypher Query Language

Comments
2 min read
Simplifying Database Management: How to Import and Export CSV Files on Xata Database.

Simplifying Database Management: How to Import and Export CSV Files on Xata Database.

Comments
4 min read
Mongo Indexes you should be known

Mongo Indexes you should be known

2
Comments
2 min read
Creating a new Cluster in EDB Big animal

Creating a new Cluster in EDB Big animal

Comments
2 min read
WTF Is a Vector Database: A Beginner's Guide!

WTF Is a Vector Database: A Beginner's Guide!

170
Comments 17
9 min read
Exploring PostgreSQL: Foreign Data Wrappers (FDW).

Exploring PostgreSQL: Foreign Data Wrappers (FDW).

14
Comments
3 min read
Summary of Chapter# 9 : "Write Ahead Logging (WAL)" from the book "The Internals of PostgreSQL" Part-4

Summary of Chapter# 9 : "Write Ahead Logging (WAL)" from the book "The Internals of PostgreSQL" Part-4

2
Comments
5 min read
Window Functions

Window Functions

2
Comments
3 min read
SQL Commands

SQL Commands

2
Comments
2 min read
MariaDB Installation Made Easy: A Guide for Arch-Based Linux Users

MariaDB Installation Made Easy: A Guide for Arch-Based Linux Users

26
Comments
2 min read
Social network analysis using graph databases

Social network analysis using graph databases

Comments
2 min read
Graph databases as a powerful tool for fraud detection

Graph databases as a powerful tool for fraud detection

Comments
2 min read
Kafka in a Nutshell 🌰: Events, Topics, and APIs made simple

Kafka in a Nutshell 🌰: Events, Topics, and APIs made simple

4
Comments 1
2 min read
SurrealDB  - The Magic Database to Keep on Your Radar

SurrealDB  - The Magic Database to Keep on Your Radar

17
Comments
3 min read
SurrealDB - Query and combine data via relations

SurrealDB - Query and combine data via relations

10
Comments
5 min read
Data migrations in regular migrations and why you (probably) should not do that

Data migrations in regular migrations and why you (probably) should not do that

12
Comments 1
3 min read
SurrealDB - Structuring Data for Multi-Tenant Role & Permission Systems

SurrealDB - Structuring Data for Multi-Tenant Role & Permission Systems

13
Comments
5 min read
loading...