dmfay

7 ms·

1.
by dmfay 3y ago
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 output mermaid and render other graphs too, like trig
2.
by dmfay 4y ago
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. These did not stretch all the way back to central Asia. Gro
3.
by dmfay 4y ago
pspg ( https://github.com/okbob/pspg ) is wonderful for tabular data.
4.
by dmfay 4y ago
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...
5.
by dmfay 4y ago
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 me the value is i
6.
by dmfay 4y ago
de Haan & Koppelaars' _Applied Mathematics for Database Professionals_ is well worth your time, especially if you haven't studied discrete math yet.
7.
by dmfay 4y ago
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 supporting it. No need to overthink formalities
8.
by dmfay 4y ago
Postgres schema comments (COMMENT ON COLUMN mytable.mycolumn IS 'spline reticulation coefficient'). Otherwise, I've given up on ever maintaining data model documentation and generate ad hoc graphs from different perspectives
9.
by dmfay 4y ago
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.
10.
by dmfay 4y ago
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 older translations now in the public doma
11.
by dmfay 4y ago
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 foreign key graph from the "viewpoint" of a g
12.
by dmfay 4y ago
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 and Margy Ross, The Data Warehouse Toolkit -- even
13.
by dmfay 4y ago
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 detection of potentially-dangerous database chang
14.
by dmfay 4y ago
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 yourself about where you are or a specific situation, and can show
15.
Show HN: Ectomigo – Measure the impact of database changes before you merge(ectomigo.com)
4 points by dmfay 5y ago|0 comments
16.
by dmfay 5y ago
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 ideas, and I'd love to see t
17.
by dmfay 6y ago
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 major RDBMS that doesn't support it is SQL Server afaik.
18.
by dmfay 6y ago
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 understanding parts of a relationship graph better and more qu
19.
Exploring Databases Visually(di.nmfay.com)
146 points by dmfay 6y ago|27 comments
20.
by dmfay 6y ago
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 aggregates the syntactic structures in your history to
21.
Show HN: Extra-fuzzy history searching with Mnem(di.nmfay.com)
2 points by dmfay 6y ago|1 comments