HNHacker News
TopNewBestAskShowJobs

392

118 karma · joined August 25, 2023

submissionscomments
392··on ShotSpotter: listening in on the neighborhood
Buy a whole load of the same model voice recorder, label them with tape for location, spread them out and record till batteries die, pull data to PC, repeat until get a sample? Someone above mentioned microsecond accurate clocks on raspberry pi being used for TDOA.
392··on ShotSpotter: listening in on the neighborhood
All of these are much more complicated and expensive than just sending someone off in a stolen car to fire some shots wherever you'd like the cops to be in 20 minutes or so. Convenient leash.
392··on The One Billion Row Challenge in Go: from 1m45s to 4s in nine solutions
True in general but some (especially libs aimed at larger datasets processed in batch) are taking advantage of benchmarks like this to do things like: Try the fast way, if it works great Try the slow way, if above fails This makes the slow path 2x slower at worst (and you can advise to always use the slow way with optional params) but the fast path can be 10x faster
392··on Moving a billion Postgres rows on a $100 budget
Hard to set up in Kubernetes. Seems to want you to know too many specifics for how to shard your db ahead of time. Don't remember how it handles schema evolution. I settled for Databend because it just worked easy and fast with nothing more than table definitions.
392··on The future of Mozilla Hubs
I use Firefox because they don't threaten to shut down power user extensions every few years. I find it faster and more reliable because it doesn't chew all of my RAM and lead to swap / early-oom-kill.

I'm quite confused by folks' opinion of Firefox in this thread because my only problem with it is that maybe once per year (or less) I find an online checkout that is subtly broken in it (sometimes it's just my adblocker). But I have occasionally found sites that are inverse, only working in Firefox.

392··on Show HN: Kubetail – Web-based real-time log viewer for Kubernetes
I have tried unsuccessfully to get those setup on my k8s twice. The default configs don't seem sufficient for even a small shop's scale, I think I must be holding them wrong. But I'm ready to try this because it's all I need if it works.
392··on Show HN: Kubetail – Web-based real-time log viewer for Kubernetes
I'll give installing it a shot after that is fixed!
392··on BMW I3 Owner Confronted with $71,000 Bill to Replace EV Battery
Yes, and it's double the price of a module quoted in the article.
392··on 2024 Kawasaki Ninja 7 hybrid motorcycle first ride review
Two more clutches to wear and be replaced adds weight, space, maintenance, and cost. Motorcycles are an art in throwing away assemblies that aren't necessary.
392··on SQL for data scientists in 100 queries
No database is fully SQL compliant. Though clickhouse can at times be painfully so.

https://stackoverflow.com/questions/784900/why-does-no-datab...

392··on The medieval habit of 'two sleeps' (2022)
>The sleep period consistently occurred during the nighttime period...was not interrupted by extended periods of waking...
392··on When U.S. Air Force discovered the flaw of averages
Or, you know, take five minutes to read the article.
392··on "Software is getting slower more rapidly than hardware becomes faster."
https://danluu.com/input-lag/
392··on Solver Performance: 1989 vs. 2024
The map is not the terrain.
392··on I cut GTA Online loading times by 70% (2021)
Chiming in here as someone who used to play in competitive GTA leagues. I quit playing because of too much time spent in load screens. It was worse than just this slow loading bug: random disconnects that triggered loading again got more and more common over time, too.
392··on Databases in 2023: A Year in Review
I actually just read a paper where some new file format achieved far faster and smaller writes than the Parquet used in all of these modern big datalakehouses, and it was done by guessing like 20 different simple compressions on a sample to figure out what will work best for each chunk of data. Sounds like manual feature detection to me!
392··on Understanding Parquet, Iceberg and Data Lakehouses
It doesn't, maybe you mean something like Dagster or Airflow managing insertion time dependcies? Although iceberg does provide transactions across tables I believe.
392··on Understanding Parquet, Iceberg and Data Lakehouses
Same. I wasted a month or so of off time trying to get that old stack to work well enough to let me just insert data, left unhappy. Had Databend up and running in an hour, figured it will get easier to do it right in the future once there's a Rust impl (for portability vs Java/Hive)
392··on Show HN: Weeks of Your Life
I don't see it on the Play Store, sadly :-)
392··on Maelstrom: A workbench for learning distributed systems
I'd start by reading the papers mentioned below and then implementing a real distributed kv store without any fluff, just hard code your test cases into a simple client. Then try load testing by running a ton of your client. The problems you run into will be practical and real and you will have to debug them yourself with real tools. Then after that basic exercise I think Maelstrom will be more useful to you. TLA+ is an awesome design tool but imo implementation practice is more helpful for a beginner, you'll be more familiar with the problems TLA+ can help you solve.

https://omscs.gatech.edu/cs-6210-advanced-operating-systems

392··on Tinnitus linked to undetected auditory nerve damage
They're not really, but I can see why Beltone stores would give you that impression. Go see an audiologist.
392··on Ask HN: Why did Google Maps turn ugly?
I found changing my phone display from Vivid colors to Flat helped.
392··on Writing documentation for your house
https://dobu.ee
392··on Dup()'s shared file IO offset is a necessary part of Unix
For a long time `npm` would do that to your stdout/in, which didn't impact anything in interactive shells because your shell resets it every time it shows the prompt, but run those same commands in a bash script and later processes will crash with strange error messages because no one has ever tested with stdout being nonblocking. So much for separate processes being independent.
392··on We built the fastest CI and it failed
Try buck2
392··on Hydra: Column-Oriented Postgres
Any thoughts on Databend? I was really impressed by the minimal time to set it up and the 100x faster inserts with parquet upload. But it doesn't seem to be picking up HN hype.
← PreviousPage 5 of 5