My previous post about indexing and connecting the subsurface internet focused on how the sausage was made so I'm finally following up with a demonstration.

My objective is to provide external links to (hopefully) good and related content on each of my posts but this works just as well when connecting arbitrary pages from the crawl corpus. In the style of the Dating Game...

Bachelorette: The Great Unzippening

swyx.io The Great Unzippening Society is splintering in an unacceptable way and I have a metaphor for it.

Bachelors, what is driving a wedge into modern society?

jfsdigital.org Talking Across Differences:A Paradigm for Raising Consciousness * Journal of Futures Studies by William Halal This article focuses on one of the great challenges facing all of us today -how can we resolve the raging conflicts fomented by social media? Conflict has always been a problem, but the digital revolution has raised it into one of the great challenges of our time. Facebook and other social media [...] The post Talking Across Differences:A Paradigm for Raising Consciousness appeared first on Journal of Futures Studies.

thezvi.wordpress.com Covid 2/18: Vaccines Still Work | Don't Worry About the Vase This week the CDC released new guidelines for schools. I've spun my analysis of that off into its own post. Scott Alexander also shared some good thoughts on Covid-19 in two new posts, and I discuss both of those, and how our models and predictions differ. Also, as some combination of retaliation and its continued...

nytimes.com Two States. Eight Textbooks. Two American Stories. - The New York Times We analyzed some of the most popular social studies textbooks used in California and Texas. Here's how political divides shape what students learn about the nation's history.

Bachelorette: Managing the Long-Range Missiles - Corporal Frisk

corporalfrisk.com Managing the Long-Range Missiles - Corporal Frisk The massed attacks on Ukraine today again raises the question about different approaches to managing the long-range ballistic and cruise missile threat, and while I don't claim to have written the book on the issue, I did write a chapter with that headline for a Swedish Defence Research Agency (FOI) report a few years ago....

Bachelors, if you were a long range missile, which would you be?

libya360.wordpress.com How Yemen is Blocking US Hegemony in West Asia - INTERNATIONALIST 360° William Van Wagenen The new US-led coalition in the Red Sea will struggle to overcome Yemen's naval blockade on Israel, as Ansarallah's domestically-produced and inexpensive drones and missiles have leveled the technological playing field. Given the renewed focus on Yemen's de facto government led by Ansarallah and its armed forces, it is time to move...

syria360.wordpress.com US Plans Military Aggression Against Yemen - SYRIA 360° INTERNATIONALIST The Cradle Yemen's Ansarallah has targeted Israeli-linked ships in the Red Sea and fired missiles at the Israeli port city of Eilat in support of the Palestinian resistance The US is discussing possible military action with allies Saudi Arabia and the UAE against Yemen's Ansarallah in response to the resistance movement's attacks on Israeli-linked ships...

theaviationist.com Let's Have A Look At Ballistic Missile Allegedly Used In Recent Attacks On US bases in Iraq and Syria - The Aviationist... Islamic Resistance in Iraq has recently released images its Al-Aqsa 1 medium range ballistic missile claiming it was used to strike US bases in Syria and Iraq.

Bachelorette: Elixir and Postgres: A Rarely Mentioned Problem | Lainblog

blog.soykaf.com Elixir and Postgres: A Rarely Mentioned Problem | Lainblog Or: How To Increase Your Elixir/Postgres Performance 20x With One Weird Trick

Bachelors, nobody likes to do SQL so just ramble I guess.

blog.logrocket.com CRUD REST API with Node.js, Express, and PostgreSQL - LogRocket Blog Learn how to install and set up PostgreSQL in the command line, create users, databases, and tables, and run SQL commands.

iamsafts.com Debugging random slow writes in PostgreSQL | safts | blog In web applications it's not rare to face performance issues that we can't quite understand. Especially when working with databases, we treat them as this huge "black box" that 99% of the times works amazingly without us even caring about it. Heck, we even use stuff like ORMs that essentially "hide" our interaction with the database, making us think that we don't need to care about this stuff. If you're developing something small, contained, simple then this is probably the case....

rasikjain.com Using dynamic SQL query in Redshift database While working with a client, we had a requirement to perform bulk insert/update using Retool table and Redshift database. For this situation, We had to loop through the table records and execute a dynamic SQL query in Redshift. Redshift database supports execution of dynamic SQL with the help of Prepared Statements or Stored Procedures. Prepared Statements We use prepared statements when we want to execute dynamic SQL queries directly without a stored procedure.

Source.

Another way to explore the web is via image links. With an index of somewhat-vetted links, I can generate a random (or topical) index of images, this one is random:


I didn't do much to prune the results - just a few logos (that slipped by my dimensions threshold) and some domains that needed to go on the blacklist.

I rehosted (with href) each of these but envision simply linking to a random assortment of indieweb graphics.

Programming language mentions from a sampling of 20,000 smallweb/indieweb pages.

After hitting 50,000 pages and retaining 20,000 of them, I threw a few keywords at the data to see what people write about.

News mentions from a sampling of 20,000 smallweb/indieweb pages.

It wasn't especially surprising to see that programming is way more popular than news or even video games.

Video game mentions from a sampling of 20,000 smallweb/indieweb pages.

I previously talked about manually seeding my blog crawler with links to more diverse content. Search sucks (even indiesearch), so it didn't work out so well. Subsequently I went on another walk through the dark forest in search of posts about wood preservation and Across The Obelisk and suspension work.

Webrings and Geocities

I've read an article or two about the revival of the old web, mostly from tech people who reject the Zuckernet. But I guess there was a recent, short-lived fad where people created websites in the style of 90s era homepages, complete with gifs and wallpapers and horrific color schemes. They seem to have considered the Geocities aesthetic "cool in an ironic way" and sought to capture that style with no actual content beyond a few shared gifs. Like the original pages that still show "Last updated September 1, 1998", these 2020s replicas are largely abandoned. They often link to webrings or directories that mirror the screenshot above, on indefinite hiatus as of a year or two ago.

/r/seo kinda

Hacker News (the proto-Reddit) is pretty good about linking quality content from the blogosphere, I often punch those in to my crawler. But perhaps HN's wayward offspring might have a vibrant indieweb community? First I checked /r/blogs. It was pretty much dead other than a few frequent posters linking AI-generated garbage. Then I went to /r/blogging, which was like /r/seo for non-technical people. Everyone was looking for an edge to get ad money for their side hustle. I spent a few minutes gawking:

• /r/blogging users posted a lot of complaints about Google recently decimating everyone's traffic by de-ranking them for something (maybe having a third party ad service?).
• Many /r/blogging subscribers vocally embraced GPT-generated content but warned that it should be used with caution.
• While /r/blogging is active relative to /r/blogs, its policy against self-promotion meant it was a dry well for seed links, not that I'd be optimistic about them anyway.

Related - internal

Related - external