Dian M Fay

I'm lately back from Chicago, where PG DATA 2026 is now in the books!

A "fitness landscape" is a topographical metaphor for evolutionary success.

At my day job, we use row-level security extensively.

In what I can't say isn't a tradition at this point, we're in an odd-numbered year so there's news on the pdot front!

Let's say you have two rasters, and you want to combine them with some extra value math -- perhaps you want to grade grassland around 50°N 100°E by latitude and elevation, so blue to green to red the more northerly or higher up the point.

Of late, I've been falling down a bunch of geospatial rabbit holes.

Welcome to Squaria.

A couple years ago, I wrote about exploring a running database by plotting relevant subsets of the foreign key relationship graph in dot and piping the resulting images directly to the terminal.

Another Phriday in the books, and it's time to see what all happened: Hari Kiran offered an introduction to the concepts and processes used in schema evolution with examples showing how to use Flyway, a popular Java-based tool.

I've used several migration frameworks in my time.

It's almost Phriday again!

pg_stat_statements for May.

Here is a summary of the rules for substitution; this assumes that braces are present around the substitution, i.e. ${...}.

It's triggers this time!

MassiveJS version 7 went places. await db.select( db.libraries .join(db.holdings) // implicit join on foreign key holdings.library_id .join(db.books) // implicit join on foreign key holdings.book_id .join(db.authors, db.

While we are concentrating on our task, both our tools and our materials merge into one entity of perception which gives us feedback about state and progress of our work....

Eight days, eight data analysis puzzles, eight solutions.

The team I work with at my day job maintains many applications and processes interacting across a smaller number of databases.

In "things you can do with a terminal emulator that renders images": One way to look at a database's structure is as a graph of foreign key relationships among tables.

Update: mcfly already existed, with a slightly different approach (neural network instead of structural analysis) with a lack of fuzzy searching its only real downside, so I added that there.

A little while back I got my hands on a copy of Software Development and Reality Construction, the output of a conference held in Berlin in 1988.

MassiveJS version 6 is imminent.

Anybody doing something interesting to a production Cassandra cluster is generally advised, for a host of excellent reasons, to try it out in a test environment first.

One of my favorite good ideas to ignore is the maxim that you should have your deployment pipeline ready to go before you start writing code.

There's a new button at the bottom of this (and each) post.

NDC talks are up!

At a talk I gave earlier this month, an audience member asked if Massive supported joining information from multiple tables together.

The shell has just about all the tooling I need for day-to-day operation of a computer: navigating and managing directories and files, text editing, and building, testing, and running projects I'm working on.

Maven's probably the only all-in-one build tool I've ever really appreciated.

I should probably say up front that I love working with Postgres and could die happy without ever seeing a mysql> prompt again.

I write a lot of integration tests that operate on data.

This is a feature I added to Massive recently.