This you find around the ๐ŸŒ Internet
๐Ÿ” Web search with Google โ€ข Bing โ€ข DuckDuckGo โ€ข Marginalia โ€ข Reddit โ€ข Spotify โ€ข TikTok โ€ข Tootfinder โ€ข X โ€ข Yandex โ€ข Youtube โ€ข YTM
This you find in the ๐Ÿ›๏ธ Agora
๐Ÿค– AI assistant on 'adding-a-list-of-nodes-in-my-garden-that-are-well-connected'
Generative AI services provided by Mistral AI. To save a generation into the Agora, for now please copy/paste into the document Stoa above.

Generating text...


๐Ÿ—ฃ๏ธ Stoas for [[adding-a-list-of-nodes-in-my-garden-that-are-well-connected]]
A Stoa is a public space where people can meet and collaborate.
๐Ÿ“– Document at https://doc.anagora.org/adding a list of nodes in my garden that are well connected
๐Ÿ“น Meeting at https://framatalk.org/adding a list of nodes in my garden that are well connected
๐Ÿ“š Node [[adding a list of nodes in my garden that are well connected]]
๐Ÿ““ garden/neil/adding-a-list-of-nodes-in-my-garden-that-are-well-connected.md by @neil ๏ธ๐Ÿ”— โœ๏ธ

Adding a list of nodes in my garden that are well-connected

[[Gordon Brander]] has a list of well-connected nodes in his pattern library.

I like the idea. Statistics relating to links and connections feels more in line with a [[relational ontology]] than just having counts of nodes, etc.

So Iโ€™ve added a page that lists the top 40 nodes in my garden by number of [[backlinks]].

Itโ€™s on the [[Well-connected]] page.

The source below is executed inline on that page when itโ€™s published. It builds a SQL query to run against the org-roam DB, then formats the results.

(let* ((sql [:select [title dest (funcall count :distinct source)]
		 :from links
		 :inner :join nodes
		 :on (= links:dest nodes:id)
		 :where (= type "id")
		 :group :by dest
		 :order-by [(desc (funcall count :distinct source))]
		 :limit 40])
	 (links (org-roam-db-query sql)))
    (cl-loop for link in links
	     collect (pcase-let ((`(,title ,dest ,count) link))
		       (format "- %s โ† %d.\n" (org-link-make-string (concat "id:" dest) title) count))))

The query counts how many nodes are linking to a particular node, rather than how many total backlinks. So node B could have multiple quotes in it that link to node A, but that only counts as one connection between A and B in the counts here.

Loading pushes...

Rendering context...