Thinking about creating a Microsub server, I remembered that my new shiny Postgres backend can easily answer if I already left a like on a post or not:

kittybox=# CREATE INDEX likes ON kittybox.mf2_json USING GIN ((mf2['properties']['like-of']));
CREATE INDEX
kittybox=# EXPLAIN SELECT EXISTS (SELECT uid FROM kittybox.mf2_json WHERE mf2['properties']['like-of'] ? 'https://aaronparecki.com/2018/12/25/17/');
                                                        QUERY PLAN                                                        
--------------------------------------------------------------------------------------------------------------------------
 Result  (cost=11.28..11.29 rows=1 width=1)
   InitPlan 1 (returns $0)
     ->  Bitmap Heap Scan on mf2_json  (cost=8.09..43.20 rows=11 width=0)
           Recheck Cond: (mf2['properties'::text]['like-of'::text] ? 'https://aaronparecki.com/2018/12/25/17/'::text)
           ->  Bitmap Index Scan on likes  (cost=0.00..8.08 rows=11 width=0)
                 Index Cond: (mf2['properties'::text]['like-of'::text] ? 'https://aaronparecki.com/2018/12/25/17/'::text)
(6 rows)

Nice. Indexes are awesome.

#Kittybox #PostgreSQL #Microsub

Build a website in an hour. And maybe move your Google Domains? It’s your < 10min update on the #IndieWeb community!

This Week in the IndieWeb audio edition for July 22nd - 28th, 2023. https://martymcgui.re/2023/07/29/this-week-in-the-indieweb-audio-edition--july-22nd---28th-2023/

This Week in the IndieWeb Audio Edition • July 22nd - 28th, 2023

#podcast #IndieWeb #this-week-indieweb-podcast

Any #matrix network hosts on the #fediverse interested in testing Commune?

https://writing.exchange/@erlend/110712778752844998

Commune is an extension of Matrix to make rooms web-public and threads-enabled. Layered unobtrusively on top of your existing Synapse server; most of the setup can be left up to us.

We’d like to eventually be a plug-and-play extension for any Matrix network, including Matrix.org 🌐

..so as a first step, we wanna work on interop with the smaller #IndieWeb networks as our earliest adopters.

Hey folks! Here’s an (under construction) early-look at an IndieWeb notes (micro-blog / short-form content) feature on my site. Working on a writeup (eventually) to walk through how/why it was made. Appreciate any interim feedback though!

https://indieweb.org/note #indieweb

@anirvan I'm using my own website, where I post long form blog posts as well as small posts via #micropub.
I don't really post much directly, mostly replies to other peoples posts via #webmention.

#indieweb

I'm already sold on the idea of having my own domain and website to own my online presence, and while supporting most of the #indieweb protocols or setting up a full-blown indie reader (e.g. syndicating my social interactions) looks like too much work for the kind of use I'd give it, building a plain old #rss reader, tailored to my preferences suddenly looks like a worthwhile and fun project to me.

More on the ActivityPub API project

Learning about the #indieweb movement has been one of the most interesting byproducts of joining Mastodon earlier this year. I particularly liked this talk transcript by Jamie Tanna as an introduction to the topic:

https://www.jvt.me/posts/2019/10/20/indieweb-talk/

I miss having a website (actually, having one "under construction" for almost a decade now) and seeing all these great #IndieWeb personal sites makes want to finish my own even more:

https://mastodon.social/@matthiasott/110782091549413231

#decentralization is growing

We have #mastodon, #pleroma and more to replace apps like Twitter, and honestly the #fediverse takes us 2 steps further than Twitter ever could.

Then #peertube is slowly providing an alternative to YouTube. It's hard to rival YouTube's library, not the features.

And then #matrix is slowly growing to be something capable of (one day) replacing #discord.

I think the #indieweb is going to be big.

This is part of a bigger question I have about the accessibility of the #indieweb. It takes people to create a "people-focused" web -- who are we leaving behind because they don't have the necessary technical skills? How do we balance a "safe" alternative to the corporate web while maintaining the accessibility necessary for community?

Gatekept environments online have the same benefits *and* consequences of irl gated communities, right? Is that something we can / should change?

3/3 for now...

Alright, let’s do another round! 😎

✨ What’s your favorite personal website and why? ✨

(Feel free to add your own site after mentioning someone else’s – but posting ONLY your site is cheating! 😉)

#websites #IndieWeb #personalsites

Hello, everyone! :ameowcomfywave:

I go by Lysianthus online. I'm a university student studying to be a materials scientist/engineer. I'm also a hobbyist developer/coder and a big fan of personal websites. I like #reading, #writing (mostly #fanfiction), #learning new things, and lurking in #fandom spaces.

My posts will be a mix of personal stuff and my hobbies + interests.

Nice to meet you all! :meowhearthug:

#introduction #introductions #personalwebsites #personalweb #indieweb #oldweb

Excellent Web 1 nostalgia piece by @lopatto

"In the old cyberpunk novels, the outside world itself rots as online becomes an endless spectacle you can vanish into. But if you look around, the world itself is still pretty vibrant, while the web seems to look like the set of Blade Runner."

https://www.theverge.com/2023/7/22/23803538/google-facebook-myspace-internet-culture-web-dot-com-crash

#web1 #enshittification #indieweb

Watch Out, Fediverse Users: The FBI Can Seize a Mastodon Server

Reading about #IndieWeb — it is way more interesting and complicated than simple "reject platforms embrace self-hosting"

@hamatti Alright! My /uses page is now live https://shellsharks.com/uses. #indieweb #usespage

Hi this is my #Introduction I’m new to the #fediverse and want to say hello to the community.
I’m a #classicalguitar professor and also teach #ukulele I like learning about #indieweb and #Linux (currently on Pop OS)
I love #books and #cats (currently living with two of them 🐱 ).
Since I’m from Argentina 🇦🇷 some of my toots will be in Spanish but I’m trying my best to improve my English skills.
I'm glad I've already found very interesting people here, Mastodon is great!