#database Development Tutorials & Tips | Roast Dev

100daysofcode 100daysofdevops 100pay 10mistakes 10yearworkanniversary 11 11labs 11tly 11ty 127001

Oracle 23ai - Hybrid Read-Only Mode for Pluggable Databases

In Oracle 23ai, a new open mode called Hybrid Read-Only has been introduced for pluggable databases (PDBs). When a PDB is set to this mode, local users can only connect with read-only access. However,...

02.04.2025 0 Read More

🚀 Optimize EF Core Queries with AsSplitQuery()

When working with Entity Framework Core (EF Core), queries that involve multiple Include() statements can result in a single large query with multiple joins. This can cause performance issues due to d...

03.04.2025 0 Read More

Foreign Keys: A must in SQL, but not in a Document Database?

In relational SQL databases, foreign keys are essential for guaranteeing referential integrity. There are two main reasons to declare them, particularly regarding their cascading behavior: Enforcing S...

03.04.2025 0 Read More

Data Engineering: The Hero Behind Smart Data Decisions

Have you ever wondered how companies handle millions of data points daily? If it’s real-time stock market updates, AI-powered recommendations, or fraud detection, none of it would be possible withou...

03.04.2025 0 Read More

5 Questions You Should Ask Before Adopting a TSDB for IIoT

If you're an industrial IoT (IIoT) developer, engineer, or manager considering adopting a time-series database, there are key considerations to evaluate before choosing your tools.Modernizing industri...

04.04.2025 0 Read More

DuckDB 🦆: Unleashing the Powerhouse Query Engine Within

Introduction DuckDB is widely recognized for its analytical processing capabilities, but its true power lies in its exceptional query engine. Unlike traditional databases that require extensi...

03.04.2025 0 Read More

DuckDB 🦆 : Libérez le puissant moteur de Requêtes

Introduction DuckDB est largement reconnu pour ses capacités de traitement analytique, mais sa véritable puissance réside dans son moteur de requête exceptionnel. Contrairement aux bases ...

03.04.2025 0 Read More

SQL Fundamentals for Beginners

The foundation of relational database data management is Structured Query Language(SQL). SQL is an essential Skill for data warehousing, web development, and data analysis. With the help of this artic...

04.04.2025 0 Read More

Multiversion Concurrency Control (MVCC) – A Deep Dive Part (1/2)

TL;DR Ever built something where two users tried to update the same record at the same time, and everything broke? Or maybe you ran into those weird bugs where a user sees stale data or, wors...

04.04.2025 0 Read More

Day 4 I have revised some of oracle concepts

Hi Everyone Today I have revised some of the topics in oracle like cross join ,set operators like union, union all, intersect, minus I would like to define them in simple words unio means that combi...

04.04.2025 0 Read More

Oracle 23ai - Hybrid Read-Only Mode for Pluggable Databases

🚀 Optimize EF Core Queries with AsSplitQuery()

Foreign Keys: A must in SQL, but not in a Document Database?

Data Engineering: The Hero Behind Smart Data Decisions

5 Questions You Should Ask Before Adopting a TSDB for IIoT

DuckDB 🦆: Unleashing the Powerhouse Query Engine Within

DuckDB 🦆 : Libérez le puissant moteur de Requêtes

SQL Fundamentals for Beginners

Multiversion Concurrency Control (MVCC) – A Deep Dive Part (1/2)

Day 4 I have revised some of oracle concepts

#reading

#popular