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, 3Electron 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.
Re:Show HN: Hacking slot machines with a buttonhole camera and brute-f...
on Thursday September 20, 2018 @08:58PM (#18036481)
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.
Thanks! I have actually been looking for some simple examples of ZEIT microservices and this happens to be a very nice one.