571
PostgreSQL EXPLAIN Output Explained
UPDATED July 2023: How to use EXPLAIN ANALYZE in PostgreSQL, learn tools to visualize the output. See query execution time and row count.
Topics /
Software Engineering
The most popular blog posts about software engineering on Hacker News. 1,517 posts.
572
How often do people copy and paste from Stack Overflow?
April Fool's may be over, but once we set up a system to react every time someone typed Command+C, we realized there was also an opportunity to learn about how people use our site. Here’s what we found.
573
Why does it take so long to build software? (2020)
Why does it take so long to build software? We hear variations of this question frequently: Why is building software so expensive? Why is my team delivering software so slowly? Why am I perpetually behind schedule with my software? There is a good reason we hear these questions over and over. Businesses need more and…
574
Make your monorepo feel small with Git’s sparse index
The new sparse index feature makes it feel like you are working in a small repository when working in a focused portion of a monorepo.
575
How to learn compilers: LLVM Edition
A collection of resources to start learning compilers (with a focus on LLVM)
576
577
How Tail Call Optimization Works
Most undergraduate computer sciences courses teach students about tail call optimization (TCO) , and even if you don't have a formal computer science background the concept is talked about enough that you might be familiar with it anyway, especially if you've ever done any functional programming. However, I think the…
578
How a hypermedia approach can address usability concerns with multi-page apps
In this essay, Carson Gross gives an analysis of Rich Harris's talk 'Have Single-Page Apps Ruined the Web?', exploring the debate between Single-Page Applications (SPAs) and Multi-Page Applications (MPAs). Carson examines Harris's criticisms of both approaches and proposes hypermedia-oriented solutions using htmx…
579
My thoughts about the Principal role
Am I a manager? No. In some cases, people may report to me from an organisational point of view but my way to manage is "don't manage at all" and let the team self organize with my help. I tend to focus more on the team and processes and less on people. I'm not a manager, I try to be a technical leader. Organizations…
580
Get Started with Tmux
Before getting started with tmux, let us go over some questions to see if tmux is right for you:
581
Remote Code Execution Found in CocoaPods
tl;dr CocoaPods is a popular package manager used by lots of iOS apps (among other Swift and Objective-C Cocoa applications). I found a remote code execution...
582
Citus 10 brings columnar compression to Postgres
Deep dive into Citus columnar storage for Postgres. Includes a quickstart, as well as performance measurements for data loading, compression ratios, and query response times. Also covers how columnar relates to Citus, integration with Postgres range partitioning, limitations, & ways to get started.
583
How the GNU coreutils are tested
Tools and techniques used to test coreutils
584
Ruby 3.1.0 Preview 1
Since Ruby 2.6 introduced MJIT in 2018 , its performance greatly improved, and finally we achieved Ruby3x3 last year . But even though Optcarrot has shown impressive speedups, the JIT hasn’t benefited real world business applications.
585
Intercal, YAML, and Other Horrible Programming Languages
Discover the bizarre world of INTERCAL, a parody programming language that will leave you scratching your head. Then, delve into the blurred line b...
586
Don’t Let Architecture Astronauts Scare You (2001)
When great thinkers think about problems, they start to see patterns. They look at the problem of people sending each other word-processor files, and then they look at the problem of people sending…
587
A New AWS SDK for Rust
We’re excited to announce the alpha release of a new AWS SDK for Rust. AWS customers developing in Rust want a native Rust SDK so they can use the language constructs they are used to, and customers new to Rust want an SDK that behaves similarly to SDKs they have used in other language environments. […]
588
Writing Pythonic Rust
Over the past several weeks I have been attempting to reimplementthe API of an existing python library as a wrapper for an equivalent library inRust.
589
A rabbit hole full of Lisp
Profiling Emacs and writing some Lisp to work with a 70000-file monorepo.
590
GitHub Actions limitations and gotchas
I’ve been leading a team at my dayjob to migrate every engineering team to GitHub Actions (GHA)
591
592
Flow-Based Programming
Official website for flow-based programming
593
Why Wasn't Ruby 3 Faster?
Ruby 3.0 is a lot faster than Ruby 2.0, with both incremental tuning and interesting new disruptive changes. 'Three times faster' is hard to define. JIT! Ractors! Autofibers!
594
Go 1.18 Beta 1 is available, with generics
Go 1.18 Beta 1 is our first preview of Go 1.18. Please try it and let us know if you find problems.
595
PyCon US 2021 Recordings are Available
The PyCon US 2021 recordings are available on our YouTube channel . Be sure to subscribe to our channel for notifications of new content. T...
596
Wgpu-0.10 released: WebGPU implementation now in pure Rust
gfx-rs is a project bringing efficient cross-platform graphics to rust. This blog supposedly hosts the major milestones, concepts, and recaps of the project.
597
Understanding Connections and Pools
What connections are, how they affect our systems, and how and why pooling works.
598
599
The stack monoid revisited
This is a followup to my previous post on the stack monoid, but is intended to be self-contained.
600
