Anthony McClosky

Anthony McClosky

@amcclosky.com

Software Development (Python, SQL/PostgreSQL, Typescript, etc). Probably some baseball. https://amcclosky.com Austin, TX

1.4K followers595 following127 posts

Anthony McClosky reposted

Jason Fried
@jasonfried.bsky.social

But that only works for small companies. But that only works if you have small teams. But that only works if you don't have investors. But that only works if you don't have to chase growth. But that only works if you don't have a board. Exactly.

Anthony McClosky reposted

Brad
@bradsbrown.dev

My life is simple — I see a Sneakers mention, I tag @amcclosky.com

robert j bennett, ceo, results omega@robertjbennett.bsky.social

in the movie Sneakers (1992) it’s always seemed an unbelievable misstep for Mary McDonnell’s character to offhandedly mention her date with Stephen Tobolowsky was set up by a computer, thus tipping off Ben Kingsley that it’s a setup. but people are never willing to discuss this at parties

Anthony McClosky
@amcclosky.com

Spectree doesn't get enough attention. Great request / response validation lib powered by @pydantic.dev that works with Flask/Quart/Starlette etc. I've used it for a few years now, and it just got a very welcome update for full pydantic 2 support. github.com/0b01001001/s...

github.comGitHub - 0b01001001/spectree: API spec validator and OpenAPI document generator for Python web frameworks.API spec validator and OpenAPI document generator for Python web frameworks. - 0b01001001/spectree
View full thread
Anthony McClosky
@amcclosky.com

Python asyncio has its place but I believe most projects would be better served by just doing standard sync python and then adding gevent if you want better throughput for an I/O heavy workload.

Anthony McClosky
@amcclosky.com

Spectree doesn't get enough attention. Great request / response validation lib powered by @pydantic.dev that works with Flask/Quart/Starlette etc. I've used it for a few years now, and it just got a very welcome update for full pydantic 2 support. github.com/0b01001001/s...

github.comGitHub - 0b01001001/spectree: API spec validator and OpenAPI document generator for Python web frameworks.API spec validator and OpenAPI document generator for Python web frameworks. - 0b01001001/spectree
Anthony McClosky
@amcclosky.com

Basically if you have an existing Flask project but you've been envious of the FastAPI validation and documentation features. This plugs in to your existing project without much fuss.

Anthony McClosky
@amcclosky.com

I have seen some posts about DSQL implying that not supporting foreign keys is ridiculous. These days I work on apps where constraints and data consistency are very important but in another life I built a crawler of all e-commerce websites and loved this script. gist.github.com/amcclosky/99...

gist.github.comRemove all foreign key constraints from a MySQL database with Django 1.3Remove all foreign key constraints from a MySQL database with Django 1.3 - remove_foreign_keys.py
View full thread
Anthony McClosky
@amcclosky.com

I have seen some posts about DSQL implying that not supporting foreign keys is ridiculous. These days I work on apps where constraints and data consistency are very important but in another life I built a crawler of all e-commerce websites and loved this script. gist.github.com/amcclosky/99...

gist.github.comRemove all foreign key constraints from a MySQL database with Django 1.3Remove all foreign key constraints from a MySQL database with Django 1.3 - remove_foreign_keys.py
Anthony McClosky
@amcclosky.com

There is a noticeable inflection point in your career as a programmer when you stop picking tools based on what you think is objectively best and start picking tools based on what you can easily and clearly explain to your coworkers.

View full thread
Anthony McClosky
@amcclosky.com

No extension ecosystem support. No support for PostGIS for geospatial queries is a big one for me. Also, the pricing details will have a big impact on how I perceive this product but I'm guessing it'll be reasonable.

Anthony McClosky
@amcclosky.com

All that said, I am definitely going to carve out time to build something on top of this. A product with a billing and scaling model more like dynamodb but allows relational modeling with SQL is going to be incredibly useful for a lot of scenarios.

Anthony McClosky
@amcclosky.com

This thing has a lot of constraints you will need to take in to account while building an app for it. Not bad constraints just not the usual PostgreSQL ones. No Sequences is a big one. Some constraints around update size that also includes having to take in to account index updates.

Anthony McClosky
@amcclosky.com

This is one reason I like making a demo video a requirement for a “complete” pull request. If you are working on a “full stack” sort of project it is a great hack to up average quality.

Brian Casel@briancasel.com

Really good hack to battle test the things you build: Publish a video to show it off. Bugs. UX. Slowness. Bloat. It all gets exposed when the camera's rolling. Once you can record in 1 take, you're ready to ship.

Anthony McClosky
@amcclosky.com

How do people handle manual enqueuing of failed celery tasks in Django? Both in bulk and individually? Is that a thing people do? Is there a UI that supports that workflow? Does flower support that and I just don't know about it?

Anthony McClosky
@amcclosky.com

The workflow I like when using RQ + RQ Dashboard is that I can be aggressive about deploying new or changing background tasks because when they fail I can easily enqueue the failed tasks from the dashboard when I've resolved the problem.

Anthony McClosky
@amcclosky.com

Reading @tkdodo.eu blog posts whenever I see them has improved my mental model of react about 1000% over the last couple years.

Dominik 🔮@tkdodo.eu

📚 Had to post this a lot on the other platform lately and apparently, it blows people's mind that this is possible. I wrote it over 2 years ago, and callback refs will only get better in v19 because they will get cleanup functions. Have a read: tkdodo.eu/blog/avoidin...

tkdodo.euAvoiding useEffect with callback refsInteracting with DOM nodes doesn't necessarily need useEffect
Anthony McClosky
@amcclosky.com

Good news that one of the pillars of our society is still functioning.

Caitlin Hudon@beeonaposy.bsky.social

You guys, I have great news: the Pizza Hut reading program still exists(!!) and in a few months I’ll get to witness the joy of my daughter eating her hard-earned personal pan pizza at an actual Pizza Hut restaurant

Anthony McClosky
@amcclosky.com

Postgres.

Zach Leatherman@zachleat.com

Software developers say “Use the right tool for the job—but wouldn’t it be better if this one tool solved every problem and use case for everyone for the remainder of time as we perceive and understand it”