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.
Base Backup & Point-in-Time Recovery: PostgreSQL

Base Backup & Point-in-Time Recovery: PostgreSQL

1
Comments
2 min read
Web server, database and other important settings

Web server, database and other important settings

Comments
2 min read
Heap Only Tuples and Index-Only Scans - A Comprehensive Guide

Heap Only Tuples and Index-Only Scans - A Comprehensive Guide

Comments
6 min read
Hasura is sooooo 2015

Hasura is sooooo 2015

Comments
9 min read
Database and Scaling : Backend Development [Part 2/2]

Database and Scaling : Backend Development [Part 2/2]

1
Comments
8 min read
Oracle Upgrade Decoded: Insights from an App Developer's Perspective

Oracle Upgrade Decoded: Insights from an App Developer's Perspective

Comments
4 min read
Chapter 3 Query Processing: Join Operations in PostgreSQL

Chapter 3 Query Processing: Join Operations in PostgreSQL

1
Comments 2
3 min read
Placements | HackerRank | MSSQL

Placements | HackerRank | MSSQL

Comments
3 min read
Rethink the way you share the data between micro-services with Change-Data-Capture

Rethink the way you share the data between micro-services with Change-Data-Capture

2
Comments
4 min read
Functions for manipulating data in PostgreSQL

Functions for manipulating data in PostgreSQL

Comments
10 min read
Integrating Apache AGE with Business Intelligence Tools

Integrating Apache AGE with Business Intelligence Tools

Comments
3 min read
Vacuum Processing - A Beginner's Guide

Vacuum Processing - A Beginner's Guide

Comments
5 min read
AntDB with CloudCC Promotes Digital Transformation

AntDB with CloudCC Promotes Digital Transformation

Comments
4 min read
How AGE is executed on top of PostgreSQL

How AGE is executed on top of PostgreSQL

5
Comments
3 min read
Connect ChatGPT to your SQL Database

Connect ChatGPT to your SQL Database

23
Comments 8
2 min read
Database regions and why they matter

Database regions and why they matter

4
Comments
2 min read
How Apache AGE Facilitates Knowledge Graph Construction: A Comprehensive Guide

How Apache AGE Facilitates Knowledge Graph Construction: A Comprehensive Guide

Comments
3 min read
Interacting with Apache AGE: Best Practices for Application Developers

Interacting with Apache AGE: Best Practices for Application Developers

1
Comments
2 min read
Timestamp SQL Files for Consistent Laravel Migration

Timestamp SQL Files for Consistent Laravel Migration

6
Comments 2
3 min read
Event Streaming Platforms: Kafka - A Hands-On Tutorial

Event Streaming Platforms: Kafka - A Hands-On Tutorial

Comments
6 min read
Databases simplified

Databases simplified

6
Comments
1 min read
Database Transactions

Database Transactions

Comments
2 min read
How to deliver the best search results: inside a full text search engine

How to deliver the best search results: inside a full text search engine

2
Comments
10 min read
Structured Query Language (SQL)| Full Explanation (Definition, usage, structure and example with MySQL)

Structured Query Language (SQL)| Full Explanation (Definition, usage, structure and example with MySQL)

4
Comments
3 min read
Supabase Needs Column Level Security

Supabase Needs Column Level Security

13
Comments 2
6 min read
结构化查询语言(SQL)| 完整解释(定义、用法、结构和 MySQL 示例)

结构化查询语言(SQL)| 完整解释(定义、用法、结构和 MySQL 示例)

Comments
1 min read
Linguagem de consulta estruturada (SQL) | Explicação Completa (Definição, uso, estrutura e exemplo com MySQL)

Linguagem de consulta estruturada (SQL) | Explicação Completa (Definição, uso, estrutura e exemplo com MySQL)

Comments
3 min read
Structured Query Language (SQL)| Explicación Completa (Definición, uso, estructura y ejemplo con MySQL)

Structured Query Language (SQL)| Explicación Completa (Definición, uso, estructura y ejemplo con MySQL)

Comments
3 min read
How to deal with 40 million documents per day with AWS OpenSearch

How to deal with 40 million documents per day with AWS OpenSearch

3
Comments
5 min read
Book review: Mastering PostgreSQL 15

Book review: Mastering PostgreSQL 15

