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.
Graph representation in relational tables

Graph representation in relational tables

2
Comments
2 min read
Guide: Creating Temporary Tables in PostgreSQL

Guide: Creating Temporary Tables in PostgreSQL

3
Comments
3 min read
Enhancing Stored Procedure Efficiency: A Journey of Problem Solving and Best Practices

Enhancing Stored Procedure Efficiency: A Journey of Problem Solving and Best Practices

Comments
2 min read
Manager Handbook for Distributed AntDB-T - P1

Manager Handbook for Distributed AntDB-T - P1

2
Comments
3 min read
Creating a table in database in BigAnimal

Creating a table in database in BigAnimal

Comments
1 min read
Creating a Cluster, connecting and creating a database in EDB

Creating a Cluster, connecting and creating a database in EDB

Comments
1 min read
Backup and Recovery for PostgreSQL

Backup and Recovery for PostgreSQL

Comments
2 min read
Data Enrichment Services for B2B: Maximizing the Value of Your Data

Data Enrichment Services for B2B: Maximizing the Value of Your Data

Comments
6 min read
Connect database from the edge

Connect database from the edge

3
Comments
4 min read
Apache AGE and Machine Learning: Enhancing Analytics with Graph Databases

Apache AGE and Machine Learning: Enhancing Analytics with Graph Databases

2
Comments
3 min read
AWS HealthLake Exports

AWS HealthLake Exports

3
Comments
6 min read
Replacing Apache Hive, Elasticsearch, and PostgreSQL With Apache Doris

Replacing Apache Hive, Elasticsearch, and PostgreSQL With Apache Doris

2
Comments
5 min read
Running Python code as a migration operation in Django

Running Python code as a migration operation in Django

11
Comments 2
3 min read
🚀 Xata Launch Week & Hackathon (Aug 28, 2023)

🚀 Xata Launch Week & Hackathon (Aug 28, 2023)

3
Comments
1 min read
pg_stat_activity from all servers in YugabyteDB

pg_stat_activity from all servers in YugabyteDB

8
Comments
3 min read
Guide: Creating Views in PostgreSQL

Guide: Creating Views in PostgreSQL

1
Comments
3 min read
50,000 Kubernetes Deployments Achieved: Inside the Streaming Database Odyssey

50,000 Kubernetes Deployments Achieved: Inside the Streaming Database Odyssey

Comments
4 min read
AWS Step Functions Callback Pattern

AWS Step Functions Callback Pattern

4
Comments
10 min read
Implementing Vector Database for AI

Implementing Vector Database for AI

27
Comments 3
8 min read
Managed Relational Databases with AWS RDS and Aurora

Managed Relational Databases with AWS RDS and Aurora

11
Comments
4 min read
Creating User-Defined Functions in PostgreSQL: A Journey into Customization

Creating User-Defined Functions in PostgreSQL: A Journey into Customization

1
Comments
3 min read
AWS Certified Database - Specialty Notes

AWS Certified Database - Specialty Notes

1
Comments
7 min read
Concurrent Data-structure Design Walk-Through

Concurrent Data-structure Design Walk-Through

18
Comments
18 min read
How to Control Autovacuum Frequency in PostgreSQL

How to Control Autovacuum Frequency in PostgreSQL

4
Comments
4 min read
Guide: Creating Triggers in PostgreSQL

Guide: Creating Triggers in PostgreSQL

4
Comments
4 min read
Under the hood of Apache AGE Makefile

Under the hood of Apache AGE Makefile

Comments
5 min read
A Comprehensive Guide to Standard SQL Commands and Grammar

A Comprehensive Guide to Standard SQL Commands and Grammar

1
Comments
3 min read
The Importance of Testing in Node.js Applications: A Comprehensive Guide with Mocha and Jest

The Importance of Testing in Node.js Applications: A Comprehensive Guide with Mocha and Jest

1
Comments
2 min read
Guide: Creating Stored Procedures in PostgreSQL

Guide: Creating Stored Procedures in PostgreSQL

12
Comments
4 min read
Creating Customized i18n-Ready Authentication Emails using Supabase Edge Functions, PostgreSQL, and Resend

Creating Customized i18n-Ready Authentication Emails using Supabase Edge Functions, PostgreSQL, and Resend

