Matt Sosna

Find me on Threads at @mgsosna. 👋

[Matt Sosna @mgsosna]

New blog post in @TDataScience! When I started learning #SQL, I found it hard to progress beyond the basics because I didn't have a #database to play with.

Here we build a #postgres DB & explore set operators, arrays, window functions, EXPLAIN, and more.
https://t.co/W5nc2GG9X5

[Matt Sosna @mgsosna]

Hi all, I've stopped using Twitter/X and am on Threads now. Find me there at @mgsosna. 👋 Would love to rebuild Academia/EEB Twitter there. 🙂

[Matt Sosna @mgsosna]

@icouzin Placazoa?

[Matt Sosna @mgsosna]

New blog post in @TDataScience! #sql is deceptively simple: what you see is what you get... until you don't. This post shares 3 recent head-scratchers I encountered. They're formatted as riddles - try to figure them out before reading the answer.

https://t.co/L9MUezWa7g

[Matt Sosna @mgsosna]

@TDataScience @awscloud Non-paywall version: https://t.co/k1j7u25gbg

[Matt Sosna @mgsosna]

New blog post in @TDataScience! A deep dive on #CloudComputing in @awscloud, focusing on #ec2 and #lambda. Deploy a virtual server and train an ML classifier, then create a Lambda function you can invoke through API Gateway. https://t.co/QH5yeIjENM

[Matt Sosna @mgsosna]

@Chris_Grosse Flat Top

[Aryeh Kontorovich @aryehazan]

I had this hanging on my office door for a couple of years. A nice illustration of how limits do/don't work.

[Towards Data Science @TDataScience]

. @mgsosna breaks down how to understand and deploy EC2 and Lambda services. https://t.co/rcYXOz2TbF

[Mick Gordon @Mick_Gordon]

Marty Stratton, @idSoftware Studio Director, lied about @DOOM Eternal's OST events in a Reddit post that used disinformation to blame me entirely for its failure

Later, he offered me a six-figure sum to never speak about it

The truth is more important.
https://t.co/zSNo2QG1mI

[Andrew Hein @aHeinLab]

Thrilled to announce my lab will be moving to the Computational Biology Department @Cornell, 2023! We’ll be hiring technician, multiple postdocs and grad students to work at the interface of computational ecology and behavior. Ads to come but please DM me or email if interested.

[Caitlin C. Clements @C_C_Clements]

I’ve been holding on to some good news… next year I’ll be asst prof in the @NotreDame Psychology Dept! Can’t wait to join brilliant & passionate faculty & students, & partner with the South Bend autism community to see what great clinical science we can do together 🍀 #autism

[Science girl @sciencegirl]

Spectacular time lapse of the the Eurasian blue tit (Cyanistes caeruleus),

From finding and inspecting her new home to raising a family

[Tyler C. Coverdale @tylerccoverdale]

📢📢 Please RT and share widely! 📢📢

I'm recruiting PhD students to join my lab @NDBios for Fall 2023! Exciting opportunity to join existing projects or develop new research at field sites around the world. See attached for more info & please reach out!

https://t.co/CUyIVOxVQ6

[Mette Bendixen @Mettebendixen08]

This guide on avoiding #genderbias in reference writing in #academia is one I always return to! Print it out and hang it on your wall! 📌

[Matt Sosna @mgsosna]

@jawnsy @alexxubyte 🤣

[Wolfgang Bremer @WolfgangBremer]

being the first designer at a company

[Charlotte Dreizen @CharDreizen]

Plastic bags are the most common contaminant by a mile.

Whether it’s a plastic bag alone or recycling placed *into* a plastic bag, they jam recycling equipment and cause facilities to have to shut down multiple times a day for workers to cut out with box cutters.

[Michael Justus @mhjrad]

there's a Left shift in infectious disease doctors

[Towards Data Science @TDataScience]

. @mgsosna explains how to set up cloud storage, the right type of storage for certain types of data, and interacting with cloud storage directly from code rather than a UI. https://t.co/fz4dtWEkdh

[John Hammond @_JohnHammond]

Today I got a notification on my phone that YouTube had sent me a copyright report, claiming one of my videos violated copyright and my channel was going to receive a strike.

Except, my video didn't violate copyright. And YouTube didn't really send me a copyright report.