Patrick's Avatar

Patrick

@psanker.me.bsky.social

I mainly shitpost about SQL Server - data dude at local hospital - New Mexican in New York - R, OCaml, and DuckDB shill

270 Followers  |  988 Following  |  126 Posts  |  Joined: 23.11.2023  |  1.6948

Latest posts by psanker.me on Bluesky

Ironically (perhaps), I have observed better professionalism in research practices outside of academia than I have inside of it. Very much agree with your points about the failings of the open science movement.

09.07.2025 15:40 โ€” ๐Ÿ‘ 5    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Preview
Facebook Allegedly Detected When Teen Girls Deleted Selfies So It Could Serve Them Beauty Ads A recent tell-all by a Facebook insider reveals the insidious nature of Facebook's advertising empire, and the dangerous consequences.

Facebook allegedly detected when teen girls deleted selfies so it could serve them beauty ads

05.05.2025 21:08 โ€” ๐Ÿ‘ 1170    ๐Ÿ” 377    ๐Ÿ’ฌ 70    ๐Ÿ“Œ 151

๐Ÿ“Œ

04.05.2025 17:05 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

Isnโ€™t this the guy that did the fake tweet about the 90-day pause

30.04.2025 19:56 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

recognized the Ursula breakfast burrito immediately. thank god for that burrito being in NYC

24.04.2025 00:50 โ€” ๐Ÿ‘ 1    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

time for Senator Tim Onion

23.04.2025 16:04 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

Don't do that. Create a persisted database file in a secure location (since we're working with Medicare files), and then `use` that db. That'll allow you to spill to disk for larger-than-memory operations. I do this all the time for my work on medical claims data.

23.04.2025 14:50 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 2    ๐Ÿ“Œ 0
Preview
Six men charged after forcibly removing woman from North Idaho town hall The Coeur d'Alene City Attorney's Office has filed charges against six men involved in the forced removal of a woman at a Kootenai County town hall in February.

oh hey welcome to your trial, blackshirts

20.04.2025 03:21 โ€” ๐Ÿ‘ 14659    ๐Ÿ” 3517    ๐Ÿ’ฌ 70    ๐Ÿ“Œ 386
Video thumbnail

As promised hereโ€™s Pink Pony Club but itโ€™s about encryption

14.04.2025 20:38 โ€” ๐Ÿ‘ 2763    ๐Ÿ” 743    ๐Ÿ’ฌ 77    ๐Ÿ“Œ 65

Rest easy, Val. Itโ€™s a moral imperative.

02.04.2025 12:03 โ€” ๐Ÿ‘ 2    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Post image Post image Post image Post image

Must read: Mahmoud Khalil speaks out for the first time since his arrest by the Trump administration in an exclusive letter, dictated over the phone to his family, from ICE detention in Louisiana.

18.03.2025 21:50 โ€” ๐Ÿ‘ 13181    ๐Ÿ” 6516    ๐Ÿ’ฌ 108    ๐Ÿ“Œ 278
Preview
Long Island man is first in New York history to be cured of sickle cell anemia A patient on Long Island is the first in New York to be cured of sickle cell anemia, doctors say.

Looks like we've got a cure for sickle cell. www.cbsnews.com/newyork/news...

15.03.2025 00:16 โ€” ๐Ÿ‘ 6987    ๐Ÿ” 1834    ๐Ÿ’ฌ 162    ๐Ÿ“Œ 502
Post image

DuckDB got a local UI. Thanks to our friends at MotherDuck, you can now interact with your DuckDB database through an interactive notebook, running on localhost. Read the announcement blog post at duckdb.org/2025/03/12/d...

12.03.2025 13:18 โ€” ๐Ÿ‘ 172    ๐Ÿ” 48    ๐Ÿ’ฌ 9    ๐Ÿ“Œ 12

After running into this at work, it requires the following extensions: json, autocomplete, httpfs, and icu. After putting those into your .duckdb dir it works just fine!

