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.
Behind the scenes of the exciting beta 9 release

Behind the scenes of the exciting beta 9 release

12
Comments
4 min read
Active Record "merge" method. A Hidden Feature for Streamlining Database Operations.

Active Record "merge" method. A Hidden Feature for Streamlining Database Operations.

9
Comments 1
5 min read
Transform Your Data Import Process

Transform Your Data Import Process

Comments
4 min read
Loop on static content to upsert many rows in Oracle SQL

Loop on static content to upsert many rows in Oracle SQL

1
Comments
1 min read
Database Optimization Techniques for Laravel Applications.

Database Optimization Techniques for Laravel Applications.

4
Comments
5 min read
Why Queues for Streaming?

Why Queues for Streaming?

2
Comments
12 min read
Performance Enhancement: Conversion Funnel Analysis

Performance Enhancement: Conversion Funnel Analysis

Comments
9 min read
Designing Data-Intensive Applications: A Comprehensive Guide

Designing Data-Intensive Applications: A Comprehensive Guide

2
Comments
4 min read
Apache-Age: An Introduction to Graph Database Management System

Apache-Age: An Introduction to Graph Database Management System

5
Comments
3 min read
How to Write a GraphQL Query

How to Write a GraphQL Query

2
Comments
8 min read
The Graph Analytics Revolution: Understanding the Dynamic Tool Driving Modern Technology

The Graph Analytics Revolution: Understanding the Dynamic Tool Driving Modern Technology

5
Comments
2 min read
PostgreSQL 15: Breaking Barriers and Unleashing Creativity with Native JIT Compilation, Improved Parallelism, and More P2

PostgreSQL 15: Breaking Barriers and Unleashing Creativity with Native JIT Compilation, Improved Parallelism, and More P2

3
Comments
2 min read
Data Breaches and Healthcare: Is India Lacking in Healthcare Data Security?

Data Breaches and Healthcare: Is India Lacking in Healthcare Data Security?

2
Comments
4 min read
dbForge Studio for PostgreSQL Review: Why It’s a Winner For Me

dbForge Studio for PostgreSQL Review: Why It’s a Winner For Me

3
Comments
7 min read
Rename a MongoDB database in two commands

Rename a MongoDB database in two commands

4
Comments
2 min read
Understanding Foreign Data Wrappers (FDW) in PostgreSQL 4.1

Understanding Foreign Data Wrappers (FDW) in PostgreSQL 4.1

2
Comments
2 min read
How to copy a table from one PostgreSQL database to another?

How to copy a table from one PostgreSQL database to another?

3
Comments
2 min read
How to write bash script to insert the records from file my_records.txt into PostgreSQL DB table?

How to write bash script to insert the records from file my_records.txt into PostgreSQL DB table?

4
Comments
3 min read
Awesome Database for your Project

Awesome Database for your Project

65
Comments 18
4 min read
PostgreSQL. How to calculate the distance between two cities based on their corresponding GPS data?

PostgreSQL. How to calculate the distance between two cities based on their corresponding GPS data?

5
Comments
3 min read
How to check fragmentation of tables and indexes in PostgreSQL?

How to check fragmentation of tables and indexes in PostgreSQL?

3
Comments
2 min read
Build a Full Stack App with SvelteKit and OceanBase

Build a Full Stack App with SvelteKit and OceanBase

3
Comments
10 min read
Getting Started with Apache AGE: Writing Your First Query for a Simple Database App

Getting Started with Apache AGE: Writing Your First Query for a Simple Database App

4
Comments
6 min read
Text-Based Entity Relationship Diagrams with Mermaid.js

Text-Based Entity Relationship Diagrams with Mermaid.js

14
Comments 3
6 min read
From On-Prem Microsoft SQL Server to AWS Serverless - Migrating Business Intelligence, Application data Landscape

From On-Prem Microsoft SQL Server to AWS Serverless - Migrating Business Intelligence, Application data Landscape

4
Comments
4 min read
How to write an anonymous PL/SQL function and use it in your SQL statement

How to write an anonymous PL/SQL function and use it in your SQL statement

Comments
3 min read
Mastering PostgreSQL: Advanced SQL Commands, Security, and Administration

Mastering PostgreSQL: Advanced SQL Commands, Security, and Administration

Comments
6 min read
From indexing to querying: How MongoDB's full-text search stacks up against ElasticSearch.

From indexing to querying: How MongoDB's full-text search stacks up against ElasticSearch.

1
Comments
5 min read
Announcing Lucia 1.0 - A simple and flexible auth library with support for multiple databases and frameworks

Announcing Lucia 1.0 - A simple and flexible auth library with support for multiple databases and frameworks

