HNHacker News
TopNewBestAskShowJobs

392

118 karma · joined August 25, 2023

submissionscomments
392··on Half a century of SQL
No one has ever said that since no database implements the whole standard or limits themselves to just the standard. jOOQ blog has some good writings on this. I am glad at least that the standard gave us a sizeable common subset over half a century rather than everybody doing their own thing from day one.
392··on The Case for the Programmers' Keyboard Layout
All of these layouts are a waste of time. I have yet to see anyone make a convincing quantitative argument for learning one. If it's fun for you, great. If buying things makes you feel like you're progressing in a hobby, good luck.

I have 99th percentile typing speed on QWERTY thanks to using PCs when too young for traditional touch typing to work. My arms fly around the keyboard and I have never gotten RSI _from typing_. Using the mouse precisely for a summer where vim was forbidden (thanks big banks) did yield almost instant RSI. Trying traditional touch typing (with no movement) also agitates my arms. But imo folks should learn speedtyping techniques for qwerty to avoid RSI and skip the rabbit hole of alternate layouts and keyboards. Lot of inconvenience and more wasted time than will likely ever be saved.

The only true advancement is steno / charachorder. The actual charachorder lite isn't quite there imo (chord detection sketchy) but one of these days I will use ZMK to add the most common chords to my qwerty keychron k2 with gateron browns. Not to mention ZMK has far more features (like modtap) that you find yourself wanting once you use something like Charachorder, and Charachorder is still not open source ("someday").

If you're really in need of even faster typing than "faster than anyone you know", first reevaluate your decision-making framework, then voice dictate.

392··on Ask HN: What hair on fire problem are you willing to pay for right now?
Personal assistant without the effort of vetting / preventing identity fraud / theft would go a long way.
392··on Spotify Car Thing will be discontinued
I was suspicious when they advertised on sale for $30 last year. Maybe Lina Khan will peruse the emails that lead to that clearance.

Though it's no surprise Spotify failed at hardware given their general software competency. Broke the Chromecast app for years after the big mobile redesign. Not sure how it's possible to have such bugs in an app that shows three buttons, a progress bar, and a picture, but 2,000 engineers will find a way. Liked page on the phone app doesn't even load with bad service, which is like your umbrella not opening in the rain.

Anyone know of alternatives, even alternative clients?

392··on VideoPrism: A foundational visual encoder for video understanding
What's the better way?
392··on No One Knows What Universities Are For
We should be ashamed of every dollar wasted on this lazy-middle-class-New-Deal that wasn't spent helping children in poor schools in the same nation. Luckily, the research for how best to help those schools is being done in Universities.
392··on Algebraic Data Types for C99
What's neat about Rust is that in its macro land, writing the code that checked for this condition would be not only possible, but doable, imaginable, and aided by easily installable OSS libraries.

So it's not just about being slightly better in some ways, but smoothing over so many paper cuts that it can be hard to see how they have added up overtime across ecosystems, like CPython and co having so many of its own vocab types, or HPC libs.

For example, the problem with this macro that causes this wouldn't even be problems in a well written Rust macro. They're artifacts of smart people trying to work around C's limitations.

But then the macro wouldn't have been written anyway because this is a port of a native Rust feature (which means it gets taken advantage of in community software).

392··on Algebraic Data Types for C99
I find that most abuses of the preprocessor are by folks unwilling/unable to simplify their design into a form that's (a) native to the C language/runtime or (b) not repetitive to type.

This library on the other hand addresses a nasty papercut whose presence usually stops folks with modern language experience from choosing C when it might otherwise be valid. Plus you can't beat C's long-term stability.

Though I agree that 90+% who _think_ they still need C should probably move on to making Rust work for them, instead.

392··on The Birth of Parquet
I'm puzzled as to why this is a problem that has lasted months. My phone has enough RAM to work with this file in memory. Do not use pyspark, it is unbelievably slow and memory hogging if you hold it even slightly wrong. Spark is for tb-sized data, at minimum.

Have you tried downloading the file from s3 to /tmp, opening it with pandas, iterating through 1000 row chunks, pushing to DB? The default DF to SQL built into pandas doesn't batch the inserts so it will be about 10x slower than necessary, but speeding that up is a quick google->SO away.

392··on Book people think they know why 9-year-olds stop reading for fun
When I was that age I read basically nothing but Hardy Boys books. Also Alex Rider books and Harry Potter, all out of order.
392··on The Modern Curse of Overoptimization
Did the crap people didn't need in these eBay listings improve the world with their lower prices? I don't think folks are buying groceries there.
392··on BASIC turns 60
Exact same story for me with JustBASIC, late 2000s, no home Internet connection except dialup. Excellent built in help.
392··on Are We Modules Yet?
Learn Rust instead. This ship has holes.
392··on Memary: Open-Source Longterm Memory for Autonomous Agents
Log4j was so unbelievably slow to load data, bloated, and hard to get working on my corporate managed box that I wasn't too sad when it turned out unable to handle my workload. Then the security team asked me why it was phoning home every 30 seconds. Ugh.