12.03.2025 19:26 โ€” ๐Ÿ‘ 3    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
After President Trump's inauguration last month, he has steadily signed a slate of executive orders to keep these education promises: combatting critical race theory, DEl, gender ideology extremism, and discrimination in admissions. President Trump has also been focused on eliminating wasteful bureaucracy and harmful programs in the federal government. To that end, today he signed [Executive Order XYZ, entitled "Eliminating the Department of Education,] which has given us a clear and final mission.

We are to identify which of the Department's functions, programs, and offices are not mandated by statute, and eliminate them. This reorganization will impact staff, budgets, reporting, and more โ€”and in coming months, we will determine how it can be accomplished with minimal delay and disruption. The President further tasked us with creating a plan to reallocate and reassign functions of the Department of Education that would be more effectively managed by other agencies. This plan will offer Congress a road map toward fulfilling the expectations of the President and the American people.

The new visionโ€”which I hope each of you will embrace going forwardโ€”can be expressed as four main convictions:
๏ปฟ๏ปฟ๏ปฟParents are the primary decision makers in their children's education.
๏ปฟ๏ปฟ๏ปฟStudents deserve to be protected from physical violence, racial discrimination, medical tyranny, and gender extremism ideology on campus.
Postsecondary education should be a path to a well-paying career aligned with workforce needs. 
๏ปฟ๏ปฟ๏ปฟTaxpayer-funded education should refocus on meaningful learning: proficiency in math, reading, and core subjects, and patriotism in American history and civics.
As we move to reduce the Department's middleman role in education, these four convictions must guide us toward conscientious and pragmatic action. The elimination of bureaucracy should free us, not limit us, in our pursuit of these goals

Removing red tape and bureaucratic barriers will empower parents to make th

After President Trump's inauguration last month, he has steadily signed a slate of executive orders to keep these education promises: combatting critical race theory, DEl, gender ideology extremism, and discrimination in admissions. President Trump has also been focused on eliminating wasteful bureaucracy and harmful programs in the federal government. To that end, today he signed [Executive Order XYZ, entitled "Eliminating the Department of Education,] which has given us a clear and final mission. We are to identify which of the Department's functions, programs, and offices are not mandated by statute, and eliminate them. This reorganization will impact staff, budgets, reporting, and more โ€”and in coming months, we will determine how it can be accomplished with minimal delay and disruption. The President further tasked us with creating a plan to reallocate and reassign functions of the Department of Education that would be more effectively managed by other agencies. This plan will offer Congress a road map toward fulfilling the expectations of the President and the American people. The new visionโ€”which I hope each of you will embrace going forwardโ€”can be expressed as four main convictions: ๏ปฟ๏ปฟ๏ปฟParents are the primary decision makers in their children's education. ๏ปฟ๏ปฟ๏ปฟStudents deserve to be protected from physical violence, racial discrimination, medical tyranny, and gender extremism ideology on campus. Postsecondary education should be a path to a well-paying career aligned with workforce needs. ๏ปฟ๏ปฟ๏ปฟTaxpayer-funded education should refocus on meaningful learning: proficiency in math, reading, and core subjects, and patriotism in American history and civics. As we move to reduce the Department's middleman role in education, these four convictions must guide us toward conscientious and pragmatic action. The elimination of bureaucracy should free us, not limit us, in our pursuit of these goals Removing red tape and bureaucratic barriers will empower parents to make th

SCOOP: Now that Linda McMahon is confirmed/sworn in as secretary, Trump will be imminently issuing an executive order eliminating the Department of Education.

Iโ€™ve obtained a draft of an email that McMahon will be sending to staff re: the EO and the departmentโ€™s โ€œfinal missionโ€.

Here is a portion:

04.03.2025 00:04 โ€” ๐Ÿ‘ 7265    ๐Ÿ” 4045    ๐Ÿ’ฌ 715    ๐Ÿ“Œ 1199
Screenshot of Thomas Chatterton Williamsโ€™ Bluesky profile, where a โ€œJesse Singal Followerโ€ label is visible and circled in red by the screenshotter.

Screenshot of Thomas Chatterton Williamsโ€™ Bluesky profile, where a โ€œJesse Singal Followerโ€ label is visible and circled in red by the screenshotter.

Still remains best indicator of asshat behavior

21.02.2025 21:00 โ€” ๐Ÿ‘ 1    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

