5071
Avoiding “OR” for Better Query Performance
OR in the WHERE condition of a PostgreSQL database query is usually a cause of bad query performance. How to rewrite queries without OR.
Topics /
Software Engineering
The most popular blog posts about software engineering on Hacker News. 7,298 posts.
5072
5073
Qodo CLI agent scores 71.2% on SWE-bench Verified
Read about Qodo scores 71.2% on SWE-bench Verified in our blog.
5074
An Intro to Integer Programming for Engineers: Simplified Bus Scheduling
Explore what’s new, what’s next, and what should be on your radar in the world of transportation. Our insights are supported by real-world data from our partners across the globe.
5075
Data Structures in the Fleet Editor
This is a multipart series on building Fleet, a next generation IDE by JetBrains. Part I - Architecture Overview Part II - Breaking down the editor Part III – State Management Part IV – D
5076
Go 2017 Survey Results
What we learned from the December 2017 Go User Survey.
5077
Using JSON Schema to Document, Test, and Debug APIs
Heroku has many public API endpoints. See how Heroku uses JSON Schema to test and document our Platform API–and how it helped us uncover an unexpected bug.
5078
The way CTRL-C in Postgres CLI cancels queries is incredibly hack-y
There are a few different reasons to hit the brakes on a Postgres query. Maybe it’s taking too long to finish. Maybe you realised you forgot to create an index that will make it orders of magnitude quicker. Maybe there’s some reason the results are no longer needed. Or maybe you, or your LLM buddy, […]
5079
5080
5081
Local-First and Ejectable
An important requirement to ensure you can fully access your data in cloud apps forever is making the backend sync server available for local self-hosting. That's what EJECTABLE apps are about.
5082
Parallelism in Crystal
Crystal has made a huge step forward to have parallelism as a first class citizen. In short, you can set up the number of worker threads on runtime and each new fiber will be scheduled to run on one of them. Channel and select will work seamlessly. You are allowed to share memory between workers, but you will probably…
5083
How to Crawl the Web Politely with Scrapy
How to crawl the web with Scrapy without harming websites. Here are a few tips for netizens who want to build polite and considerate web crawlers.
5084
Supercharging GitHub Actions with Job Summaries
You can now output and group custom Markdown content on the Actions run summary page.
5085
5086
Getting to Docker 1.0
Docker is a founding member of the Blueprint Alliance, a 12-company reference architecture for securing AI agents, built around four governance questions.
5087
Plotnine: Grammar of Graphics for Python (2019)
Blog article by Jeroen Janssens. Jul 7, 2024. 93 min read. Hey there, you’re reading an updated version of a post I published way back in 2019. Because of the 2024 Plotnine contest and the recent release of Polars 1.0, I decided to freshen things up. Changes include: Upgrade to Plotnine version 0.13.6 (from…
5088
Stateful Apps on Kubernetes: A quick primer
Managing state in Kubernetes is difficult because the system’s dynamism is too chaotic for most databases to handle; especially SQL databases that offer strong consistency.
5089
The Earliest Unix Code: An Anniversary Source Code Release
In celebration of Unix’s 50th anniversary, the CHM Software History Center is delighted to make publicly accessible for the first time some of the earliest source code produced in the Unix story.
5090
5091
Multiranges in Postgres
Multiranges are a new feature in PostgreSQL 14. Here's a brief introduction on how to use them - learn the basics & important new uses.
5092
5093
A big step towards Firefox generational and compacting GC
People frequently ask me for status updates on generational GC, and I usually say I’ll tell them when something notable happens. Well, something notable just happened: exact rooting landed .
5094
Effective Go
Go is an open-source programming language that focuses on simplicity, reliability, and efficiency, specifically designed to make it easy to build software at scale. Although it borrows ideas from existing languages, it has unusual properties that make effective Go programs different in character from programs written…
5095
High-Performance GPU Computing in the Julia Programming Language
Julia is a high-level programming language for mathematical computing that is as easy to use as Python, but as fast as C. The language has been created with performance in mind…
5096
5097
5098
5099
The Glasgow Haskell Compiler and LLVM
If you read the LLVM 2.7 release notes carefully you would have noticed that one of the new external users is the Glasgow Haskell Compiler (GHC). As the author of the LLVM backend for GHC, I have been invited to write a post detailing the design of the backend and my experiences with using LLVM.
5100
Nerves v1.0 Released
We are thrilled to announce Nerves v1.0 is finally out. This has been 4219 commits by 102 contributors since the initial commit on October 29th, 2013! This would not have been possible without our corporate sponsors and individual backers.