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.
Getting started with Xata

Getting started with Xata

Comments
6 min read
Demystifying Serverless Databases

Demystifying Serverless Databases

Comments
4 min read
SQLite UPDATE Query: A Comprehensive Guide

SQLite UPDATE Query: A Comprehensive Guide

Comments
5 min read
Optimizing SQL Performance with Execution Plans

Optimizing SQL Performance with Execution Plans

8
Comments
3 min read
Association Accessors

Association Accessors

1
Comments
2 min read
Introducing MonkeyslegionDB: A Specialized Database Connection Manager for PHP

Introducing MonkeyslegionDB: A Specialized Database Connection Manager for PHP

1
Comments
2 min read
How to update multiple rows based on list of key-val pairs (in MySQL, MariaDB, & PostgreSQL)

How to update multiple rows based on list of key-val pairs (in MySQL, MariaDB, & PostgreSQL)

1
Comments
2 min read
Active record vs Object mapper ORM

Active record vs Object mapper ORM

13
Comments
2 min read
Detailed Introduction To Prisma ORM

Detailed Introduction To Prisma ORM

18
Comments
5 min read
How Modern SQL Databases Are Changing Web Development - #2 New Ways to Program

How Modern SQL Databases Are Changing Web Development - #2 New Ways to Program

38
Comments 1
6 min read
SurrealDB: Version 1.0 🥇 Just Released! Next Gen SQL Database?

SurrealDB: Version 1.0 🥇 Just Released! Next Gen SQL Database?

1
Comments
3 min read
Explanation of MySQL table field types

Explanation of MySQL table field types

Comments
4 min read
Revolutionizing Database Services: An Inside Look at Sealos and KubeBlocks

Revolutionizing Database Services: An Inside Look at Sealos and KubeBlocks

1
Comments
4 min read
Making the Best PostgreSQL Cloud Provider Selection

Making the Best PostgreSQL Cloud Provider Selection

Comments
3 min read
How QuestDB saved a project and the team's mental health

How QuestDB saved a project and the team's mental health

3
Comments
7 min read
Setting the Stage: Unraveling MongoDB Query Performance

Setting the Stage: Unraveling MongoDB Query Performance

1
Comments
7 min read
Setting and Displaying Patroni's Max Connection Count

Setting and Displaying Patroni's Max Connection Count

3
Comments
1 min read
An Honest Question: Do you put relational data in Google Firestore?

An Honest Question: Do you put relational data in Google Firestore?

Comments
2 min read
Resolving PostgreSQL Database Connection Issues with dblink on Amazon RDS

Resolving PostgreSQL Database Connection Issues with dblink on Amazon RDS

1
Comments
3 min read
Simple API CRUD done with ExpressoTS and Postgres

Simple API CRUD done with ExpressoTS and Postgres

24
Comments
4 min read
PostgreSQL 16 Installation on Ubuntu 22.04

PostgreSQL 16 Installation on Ubuntu 22.04

172
Comments 12
2 min read
Is MongoDB Good For Data Analytics? Let's Find Out!

Is MongoDB Good For Data Analytics? Let's Find Out!

10
Comments
4 min read
Auto-scaling DynamoDB Streams applications on Kubernetes

Auto-scaling DynamoDB Streams applications on Kubernetes

5
Comments
12 min read
Fortify Your Database: Supabase's Row Level Security

Fortify Your Database: Supabase's Row Level Security

2
Comments
3 min read
Fazendo Comandos SQL

Fazendo Comandos SQL

3
Comments
4 min read
My Database History

My Database History

6
Comments
4 min read
Comparison of Search and Information Retrieval Technologies

Comparison of Search and Information Retrieval Technologies

1
Comments
2 min read
Creating a distributed high-availability cluster

Creating a distributed high-availability cluster

Comments
2 min read
Seeding Database With Drizzle ORM

Seeding Database With Drizzle ORM

28
Comments 9
2 min read
File attachment in Xata Database: How to build an Online Library.

File attachment in Xata Database: How to build an Online Library.

7
Comments
6 min read
Meet Five: A Popular FileMaker Alternative

Meet Five: A Popular FileMaker Alternative

Comments
13 min read
Query Like a Pro: Active Record for Database Queries

Query Like a Pro: Active Record for Database Queries

1
Comments
4 min read
Comparison between Apache AGE and other popular graph databases.

Comparison between Apache AGE and other popular graph databases.

7
Comments
3 min read
SPL computing performance test series: associate tables and wide table

SPL computing performance test series: associate tables and wide table

Comments
6 min read
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
loading...