6
Comments
5 min read
Deploy Rails with Yugabyte

Deploy Rails with Yugabyte

2
Comments
2 min read
Deploy your full stack React & Node.js app

Deploy your full stack React & Node.js app

Comments
6 min read
Central Repository of CVs with Amazon Textract and Neptune

Central Repository of CVs with Amazon Textract and Neptune

1
Comments
3 min read
PostgreSQL-Elasticsearch Replication: A Deep Dive into Write-Ahead Logging.

PostgreSQL-Elasticsearch Replication: A Deep Dive into Write-Ahead Logging.

Comments
4 min read
Speed up your query in Postgres

Speed up your query in Postgres

2
Comments
5 min read
The best way to store and read relational data with Dapper

The best way to store and read relational data with Dapper

Comments
9 min read
System Design vs Software Architecture : What You Need to Know

System Design vs Software Architecture : What You Need to Know

3
Comments
8 min read
Introduction to Apache AGE: Exploring the Capabilities

Introduction to Apache AGE: Exploring the Capabilities

2
Comments
2 min read
ReductStore v1.5.0 has been released

ReductStore v1.5.0 has been released

6
Comments
2 min read
Enhance Your Search Capabilities with MongoDB Atlas: Advanced Querying Techniques

Enhance Your Search Capabilities with MongoDB Atlas: Advanced Querying Techniques

Comments
4 min read
Using PgBouncer to improve performance and reduce the load on PostgreSQL

Using PgBouncer to improve performance and reduce the load on PostgreSQL

3
Comments
7 min read
Use Prometheus to Monitor Memgraph’s Performance Metrics

Use Prometheus to Monitor Memgraph’s Performance Metrics

Comments
6 min read
Use ChatGPT to Explore Your Database Schema

Use ChatGPT to Explore Your Database Schema

26
Comments 11
2 min read
Save documets or files using EntityFrameworkCore to database

Save documets or files using EntityFrameworkCore to database

1
Comments
2 min read
Exploring the Limitations of Postgres Partitioning: Lessons Learned and Best Practices

Exploring the Limitations of Postgres Partitioning: Lessons Learned and Best Practices

6
Comments
2 min read
The Significance of Encryption in Database Security

The Significance of Encryption in Database Security

Comments
5 min read
Serve your hash with Salt and Pepper for Stronger Account Security

Serve your hash with Salt and Pepper for Stronger Account Security

2
Comments
6 min read
Unveiling the Capabilities of Managed Databases: An In-Depth Look at Amazon RDS

Unveiling the Capabilities of Managed Databases: An In-Depth Look at Amazon RDS

2
Comments
9 min read
Using Prisma with SvelteKit

Using Prisma with SvelteKit

38
Comments 1
4 min read
Aggregation Function in Apache AGE: The count() function

Aggregation Function in Apache AGE: The count() function

3
Comments
3 min read
Migrating from a Redis Cluster to Dragonfly on a single node

Migrating from a Redis Cluster to Dragonfly on a single node

Comments
7 min read
Understanding the Apache AGE DELETE Clause.

Understanding the Apache AGE DELETE Clause.

2
Comments
2 min read
Comparing Aerospike clusters using "queryPartitions"

Comparing Aerospike clusters using "queryPartitions"

1
Comments
8 min read
Migrate a MySQL database to a new version and cloud provider

Migrate a MySQL database to a new version and cloud provider

Comments
9 min read
5 Questions on Performance Benchmarks

5 Questions on Performance Benchmarks

Comments
5 min read
Understanding Query Processing in PostgreSQL: Part 1

Understanding Query Processing in PostgreSQL: Part 1

2
Comments
3 min read
Exploring the Fundamentals of Database Cluster, Databases, Tables, and Internal Layout in PostgreSQL

Exploring the Fundamentals of Database Cluster, Databases, Tables, and Internal Layout in PostgreSQL

Comments
4 min read
How to Start Using psql in Terminal (for Beginners)

How to Start Using psql in Terminal (for Beginners)

3
Comments
3 min read
More String Functions in SQLite

More String Functions in SQLite

1
Comments
3 min read
Trigonometric Functions in Apache AGE

Trigonometric Functions in Apache AGE

Comments
2 min read
loading...