xucheng (u/xucheng) - Readit News

xucheng commented on Reverse geocoding is hard shkspr.mobi/blog/2025/04/... · Posted by u/pavel_lishin

Dachande663 · 4 months ago

Fun fact that was dredged up because the author mentions Australia: GPS points change. Their example coordinates give 6 decimal places, accurate to about 10-15cm. Australia a few years back shifted all locations 1.8m because of continental drift they’re moving north at ~7cm/year). So even storing coordinates as a source of truth can be hazardous. We had to move several thousand points for a client when this happened.

xucheng · 4 months ago

Can this be solved by storing a timestamp of the record along with precise GPS coordinates? Could we then utilize some database to compute the drift from then and now?

xucheng commented on When the Dotcom Bubble Burst dfarq.homeip.net/when-the... · Posted by u/rbanffy

robinhouston · 5 months ago

To me the most sobering cautionary tale from the dotcom bubble is the story of Cisco. Cisco manufactured, in a very real sense, the physical infrastructure of the internet: the routers, switches, modems, etc. that directed the IP packets to their destinations. (To a significant extent they still do, though nowadays they have more competition in that area.)

Savvy investors piled in to the stock, reasoning that, while internet startups might come and go, the internet itself was surely here to stay. It was popular to observe that, in the California gold rush of the mid-1800s, the purveyors of mining equipment made it rich more reliably than the prospectors for gold.

Anyway the Cisco stock price peaked in March 2000, and to this day it still has not reached that level again. The savvy investors were of course correct in their belief that the internet would continue to be important, and that Cisco would continue to be an important manufacturer of internet networking equipment. But they lost money anyway, because once the euphoria had worn off the market consensus was that the stock just wasn’t worth as much as the price it had been selling for at the height of the mania.

Any parallels to hot contemporary stocks are left as an exercise for the reader — and I do not mean to suggest that history must always repeat exactly.

xucheng · 5 months ago

At least, Cisco survived. Nortel and Lucent were not so lucky.

xucheng commented on iTerm2 critical security release iterm2.com/downloads/stab... · Posted by u/tjwds

xucheng · 8 months ago

Many years ago, I reported an issue where iTerm2 leaks sensitive search history to preference files [1]. The issue was quickly fixed. But until this day, I can still find people unintentionally leak their search history in public dotfiles repos [2].

[1]: https://gitlab.com/gnachman/iterm2/-/issues/8491

[2]: https://github.com/search?q=NoSyncSearchHistory+path%3A*.pli...

xucheng commented on FDA Authorizes First Over-the-Counter Hearing Aid Software fda.gov/news-events/press... · Posted by u/mgerdts

xucheng · a year ago

Interestingly, in the end of the article, the FDA links to an old article hosted on web.archive.org[1] even though the linked article was originally published by FDA themselves. Considering the linked article was only published at 2022, a merely 2 years ago, maybe the FDA should do more to prevent dead links.

[1]: https://web.archive.org/web/20221028042729/https:/www.fda.go...

xucheng commented on Gilead shot prevents all HIV cases in trial bloomberg.com/news/articl... · Posted by u/toomuchtodo

xucheng · a year ago

Maybe better url, the official press release : https://www.gilead.com/news-and-press/press-room/press-relea...

@dang

xucheng commented on SQL:2023 has been released iso.org/standard/76584.ht... · Posted by u/MarkusWinand

xucheng · 2 years ago

A related question: what is the state in term of supporting the SQL standard among the popular RDBMS? It seems that almost all database engines use their own custom syntax.