I don’t know where the supplement files will be posted, possibly on the legacy site this month.
We’ll be checking them carefully to make sure they look right before we release them, including making sure they load into WinTD and SwissSys. (I know people who have tried to load the Golden Master file into Excel, it failed because Excel had a maximum of somewhere around 640,000 rows, and the Golden Master files have more like 1.2 million rows in them.)
FWIW, there have been several times in the last year when the supplement files weren’t posted until Friday or Saturday due to issues with their generation. That may be the case with the December 2025 files as well.
Not one I’ve used. I have several PHP programs I wrote that can extract data from DBF files, most using the PHP dBase tool kit which makes it easy to read individual records from the file and process or aggregate them. If I want to do serious fiddling with the data in a DBF files, I write a tool to extract the records, create a database table for them and generate SQL inserts to populate the table, then it is just another table in Postgres.
Years ago, when my younger son was taking his first data structures course, the instructor had them write SQL statements to pull a variety of data reports from a set of MySQL tables.
Some of them were kind of tricky, I think most of the class wound up generating some kind of temporary table to handle some of the data reports, but the more I looked at the list the more certain I was that with feature like subqueries and windowing functions, every one of them could be done in a single SQL statement.
It reminded me of my days at the computer center at Northwestern, when the head of technical services would create some data records and ask the staff as a training exercise (mostly grad students, I was the first undergrad hired to work there) to produce some output from those data records using a variety of language tools including FORTRAN, COBOL, ALGOL-60, BASIC, APL, LISP and SNOBOL. Some of those languages were better suited for the specific tasks than others but there was always a way to do it with each of the assigned tools. It was excellent training for figuring out how to use a tool for purposes for which it was not well-suited or designed. Sometimes you have to use the tools you have, not the tools you’d like to have, to get the job done.
What’s the timeline between updating affiliate expiration (and member expiration) and display in the new system? It appears that my affiliate (which I renewed last month) is not showing renewed in Leago? I’m thinking it might have gotten caught between systems? If mine got missed, I’m wondering if other affiliates / memberships also might be missed? I was under the impression that future state these would be almost instantaneous (it was like 15 mins historically, I think?).