iiinova — where your digital self keeps evolving

Foysal @foysal.it · 07/04/2025

the Examples menu item on the left sidebar here tanstack.com/pacer/latest takes you there

Foysal @foysal.it · 07/11/2024

currently reading "tesla" - margaret cheney. prolly dumb but more i read about the visions/visuals he had of the atmosphere being on fire, the more i imagine the scenes from the oppenheimer movie showing light particles. cant wait for humankind to figure out how to transfer visuals between brains

020

Foysal @foysal.it · 29/10/2024

literally me in our slack last week

a slack message from me saying how much better tech content on bsky is now.

040

Foysal @foysal.it · 20/10/2024

somehow, didnt collapse, phew!

0100

Foysal @foysal.it · 17/09/2024

the madlads did it, they actually put "bluesky elder" stamp

0140

Foysal @foysal.it · 12/09/2024

fall weather is almost here and couscous makes it even better!

1120

Foysal @foysal.it · 25/08/2024

bit hazy but pretty sunset today

Sunset picture showing pinkish hue in the sky

010

Foysal @foysal.it · 04/08/2024

Found a nice spot for a picnic this weekend. Almost ruined our car getting there tho.

Peaceful mountain river in an alpine valley.

3193

Foysal @foysal.it · 08/07/2024

whatever my wife used to make lol. here's a fruity one that i dug up from like 5yrs ago

100

Foysal @foysal.it · 28/06/2024

Did you know that you can report ANY atproto record to ozone? As long as the subject is a valid at-uri, anything goes. If you're curious to find out records from which collections are being reported to your ozone this query might help. #OzoneInsights

Shows the below SQL query in a screenshot

```
SELECT
split_part("subjectUri", '/', array_length(string_to_array("subjectUri", '/'),1) - 1) AS collection,
COUNT(*) AS "count"
FROM
moderation_event
WHERE
"action" = 'tools.ozone.moderation.defs#modEventReport'
GROUP BY
split_part("subjectUri", '/', array_length(string_to_array("subjectUri", '/'),1) - 1) AS collection
ORDER BY
"count" DESC;
```

1101

Foysal @foysal.it · 23/06/2024

Hike with @iraamoni.bsky.social and @ibrahimthanbir.bsky.social was amazing! Got a bit windy near the end but beautiful views all along the trail.

Mountain river with snowy caps in the background

Some of the lake covered in cloud while snowy caps can still be seen.

more of the same, mountains, lake and clouds.

060

Foysal @foysal.it · 19/06/2024

new keyboard, who dis?

4220

Foysal @foysal.it · 17/06/2024

literally me the other day in our slack

Screenshot of my slack message saying "surprised there's no feed for the euro cup"

150

Foysal @foysal.it · 13/06/2024

Already had some food with us but couldnt say no to a little polenta with mushrooms at this mountain refuge restaurant 🍜

050

Foysal @foysal.it · 13/06/2024

Little lake at the start of the trail. Almost didnt wanna leave it behind.

Tiny lake at the beginning of the trail with matterhorn's snowy cap in the background.

130

Foysal @foysal.it · 13/06/2024

Herd of mountain goats, never get tired of them staring you down like the own the trail.

161

Foysal @foysal.it · 13/06/2024

Took the butterfly to the matterhorn today. It was beautiful out after a few days of nonstop rain so didnt wanna miss the chance to squeeze in a short hike.

bluesky swag with the matterhorn peak in the background.

1200

Foysal @foysal.it · 01/06/2024

Touch grass ✅ Touch water ✅ See mountain goats ✅ Let me just skip forward to monday already

Me and wifey sitting by a mountain lake.

1261

Foysal @foysal.it · 31/05/2024

Freestyling on some riso nero with cozze on the side for lunch today 🍜

190

Foysal @foysal.it · 30/05/2024

Having a bit more fun with the power of postgres, here's how you can get total report count per month for each reason type. #OzoneInsights

Shows the below SQL query in a screenshot

