Operations | Monitoring | ITSM | DevOps | Cloud

The latest News and Information on Databases and related technologies.

NHibernate vs ADO.NET: Which Is Better for .NET Development?

NHibernate vs ADO.NET is the classic clash in.NET development: raw SQL muscle on one side, high-level abstraction on the other. One promises speed and precision, the other productivity and cleaner code. For most.NET teams, the real challenge here is determining which approach best suits their project’s scale, timeline, and goals. That choice directly influences database efficiency, developer productivity, and long-term stability.

How DreamHost Slashed Memory Usage by 80% and Scaled to 76 Million Time Series

For any growing business, there comes a point where the tools that once worked perfectly begin to show their limits. This is especially true for monitoring infrastructure. As your user base, services, and data volumes expand, the pressure on your monitoring stack intensifies. For web hosting leader DreamHost, with over 1.5 million websites to manage, their existing open-source solutions simply couldn’t keep up.

Data Integrity in a Database: How to Ensure Accuracy and Security

Data integrity in a database is the backbone of accurate decision-making, regulatory compliance, and organizational security. Without it, even the most advanced analytics or AI models are built on shaky ground. Imagine going through your database and noticing that the numbers in your sales report are inconsistent, financial data tells three different stories, and some customer records are missing. This mismatch can compromise business decisions and lead to missed opportunities.

Need to do Integration Testing without a real Postgres SQL Database? #speedscale #postgres #sql

Struggling with integration testing because you need a real Postgres SQL database running? This video walks you through how to use Speedscale's proxymock to easily record and mock a live Postgres connection. You'll see how to: By the end, you'll be able to create realistic database mocks for your testing and development, saving you time and hassle.

New in Flyway: Pre and post deployment scripts for state-based deployments via callbacks

Flyway provides a lot of flexibility for releasing database changes in a safe and repeatable manner. Earlier this year, we added the ability to automate state-based deployments. This means the structure of the database is defined in version control and Flyway handles updating a target database to match it. The Flyway comparison engine does all the hard work of identifying what’s different and creating a script that will run on the target database to alter it so it matches the latest state.

SQL NTILE Function Explained with Practical Examples

NTILE in SQL transforms raw lists into structured distributions before they reach a dashboard. By pushing distribution logic upstream, it divides ordered rows at the query level, so the insights in Power BI, Tableau, or Excel are accurate, not just polished visuals. This guide explores its syntax, practical examples, and comparisons with other ranking functions. It also highlights how database IDEs bring NTILE insights directly into analysis and reporting workflows. Table of contents.

Welcome PostgreSQL 18: A New Era of Performance on Aiven

Aiven is proud to launch the newest version of PostgreSQL, version 18, alongside with the open source community as the first managed PostgreSQL provider to support the latest version. This year we had three Aiveners join in on contributing to this major release, a trend which we hope to only see increase. Congrats to Patrick Stählin, Ronan Dunklau, and Thomas Krennwallner for your contributions to the codebase.

Learn to mock your MySQL database and get realistic test data without the hassle of a live server!

Proxymock allows you to record real interactions between your application and a MySQL database. Use proxymock to simulate your database during local development and testing. Get real data without running a live MySQL server. Modify mock responses to fit your testing needs. Simplify your testing workflow and replicate production data easily.

Creating a Sustainable Open Source Business Model - Introduction

Open source defies everything you’ve ever heard or learned about business before (author’s quote). Yes, open source software has been around since the 90s, but there’s still little else like it. If anything, as time has gone on, we’ve added adjacent concepts like “open core” and “source available” that have added complexity to a model that isn’t that straight forward to grasp to begin with. VictoriaMetrics is an open source company.

SecureBridge 11.0, EntityDAC 3.5, and dbExpress Drivers: Latest Versions Released

We are excited to announce a new release of SecureBridge, EntityDAC, and the dbExpress product line. This update introduces support for the newest RAD Studio version, enhances compatibility with popular databases, and adds new components and options to simplify development and strengthen security.