Viewing profile — dmfay

My project pdot^1 has a full-ERD mode but it's honestly less useful than the semi-interactive/contextual mode of navigating schema subgraphs in a database of any size. pdot can out…

Supply chains in the sense of a centralized (or multi-centralized) logistics no, supply chains in the sense of mobile pastoral groups supporting armies' further extension yes. Thes…

pspg ( https://github.com/okbob/pspg ) is wonderful for tabular data.

The image they're using is from a 2013 excavation of a Sarmatian kurgan in the Urals: https://www.archaeology.wiki/blog/2013/09/12/the-life-of-the...

It went offline earlier this year, but https://web.archive.org/web/20220330034214/http://www.databa... > is something similar too. Diagrams not copy-pastable DDL, but at least for …

de Haan & Koppelaars' _Applied Mathematics for Database Professionals_ is well worth your time, especially if you haven't studied discrete math yet.

Ask! Create an issue if there's a tracker or send a short email explaining what you want to do and see if they're open to the idea, have more questions, or aren't interested in sup…

Postgres schema comments (COMMENT ON COLUMN mytable.mycolumn IS 'spline reticulation coefficient'). Otherwise, I've given up on ever maintaining data model documentation and genera…

I haven't tried it myself yet but https://arcan-fe.com/2021/04/12/introducing-pipeworld/ has been on my radar for a while.

I can't tell you whether you'll love or hate Fyodor Sologub's The Petty Demon but you won't feel lukewarm on it. The Cioran translation is more complete but harder to find than old…

Full ERDs have always been more valuable to me in the making than in the having largely for that reason. But I've gotten a lot of mileage out of generating ephemeral slices of the …

Lex de Haan and Toon Koppelaars, Applied Mathematics for Database Professionals -- a fairly gentle introduction to database theory starting with logic & discrete math Ralph Kimball…

I'm using a tree-sitter grammar^1, which category the OP doesn't mention, to index database object references in data access code and process schema migrations^2. The idea is early…

Nothing metaphysical about tarot, but it can be useful to challenge how you naturally think. The random cards you lay out force you to reconcile them with the story you tell yourse…

I think mcfly's ( https://github.com/cantino/mcfly ) prioritization engine is still the killer feature for my purposes, but the sync server and timing display are both fantastic id…

You may be interested in the USING clause SQL-92 added for foreign keys where the referencing columns have the same name as the referenced columns: JOIN b USING (a_id). The only ma…

That looks like another full-scale ERD generator, with much more detailed structural information too. Those make useful references, but what I'm trying to reach is a way of underst…

Searching shell command history one line at a time with ctrl-r and ctrl-s is useful but it's not how my brain works, and it probably isn't exactly how yours works either. Mnem aggr…