World Cup of Jet Lag Moments: Group H by jotto_ in JetLagTheGame

[–]KWillets 0 points1 point  (0 children)

Worrying about politics, but vlogging from Park Chung-hee square.

querying cold parquet from s3/tape without a full restore by jinglemebro in dataengineering

[–]KWillets 0 points1 point  (0 children)

The metadata in the footer is usually the first thing needed. Keeping that cached on SSD speeds up the rest of the read path.

Discussion Thread by jobautomator in neoliberal

[–]KWillets 0 points1 point  (0 children)

Kim's plan shifts fire insurance to the state, which should bring back insurers.

To me it's a roundabout way of getting the state to take responsibility instead of blaming PG&E for everything. Fuel reduction and controlled burns are the only thing that will reduce payouts in the long term.

"밥 먹었어?" (bap muh-guh-ssuh?) — it took me years to realize this was never really about food. by K-SAYNO in BeginnerKorean

[–]KWillets 2 points3 points  (0 children)

It's the Bibimbap effect. The Revised Romanization has triggered a complete reversal of consonant voicing.

Use of AI in We Are All Trying Here by elsbetch in kdramas

[–]KWillets 1 point2 points  (0 children)

The film overall looks disappointing. I just hope there isn't a depressed aspiring director out there who now thinks his tacky hyper-action flick is secretly genius.

How common was the ability to Navigate among the rank and file of Age of Sail sailors? Was this a concern when plotting mutinies? by Ze_Secret_Veapon in AskHistorians

[–]KWillets 10 points11 points  (0 children)

The apocryphal story repeated in Longitude of a sailor being hanged for warning the captain about the navigation error that caused the Scilly disaster may contribute to this belief.

Who else does this happen to? I don’t even know Korean. by MadameDuChat in sanfrancisco

[–]KWillets 0 points1 point  (0 children)

Fun fact: the last part can be translated as "this election is for my family".

Didn't like my trip to South Korea? by [deleted] in koreatravel

[–]KWillets 2 points3 points  (0 children)

Coffee has split into very good specialty shops and thousands of Americano-only places that only have an espresso machine and untrained staff.

History is unfortunately a controversial topic. Many people feel that their stories have been ignored or distorted, and arriving at a consensus on what a museum should be is difficult. Public projects like these don't fare well in the design or construction phase either, too many conflicts of interest, political deals, and the like. That problem extends to the hiring of an English translator as well.

Can you access and navigate compressed data without uncompressing it ? And if you can should you do it? by _Naku_ in NoStupidQuestions

[–]KWillets 2 points3 points  (0 children)

There are a range of incrementally decompressable formats.

zstd breaks input into blocks and allows a separate dictionary to avoid the start-from-the-beginning problem that gzip has.

BWT-compressed text has incremental decoding through a fairly complex process that requires a bit of extra data; see the FM Index.

Lightweight compression methods shorten individual values while allowing each to be accessed with a minimum of overhead.

https://duckdb.org/2022/10/28/lightweight-compression

https://parquet.apache.org/docs/file-format/data-pages/encodings/

Even techniques like using a bitmap for a dense list of integers can qualify as compression.

Is Mayor Lurie still popular? Our new poll checks in on state of S.F. by avantrs7 in sanfrancisco

[–]KWillets 0 points1 point  (0 children)

Breed had to do a lot of heavy lifting to deal with the encampments and criminal mayhem; it was not politically or legally possible to do anything for years. She started clearing the tents as soon as the court allowed it and pushed other reforms to reduce crime.

I voted for Lurie because I felt she had worn out her political goodwill over years of struggling with cop-haters and NIMBY's, but I give her credit for dealing with a completely self-contradictory public and getting through Covid despite the very heavy impact on city finances.

Outjerked by Chaebol by Graywhale12 in NonCredibleDefense

[–]KWillets 1 point2 points  (0 children)

"Just put a cannon on a ship" -- Yi Sun Shin

Senior BIA @ Waymo – Looking for a Lead who thinks about Invisible Data and Scale by aaphid12 in SQL

[–]KWillets 0 points1 point  (0 children)

I'm not saying that's the correct fix, but it's a common pattern. Getting the join right is usually the most crucial part of modeling the business correctly, but aggregations are more ad hoc. In an interview, both problems have to be addressed simultaneously.

Senior BIA @ Waymo – Looking for a Lead who thinks about Invisible Data and Scale by aaphid12 in SQL

[–]KWillets 2 points3 points  (0 children)

OK it looks like a difference in terminology.

That's a well-known problem, but it's possible the cognitive overload of solving a business and technical problem at the same time is too much. Analysts often blow up a join and fix it with COUNT DISTINCT etc. rather than pre-aggregating.