Foysal

@foysal.it

9765 Followers 207 Following

Build things.

a slack message from me saying how much better tech content on bsky is now.
Couscous in a plate
Sunset picture showing pinkish hue in the sky
Peaceful mountain river in an alpine valley.
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; ```
Complex structure representing the bsky app and samuel's labeler holding it all up
Mountain river with snowy caps in the background
keychron q11 keyboard
Screenshot of my slack message saying "surprised there's no feed for the euro cup"
Polenta with mushroom and cheese
Tiny lake at the beginning of the trail with matterhorn's snowy cap in the background.
herd of mountain goats
bluesky swag with the matterhorn peak in the background.
Me and wifey sitting by a mountain lake.
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;
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
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
domain TLD search showing foysal.eat being taken already.
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;
Ibex in the swiss alps next to a small amount of snow.
1 plate dish with pan fried maultaschen and eggplants with avocado and tomatoes on the side.
elderly person describing bluesky's invite code "feature" while her grandkid helps her walk.
matthew mcconaughey doing the lecture of "those are rookie numbers" in wolf of wallstreet.
fancy winnie
office meme: michael scott screaming "I declare federation" instead of backruptcy
A google search result showing that humans can comfortably maintain 150 stable relationships.
Screenshot of the feed details screen showing slightly off spacing of the "Saved" button.
A helicopter landing, guided by a paramedic from the ground
Car salesman meme with text saying "This bad boy can fit so much beef in it"
3 tents under a tree, next to a mountain lake
yellow colored butcheeks in the sky