@mistersql@mastodon.social
@mistersql@mastodon.social avatar

mistersql

@mistersql@mastodon.social

Software developer, tech lead in Washington, DC.

I tweet about

  • software, programming, #python, dad jokes, DC, Fed government tech contracting and jobs, #govtech

I also tweet mixed content with keywords you can mute if you want to.

I don't speak for my employer.

This profile is from a federated server and may be incomplete. Browse more on the original instance.

anze3db, to random
@anze3db@fosstodon.org avatar

Any idea why PostgreSQL is this much slower compared to SQLite and MySQL?

This is on Ubuntu 24.04, connecting through Django and I've tried both psycopg and psycopg2, but the result is the same: ~200 requests per second with Postgres compared to ~2000 with SQLite or MySQL.

mistersql,
@mistersql@mastodon.social avatar

@anze3db Connection pooling not happening?

mistersql, to random
@mistersql@mastodon.social avatar

With R's flying flags upside down, finally Dems can reclaim the flag for their own. Sort of a capture the flag in the game of memetic warfare.

mistersql, to random
@mistersql@mastodon.social avatar

It's like 12 voices cried out "Guilty"

josh, (edited ) to random
@josh@josh.tel avatar

Hey folks! I'm looking for examples of elected officials and people running for office who have accounts on the fediverse.

Know of one? Please let me know! Boosts appreciated :boost_requested:

mistersql,
@mistersql@mastodon.social avatar

@josh Don't forget @RepDonBeyer He's been on Mastodon awhile, which makes him an early adopter among Congressmen

mistersql, to random
@mistersql@mastodon.social avatar

Did an office building write this?

"Why in-person friendships are better for health than virtual pals"

My take: if you use communication tech poorly, you get few of the benefits of socializing.

Tech work has gone remote & will be probably forever. We should do it right and not pine for the days of an office which was an isolating wasteland of isolation and alienation.

https://wapo.st/3ViUifJ

ZachWeinersmith, to random
@ZachWeinersmith@mastodon.social avatar

So, one lens on the weird direction of the modern Internet is that entities created to route you to cool stuff, e.g. search, social media, have especially in the last 5-10 years been taking an ever larger part of the pie via having giant networks. Google can now control whether a news site lives or dies. Meta can take 99.5% of all ad revenue displayed next to an artist's work and they have no power.

Long-term effect? Damage to the creative class.

mistersql,
@mistersql@mastodon.social avatar

@ZachWeinersmith Everything is a trolly problem. City leaders ripping up all the trolleys and public transit were on to something?

JackEvans, to python
@JackEvans@fosstodon.org avatar

Python folks I'm looking for a tool.

I want something like modulefinder that I can point at a target that outputs a subset of deps/requirements (so I can tree shake requirements in a monorepo).

Does such a tool exist? (before I attempt to write one)

mistersql,
@mistersql@mastodon.social avatar

@ucodery @JackEvans @orsinium Seems to be a boom in these sort of libraries recently. deptry does this too

https://github.com/fpgmaas/deptry

brianokken, to random
@brianokken@fosstodon.org avatar

We spread garden compost last year, and now these little guys are growing all over the garden. So cute. Anyone know what variety they are?

mistersql,
@mistersql@mastodon.social avatar

@dabeaz @brianokken Gpt4o said can't say for sure, probably Amanita and it is important to not eat it, too risky without more expertise.

Gemini (not Advanced) said not sure, probably Amanita and please don't eat it.

Claude Sonnet said Agaricus or Amanita. I didn't press, but it didn't volunteer if it thought you should eat it or not.

treyhunner, to vegan
@treyhunner@mastodon.social avatar

I decided to be for the week of 2024. I put little effort into this endeavor but I did think about it during each meal.

I'd like to share how it went, but first I'll note why I did this.

Since early 2020, I've been attempting to gradually reducing the animal suffering I cause (as much as I'm individually able to).

I focused one-by-one on small habit changes that had large impacts (e.g. I completely cut out chicken first). After ~2 years of this, I was .

mistersql,
@mistersql@mastodon.social avatar

@treyhunner I recognize all your stories. On the way to Pycon I packed a bag of emergency foods-mostly used on the drive back home. I too have had to draw up some sort of rule for how much rule bending I can tolerate, my goal is to eat <1lb of animal products/year. Getting used to the volume of food needed is easy enough, but often people serving veg*n food misinterpret the project as fasting & serve minimal calories. Simply not eating enough is a common reason cited for giving up on plant based

meejah, to ai
@meejah@mastodon.social avatar

Anyone have any success (or failure!) at using "post-prompts" in resumes?

mistersql,
@mistersql@mastodon.social avatar

@meejah It wouldn't get past HR, there still is a human in the loop. I can imagine the popular jailbreak scripts (very authoritarian role play trying to get the bot to be obedient) making a great impression on the hiring person.

mistersql,
@mistersql@mastodon.social avatar

@meejah I've read real resumes where the whole thing is a colossal obvious fabrication & I'm expected to interview them anyhow and check if the liar is a competent developer. Keyword hacking is more than enough to get thru a dodgy hiring process during a hot market. PDFs probably could hide all sort of messages to the bot.

I did a quick google, I guestimate there is a 5% chance that 0.01% of resumes are getting classified by LLMs.

anze3db, to random
@anze3db@fosstodon.org avatar

Quick takeaway from the public speaking workshop: you don’t need an about me slide.

BRB while I update my presentations 😂

#PyconIT2024

mistersql,
@mistersql@mastodon.social avatar

