News for hackers. Stuff that matters.

available

Re:How I format SQL code on Thursday January 30, 2020 @07:59PM (#22197878)
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
Re:RunJS on Saturday January 12, 2019 @07:26PM (#18894153)
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.

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.
Re:Exif.tools – A multimedia file metadata tool on Tuesday August 14, 2018 @11:13AM (#17758643)
I have recently been trying to organize an old photo library, looks like these tips could come in handy!
Re:Firefox 58 on Tuesday January 23, 2018 @02:28PM (#16216678)
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.
Re:Pure UI on Thursday November 09, 2017 @05:43AM (#15661364)
Thanks! I have actually been looking for some simple examples of ZEIT microservices and this happens to be a very nice one.
Re:Pure UI on Tuesday November 07, 2017 @10:52PM (#15649809)
How was the view counter made? It's cool to see it increase in realtime.