HNHacker News
TopNewBestAskShowJobs

thedirt0115

348 karma · joined March 3, 2017

submissionscomments
thedirt0115··on How to check if two SQL tables are the same
Consider owning an ETL system where users can create periodic jobs, like calculating a "daily active user" rollup table from a bunch of event source tables. Now consider being asked to switch the query execution engine from A to B, perhaps because engine B is much more cost-effective for your system's query patterns. Ex: You are tasked with switching from MapReduce to Tez, from Presto to Spark, etc. Before full migration, you can reduce risk by double-writing jobs, with engine A writing to the standard output location, and engine B writing to some other migration location. This should lead to two identical SQL tables, which you should then verify, because sometimes these execution engines have bugs hiding in the corners :)
thedirt0115··on Pro-cash movement warns that people could be losing more than they bargained for
This got me interested as well. I couldn't find the specific incident they were referring to with a brief search, but I did find this, which implies that toll data can be and has been used in child custody disputes, etc: https://familylawyermagazine.com/articles/i-pass-tollway-dat...
thedirt0115··on How poker and a spaceship imposter game make you better at life
There is a rule variation that disables confirmation of whether the person you're voting off was a crewmate or imposter --- this variation makes the "kill, self-report, blame other person" strategy viable. It's a simple change, but it really spices things up!
thedirt0115··on Why Understanding Beats Knowledge
Here is a GIF demonstrating the tangent line as a point traverses a curve: https://s3-us-west-2.amazonaws.com/courses-images/wp-content...

The "pencil" (the short line representing the tangent) is green when positive, black when zero, and red when negative. Note that when it is black/zero, the "pencil" line is flat. This occurs at both local maxima and minima.

thedirt0115··on Show HN: Dungeon Map Doodler – Free online map drawing tool
This is really cool, thanks for sharing! It would be great if the hover text for the tools also displayed the keyboard shortcuts that I found in the nice and easy-to-read JavaScript :)
thedirt0115··on Understanding quaternions and the Dirac belt trick (2010)
Here's a GIF of the belt trick they're talking about in the paper: https://www.gregegan.net/images/DiracAnimation.gif
thedirt0115··on Recreating YikYak with Postgres
Don't be afraid to put unfinished code or code without tests up on GitHub -- just mention in your README that it's not production-ready yet or something. It still has educational value for the community. Maybe someone will even help you write tests! Btw, thanks for sharing -- I had never heard of the R-Tree data structure before.
thedirt0115··on Kongregate closed to new games, shutting down forums and chat
I too miss Flash games, but there are still tons and tons of free indie games on the web. Have you checked out itch.io, for example? There are ~90k free HTML5 games [1].

[1]: https://itch.io/games/html5

thedirt0115··on Fix Your Timestep
There's a billiards simulator/game[1] that uses event prediction instead of step-based physics for realistic and reproducible results. It solves the equations of motion to find the next event, animates to that point, and continues until nothing is moving. This is feasible since there are only 16 balls and 1 cue tip, but I imagine that as computational power continues to increase, the scale of such simulations will increase too. I'm excited to see what's next :)

[1] - I read a paper that specifically talked about step-based vs event-prediction for billiards simulation, but I can't find it now :/ Virtual Pool 4 might use the system for its physics, but don't quote me on that!

P.S. - Unity has a pretty handy built-in CharacterController class that lets you move around while respecting collisions -- you just need to add your own Gravity. Also, for more advanced character movement, Catlike Coding has a great series of tutorials: https://catlikecoding.com/unity/tutorials/movement/

thedirt0115··on Syncthing is everything I used to love about computers
That looks like it's from 2016 -- is this still the case? (I'm not a Dropbox user, but would like to know)
thedirt0115··on High-Speed Pool and Billiards Video Clips
The author was a mechanical engineering professor who loves pool. These slow motion videos are more physics demonstrations than instructional.

Not many people know how to jump the cue ball legally, and even fewer know how to control the spin on a jump shot, so I thought these different jumps were interesting: https://billiards.colostate.edu/high-speed-video/hsv-7-23/ https://billiards.colostate.edu/high-speed-video/hsv-7-24/ https://billiards.colostate.edu/high-speed-video/hsv-7-25/

If you're looking for more instructional videos, check out the normal speed ones on https://billiards.colostate.edu/normal-video/

thedirt0115··on High-Speed Pool and Billiards Video Clips
Dr. Dave is awesome. If you like this, you might also like "Amateur Physics for the Amateur Pool Player" -- http://www.sfbilliards.com/Misc/Shepard_apapp.pdf
thedirt0115··on I was emailed after abandoning a registration form. I did not click Submit
Demo + discussion: https://news.ycombinator.com/item?id=13329525
thedirt0115··on But no, 80-column terminals in 2020 isn't “reasonable” any more
Hammerspoon can do this (and way more!) for free :)

https://www.hammerspoon.org/go/#winresize

thedirt0115··on All the Letters
These are called "pangrams". Here's a fun one that's short and makes sense: Waltz, bad nymph, for quick jigs vex!
thedirt0115··on What Unity Is Getting Wrong
This is correct, they released the source code a couple years ago under a reference license.

https://blogs.unity3d.com/2018/03/26/releasing-the-unity-c-s...

