#database Development Tutorials & Tips | Roast Dev

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

DiceDB Deep Dive: Unpacking the In-Memory Beast That Outmuscles Redis and KeyDB

Hey, code wranglers! Let’s rip into DiceDB, an in-memory database that’s not just another Redis wannabe—it’s a precision-engineered beast built to dominate modern workloads. I’m going under ...

17.03.2025 0 Read More

Normalization and Relational Division in SQL and MongoDB

MongoDB promotes document data modeling rather than the highest normal forms of a relational model. To understand this approach, it's interesting to examine the reasons why E. F. Codd introduced norma...

17.03.2025 0 Read More

Read-Only Oracle Home: Disabled by Default in Oracle 23ai

The Read-Only Oracle Home feature was introduced in Oracle 18c. This feature moves log files and configuration files located in the ORACLE_HOME directory-such as listener.ora, sqlnet.ora, spfile.ora, ...

17.03.2025 0 Read More

ServiceNow and GitHub Integration 🔌 for Database Change Automation 🔧⚙️

Why ServiceNow Many enterprise organizations have adopted ServiceNow as their centralized IT Service Management (ITSM) platform. Database changes demand robust approval workflows and comprehe...

18.03.2025 0 Read More

SQL

Introduction: sQL is the standard language for manipulating and managing relational database.It is used to interact to database to perform tasks like querying,deleting and updating data. ...

18.03.2025 0 Read More

PSQL COMMAND DAY 2

PostgreSQL, or Postgres, is an object-relational database management system that utilizes the SQL language. PSQL is a powerful interactive terminal for working with the PostgreSQL database. It enables...

18.03.2025 0 Read More

Redis Headless Service vs. Cluster IP Service: Which one should you use?

If you’ve ever tried to set up a Redis cluster in Kubernetes, you’ve probably stumbled upon two types of services: the ClusterIP service and the Headless service. At first glance, they might seem ...

18.03.2025 0 Read More

Is 'tablename' Compulsory in SQLAlchemy? Can We Change It?

📌 Is __tablename__ Compulsory in SQLAlchemy? Can We Change It? No, __tablename__ is not compulsory, but it is highly recommended in SQLAlchemy when using the ORM (Object-Relational Mapping...

18.03.2025 0 Read More

PostgreSQL Indexes for Columnstore: 1,185x Faster Lookup Queries, 224x Faster Inserts in TimescaleDB

TimescaleDB 2.18 adds PostgreSQL indexes to columnstore, speeding up lookups by 1,185x and inserts by 224x. Now you can have both fast analytics and quick data retrieval without compromise. 📄 Skip ...

19.03.2025 0 Read More

The Dark Side Of Using UUID as a Primary Key in MySQL

Using a UUID as a primary key in large tables may lead to performance issues, especially in terms of efficiency when inserting and modifying data. Below is a detailed analysis of the reasons behind th...

18.03.2025 0 Read More

DiceDB Deep Dive: Unpacking the In-Memory Beast That Outmuscles Redis and KeyDB

Normalization and Relational Division in SQL and MongoDB

Read-Only Oracle Home: Disabled by Default in Oracle 23ai

ServiceNow and GitHub Integration 🔌 for Database Change Automation 🔧⚙️

SQL

PSQL COMMAND DAY 2

Redis Headless Service vs. Cluster IP Service: Which one should you use?

Is 'tablename' Compulsory in SQLAlchemy? Can We Change It?

PostgreSQL Indexes for Columnstore: 1,185x Faster Lookup Queries, 224x Faster Inserts in TimescaleDB

The Dark Side Of Using UUID as a Primary Key in MySQL

#reading

#popular