21811
OFFSET is bad for skipping previous rows
OFFSET doesn’t deliver stable results and makes the query slow. Key-set pagination does neither.
Top posts
Every blog post that took off on Hacker News, ranked by the votes of its best submission. 21,844 posts.
21812
Why Can’t Programmers... Program?
I was incredulous when I read this observation from Reginald Braithwaite: Like me, the author is having trouble with the fact that 199 out of 200 applicants for every programming job can’t write code at all. I repeat: they can’t write any code whatsoever. The author he’s
21813
The Meaning of ‘Hack’
“ The word hack doesn't really have 69 different meanings”, according to MIT hacker Phil Agre. “ In fact, hack has only one meaning, an extremely subtle and profound one which defies articulation. Which connotation is implied by a given use of the word depends in similarly profound ways on the context. Similar remarks…
21814
PEP 3146 – Merging Unladen Swallow into CPython
This PEP proposes the merger of the Unladen Swallow project 3 into CPython’s source tree. Unladen Swallow is an open-source branch of CPython focused on performance. Unladen Swallow is source-compatible with valid Python 2.6.4 applications and C extensi...
21815
NPM & left-pad: Have We Forgotten How To Program?
Intro Okay developers, time to have a serious talk. As you are probably already aware, this week React, Babel, and a bunch of other high-profile packages on NPM broke. The reason they broke is rather astounding: A simple NPM package called left-pad that was a dependency of their code. left-pad, at the time of writing…
21816
Data Race Detector
Data races are among the most common and hardest to debug types of bugs in concurrent systems. A data race occurs when two goroutines access the same variable concurrently and at least one of the accesses is a write. See the The Go Memory Model for details.
21817
TCCBOOT: TinyCC Boot Loader
TCCBOOT is only 138 KB big (uncompressed code) and it can compile and run a typical Linux kernel in less than 15 seconds on a 2.4 GHz Pentium 4.
21818
bliki: Anemic Domain Model
If you use an object-oriented domain model, and you don't put behavior in your objects, you're missing out on most of the benefits of that pattern.
21819
PEP 263 – Defining Python Source Code Encodings
This PEP proposes to introduce a syntax to declare the encoding of a Python source file. The encoding information is then used by the Python parser to interpret the file using the given encoding. Most notably this enhances the interpretation of Unicode ...
21820
Object-Relational Mapping is the Vietnam of Computer Science
I had an opportunity to meet Ted Neward at TechEd this year. Ted, among other things, famously coined the phrase “Object-Relational mapping is the Vietnam of our industy” in late 2004. It’s a scary analogy, but an apt one. I’ve seen developers struggle for years with the
21821
Tabs versus Spaces
The last time the tabs-versus-spaces argument flared up in my presence, I wrote this. Gasoline for the fire? Maybe.
21822
PEP 3107 – Function Annotations
This PEP introduces a syntax for adding arbitrary metadata annotations to Python functions 1.
21823
PEP 635 – Structural Pattern Matching: Motivation and Rationale
This PEP provides the motivation and rationale for PEP 634 (“Structural Pattern Matching: Specification”). First-time readers are encouraged to start with PEP 636, which provides a gentler introduction to the concepts, syntax and semantics of patterns.
21824
A case against syntax highlighting
Do you rely on syntax highlighting when developing software? If so, you may be shooting yourself in the foot. In this post, I will argue that syntax highlighting, while aesthetically seductive, moves focus from content to form, and discourages those who look at the code from trying to understand it.
21825
cgo is not Go
Some people, when confronted with a problem, think “I know, I’ll use cgo.” Now they have two problems.
21826
Computed goto for efficient dispatch tables
Recently, while idly browsing through the source code of Python, I came upon an interesting comment in the bytecode VM implementation ( Python/ceval.c ) about using the computed gotos extension of GCC [1] . Driven by curiosity, I decided to code a simple example to evaluate the difference between using a computed goto…
21827
Groupware Bad
This piece has gotten a lot of attention over the years. I have heard a lot of people saying that they had been "inspired" by it. I fear that what they meant was that they were inspired by the one pull-quote that people tend to quote from it, and ignored the rest. So if someone has linked you to this page, or if…
21828
Component · Decoupling Patterns
Allow a single entity to span multiple domains without coupling the domains to each other.
21829
The Practical Test Pyramid
Find out what kinds of automated tests you should implement for your application and learn by examples what these tests could look like.
21830
Code of Conduct ⚡ Zig Programming Language
The Zig community is decentralized. Anyone is free to start and maintain their own community , which is not subject to these rules.
21831
Schelling's Model of Segregation
Racial segregation has always been a pernicious social problem in the United States. Many factors have contributed to segregation including prejudice, zoning laws, housing discrimination, and loan discrimination. Although much effort has been extended to desegregate our schools, churches, and neighborhoods, the US…
21832
DWIM
1. adj. Able to guess, sometimes even correctly, the result intended when bogus input was provided.
21833
wheel of reincarnation
[coined in a paper by T.H. Myer and I.E. Sutherland On the Design of Display Processors , Comm. ACM, Vol. 11, no. 6, June 1968)] Term used to refer to a well-known effect whereby function in a computing system family is migrated out to special-purpose peripheral hardware for speed, then the peripheral evolves toward…
21834
Commandos, Infantry, and Police
As I was driving home, I found myself thinking about a favorite section of the book Accidental Empires, by longtime computer journalist Robert X. Cringely. Originally published in 1993, it’s getting a little long in the tooth, but it still contains a lot of great insights about the personalities
21835
Welcome to Gitea
Gitea is a community fork of the popular self hosted Git service Gogs. We're a growing group of former Gogs users and contributors who found the single maintainer management model of Gogs frustrating and thus decided to make an effort to build a more open and faster development m
21836
HyperSwitch
Yet another window switcher for your Mac.
21837
How to Report Bugs Effectively
[ English | Português | 简体中文 | Česky | Dansk | Deutsch | Español | Français | Magyar | Italiano | 日本語 | Nederlands | Polski | Русский | 繁體中文 ]
21838
Semantic Compression
An introduction to the idea that code should be approached with a mindset towards compressing it semantically, rather than orienting it around objects.
21839
The “Why your anti-spam idea won’t work” checklist
This comes up regularly on Slashdot and I find it hilarious each time, but can never find it when I go looking for it. So, here it is:
21840
E.W. Dijkstra Archive: On the cruelty of really teaching computing science (EWD 1036)
The second part of this talk pursues some of the scientific and educational consequences of the assumption that computers represent a radical novelty. In order to give this assumption clear contents, we have to be much more precise as to what we mean in this context by the adjective "radical". We shall do so in the…