HNHacker News
TopNewBestAskShowJobs

available

12 karma · joined September 14, 2017

After many failed attempts, I finally found a username that was available.
submissionscomments
available··on How I format SQL code
What do you think about only capitalizing the first letter like this:

  Select
      region_fleet,
      Case When status = 'Delivered' Then 'Delivered' Else 'Not Delivered' End As status,
      Date_Trunc('week', day) As week,
      Count(Distinct Row(day, so_number)) As num_orders,
      Count(Distinct Case When scheduled_accuracy_meters <= 500 Then Row(day, so_number) Else Null End) As num_accurate,
      Avg(scheduled_accuracy_meters) As scheduled_accuracy_meters
  From
      deliveries
  Where
      ...
  Group By
      1, 2, 3
available··on RunJS
Electron is one of the reasons apps like this even gets made in the first place, other options are often not worth the time of development.

A solution to reduce the size could be to ship the Electron runtime similar to .NET, etc.

However, PWA's are probably going to be the best bet going forward.

available··on Show HN: Hacking slot machines with a buttonhole camera and brute-force search
It's strange that he basically removed the entire history, but kept a couple of commits such that the 'face' gif can still be accessed? Regardless, several forks exists with the original history dating back to 2016. So it's probably too late to do anything about now.
available··on Exif.tools – A multimedia file metadata tool
I have recently been trying to organize an old photo library, looks like these tips could come in handy!
available··on Firefox 58
Yes, I simply couldn't use it because it drained my macbook battery too quickly. I just updated to 58, but it seems to still be a problem.
available··on Pure UI
Thanks! I have actually been looking for some simple examples of ZEIT microservices and this happens to be a very nice one.
available··on Pure UI
How was the view counter made? It's cool to see it increase in realtime.