Posts tagged "database"

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

The Day I Passed Out Because of a Single AWS Command

I want to share a mistake that turned into a valuable experience—so you don’t have to learn the hard way like I did.April 11th. The day I almost quit my career in software development.I had built ...

30.04.2025 0 Read More

Cracking MySQL Performance: What is Indexing and Why It Matters

🚀 Introduction Have you ever run a SQL query that just took forever and wondered, "Why is this so slow?" You're not alone. Databases are fast until they're not. And one of the simplest, ye...

30.04.2025 0 Read More

Sharding with SpringBoot

Understanding Database Sharding Imagine your application has grown so popular that a single database server can’t handle all your data efficiently. Sharding is like splitting your database ...

01.05.2025 0 Read More

When Not to Use DB Indexes

Avoid Indexing DB Columns with Highly Repeated Values Indexing is a powerful tool in databases that can dramatically improve query performance when used appropriately. However, not all indice...

01.05.2025 0 Read More

How I Replaced Python with C in My Project

For years, I had been using Python as my go-to language for most projects. Its simplicity, vast ecosystem, and rapid development capabilities made it an obvious choice. However, as my latest project g...

01.05.2025 0 Read More

What kind of database should you choose for your startup app?

When you’re starting to build an app for your startup, one common question is: what kind of database should we use?My answer would be surprisingly simple: 👉 Just go with a database you’re most ...

01.05.2025 0 Read More

Microsoft CosmosDB: RUM instead of GIN but same limitations on JSON paths

Storing documents in PostgreSQL does not transform it to a document database. Embedded documents in JSONB require GIN indexes, which are not effective for range or pagination queries. Microsoft recogn...

01.05.2025 0 Read More

Postgres: Ordered Queries and the Planner

Most SQL queries require the results of the particular query to be ordered in a some way. The returned data can still be implicitly ordered by the primary key(if present) if the user does not apply th...

01.05.2025 0 Read More

What is Data Engineering?

With data being a highly valuable asset in today’s data-driven world, roles requiring expertise and knowledge on data have been on the rise as institutions hire data experts to help make the most ou...

01.05.2025 0 Read More

Oracle 23ai — Read-Only User Feature

The Read-Only User is one of the new features introduced in Oracle Database version 23ai. This feature enables administrators to restrict users from making any data modifications, even if they have th...

02.05.2025 0 Read More

The Day I Passed Out Because of a Single AWS Command

Cracking MySQL Performance: What is Indexing and Why It Matters

Sharding with SpringBoot

When Not to Use DB Indexes

How I Replaced Python with C in My Project

What kind of database should you choose for your startup app?

Microsoft CosmosDB: RUM instead of GIN but same limitations on JSON paths

Postgres: Ordered Queries and the Planner

What is Data Engineering?

Oracle 23ai — Read-Only User Feature

#reading

#popular