I have since found Kuzu Db, which looks foundationally miles ahead. Plus no jvm. But have not yet given it a shot for rough edges. At the time, it was easier just to stay in plain application code.

Hopefully the workload intended by this tool won't notice the bloat. But it would be nice to be able to dump huge loads of data into this knowledge graph as well, and let the GPT generate queries against it.

392··on The failure of the Domino's 30-minute delivery guarantee
No one ever notices the no garlic spray order. I eat dominos weekly and every time I move, it takes a few weeks for the new store to catch on that I order without garlic, and they always know me after that. Any Dominos ordered while out of town is 75% chance of being wrong. I've given up at this point. Papa Johns and gets it it perfect every time, and I can forgive Little Caesars.
392··on Ask HN: Outstanding Programmers
Sentence two does not follow from sentence one.

https://www.theintrinsicperspective.com/p/why-we-stopped-mak...

392··on Use Your Potions and Scrolls
Go pick up a bottle you could afford to replace if it broke by accident. Throw it outside to break it or give it away. Write about how you feel about it every few days for a week or two. I'd read it, I have this problem sometimes too.
392··on Blaze: A High Performance C++ Math Library
Are there any benchmarks to show it would be noticeably faster to compile with a non-templated design?
392··on Do we need to store all that telemetry?
This is all quite true, but a possibly faster way to prototype would be to use DRAIN algorithm (there are rust and python impls that are easy to use) to determine the "log template". Then push the log template when its first seen and nothing but values after that, into a programmatically generated table in a common columnar format like Parquet or Iceberg. Then you can point the myriad of data analysis tools like DuckDb, DataFusion, or the latest InfluxDb at it, you've got your SQL on logs implemented. It can feel a bit Rube-Goldbergish, and it's a bit tricky to navigate the space uninformed because it's early, but it can also handle all other data your company uses in one platform, no need to special case "applications" from the "data analysis"/historical/log side. One place to handle permissions. Then there are tools like Dagster for managing this humongous single database in a straightforward way rather than writing a web of applications that push and pull to it but without a complete picture being possible, or needing devs to remember their place in the system. Search up Uber CLP for prior art, or more generally the "modern data stack" (PRQL will be perfect for querying logs). But by piggybacking on big systems like this, you can take advantage of future advancements in state of the art, like BtrBlocks https://www.google.com/url?sa=t&source=web&rct=j&opi=8997844.... Of course, if the savings/earnings are high enough, I guess you start on implementing this now.
392··on I nearly died drowning
Every generation before me was taught to swim by being tossed in a pond. It's a dangerous world. Pretending it isn't just lowers the minimum required stress before anxiety takes over.
392··on Obituary for a quiet life (2023)
No distractions like friends? No awareness that Max has headlines like "forged by his father's beatings and humiliation?" You should probably seek a less results driven focus on life, perhaps with a therapist, unless just trolling in which case carry on. But regardless, there's an article called "Why we stopped making Einsteins" that you may find interesting.
392··on Show HN: Dimity Jones in Puzzle Castle: An Electronic Escape Novel
This is exactly the kind of art I've always enjoyed the most, but I'm most glad that someone finally pointed out to me that it was art. Thank you!
392··on Preview of Explore Logs, a new way to browse your logs without writing LogQL
You may be amazed at how hard these tools are to get started with relative to that. I have been thoroughly unimpressed with and unable to really get started with any of these tools because of the overemphasis on cloud. Not sure what people were doing before, but sshing to the prod box kinda sucks.
392··on Show HN: Shorebird 1.0, Flutter Code Push
Could write them for Buck2 and avoid the old bazelisms. But already need a jvm I guess so bazel is no harm.
392··on Xbox has a new team dedicated to game preservation and forward compatibility
Insane FPS refresh rates. A different lighting technique that kind of blurred together the pixels in a vague antialias. Less tearing than their potentially cheap TV.
392··on The Past, Present and Future of Stream Processing
Sounds like my experience when tinkering as well.

https://adamdrake.com/command-line-tools-can-be-235x-faster-...

392··on Friends don't let friends export to CSV
I must have missed when Excel added Parquet support.
392··on SQL is syntactic sugar for relational algebra
You may like PRQL, which gives a more composable-atoms based approach. I find it far easier than SQL.
392··on The Mythical Non-Roboticist
I think it is pessimistic to say that number precision is a problem fundamental to computing. The bitter lesson gives me hope that someday no one will have to care about non-arbitrary-precision math. Programming could get that simplified by a great platform.
392··on The Mythical Non-Roboticist
I think it will first be a kit to convert your average forklift into autonomous by retrofitting some sensors, motors for pulling cables or changing pressure on hydraulic lines electronically, and a laptop. The humanoid thing will be killer when it's out but it will be a century long boundary pushing dream to be chased.
← PreviousPage 4 of 5Next →