Redgate Blog

Posts tagged with PostgreSQL

18 March 2026

Let’s Tune Our AWS Aurora PostgreSQL Database

In case you don’t know the back story, in order for me to play with radios and label it “work,” I’ve created a PostgreSQL database running on AWS Aurora. The db is fed from API calls to aprs.fi through Lambda functions on AWS. Some of the DDL & code is… Read more

24 February 2026

24 February 2026

PostgreSQL Explain Plans in AWS Aurora

I recently wrote about a project I created on AWS Aurora PostgreSQL where I’m capturing APRS data from a radio. I focused on the ease of use, getting a database, some Lambda Functions, and a few schedulers working together with a web page. It was easy. However, I’d like to… Read more

20 February 2026

20 February 2026

Putting AWS To Work On My Hobby

I’m sure I’ve never mentioned it, but I’m a licensed amateur radio operator, commonly called a ham. KC1KCE is my call sign. OK, those who know me are currently mumbling to themselves “He won’t shut up about it.” I can hear you. I promise, I’ll keep the radio discussions to… Read more

10 December 2025

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

PostgreSQL

Redgate Flyway

Redgate Flyway Enterprise

Laura Ray

7 July 2025

Laura Ray

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

career development

Conferences

Databases

Security and compliance

Database monitoring and observability

Database change management

Productivity and workflow automation

AI data readiness

Database modernization

Efficiency and cost optimization

Cloud migration and workload optimization

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Test Data Manager

Redgate Blog

Posts tagged with PostgreSQL

Let’s Tune Our AWS Aurora PostgreSQL Database

PostgreSQL Explain Plans in AWS Aurora

Putting AWS To Work On My Hobby

Building dbRosetta Part 5: We Need an API

Building dbRosetta Part 4: Automating a CI Database Build

Building dbRosetta Using AI: Part 3, Creating a Database

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

Building dbRosetta Using AI: Part 1 of Many

Introducing PostgreSQL Static Data in Flyway

How Attending Conferences Can Boost Your Skills and Career

2026 State of the Database Landscape

Introduction to PostgreSQL for the data professional

Security and compliance

Database monitoring and observability

Database change management

Productivity and workflow automation

AI data readiness

Database modernization

Efficiency and cost optimization

Cloud migration and workload optimization

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Test Data Manager

Posts tagged with PostgreSQL

Cookies on red-gate.com