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

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.

Yeah, it's not anon: the game was retired from machines and I left the ROM out. Wouldn't recommend to do for other than fun (and tbh hourly wage would be very small), but was a fun side-project!

I have recently been trying to organize an old photo library, looks like these tips could come in handy!

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.

Same here - first thing I did when v58 came out was check to see if CPU usage was lowered, which it unfortunately wasn't.

I see no reason why CPU activity should spike to 20% every few seconds with one blank tab open and no extensions enabled.

To save battery life I'm trying to switch to Safari (from Chrome -> Firefox) but container tabs in Firefox are amazing - the ability to automatically open a domain in a container is perfect.

Is it possible to whitelist cookies per domain in Safari?

How was the view counter made? It's cool to see it increase in realtime.

If you are interested here is source code for the blog views. https://github.com/rauchg/blog-views

Thanks! I have actually been looking for some simple examples of ZEIT microservices and this happens to be a very nice one.

It uses Firebase i think

Yes there's an open firebase websocket connection that emits the count.

example payload:

{"t":"d","d":{"b":{"p":"views/2015-pure-ui","d":514866},"a":"d"}}

I came here just to compliment the counter. Very cool.