Foysal

@foysal

Build things.

207 Following9,770 Followers510 Posts

Bluesky

Is this your profile?Claim it and foysal.dirty.social is yours.Claim profile

Foysal@foysal· Apr 7

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

Foysal@foysal· Nov 7

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

Foysal@foysal· Oct 29

literally me in our slack last week

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

Foysal@foysal· Oct 20

somehow, didnt collapse, phew!

Foysal@foysal· Sep 17

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

Foysal@foysal· Sep 12

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

Foysal@foysal· Aug 25

bit hazy but pretty sunset today

Sunset picture showing pinkish hue in the sky

Foysal@foysal· Aug 4

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

Peaceful mountain river in an alpine valley.

Foysal@foysal· Jul 8

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

Foysal@foysal· Jun 28

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;
```

Foysal@foysal· Jun 24

iykyk

Complex structure representing the bsky app and samuel's labeler holding it all up

Foysal@foysal· Jun 23

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.

Foysal@foysal· Jun 19

new keyboard, who dis?

Foysal@foysal· Jun 17

literally me the other day in our slack

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

Foysal@foysal· Jun 13

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

Foysal@foysal· Jun 13

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.

Foysal@foysal· Jun 13

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

Foysal@foysal· Jun 13

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.

Foysal@foysal· Jun 1

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

Me and wifey sitting by a mountain lake.

Foysal@foysal· May 31

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

Foysal@foysal· May 30

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;

Foysal@foysal· May 30

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

Foysal@foysal· May 30

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

Foysal@foysal· May 29

the TLD gods had other plans

domain TLD search showing foysal.eat being taken already.

Foysal@foysal· May 29

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;

Foysal@foysal· May 29

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.

Foysal@foysal· Apr 27

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.

Foysal@foysal· Feb 6

elderly person describing bluesky's invite code "feature" while her grandkid helps her walk.

Foysal@foysal· Jan 19