Lakehouse architectures enable multiple engines to operate on shared data using open table formats such as Apache Iceberg. However, differences in SQL identifier resolution and catalog naming...

The article discusses the challenges faced during a migration from a relational database to NoSQL, focusing on the importance of database sequences for unique identifiers. It outlines the...

This guide explains how to subtract days from dates across MySQL, H2, and other databases with different SQL dialects. Learn how to standardize behavior using compatibility modes, wrapper...

A client accidentally ran rm -rf /*, wiping out the entire OS and database. After disk recovery experts salvaged the data files, PDU adapted to this domestic PostgreSQL variant and completed full...

Announcing official support for the Stripe Sync Engine in the Supabase Dashboard. Get a one-click integration that syncs your Stripe data directly into your Supabase database.

In part 4 of our series on the OCI Hackathon Starter Kit, we saw how to connect to the deployed MySQL HeatWave instance from our clients (MySQL Shell, MySQL Shell for VS Code, and Cloud Shell). In...

Let’s now see how we can connect to our MySQL HeatWave DB System, which was deployed with the OCI Hackathon Starter Kit in part 1. We have multiple possibilities to connect to the DB System, and...

The bustling city of Atlanta served as the backdrop for KubeCon from November 10-13, where more than 9,000 attendees gathered to explore the latest innovations in cloud-native computing. Among the...

Announcing MySQL HeatWave Migration Assistant — the newest way to move MySQL workloads to Oracle Cloud Infrastructure (OCI) with ease! Migrating critical databases to the cloud is often viewed as...

Executive Summary AI applications rely on vector embeddings to power search and recommendations, but these data-rich vectors introduce new security and privacy risks. This blog explains the main...

I'm designing an application that is going to receive tens to hundreds of thousands of requests. Users submit requests on behalf of Customers (which are singular persons). Each request will...

Where I work, they have never implemented web APIs. At my previous job, which I left 11 years ago, I would write several web APIs to be used for applications, reports, etc. So when I came to this...

Learn how to safeguard your MySQL database with simple, reliable backup and restore techniques! This final post in the beginner series uses fun library analogies and clear MySQL Shell examples to...

Keep your MySQL database protected with beginner-friendly advice on user management and security! Learn how to create users, grant and revoke privileges, and safeguard your data using...

PGConf.EU schedule can feel like a parallel query gone wild, so many great talks but not enough CPU. I built this guide to help my fellow database nerds skip the overwhelm and enjoy the best...

PostgreSQL is a very versatile database. It has countless ways of bringing different functionalities to an already very sophisticated piece of software. Today, I’m going to show you how to use...

Learn what data integrity in DBMS means, why it’s vital for database accuracy, and how to maintain it effectively. Read on to protect your data now. The post Data Integrity in a Database: How to...

This post guides newcomers through accessing and exploring their databases using MySQL Shell. Clear instructions, friendly guidance, and practical tips ensure a confident start for any data...

This post explains how to collect metrics on connections, resource usage, query performance and database characteristics.