Redgate Blog

Posts tagged with PostgreSQL

10 December 2025

Building dbRosetta Part 5: We Need an API

Because I don’t want to have to fight with our support team (they’re awesome, but busy) I decided that, initially, I’m going to host dbRosetta at ScaryDBA.com. I have full control of the web site, and I won’t be breaking Redgate Software entirely if I accidently do something silly. Before… Read more

Agentic AI

artificial intelligence

Grant Fritchey

4 December 2025

Grant Fritchey

4 December 2025

Building dbRosetta Part 4: Automating a CI Database Build

Since I’m starting development with the dbRosetta database, and since I’m way more comfortable with databases than with code, I’m going to continue within the database sphere for a bit as we build out dbRosetta. My next step is to work with the AI to get a pipeline in place… Read more

10 November 2025

10 November 2025

Building dbRosetta Using AI: Part 3, Creating a Database

The AI said I had to do a database first, not code. Who am I to argue? So, with all the prompts outlining the goals of the project, I’ve gone forward with the project, and step one is creating a PostgreSQL database on Azure. This is part three of a… Read more

artificial intelligence

CoPilot

Grant Fritchey

5 November 2025

Grant Fritchey

5 November 2025

Building dbRosetta Using AI: Part 2, Defining the Project & Prompt Templates

This is the next installment of the series on building a database and an application called dbRosetta using AI/LLM. Part 1 introduces the concept. THE AI PICKED DATABASE FIRST! Look, I talk databases at this thing a lot, so it probably knows my own preference, but when I asked it,… Read more

artificial intelligence

CoPilot

Grant Fritchey

3 November 2025

Grant Fritchey

3 November 2025

Building dbRosetta Using AI: Part 1 of Many

Like many of you, over the last couple of years, I’ve been using AI, or, well, let’s just name it appropriately, Large Language Models (LLM), as a part of my job. I’ve also used it in my hobby. With it, I’ve generated snippets of code, tested data conversions, even built… Read more

artificial intelligence

large language model

Grant Fritchey

19 September 2025

Grant Fritchey

19 September 2025

Introducing PostgreSQL Static Data in Flyway

One kind of data in most relational databases is what we call static data. This is also referred to as lookup data, code data, domain data or even list data. Whatever you like to call it, it’s usually smaller data sets consisting of data that never changes, or changes very… Read more

7 July 2025

7 July 2025

How Attending Conferences Can Boost Your Skills and Career

If you’ve ever wondered whether attending a conference is worth the time and budget, you’re not alone. But for data professionals, the right event can be a game-changer, not just for your technical skills, but for your career trajectory. At Redgate, we’ve seen firsthand how events like PASS Data Community… Read more

2 July 2025

2 July 2025

10 Essential Things to Know Before Diving into Database DevOps

In today’s rapidly evolving world of development, Database DevOps is becoming an essential practice. It combines the agility of DevOps with the intricacies of databases, all with the goal of enhancing speed, stability and collaboration when it comes to database changes. However, before diving into Database DevOps there are some… Read more

16 May 2025

16 May 2025

Database monitoring in Financial Services: why this high-stakes sector requires a scalable, more comprehensive solution

IT and data teams in Financial Services must meet the more exacting demands for data integrity, compliance, performance, high availability and security that are expected in the sector. These demands require a dedicated, comprehensive, and scalable monitoring solution to help teams succeed in this high stakes environment. Read more

database monitoring

database monitoring tool

financial services