1
Comments
2 min read
Guide to Apache AGE 1.3.0 Release for PostgreSQL 13

Guide to Apache AGE 1.3.0 Release for PostgreSQL 13

2
Comments
5 min read
Scalable bounded COUNT DISTINCT in YugabyteDB

Scalable bounded COUNT DISTINCT in YugabyteDB

Comments
6 min read
Clustered and Foreign Tables in PostgreSQL

Clustered and Foreign Tables in PostgreSQL

Comments
8 min read
How to install postgresql-server-dev-11 on ubuntu

How to install postgresql-server-dev-11 on ubuntu

1
Comments
1 min read
Step by step guide to install PostgreSQL + Apache AGE on Windows

Step by step guide to install PostgreSQL + Apache AGE on Windows

6
Comments
4 min read
The Story of One Mistake: How a Database Monitoring Tool Can Help a Developer

The Story of One Mistake: How a Database Monitoring Tool Can Help a Developer

7
Comments
5 min read
SQL Datatypes and Commands

SQL Datatypes and Commands

2
Comments
2 min read
How Change Data Capture (CDC) Works with Streaming Database

How Change Data Capture (CDC) Works with Streaming Database

8
Comments
8 min read
Exploring Shortest Path Algorithms with Apache AGE

Exploring Shortest Path Algorithms with Apache AGE

4
Comments
6 min read
Integrate Apache Spark and QuestDB for Time-Series Analytics

Integrate Apache Spark and QuestDB for Time-Series Analytics

7
Comments
20 min read
Vector Databases

Vector Databases

30
Comments 4
3 min read
Supercharge Your Database: A Deep Dive into Optimizing Queries with ApacheAGE

Supercharge Your Database: A Deep Dive into Optimizing Queries with ApacheAGE

1
Comments
3 min read
Database Change Management with ClickHouse

Database Change Management with ClickHouse

Comments
7 min read
Data Reduction and Why It Is Important For Edge Computing

Data Reduction and Why It Is Important For Edge Computing

5
Comments
3 min read
Uncovering Credit Card Thieves: A Graph-Based Approach with Apache AGE

Uncovering Credit Card Thieves: A Graph-Based Approach with Apache AGE

4
Comments
9 min read
Graph Databases vs Relational Databases: What and why?

Graph Databases vs Relational Databases: What and why?

166
Comments 6
13 min read
Exploring the Advanced Features of Apache AGE: How This Graph Extension Can Take Your Data Management to the Next Level

Exploring the Advanced Features of Apache AGE: How This Graph Extension Can Take Your Data Management to the Next Level

2
Comments
3 min read
Getting Started with Apache AGE: A Comprehensive Guide (Part 1)

Getting Started with Apache AGE: A Comprehensive Guide (Part 1)

5
Comments
2 min read
Taming Time: how to install & develop with XTDB

Taming Time: how to install & develop with XTDB

1
Comments
11 min read
Migration Magic ✨, Handling Not-Null Constraints in Production with Ruby on Rails

Migration Magic ✨, Handling Not-Null Constraints in Production with Ruby on Rails

2
Comments
3 min read
Understanding Indexes in PostgreSQL: Part 2

Understanding Indexes in PostgreSQL: Part 2

1
Comments
3 min read
Understanding Indexes in PostgreSQL: An Introduction

Understanding Indexes in PostgreSQL: An Introduction

1
Comments
3 min read
How to build a custom eloquent builder class in Laravel.

How to build a custom eloquent builder class in Laravel.

7
Comments
6 min read
Como eu deixei meu banco de dados open-source 4 VEZES mais rápido

Como eu deixei meu banco de dados open-source 4 VEZES mais rápido

2
Comments
4 min read
Stop Wasting Time Comparing Databases Manually! Learn How Dynamic Queries Can Save You Time and Hassle 💻🚀

Stop Wasting Time Comparing Databases Manually! Learn How Dynamic Queries Can Save You Time and Hassle 💻🚀

Comments
2 min read
Simulating Streaming Data for Fraud Detection with Datagen CLI

Simulating Streaming Data for Fraud Detection with Datagen CLI

28
Comments 1
5 min read
Relational database vs nosql: A Beginner's Guide

Relational database vs nosql: A Beginner's Guide

12
Comments
9 min read
A Complete Guide to Database Security Testing

A Complete Guide to Database Security Testing

5
Comments 1
3 min read
MLOps is 98% Data Engineering

MLOps is 98% Data Engineering

1
Comments
10 min read
Distributed Managed PostgreSQL Database Alternatives in the Cloud

Distributed Managed PostgreSQL Database Alternatives in the Cloud

2
Comments
3 min read
Programming is the art of trade-off

Programming is the art of trade-off

25
Comments 4
5 min read
loading...