Get bent, Peter Baker. They are our neighbors, not political playthings. You have actively made this country worse with your โ€œreportingโ€. What โ€œnewsโ€ is there here? This is nothing but dangerous speculation. I would say shame on you, but I donโ€™t think you have the capacity for shame.

18.02.2025 11:08 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Meme from Arrested Development where Tobias says โ€œI mean, these people somehow delude into thinking it might, but it might work for usโ€

Meme from Arrested Development where Tobias says โ€œI mean, these people somehow delude into thinking it might, but it might work for usโ€

playbook for the last 30 years going strong

09.02.2025 06:13 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

New โ€” The National Center for Missing & Exploited Children (NCMEC) was told this week by DOJ that they'd lose their funding if the org didn't remove any mentions of LGBTQIA+ issues from their public materials, I've learned. Staff were told they need to deadname trans kids in their reports to comply.

07.02.2025 03:30 โ€” ๐Ÿ‘ 13521    ๐Ÿ” 5952    ๐Ÿ’ฌ 632    ๐Ÿ“Œ 1725

why are these people just plain evil?

06.02.2025 03:26 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

donโ€™t give them ideas Hank wtf

05.02.2025 22:54 โ€” ๐Ÿ‘ 4    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

On May 10, 1933, Nazis burned the library of The Institute for Sexual Science.

The Institute was founded by Dr. Magnus Hirschfeld. Its community clinic pioneered healthcare for queer, trans, & intersex people.

The Institute was targeted & attacked as part of a Nazi government censorship program.

02.02.2025 00:10 โ€” ๐Ÿ‘ 6309    ๐Ÿ” 3412    ๐Ÿ’ฌ 46    ๐Ÿ“Œ 53

they want all trans people to detransition or die and everyone who led us to this point has every last bit of that blood on their hands

28.01.2025 22:55 โ€” ๐Ÿ‘ 1909    ๐Ÿ” 393    ๐Ÿ’ฌ 20    ๐Ÿ“Œ 1
Don Cheadle appearing on Saturday Night Live in 2019. He is about to introduce the musical guest. The stage is behind him, audience members behind him have their backs to him. He is looking into the camera. Heโ€™s wearing a baseball cap of some kind and a dark shirt with the phrase PROTECT TRANS KIDS in white letters across his chest.

Don Cheadle appearing on Saturday Night Live in 2019. He is about to introduce the musical guest. The stage is behind him, audience members behind him have their backs to him. He is looking into the camera. Heโ€™s wearing a baseball cap of some kind and a dark shirt with the phrase PROTECT TRANS KIDS in white letters across his chest.

28.01.2025 23:02 โ€” ๐Ÿ‘ 5366    ๐Ÿ” 1196    ๐Ÿ’ฌ 18    ๐Ÿ“Œ 13

THIS IS ILLEGAL.

He literally does not have legal authority to do this. Do NOT obey in advance.

28.01.2025 23:08 โ€” ๐Ÿ‘ 1483    ๐Ÿ” 538    ๐Ÿ’ฌ 20    ๐Ÿ“Œ 8
Preview
Protecting Children from Chemical and Surgical Mutilation โ€“ The White House By the authority vested in me as President by the Constitution and the laws of the United States of America, it is hereby ordered: Section 1. ย Policy

is it uncharitable to say, i hope the new york times leadership gets not one moment of peace after this

28.01.2025 22:27 โ€” ๐Ÿ‘ 6543    ๐Ÿ” 1042    ๐Ÿ’ฌ 158    ๐Ÿ“Œ 265
screenshot of Mark Cuban's name and username on Bluesky with a "Jesse Singal Follower" label underneath

screenshot of Mark Cuban's name and username on Bluesky with a "Jesse Singal Follower" label underneath

incredible bat signal

25.01.2025 19:03 โ€” ๐Ÿ‘ 23    ๐Ÿ” 1    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

utterly insane

23.01.2025 04:13 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

children of the chatbot prompt

22.01.2025 22:45 โ€” ๐Ÿ‘ 2    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

this truly is the everything app that was promised

22.01.2025 14:14 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

@psanker.me is following 20 prominent accounts