Posts tagged "database"

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

Best .NET NuGet Packages for Oracle Database

When working with Oracle databases in .NET applications, selecting the right NuGet package can significantly impact performance, compatibility, and ease of development. Below, we explore the top NuGet...

13.03.2025 0 Read More

Real-Time IoT Analytics at Scale: Concepts and Tools

Hey dev community! 👋 Today I'm kicking off a hands-on tutorial series where we'll build a production-ready IoT analytics system from scratch. Together, we'll create a scalable infrastructure that c...

13.03.2025 0 Read More

Why Every Data Analyst Needs To Know SQL: A Beginner's Guide

Why Every Data Analyst Needs To Know SQL: A Beginner's Guide Introduction Transitioning into data analytics can feel overwhelming, especially when coming from a different career fiel...

13.03.2025 0 Read More

Open-Source Databases for Real-Time Analytics

Real-time analytics break conventional databases. When milliseconds matter and data floods in by the millions, you need purpose-built solutions.For a deep dive, jump to 👉 The Complete Guide to Time...

13.03.2025 0 Read More

Setting the correct database connection on production with Render

While deploying a Rails 8 app on Render today, I faced this issue in the deployment log: ⛶ActiveRecord::ConnectionNotEstablished: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" f...

13.03.2025 0 Read More

Data Redaction and View Enhancements – Oracle 23ai(23.6)

Oracle 23.6 introduces new capabilities in Data Redaction, one of which is Data Redaction support at the view level. In previous versions, attempting to access a redacted column in a view resulted in ...

13.03.2025 0 Read More

Cursor-Based Pagination in NestJS with TypeORM 🚀

Hey there, devs! 👋 If you've ever struggled with paginating large datasets efficiently, you're in the right place. Today, we'll implement cursor-based pagination in a NestJS API using TypeORM. This...

13.03.2025 0 Read More

Game-Changing Guide to SQL for SEO Optimization

SQL for SEO is like a recipe book for culinary fans. Just like a thick recipe book that provides stepwise instructions on how to cook your favorite meals, SQL delivers structured information from diff...

13.03.2025 0 Read More

MongoDB Multi-Planner Optimizer and Plan Cache

Database systems utilize query planners to optimize data retrieval, primarily through two methods: Rule-Based Optimizers (RBO) and Cost-Based Optimizers (CBO). Rule-Based Optimizer (RBO): This method ...

13.03.2025 0 Read More

TiDB Serverless vs Amazon RDS: The Ultimate Cloud Database Showdown

Introduction If you’ve ever found yourself scrambling to keep a database from melting under unexpected load, you know how crucial a solid, hassle-free backend can be. With so many cloud dat...

13.03.2025 0 Read More

Best .NET NuGet Packages for Oracle Database

Real-Time IoT Analytics at Scale: Concepts and Tools

Why Every Data Analyst Needs To Know SQL: A Beginner's Guide

Open-Source Databases for Real-Time Analytics

Setting the correct database connection on production with Render

Data Redaction and View Enhancements – Oracle 23ai(23.6)

Cursor-Based Pagination in NestJS with TypeORM 🚀

Game-Changing Guide to SQL for SEO Optimization

MongoDB Multi-Planner Optimizer and Plan Cache

TiDB Serverless vs Amazon RDS: The Ultimate Cloud Database Showdown

#reading

#popular