361
Speeding up SQL queries by orders of magnitude using UNION
SQL's UNION operation isn't usually regarded as a way to optimize query performance, but in many cases it can be used to achieve massive improvements in speed.
Top posts
Every blog post that took off on Hacker News, ranked by the votes of its best submission. 2,323 posts.
362
How we built an auto-scalable Minecraft server for 1000+ players
Raising Minecraft world capacity by spreading players across multiple synchronized server processes
363
364
365
Sequencing your DNA with a USB dongle and open source code
It takes the most exquisite measurements you can imagine, recording the changes in current associated with different bits of DNA.
366
FIDO2 security key company releases hardware that's open source and uses Rust
Our Kickstarter campaign for our next generation of Solo products launches on January 26th. To get alerted when the campaign is live, you can sign up here. Update: The campaign is now live! Check it out to see all the details. Humble beginnings I've been working on Solo for almost 3 years now. It started back when I…
367
In praise of --dry-run
See how we improve software reliability with --dry-run modes. Learn best practices for tool development with insights from our expert, Patrick Stevens.
368
The SaaS CTO Security Checklist Redux
Learn how to protect your SaaS applications with the SaaS CTO security checklist. Doing the basics goes a long way in keeping your company and product secure.
369
Will Cloudflare R2 Win Customers from Amazon S3?
Cloudflare announced their exciting new object storage product, Cloudflare R2. Will they take market share?
370
Django 3.2
Posted by Carlton Gibson on April 6, 2021
371
Kafka without ZooKeeper
Major milestone release Apache Kafka 4.0 removes ZooKeeper entirely, provides early access to Queues for Kafka, and enables faster rebalances, in addition to many other new KIPs.
372
GCC: The customer has nuclear weapons. They do not do “bounty”
Anubis could not load its JavaScript. The server may be overloaded. Please reload the page to try again.
373
HTTP/2-exclusive threats caused by implementation flaws and RFC imperfections
In this research paper James Kettle introduces multiple new classes of HTTP/2-exclusive attacks, demonstrated on popular websites and servers.
374
1Password for Linux
The wait is over. [1Password for Linux is officially here](https://support.1password.com/getting-started-linux/).
375
Web Scraping 101 with Python
Learn web scraping using Python in this step-by-step tutorial. Use Requests, Beautiful Soup, Playwright, Scrapy, Selenium, and scraping APIs with practical 2026 examples.
376
Postgres scaling advice
Planning to scale PostgreSQL? Learn when a single node is enough, how to prepare for sharding, and which scaling steps to consider first.
377
WebAssembly and Back Again: Fine-Grained Sandboxing in Firefox 95
In Firefox 95, we're shipping a sandboxing technology called RLBox — developed with researchers at UC San Diego and the University of Texas
378
It’s mostly a demand shock, not a supply shock, and it’s everywhere
Monetary Policy 3 created a self-reinforcing demand explosion that is getting harder, not easier, for supply to keep up with.
379
Dark Patterns at Scale: Findings from a Crawl of 11K Shopping Websites (2019)
Dark patterns are user interface design choices that benefit an online service by coercing, steering, or deceiving users into making unintended and potentially harmful decisions. We conducted a large-scale study, analyzing ~53K product pages from ~11K shopping websites to characterize and quantify the prevalence of…
380
Firefox 87 introduces SmartBlock for Private Browsing
Today, with the launch of Firefox 87, we are excited to introduce SmartBlock, a new intelligent tracker blocking mechanism for Firefox Private Browsing and Strict Mode. SmartBlock ensures that strong ...
381
382
383
Bigger vehicles are directly resulting in more deaths of people walking
Smart growth is an approach to community design that connects housing, transportation, and land use to create healthy, prosperous, and resilient neighborhoods.
384
WebContainers: Run Node.js natively in the browser
Today we're excited to announce WebContainers, a new type of WebAssembly-based operating system that boots instantly and enables Node.js environments to run natively in-browser.
385
We bootstrapped to $11M in ARR
This year Thinkst Canary crossed the line to $11M in ARR. That number is reasonably significant in the startup world, where Lemkin refers to it as “initial scale”. For us; it’s a happy reminder of Canary's spread into the market. $11M ARR certainly isn’t our end goal, but it provides the fuel for us to…
386
API Tokens: A Tedious Survey
Documentation and guides from the team at Fly.io.
387
‘Dancing molecules’ successfully repair severe spinal cord injuries
Researchers have developed an injectable therapy based on nanofibers that has enabled paralyzed mice with severe spinal cord injuries to regain the ability to walk.
388
389
Nix is the ultimate DevOps toolkit
At Channable we use Nix to build and deploy our services and to manage our development environments. This was not always the case: in the past we used a combination of ecosystem-specific tools and custom scripts to glue them together. Consolidating everything with Nix has helped us standardize development and…
390
Tiny Container Challenge: Building a 6kB Containerized HTTP Server
TL;DR I set out to build the smallest container image that I could that was still able to do something useful. By taking advantage of multistage builds, the scratch base image, and a tiny assembly-based HTTP server, I was able to get it down to 6.32kB!