Search results

Masterclass: Grokking `EXPLAIN` in PostgreSQL In the corresponding Slack of this group, someone suggested a masterclass on EXPLAIN in response to my prior post. This is my attempt at that. Understanding the output of `EXPLAIN` is like reading a treasure map. Each part of the map gives you...

Helpful Postgres Techniques from 15 Years Experience In no way do I claim mastery or expertise, but I've put together a few things that could be helpful for anyone learning Postgresql - my personal preference of db for most things. Feel free to add to the list, question, or correct anything...

The Valley of Code is an excellent source of information about how the internet functions as a whole.

What are some of the weirder or unique use cases you all are using Proxmox for? Is anyone running 100 instances of Android for adclick farms or anything wild? Game server farms? Render farm? Retro computing labs? Cybersecurity playgrounds? Smarthome hubs? I'm looking for ideas and...

I've done rolling upgrades (node-by-node) replacement before and while nothing is wrong with that, I think since you mention these VMs being manually managed, that your setup-new-and-replicate would be smoother (imho). Possibly helpful (If not for you, then maybe others reading) stuff from my...

I'm not a C# dev but can vouch that it will lead to more opportunities than any other in this region. That feeling you describe was true of Ruby on Rails around 2015, leading it to be the hotness for several years. I wouldn't say the current RoR feels as smooth (been a ruby dev for 12+ years)...

I use yt-dlp infrequently enough that I have to look up all of the options and features every single time I use it. So I'm putting a few of the most useful options here to be easily accessible to others. While it has YouTube in the name, here is the list of currently supported sites. And now...

Design Patterns: Elements of Reusable Object-Oriented Software" by Erich Gamma, Richard Helm, Ralph Johnson, and John Vlissides (Gang of Four) This textbook will be mentioned at a non-trivial amount of interviews, and design patterns are important to learn about, but it is so wordy and...

It is a rite of passage to take prod offline or wipe a db. Tell us your best worst stories.

What are some must-read books for anyone wishing to improve their skills and career?

This x1000! Be active, ask questions, ask 'why did you do it that way?', look for feedback, ask 'how could I have done this better?'. Not only will you be more visible, but you will be more visible by the right people that can connect you with opportunities and jobs.

If you do, here you go: https://brand.devanooga.com/ May save a little time.

Found some really cool projects that may not be well known amongst the group. First off, an open-source Zapier or Make tool called n8n. It has tons of integrations. Next up, Appwrite. If you have been a developer long enough to miss how amazing Parse was, this will at least attempt to scratch...

If there is a way to make this an editable wiki by the community, please do so. Otherwise I will update it and add new replies as they come in. HVAC ActionAir Travis H. Smith (423.718.4091) Bell Heating and Air Water Damage/Mold Mitigation Voda Cleaning and Restoration of Chattanooga (Owned by...

Welcome to the Self-Hosted Megathread! We can use this place for sharing recommendations, experiences, and tips about any self-hosted apps or setups. A few places to bookmark: 1. r/selfhosted - A highly active community sharing and discussing self-hosted solutions 2. Awesome Selfhosted- A...

#selfhosted? or Maybe it would be an ongoing thread in homelab? idk.

I noticed @brb3 has a nice one in his signature. Does anyone know of a good repo or collection of badges?

I started app dev in 2009 learning php. Somewhere around 2013 I moved away from it whiles focusing mostly on mobile app dev, and really only very recently poked my head back into the PHP ecosystem. Imagine my surprise to learn of all the neat improvements and features of the latest and greatest...

What are the immediate benefits of HTTP/3 and do app devs need to worry about it at the application layer? I was reading up on HTTP/3 and more specifically QUIC a moment ago, and while it seems like it is mostly applicable to the crew operating at the transport layer, what things does the...