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.
Why You Should Learn Entity Relationship Diagrams Before ORMs and Specific Databases

Why You Should Learn Entity Relationship Diagrams Before ORMs and Specific Databases

2
Comments 1
4 min read
New PostgreSQL ORM for Golang: Enterprise

New PostgreSQL ORM for Golang: Enterprise

6
Comments 1
3 min read
Solution for "DLL Load Failed Due to Absence of Wheel for sqlcipher3" Error

Solution for "DLL Load Failed Due to Absence of Wheel for sqlcipher3" Error

Comments
3 min read
Weekly Updates - Dec 20, 2024

Weekly Updates - Dec 20, 2024

7
Comments 1
1 min read
Migrating from Azure Database for PostgreSQL to Neon

Migrating from Azure Database for PostgreSQL to Neon

9
Comments
7 min read
Partitions in Azure Cosmos DB: A Common Discussion with Customers

Partitions in Azure Cosmos DB: A Common Discussion with Customers

Comments
6 min read
Using WordPress as a Data Entry Site to Power a Central API

Using WordPress as a Data Entry Site to Power a Central API

13
Comments
4 min read
Data Warehousing Architectures

Data Warehousing Architectures

Comments
5 min read
A Robust Database Migration and Release Process for Web Applications

A Robust Database Migration and Release Process for Web Applications

1
Comments
3 min read
Referential integrity In The Absence Of Foreign Key

Referential integrity In The Absence Of Foreign Key

9
Comments
5 min read
Unleash the Power of Data: The Hottest AWS Database Trends of 2024

Unleash the Power of Data: The Hottest AWS Database Trends of 2024

Comments
5 min read
Advanced MySQL Techniques for Developers: Boost Performance, Scalability, and Flexibility

Advanced MySQL Techniques for Developers: Boost Performance, Scalability, and Flexibility

1
Comments
5 min read
Understanding MySQL Indexes: A Comprehensive Guide to Query Optimization

Understanding MySQL Indexes: A Comprehensive Guide to Query Optimization

Comments
5 min read
Beware the Performance Dangers of MySQL Views

Beware the Performance Dangers of MySQL Views

Comments
4 min read
10 Bad Practices to Avoid When Writing SQL Queries for Better Performance

10 Bad Practices to Avoid When Writing SQL Queries for Better Performance

Comments
4 min read
Optimizing Your MySQL Queries for Maximum Efficiency

Optimizing Your MySQL Queries for Maximum Efficiency

Comments
3 min read
Detecting and Analyzing Comment Quality Using Vector Search

Detecting and Analyzing Comment Quality Using Vector Search

22
Comments
6 min read
SQL Basic Question for interview

SQL Basic Question for interview

19
Comments 8
4 min read
How to detect query which holds the lock in Postgres?

How to detect query which holds the lock in Postgres?

Comments
1 min read
Find high dead_tuples

Find high dead_tuples

Comments
1 min read
AWS Database Services: Find the Best Fit for Your Application

AWS Database Services: Find the Best Fit for Your Application

Comments
3 min read
Check Table size in Postgresql Database

Check Table size in Postgresql Database

Comments
1 min read
Effective Strategies for Writing Unit Tests with External Dependencies like Databases and APIs

Effective Strategies for Writing Unit Tests with External Dependencies like Databases and APIs

Comments
7 min read
Failover in Amazon RDS Multi-AZ Architectures

Failover in Amazon RDS Multi-AZ Architectures

5
Comments
7 min read
SQL Window functions: Understanding PARTITION BY

SQL Window functions: Understanding PARTITION BY

1
Comments
5 min read
loading...