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.
Learn SQL in 30 Days

Learn SQL in 30 Days

Comments
2 min read
Oracle Database Admin: Comprehensive Training for Managing Oracle Databases

Oracle Database Admin: Comprehensive Training for Managing Oracle Databases

Comments
1 min read
PostgreSQL Database Admin: Master the Intricacies of Database Management

PostgreSQL Database Admin: Master the Intricacies of Database Management

Comments
2 min read
How NL2SQL Tools Like Chat2DB Simplify Data

How NL2SQL Tools Like Chat2DB Simplify Data

Comments
11 min read
Understanding PDO in PHP and Why It is Recommended Over `mysql_*` Functions

Understanding PDO in PHP and Why It is Recommended Over `mysql_*` Functions

Comments
4 min read
Kysely + Kanel: a dupla perfeita

Kysely + Kanel: a dupla perfeita

Comments
6 min read
How Can You Optimize MySQL Performance for High-Load Applications?

How Can You Optimize MySQL Performance for High-Load Applications?

1
Comments
3 min read
Cost Comparison: Neon vs. Azure Database for PostgreSQL Flexible Server

Cost Comparison: Neon vs. Azure Database for PostgreSQL Flexible Server

5
Comments
7 min read
Trees in SQL

Trees in SQL

Comments
9 min read
SQL 101 | Chapter 1: Understanding SQL and Databases

SQL 101 | Chapter 1: Understanding SQL and Databases

1
Comments
3 min read
Trees in SQL (part 2)

Trees in SQL (part 2)

Comments
5 min read
3 Things You Need To Take Control Of Your Database

3 Things You Need To Take Control Of Your Database

Comments
3 min read
How I Solved the 'General Error: 1813' in MySQL (XAMPP)

How I Solved the 'General Error: 1813' in MySQL (XAMPP)

Comments
2 min read
Understanding Disk Management in Database Systems: From Fundamentals to RAID

Understanding Disk Management in Database Systems: From Fundamentals to RAID

Comments
2 min read
Sequelize seeders for static data

Sequelize seeders for static data

Comments
2 min read
Sequelize migrations

Sequelize migrations

Comments
2 min read
SSIS for Modern Data Integration

SSIS for Modern Data Integration

Comments
3 min read
HadiDB: A Lightweight, Horizontally Scalable Database in Python

HadiDB: A Lightweight, Horizontally Scalable Database in Python

Comments
3 min read
Big Discovery - lowCalAlt_update 7

Big Discovery - lowCalAlt_update 7

Comments
1 min read
SQL Filtering and Sorting with Real-life Examples

SQL Filtering and Sorting with Real-life Examples

Comments
4 min read
Part 2 - CosmosDB Logical Partition and the Impact on Partition Key Choice

Part 2 - CosmosDB Logical Partition and the Impact on Partition Key Choice

Comments
4 min read
lowCalAlt_update 6

lowCalAlt_update 6

Comments
1 min read
Iterations

Iterations

Comments
6 min read
Mastering PostgreSQL Performance: Tips and Best Practices

Mastering PostgreSQL Performance: Tips and Best Practices

Comments
1 min read
How PostgreSQL Powers the Future of Data-Driven Applications

How PostgreSQL Powers the Future of Data-Driven Applications

Comments
1 min read
PostgreSQL vs. Other Databases: Why It’s the Top Choice for Modern Applications

PostgreSQL vs. Other Databases: Why It’s the Top Choice for Modern Applications

Comments
1 min read
When to replace IN() with EXISTS() - correlated and uncorrelated subqueries

When to replace IN() with EXISTS() - correlated and uncorrelated subqueries

4
Comments
8 min read
When Should You Create Views in Your Database?

When Should You Create Views in Your Database?

Comments
5 min read
T-SQL avanzato: tecniche da ricordare

T-SQL avanzato: tecniche da ricordare

Comments
3 min read
🔍 MongoDB Data Modeling: Embedding vs. Referencing - A Strategic Choice!

🔍 MongoDB Data Modeling: Embedding vs. Referencing - A Strategic Choice!

Comments
1 min read
Understanding Database Consistency

Understanding Database Consistency

3
Comments
3 min read
Bulk Update with Entity Framework Core (EF Core)

Bulk Update with Entity Framework Core (EF Core)

2
Comments
3 min read
Mastering ACID Properties: Safeguarding Your Database Transactions

Mastering ACID Properties: Safeguarding Your Database Transactions

1
Comments
2 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
Data Warehousing Architectures

Data Warehousing Architectures

Comments
5 min read
Comparing AWS RDS and Amazon Aurora: Which Managed Database Service is Right for You?

Comparing AWS RDS and Amazon Aurora: Which Managed Database Service is Right for You?

1
Comments
3 min read
Introducing Surreal Sidekick, your personal AI assistant

Introducing Surreal Sidekick, your personal AI assistant

44
Comments 5
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

5
Comments
4 min read
How to Push, Store, and Visualize IoT Data to the Cloud (No Self-Hosting Required)

How to Push, Store, and Visualize IoT Data to the Cloud (No Self-Hosting Required)

Comments
6 min read
That's how I Use 100% of Azure Databases

That's how I Use 100% of Azure Databases

Comments
8 min read
Find high dead_tuples

Find high dead_tuples

Comments
1 min read
Check Table size in Postgresql Database

Check Table size in Postgresql Database

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
Reasons for Index Invalidity in Databases

Reasons for Index Invalidity in Databases

Comments
4 min read
TableSavvy ( MYSQL DATABASE MANAGEMENT SOFTWARE )

TableSavvy ( MYSQL DATABASE MANAGEMENT SOFTWARE )

Comments
2 min read
Having "permission denied" error while creating table in DBeavers using postgres?

Having "permission denied" error while creating table in DBeavers using postgres?

Comments
1 min read
They Stopped Using Load Tests - And Here Is Why

They Stopped Using Load Tests - And Here Is Why

Comments
3 min read
Top 5 Text2SQL Tools for Effortless SQL Generation

Top 5 Text2SQL Tools for Effortless SQL Generation

Comments
7 min read
Prisma & MongoDB: server to be run as a replica set

Prisma & MongoDB: server to be run as a replica set

Comments
1 min read
Series de tiempo en MongoDB

Series de tiempo en MongoDB

Comments
6 min read
Inside the Database: Query To Execution Explained

Inside the Database: Query To Execution Explained

Comments
3 min read
2024.2: Faster with Shared Memory Between PostgreSQL and TServer Layers

2024.2: Faster with Shared Memory Between PostgreSQL and TServer Layers

Comments
4 min read
Top AI Tools for Generating SQL in 2024

Top AI Tools for Generating SQL in 2024

Comments
8 min read
Migrating Vector Data from Milvus to TiDB

Migrating Vector Data from Milvus to TiDB

Comments
6 min read
Is it possible to upload a file to a database in Next.js?

Is it possible to upload a file to a database in Next.js?

Comments
3 min read
New PostgreSQL ORM for Golang: Enterprise

New PostgreSQL ORM for Golang: Enterprise

5
Comments 1
3 min read
Weekly Updates - Dec 20, 2024

Weekly Updates - Dec 20, 2024

6
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
Database Tools 🛢️🔧 in 2024: A Year in Review 🗓️

Database Tools 🛢️🔧 in 2024: A Year in Review 🗓️

47
Comments 3
3 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
loading...