@anze3db @hamatti @carlton @mathsppblog I own a cat. I am adding value to this dialog.

mistersql, to random
@mistersql@mastodon.social avatar

Yes.

"Dear presenters. Here are my accessibility requests for next year. 1. No colorized code on black backgrounds. Blue or purple or gray is really hard to read. 2. Use large text please. I cannot read your regular terminal font. PLEASE."
https://twitter.com/gvanrossum/status/1792293514929176817

mistersql, to random
@mistersql@mastodon.social avatar

Regarding MS Recall, I've been running #timesnapper on my machines for ages and #rescuetime - I think MS needs to ask people if they want to turn it on, people are either going to really like it or want to leave no trail (and boy do we leave trails, in browser and file system w/o Recall). Other than that, this doesn't seem to warrant the drama people are tweeting.

https://timesnapper.com/

ZachWeinersmith, to comics
@ZachWeinersmith@mastodon.social avatar

The rant nobody asked for.

Full comic here: http://smbc-comics.com/comic/myth-2

mistersql,
@mistersql@mastodon.social avatar

@ZachWeinersmith 🦇🐮

treyhunner, (edited ) to python
@treyhunner@mastodon.social avatar

I'm jealous of the little Python logo badge many of y'all have next to your names and many community folks I appreciate (@fedidevs, @ThePSF, and many others) are on fosstodon.

I've been posting on mastodon.social for a while and I have no meaningful complaints though (ever since the servers were upgraded!).

Should I switch to fosstodon.org? (Multiple select voting is allowed)

mistersql,
@mistersql@mastodon.social avatar

@treyhunner @fedidevs I got exactly two account on two server where the "Local" feed is more useful than any other feed: the Esperanto Server and the Washington DC server. For Esperanto, not everyone tags their posts with Esperanto, but almost everyone sets up an Eo account on the Eo server. The DC server is all DC people, but not all people who live in DC or post about it joined the server. There is a difference in moderation & tag availability on different servers.

mistersql, to random
@mistersql@mastodon.social avatar

Maybe tech debt could use a car repair metaphor. Instead of "our car is a rusty jalopy that we dearly love if maybe someday we should wash it for show (i.e. improvement is arrogance & cosmetics)", tech debt is "we drilled multiple holes into the oil pan because we didn't know what we were doing. We can still drive the car for a while."

I don't know, taking tech debt serious means owning up to a mistake, or having made a trade off that looks the same as a mistake.

ZachWeinersmith, to comics
@ZachWeinersmith@mastodon.social avatar

I solved ethics. Full comic here: http://smbc-comics.com/comic/consequent

mistersql,
@mistersql@mastodon.social avatar

@ZachWeinersmith This is the trolley problem with hamsters. But hamsters aren't even capable of ethical behavior because they can't pull the lever, it's like, 500x taller than them.

khalidabuhakmeh, to random
@khalidabuhakmeh@mastodon.social avatar

Windows out here diagnosing the state of my mental health… 😭

mistersql,
@mistersql@mastodon.social avatar

@khalidabuhakmeh You are being hypnotized, now now feel 100%, you may now resume computing.

treyhunner, to random
@treyhunner@mastodon.social avatar

@mistersql, I don't think we ran into each other at PyCon. At the sprints today if you're around. Otherwise, maybe next year?

mistersql,
@mistersql@mastodon.social avatar

@treyhunner I'll be there next year, see you online in the meanwhile!

mistersql, to random
@mistersql@mastodon.social avatar

I went to a openspace on DevEx (DX), esp in the context of work some idea the attendees mentioned

  • a lot of social/organization issues-bosses' fault?
  • varies by context-startups have different incentives than big stable companies & cause their devs different pain
  • leads to shadow IT, burn out & stress
  • monorepo = pain! me: polyrepo= pain!

My idea was shadow IT should be formalized. Help techies help themselves when the org knows it lacks the leadership & skills to create a good DX.

mistersql,
@mistersql@mastodon.social avatar

One theme was "Things aren't going to improve until a developer who has lived through the pain is promoted and does something about it"

mistersql, to random
@mistersql@mastodon.social avatar

Almost vegan friendly city...I think the majority of vegan restaurants were nowhere near downtown Pittsburgh.

Economic crisis in Venezuela is bringing Arepas to all the downtown, I need to find the ones near DC.

image/jpeg
image/jpeg
image/jpeg

mistersql, to random
@mistersql@mastodon.social avatar

Time to learn to use rust with python.

from this guy

https://www.youtube.com/@davidhewittdev

mistersql,
@mistersql@mastodon.social avatar

import b will import b.pyd using the ABI the same as if it were b.py
Cython *et al *do the same thing.

In 2 years, 1/2 of new packages using native code will be using Rust instead of C/C++

mistersql,
@mistersql@mastodon.social avatar

Rust to python cheat sheet, they are similar

def - fn
str - &str
int - usize
let mut - (initialization)
return - (last line in function is return)

  • All
  • Subscribed
  • Moderated
  • Favorites
  • •
  • megavids
  • thenastyranch
  • rosin
  • GTA5RPClips
  • osvaldo12
  • love
  • Youngstown
  • slotface
  • khanakhh
  • everett
  • kavyap
  • mdbf
  • DreamBathrooms
  • ngwrru68w68
  • provamag3
  • magazineikmin
  • InstantRegret
  • normalnudes
  • tacticalgear
  • cubers
  • ethstaker
  • modclub
  • cisconetworking
  • Durango
  • anitta
  • Leos
  • tester
  • JUstTest
  • All magazines
    •