Readit News logoReadit 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 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.

u/xucheng

KarmaCake day1181September 18, 2014
About
https://xuc.me

[ my public key: https://keybase.io/xucheng; my proof: https://keybase.io/xucheng/sigs/WxFwFwijzQd1QEoW589Bdm3s-u55v03sSLljKAHlGzc ]

View Original