Forem

Database

Posts on building, using, and learning about databases.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
Guide: How to add Write-Back capabilities to your Power BI reports with Power Apps - Part 1

Guide: How to add Write-Back capabilities to your Power BI reports with Power Apps - Part 1

Comments
5 min read
SQL Indexes

SQL Indexes

Comments
3 min read
System design: SQL vs NoSQL Databases: A Deep Dive

System design: SQL vs NoSQL Databases: A Deep Dive

Comments
6 min read
System design: Database Partitioning, Sharding, and Replication

System design: Database Partitioning, Sharding, and Replication

Comments
6 min read
How to get several data count in a single query by applying conditions

How to get several data count in a single query by applying conditions

1
Comments
1 min read
System design: Relational vs Non-Relational Databases

System design: Relational vs Non-Relational Databases

Comments
6 min read
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
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
Indexes in SQL | Clustered and Non Clustered Index

Indexes in SQL | Clustered and Non Clustered Index

4
Comments
2 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
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
Procedure vs Function | PLSQL

Procedure vs Function | PLSQL

1
Comments
2 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
Normalisation | 2 NF

Normalisation | 2 NF

5
Comments
2 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
Normalization | 1 NF

Normalization | 1 NF

5
Comments
1 min read
Function-Based Index in SQL

Function-Based Index in SQL

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