https://github.com/Unity-Technologies/UnityCsReference

thedirt0115··on Show HN: Lite – A small, fast text editor
My Lua isn't strong, but I think this is what you're looking for:

Data structure initialization: https://github.com/rxi/lite/blob/master/data/core/doc/init.l...

How insertion works here, which illuminates how the table is used: https://github.com/rxi/lite/blob/143f8867a13a35f5688ad7c9771...

thedirt0115··on New 13-inch MacBook Pro
AutoHotkey can do this "caps lock as both escape and control" thing too. I use this, from http://vim.wikia.com/wiki/Map_caps_lock_to_escape_in_Windows :

  ; Author: fwompner gmail com
  #InstallKeybdHook
  SetCapsLockState, alwaysoff
  Capslock::
  Send {LControl Down}
  KeyWait, CapsLock
  Send {LControl Up}
  if ( A_PriorKey = "CapsLock" )
  {
      Send {Esc}
  }
  return
thedirt0115··on Show HN: RegEx for Regular Folk – A visual, example-based introduction
I agree that it would be nice if the learner was given some instruction on how to experiment right away. I'd recommend https://regex101.com/ as a tool to complement this (or any) regex tutorial, as well as when you're crafting/debugging regex. It's language-agnostic in that you don't need to write any code, just the regex and input -- but you can still pick different regex flavors like PCRE vs JavaScript.
thedirt0115··on 3D cartoon face and cat face from one image
And interestingly, not everyone sees the illusion: https://www.ncbi.nlm.nih.gov/pubmed/27847925
thedirt0115··on Game developers share what they're most proud of making
One of the featured games is Kine, a cool looking 3D puzzle game. The creator, Gwen Frey, just did a great GDC talk, "The Kine Postmortem": https://www.youtube.com/watch?v=wDG_EvHCIxQ
thedirt0115··on UDepth: Real-time 3D Depth Sensing on the Pixel 4
I'm not into 3D printing, so I'm unsure of what viable means in that context, but for photogrammetry in general, I've had success generating 3D models of little figurines/statues with just a bunch (~15-20) of photos from my cell phone using Meshroom[1] followed by light touch up in Blender[2] to separate the environment from the model. Both are open source.

[1] https://alicevision.org/#meshroom [2] https://www.blender.org/

thedirt0115··on Why Don’t We Use Chemical Weapons Anymore?
tl;dr: "Not because chemical weapons are immoral. Because they are ineffective" :'(
thedirt0115··on Pro drivers are competing with gamers after F1 and Nascar canceled races
Another sports sim that is incredibly close to real life is Virtual Pool 4. It looks quite dated, but no other game has more realistic billiard physics that I know of.
thedirt0115··on Swift: Announcing ArgumentParser
There's an issue open for this, so they'll probably have it pretty soon: https://github.com/apple/swift-argument-parser/issues/8
thedirt0115··on What happens if I don't fill out my census form? (2019)
Hopefully you are in a better situation now. For anyone who is currently homeless, but wants to be counted, the census bureau has the following plans:

March 30, 2020: Counting people who are in shelters.

March 31, 2020: Counting people at soup kitchens and mobile food vans.

April 1, 2020: Counting people in non-sheltered, outdoor locations, such as tent encampments and on the streets.

See this for more information: https://2020census.gov/en/what-is-2020-census/focus/people-e...

thedirt0115··on Expertise Is 'Just' Pattern Matching
I didn't say there wasn't pattern matching in video games, I said that pattern matching is only part of being an expert.

To use your FPS example, knowing all of those things still doesn't matter if you miss every shot.

Another example -- 99% of the best Olympic athletes at the 2012 Olympics were less than 40 years old.[1] I don't think that people over 40 are worse at pattern matching, I think being an expert at something requires more than just pattern matching. Depending on the activity, physical strength, eyesight, reaction time, and so many other things matter too.

[1]: https://rua.ua.es/dspace/bitstream/10045/61889/1/jhse_Vol_11...

thedirt0115··on Expertise Is 'Just' Pattern Matching
Being an expert is certainly not "just pattern matching" for physical sports, music, real-time video games, and many, many other things. Not only does one need to see the pattern, but they must be able to physically make their body do what they recognize needs to be done. Beyond "just pattern matching", if there's any chance of failure, what separates experts from amateurs is consistency of execution.
thedirt0115··on Human reproductive cloning: The curious incident of the dog in the night-time
I'm pretty interested in the morals/law discussion we'll need to have soon when we have creation of embryos without needing exactly two parents, plus the ability for the embryo to develop to term in an artificial uterus (no humans needed). There are so many questions here that we just don't have precedent for!
thedirt0115··on 500 Byte Images: The Haiku Vector Icon Format (2016)
They may not resize the browser window often, but when they do, it fires a lot of events with a lot of resolutions depending on how exactly they move the mouse to the desired position. Try opening your browser console, paste the code below, then resize a few times and see how many events you get.

    window.onresize = function() { console.log("resizing!"); };
You could do various techniques like detecting the start of resizing and waiting for it to settle down before requesting the new image, but still, I think you may be underestimating how many resolutions there are out in the wild :)
Page 1 of 6Next →