mister_goo's comments

mister_goo | 3 years ago | on: Stop Using “Real Time” Wrong

Real-Time. Consistency. High-Availability. Concurrency. Words with too many different meanings are not sufficient for describing softwares. I treat those words as marketing terms.

mister_goo | 3 years ago | on: SpatiaLite: Extends SQLite core to support Spatial SQL capabilities

SpatiaLite is a great extension for spatial functions, it is very useful for implementing location-based services. And I like the idea of extending SQLite just for the simplicity of file base DB.

A slightly related problem I encountered several times is reverse geocoding: given a point, a map, which polygon the point is in? I figured out that the problem is solvable via rasterization and run-length-encoding, which doesn't need a spatial library, and works efficiently with any SQL DBs without GIS/spatial extensions. I created a website (https://reverse-geocoding.com/) to demonstrate the idea, which has a GPS-to-country DB in SQLite format.

mister_goo | 3 years ago | on: How many technical books do you read per year?

It's just personal preference.

Books that just give information (especially techs) are replaced by the Internet. Other books are supposed to teach me something, but my experience is that I learn stuff by doing and thinking rather than reading.

mister_goo | 3 years ago | on: Why Is This Tiny Frog So Awful at Jumping?

> Perhaps the takeaway of the pumpkin toadlet is that not everything must be optimized. Just because you are bad at something does not mean you should not do it. > Every species should have the right to fail spectacularly, but on its own terms.

mister_goo | 3 years ago | on: Mptcp: Moving laptop from GBit to wireless without applications noticing?

So there is a difference between what people are supposed to do and what people actually do. What I am wondering now is why IPv6 didn't adapt NAT as a first class feature, if IPv6 added something like port number in IPv6 header, NAT could not break protocols. It seems IPv6 strongly resists NAT, but in reality, people still use NAT on IPv6.
page 1