Here is an article that explains it better - https://www.salesforceben.com/salesforce-shuts-down-heroku-e...

Stolen from https://www.reddit.com/r/webdev/s/6U8jJJRzBC

Completed books:

Project Hail Marry by Andy Weir

Dungeon Crawler Carl (Books 1-7) by Matt Dinniman

I'm currently reading:

Careless People: A Cautionary Tale of Power, Greed, and Lost Idealism by Sarah Wynn-Williams

> Project Hail Marry by Andy Weir

The only Andy Weir book I've read. Loved it.

For the last 10(ish) years I've been using Greenshot [1]. I haven't found any issues with it but it is only available on Windows and Mac.

[1] https://getgreenshot.org/

Greenshot is great! I use it on Windows, and ksnip on everything else atm as it has similar draw arrows/annotation features.

If ksnip is cross-platform, may I ask why don't you use it everywhere, if it's so similar to Greenshot?

BTW I've never heard of Ksnip before. I gotta try it.

I haven't used Greenshot in a couple months, but I think I remember it being better than ksnip, will have to look again.

I've been reading Brain Energy by Dr. Chris Palmer that makes a compelling argument that all mental illnesses are metabolic disorders of the brain

https://brainenergy.com/

See this post on why.

https://news.ycombinator.com/item?id=40097818

Never heard of exoscummvm but https://www.scummvm.org/ is the original site. I spent a lot of time playing Monkey Island the ds version of scummvm.

You can using wsl [1] or without [2].

[1] https://news.ycombinator.com/item?id=20632942

[2] https://news.ycombinator.com/item?id=38909304

select distinct customer_id, max(order_id) over (partition by customer_id order by created_date desc) FROM orders

http://sqlfiddle.com/#!15/51df39/2

Hmm… my hunch is that this doesn’t do what you think it does.

I expect the order by in the window function is effectively lost because max operated over the whole window. (And you happen to get the most recent, because in many implementations, order_id will be a sequence.)

But I might be wrong. And I might only now be learning that order by with max() and over substitutes how the “value” of the order_id is understood.

You aren't wrong.

http://sqlfiddle.com/#!15/7eb3a/7

Here's a pretty simple/normalish way to handle the edge cases. This one (without distinct) is far more consistent (wall-clock-wise, doesn't depend on caches): http://sqlfiddle.com/#!15/7eb3a/9

Note that order 2 is after order 4 in the example schema.

If you just need customer id and order id (and nothing from the original orders table), you can simplify it further http://sqlfiddle.com/#!15/7eb3a/10

Oops, you are right

Im very ignorant of partition by, but it doesn’t look like it works? http://sqlfiddle.com/#!15/696cb/1

It doesn't. http://sqlfiddle.com/#!15/7eb3a/7 is a proper implementation using windowing functions to get the first something.

You could try Modern Treasury and outsource the API requirements.

https://www.moderntreasury.com/products/payments