2
Comments
7 min read
Dead simple Role-based access control in supabase

Dead simple Role-based access control in supabase

1
Comments 1
2 min read
Relational Database

Relational Database

2
Comments 1
2 min read
The Dangers of Using the Same Database for Development and Production

The Dangers of Using the Same Database for Development and Production

Comments
3 min read
What are Indexes?: Creating Indexes in PostgreSQL

What are Indexes?: Creating Indexes in PostgreSQL

Comments
3 min read
DataBrew - a new way of integrating CDC into your project

DataBrew - a new way of integrating CDC into your project

1
Comments
3 min read
SQL is consuming the lives of data scientists

SQL is consuming the lives of data scientists

6
Comments 3
20 min read
Sampling in PostgreSQL with BERNOULLI Function

Sampling in PostgreSQL with BERNOULLI Function

Comments
3 min read
AsiaInfo honored as deputy leader with AntDB listed in China Database Catalog in successive years

AsiaInfo honored as deputy leader with AntDB listed in China Database Catalog in successive years

1
Comments
3 min read
An Introduction to Postgres Enterprise Manager

An Introduction to Postgres Enterprise Manager

1
Comments
2 min read
Unleashing PostgreSQL's Potential: Easy C Extension Development for Beginners! Part-1

Unleashing PostgreSQL's Potential: Easy C Extension Development for Beginners! Part-1

2
Comments
2 min read
The Unbearable Lightness of Horizontal Scaling

The Unbearable Lightness of Horizontal Scaling

Comments
6 min read
Enhancing Database Performance: In-Depth Query Optimization with ApacheAGE

Enhancing Database Performance: In-Depth Query Optimization with ApacheAGE

2
Comments
3 min read
Sharding in Rails 7: A New Horizon in Database Management

Sharding in Rails 7: A New Horizon in Database Management

6
Comments 2
4 min read
Database Transactions in Laravel

Database Transactions in Laravel

3
Comments 1
1 min read
Diagramming and Database Design📊🔍💡

Diagramming and Database Design📊🔍💡

39
Comments 7
12 min read
Fuzz testing: the best thing to happen to our application tests

Fuzz testing: the best thing to happen to our application tests

7
Comments
8 min read
A Better Way To Store Record Status In A Relational Database

A Better Way To Store Record Status In A Relational Database

28
Comments 6
8 min read
How Modern SQL Databases Are Changing Web Development - #1 Serverless & Edge

How Modern SQL Databases Are Changing Web Development - #1 Serverless & Edge

29
Comments
6 min read
SQL Data Types: A Comprehensive Overview

SQL Data Types: A Comprehensive Overview

19
Comments 4
2 min read
PostgreSQL - History and Common Use cases

PostgreSQL - History and Common Use cases

1
Comments
2 min read
PostgreSQL and Apache Age as a stand-alone Approach

PostgreSQL and Apache Age as a stand-alone Approach

1
Comments
2 min read
Enhancing Data Security in Apache AGE: A Comprehensive Guide

Enhancing Data Security in Apache AGE: A Comprehensive Guide

2
Comments
2 min read
Why We Open Sourced RisingWave under Apache 2.0 License

Why We Open Sourced RisingWave under Apache 2.0 License

1
Comments
3 min read
PostgreSQL Full-Text Search: A Practical Introduction with Examples

PostgreSQL Full-Text Search: A Practical Introduction with Examples

7
Comments
7 min read
Local database > cache 💸

Local database > cache 💸

6
Comments 1
2 min read
Deep dive N+1 Queries in Graphql Ruby

Deep dive N+1 Queries in Graphql Ruby

6
Comments
4 min read
Basic PostgreSQL Configuration on Linux

Basic PostgreSQL Configuration on Linux

5
Comments
8 min read
Transaction Isolation Levels and why we should care

Transaction Isolation Levels and why we should care

5
Comments
9 min read
Unraveling the Power of PostgreSQL Indexes: Supercharge Your Query Performance!

Unraveling the Power of PostgreSQL Indexes: Supercharge Your Query Performance!

1
Comments
2 min read
Unveiling String Distances: A Dive into Levenshtein and Jaro Distances in Databases

Unveiling String Distances: A Dive into Levenshtein and Jaro Distances in Databases

Comments
3 min read
loading...