SELECT
to_char(
date_trunc('month', "createdAt" :: timestamp),
'FMMonth YYYY'
) as "Month",
replace(
meta ->> 'reportType', 'com.atproto.moderation.defs#reason',
''
) as "Type",
COUNT(*) as "Total"
FROM
moderation_event
WHERE
"action" = 'tools.ozone.moderation.defs#modEventReport'
GROUP BY
date_trunc('month', "createdAt" :: timestamp),
"Type"
ORDER BY
date_trunc('month', "createdAt" :: timestamp) DESC,
"Total" DESC;

120

Foysal @foysal.it · 30/05/2024

A small tweak to get total reports per day without the reason breakdown. #OzoneInsights

Shows the below SQL query in a screenshot

SELECT
"createdAt" :: date as "Date",
COUNT(*) as "Total"
FROM
moderation_event
WHERE
"action" = 'tools.ozone.moderation.defs#modEventReport'
GROUP BY
"Date"
ORDER BY
"Date" desc,
"Total" desc

120

Foysal @foysal.it · 30/05/2024

This query shows total number of reports your ozone instance received per day, per report reason. #OzoneInsights

Shows the below SQL query in a screenshot

SELECT
"createdAt" :: date as "Date",
replace(
meta ->> 'reportType', 'com.atproto.moderation.defs#reason',
''
) as "Type",
COUNT(*) as "Total"
FROM
moderation_event
WHERE
"action" = 'tools.ozone.moderation.defs#modEventReport'
GROUP BY
"Date",
"Type"
ORDER BY
"Date" desc,
"Total" desc

130

Foysal @foysal.it · 29/05/2024

the TLD gods had other plans

domain TLD search showing foysal.eat being taken already.

010

Foysal @foysal.it · 29/05/2024

This query shows which label was added to how many unique records/accounts through your ozone instance. Keep in mind that this will count labels that you added and then removed. #OzoneInsights

Shows the below SQL query in a screenshot
SELECT
label,
COUNT(
DISTINCT CASE WHEN "subjectUri" IS NOT NULL THEN "subjectUri" END
) AS unique_subjectUri_count,
COUNT(
DISTINCT CASE WHEN "subjectUri" IS NULL THEN "subjectDid" END
) AS unique_subjectDid_count
FROM
(
SELECT
"subjectUri",
"subjectDid",
UNNEST(
STRING_TO_ARRAY("createLabelVals", ' ')
) AS label
FROM
moderation_event
WHERE
"action" = 'tools.ozone.moderation.defs#modEventLabel'
AND $__timeFilter("createdAt")
) AS labels
GROUP BY
label
ORDER BY
unique_subjectUri_count DESC,
unique_subjectDid_count DESC;

1162

Foysal @foysal.it · 29/05/2024

Saw the biggest herd of ibex ever on a hike last weekend. We counted 21 total. If you're gonna press the like button, do it quietly, they are easily scared.

Ibex in the swiss alps next to a small amount of snow.

0121

Foysal @foysal.it · 27/04/2024

Wife made the hell out of these maultaschen that our friends brought straight from germany. solid10/10

1 plate dish with pan fried maultaschen and eggplants with avocado and tomatoes on the side.

030

Foysal @foysal.it · 25/11/2023

Guess im a little-stitious

030

Foysal @foysal.it · 06/11/2023

Just saw someone post this. absolutely going to try and sneak in some code that applies a limit of max 150 follows on this app this week. yeah, no need to thank me.

A google search result showing that humans can comfortably maintain 150 stable relationships.

150

Foysal @foysal.it · 22/10/2023

quickly accessible feed details screen is quite nice! nitpick but the 'Save' button's spacing looks off. then, in dark mode, the bottom sheet text is almost unreadable (alt text warning sheet, to be more precise)

Screenshot of the feed details screen showing slightly off spacing of the "Saved" button.

screenshot of the alt text bottom sheet styling, showing that the text is hard to read.

220

Foysal @foysal.it · 22/10/2023

ok dont hate me but ill just live post some feedback here lol. the screenshots on playstore look quite stretched, could be just me tho.

220

Foysal @foysal.it · 01/10/2023

I pay a LOT on taxes. Living in italy, just like every italian, I feel tired of it at times Today, an elderly lady had some kind of episode right across the street and within a few mins an ambulance arrived and a helicopter followed soon. All of that, for free. Felt better about my taxes right away