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.
Boosting EF Core Performance: 7 Essential Optimization Tips

Boosting EF Core Performance: 7 Essential Optimization Tips

1
Comments
1 min read
How to implement CREATE TABLE IF NOT EXISTS in Oracle

How to implement CREATE TABLE IF NOT EXISTS in Oracle

5
Comments
3 min read
SQL-92 in TPC Benchmarks: Are They Still Relevant?

SQL-92 in TPC Benchmarks: Are They Still Relevant?

8
Comments
10 min read
How Pipe Syntax Fix SQL Design Problems

How Pipe Syntax Fix SQL Design Problems

Comments
5 min read
Inside the Database: A Deep Dive into Disk-Oriented DBMS.

Inside the Database: A Deep Dive into Disk-Oriented DBMS.

Comments
7 min read
Real-Time Processing of Big Data: Tools and Best Practices

Real-Time Processing of Big Data: Tools and Best Practices

2
Comments
9 min read
What Is a NoSQL Database and When Should You Use It?

What Is a NoSQL Database and When Should You Use It?

7
Comments 4
6 min read
Why Running Databases on Kubernetes is a Recipe for Disaster: The Case for a New Platform Designed for Stateful Workloads

Why Running Databases on Kubernetes is a Recipe for Disaster: The Case for a New Platform Designed for Stateful Workloads

13
Comments 5
7 min read
A CDC Way to Sync Data from ElasticSearch to ElasticSearch with BladePipe

A CDC Way to Sync Data from ElasticSearch to ElasticSearch with BladePipe

5
Comments
4 min read
Indexes in SQL | Clustered and Non Clustered Index

Indexes in SQL | Clustered and Non Clustered Index

4
Comments
2 min read
Persistent Storage vs. Cache Storage: Understanding the Differences and Use Cases

Persistent Storage vs. Cache Storage: Understanding the Differences and Use Cases

1
Comments
3 min read
Exploring InstantDB: A New Approach to Local-First Databases

Exploring InstantDB: A New Approach to Local-First Databases

Comments
3 min read
Optimizing Laravel Performance: Addressing Slowdowns with Large Datasets

Optimizing Laravel Performance: Addressing Slowdowns with Large Datasets

Comments 1
1 min read
Mastering Databases: From Optimizing Queries to Distributed Systems — Hoài Nhớ

Mastering Databases: From Optimizing Queries to Distributed Systems — Hoài Nhớ

33
Comments 8
4 min read
Data Lake vs. Data Lakehouse vs. Data Warehouse: Which One Fits Your Business Needs?

Data Lake vs. Data Lakehouse vs. Data Warehouse: Which One Fits Your Business Needs?

1
Comments
2 min read
Normalisation | 2 NF

Normalisation | 2 NF

5
Comments
2 min read
Normalization | 1 NF

Normalization | 1 NF

5
Comments
1 min read
Connecting to a MySQL Database in PHP

Connecting to a MySQL Database in PHP

Comments
4 min read
Getting positions of members based on a specified condition #eg46

Getting positions of members based on a specified condition #eg46

11
Comments
1 min read
Function-Based Index in SQL

Function-Based Index in SQL

1
Comments
3 min read
Partitioning in ORACLE SQL | Horizontal and Vertical Partitioning

Partitioning in ORACLE SQL | Horizontal and Vertical Partitioning

5
Comments
3 min read
Strange PostgreSQL query planner behavior in subqueries

Strange PostgreSQL query planner behavior in subqueries

Comments
11 min read
SQL in Minutes: Your Ultimate SQL Cheat Sheet

SQL in Minutes: Your Ultimate SQL Cheat Sheet

2
Comments
1 min read
Best Practices for GanosBase Real-Time Heatmap Aggregation Query

Best Practices for GanosBase Real-Time Heatmap Aggregation Query

1
Comments
9 min read
SQL INJECTION AND ITS TYPES.

SQL INJECTION AND ITS TYPES.

4
Comments
3 min read
loading...