Foysal
LightNews LightNews
banner
foysal.it
Foysal
@foysal.it
8K followers 180 following 470 posts
Build things.
Posts Replies Media Videos
foysal.it
the Examples menu item on the left sidebar here tanstack.com/pacer/latest takes you there
April 7, 2025 at 8:59 PM
foysal.it
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
November 7, 2024 at 9:29 AM
foysal.it
literally me in our slack last week
a slack message from me saying how much better tech content on bsky is now.
October 29, 2024 at 9:13 AM
foysal.it
somehow, didnt collapse, phew!
October 20, 2024 at 4:03 PM
foysal.it
the madlads did it, they actually put "bluesky elder" stamp
September 17, 2024 at 11:09 AM
foysal.it
fall weather is almost here and couscous makes it even better!
Couscous in a plate
September 12, 2024 at 10:22 AM
foysal.it
bit hazy but pretty sunset today
Sunset picture showing pinkish hue in the sky
August 25, 2024 at 6:25 PM
foysal.it
Found a nice spot for a picnic this weekend. Almost ruined our car getting there tho.
Peaceful mountain river in an alpine valley.
August 4, 2024 at 8:58 PM
foysal.it
whatever my wife used to make lol. here's a fruity one that i dug up from like 5yrs ago
July 8, 2024 at 10:47 PM
foysal.it
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; ```
June 28, 2024 at 10:21 AM
foysal.it
iykyk
Complex structure representing the bsky app and samuel's labeler holding it all up
June 24, 2024 at 3:24 PM
foysal.it
June 23, 2024 at 8:55 PM
foysal.it
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.
June 23, 2024 at 8:19 PM
foysal.it
new keyboard, who dis?
keychron q11 keyboard
June 19, 2024 at 4:22 PM
foysal.it
literally me the other day in our slack
Screenshot of my slack message saying "surprised there's no feed for the euro cup"
June 17, 2024 at 11:29 AM
foysal.it
Already had some food with us but couldnt say no to a little polenta with mushrooms at this mountain refuge restaurant 🍜
Polenta with mushroom and cheese
June 13, 2024 at 7:41 PM
foysal.it
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.
June 13, 2024 at 7:39 PM
foysal.it
Herd of mountain goats, never get tired of them staring you down like the own the trail.
herd of mountain goats More panoramic view of the herd
June 13, 2024 at 7:35 PM
foysal.it
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.
June 13, 2024 at 4:39 PM
foysal.it
Touch grass ✅
Touch water ✅
See mountain goats ✅
Let me just skip forward to monday already
Me and wifey sitting by a mountain lake. Mountain goat brooding
June 1, 2024 at 5:20 PM
foysal.it
Freestyling on some riso nero with cozze on the side for lunch today 🍜
May 31, 2024 at 12:51 PM
foysal.it
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;
May 30, 2024 at 6:44 PM